Table: Temp Purple Panelists Summary
Primary Key: Purple
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Purple Panelist ID | Long | 4 | ✓ | |
| Purple Panel ID | Long | 4 | ||
| Panelist Number | 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 | - |
Indexes
- PanelistNumber
- PrimaryKey [PRIMARY KEY] [UNIQUE]