Table: dbo.PPC_Smart_Engagement
This table is used for PPC SMART integration. A binder that is linked with SMART engagement will store the linking information in this table.
Columns
NameTypeConstraintsDescription
ppc_smart_engagement_KEYint (4)NOT NULLThe primary key for this table.
engagement_binder_KEYint (4)NOT NULLWorkpaperCS engagement binder key. This is also the primary key of Engagement_Binder table.
ppc_smart_engagement_guiduniqueidentifier (16)NOT NULLThis is PPC SMART engagement unique identifier. This information is passed to us from SMART.
ppc_smart_engagement_client_namenvarchar (150)NOT NULLThis is PPC SMART engagement client name. This information is passed to us from SMART.
ppc_smart_engagement_namenvarchar (150)NOT NULLThis is PPC SMART engagement name. This information is passed to us from SMART.
Primary key
NameColumnsDescription
PK_PPC_Smart_Engagementppc_smart_engagement_KEY
Unique constraints
NameColumnsDescription
UK_PPC_Smart_Engagement$ppc_smart_engagement_client_name$ppc_smart_engagement_name$engagement_binder_KEYppc_smart_engagement_client_name, ppc_smart_engagement_name, engagement_binder_KEY
UK_PPC_Smart_Engagement$ppc_smart_engagement_guidppc_smart_engagement_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_PPC_Smart_Engagement__Engagement_Binder__engagement_binder_KEYengagement_binder_KEYEngagement_Binder (engagement_binder_KEY)

Schema diagram