Database Column Names

[jewillis]

Are the below column names (GUID/CallGUID) correct? The VG DB script creates these names, BUT if we use the linkfield, shouldn't the column names be the same in both tables. I have had issues where data from the tables are not in sync and the only thing I can assume is because the column names are different and the linkfield will not see them correctly

 

Jeff

 

CREATE TABLE CallQue

(

ID Int IDENTITY(1, 1) PRIMARY KEY,

GUID UniqueIdentifier,

 

 

 

CREATE TABLE PortToUse

(

CallID Int,

CallGUID UniqueIdentifier,

 

 

<OutDialQue_PortToUse_LinkField>GUID</OutDialQue_PortToUse_LinkField>

 

 

 

[SupportTeam]

The column names as quoted are correct.

 

The CallGUID column stores the GUID from the referenced entry in the CallQue table.

 

The OutDialQue_PortToUse_LinkField config field does not actually specify the column name, it specifies the general approach/algorithms to use.