Table: Purple Panelists
Primary Key: Purple
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Purple Panelist ID | Long | 4 | ✓ | |
| Purple Panel ID | Long | 4 | ||
| Purple Panelist | Text | 255 | ||
| Business Area | Text | 255 | ||
| Purple Panelist Total Score | Double | 8 | ||
| Possible Total Score | Double | 8 | ||
| Convener | Boolean | 1 | ||
| Questions | Memo | - | ||
| Submitted | Boolean | 1 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ |
Indexes
- Purple Panelists$PrimaryKey [PRIMARY KEY] [UNIQUE]
- Purple Panelists$Purple Panel Details ID
- Purple Panelists$Purple Panel ID