MKTPREACTIVATION
Stores relationship information between a given business process status record and a marketing effort.
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | uniqueidentifier |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| BUSINESSPROCESSSTATUSID | uniqueidentifier | BUSINESSPROCESSSTATUS.ID | The business process status row for this set of record counts. | |
| SEGMENTATIONID | uniqueidentifier | yes | MKTSEGMENTATION.ID | The segmentation associated with this business process status. |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_MKTPREACTIVATION_BUSINESSPROCESSSTATUSID | BUSINESSPROCESSSTATUSID | |||
| IX_MKTPREACTIVATION_SEGMENTATIONID | SEGMENTATIONID | |||
| PK_MKTPREACTIVATION | ID | yes | yes | yes |