REVENUESEGMENT
Primary Key
| Primary Key | Field Type |
|---|---|
| REVENUEID | uniqueidentifier |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| REVENUEID | uniqueidentifier | FINANCIALTRANSACTION.ID | ||
| SEGMENTID | uniqueidentifier | MKTSEGMENTATIONSEGMENT.ID | ||
| TESTSEGMENTID | uniqueidentifier | yes | MKTSEGMENTATIONTESTSEGMENT.ID | |
| SOURCECODEMAPID | uniqueidentifier | yes | MKTSOURCECODEMAP.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_REVENUESEGMENT_SEGMENTID | SEGMENTID | |||
| IX_REVENUESEGMENT_SOURCECODEMAPID | SOURCECODEMAPID | |||
| IX_REVENUESEGMENT_TESTSEGMENTID | TESTSEGMENTID | |||
| PK_REVENUESEGMENT | REVENUEID | yes | yes | yes |