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
Name | Type | Constraints | Description
ppc_smart_engagement_KEY | int (4) | NOT NULL | The primary key for this table.
engagement_binder_KEY | int (4) | NOT NULL | WorkpaperCS engagement binder key. This is also the primary key of Engagement_Binder table.
ppc_smart_engagement_guid | uniqueidentifier (16) | NOT NULL | This is PPC SMART engagement unique identifier. This information is passed to us from SMART.
ppc_smart_engagement_client_name | nvarchar (150) | NOT NULL | This is PPC SMART engagement client name. This information is passed to us from SMART.
ppc_smart_engagement_name | nvarchar (150) | NOT NULL | This is PPC SMART engagement name. This information is passed to us from SMART.

Primary key
Name | Columns | Description
PK_PPC_Smart_Engagement | ppc_smart_engagement_KEY |
Unique constraints
Name | Columns | Description
UK_PPC_Smart_Engagement$ppc_smart_engagement_client_name$ppc_smart_engagement_name$engagement_binder_KEY | ppc_smart_engagement_client_name, ppc_smart_engagement_name, engagement_binder_KEY |
UK_PPC_Smart_Engagement$ppc_smart_engagement_guid | ppc_smart_engagement_guid |

Foreign keys
Name | Columns | Referenced table | Description
FK_PPC_Smart_Engagement__Engagement_Binder__engagement_binder_KEY | engagement_binder_KEY | Engagement_Binder (engagement_binder_KEY) |