Table: Sub Products
Primary Key: Sub
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Sub Product ID | Long | 4 | ✓ | |
| Sub Product | Text | 255 | ||
| BBBEE Pillar | Text | 255 | ||
| Frequency | Text | 255 | ||
| Active | Boolean | 1 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ |
Indexes
- PK_Sub Products [PRIMARY KEY] [UNIQUE]
Primary Key: Sub
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Sub Product ID | Long | 4 | ✓ | |
| Sub Product | Text | 255 | ||
| BBBEE Pillar | Text | 255 | ||
| Frequency | Text | 255 | ||
| Active | Boolean | 1 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ |