Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 USERNAME nvarchar(100)   Default = ''
 PASSWORD nvarchar(4000)   Default = ''
 DOMAIN nvarchar(250)   Default = ''
 URL nvarchar(500)   Default = ''
 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.
 USEIMPERSONATION bit   Default = 1 Designates that the defined exchange user information should be used to impersonate other exchange users.
 SUBSCRIPTIONPAUSELENGTH int   Default = 5 Value represents seconds. There must be a pause between the call to create the subscription and the call to get the events in order for the GetEvents() call to return values.

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_EXCHANGEINTEGRATION_DATEADDED DATEADDED    
 IX_EXCHANGEINTEGRATION_DATECHANGED DATECHANGED      
 PK_EXCHANGEINTEGRATION ID  

Trigger Name Description
 TR_EXCHANGEINTEGRATION_AUDIT_UPDATE
 TR_EXCHANGEINTEGRATION_AUDIT_DELETE