Table: Marketing Sub Campaigns
Primary Key: Marketing
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Marketing Sub Campaign ID | Long | 4 | ✓ | |
| Marketing Campaign ID | Long | 4 | ||
| Marketing Channel | Text | 255 | ||
| Marketing Sub Campaign Start Date | DateTime | 8 | ||
| Marketing Sub Campaign End Date | DateTime | 8 | ||
| Marketing Sub Campaign Spend | Double | 8 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ |
Indexes
- Marketing Sub Campaigns$Marketing Campaign ID
- Marketing Sub Campaigns$PrimaryKey [PRIMARY KEY] [UNIQUE]