| Primary Key | Field Type |
|---|---|
 MARKETINGCONSTITUENTID |
bigint |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 CONSTITUENTID |
uniqueidentifier |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 SEGMENTID |
uniqueidentifier | MKTSEGMENTATIONSEGMENT.ID | ||
| TESTSEGMENTID |
uniqueidentifier |  |
MKTSEGMENTATIONTESTSEGMENT.ID | |
| SOURCECODEMAPID |
uniqueidentifier | |
MKTSOURCECODEMAP.ID |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_CONSTITUENTSEGMENT_SEGMENTID |
SEGMENTID | |||
| IX_CONSTITUENTSEGMENT_SOURCECODEMAPID |
SOURCECODEMAPID | |||
| IX_CONSTITUENTSEGMENT_TESTSEGMENTID |
TESTSEGMENTID | |||
| PK_CONSTITUENTSEGMENT |
MARKETINGCONSTITUENTID | |
|
|
| UIX_CONSTITUENTSEGMENT_CONSTITUENTID_SEGMENTID_TESTSEGMENTID |
CONSTITUENTID, SEGMENTID, TESTSEGMENTID | |