Table: Products
Primary Key: Product
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Product ID | Long | 4 | ✓ | |
| Product | Text | 255 | ✓ | |
| Certificate Programme Name | Text | 255 | ||
| Product Code | Text | 255 | ||
| Pipeline ID | Long | 4 | ||
| Last Modified By | Text | 255 | ||
| Date Modified | DateTime | 8 | ||
| Active | Boolean | 1 | ||
| Programme Year Length | Double | 8 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ |
Indexes
- Products$Pipeline ID
- Products$PrimaryKey [PRIMARY KEY] [UNIQUE]