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.
 RE7WEBSERVER UDT_WEBADDRESS   Default = ''
 CUSTOMCREDENTIALS bit   Default = 0
 RE7WEBSERVER_USERID nvarchar(100)   Default = ''
 RE7WEBSERVER_PASSWORD nvarchar(4000)   Default = ''

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