| Primary Key | Field Type |
|---|---|
 MARKETINGCONSTITUENTID |
bigint |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 CONSTITUENTID |
uniqueidentifier | |||
| FINDERNUMBER |
bigint |
| 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_CONSTITUENTID |
CONSTITUENTID | |||
| IX_CONSTITUENTSEGMENT_FINDERNUMBER |
FINDERNUMBER | |||
| IX_CONSTITUENTSEGMENT_SEGMENTID |
SEGMENTID | |||
| IX_CONSTITUENTSEGMENT_SOURCECODEMAPID |
SOURCECODEMAPID | |||
| IX_CONSTITUENTSEGMENT_TESTSEGMENTID |
TESTSEGMENTID | |||
| PK_CONSTITUENTSEGMENT |
MARKETINGCONSTITUENTID | |
|
|