Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 RE7DBID int   Default = 0 The ID of the RE7 Database.
 RE7DBDESCRIPTION nvarchar(128)   Default = '' Description of the RE7 Database to link to.
 RE7DBSERIALNUMBER nvarchar(100)   Default = '' Serial number of the RE7 Database to link to.
 DBSELECTIONLOCKED bit   Default = 0 Flag which indicates the configuration values are locked and cannot be changed.
 TORE7 bit   Default = 1 Stores whether data should be copied to RE 7 during integration.
 FROMRE7 bit   Default = 1 Stores whether data should be copied from RE 7 during integration.
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.

Foreign Key Field Type Null Notes Description
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_RE7INTEGRATIONCONFIGURATION_DATEADDED DATEADDED    
 IX_RE7INTEGRATIONCONFIGURATION_DATECHANGED DATECHANGED      
 PK_RE7INTEGRATIONCONFIGURATION ID  

Trigger Name Description
 TR_RE7INTEGRATIONCONFIGURATION_AUDIT_UPDATE
 TR_RE7INTEGRATIONCONFIGURATION_AUDIT_DELETE