CONSTITUENTSEGMENT
Primary Key
| Primary Key | Field Type |
|---|---|
| MARKETINGCONSTITUENTID | bigint |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| CONSTITUENTID | uniqueidentifier | |||
| FINDERNUMBER | bigint |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| SEGMENTID | uniqueidentifier | MKTSEGMENTATIONSEGMENT.ID | ||
| TESTSEGMENTID | uniqueidentifier | yes | MKTSEGMENTATIONTESTSEGMENT.ID | |
| SOURCECODEMAPID | uniqueidentifier | yes | MKTSOURCECODEMAP.ID |
Indexes
| Index Name | Fields | 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 | yes | yes | yes |