Table: Purple Panelists Scores
Primary Key: Purple
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Purple Panelist Score ID | Long | 4 | ✓ | |
| Purple Panelist ID | Long | 4 | ||
| Rubric Metric Template ID | Long | 4 | ||
| Purple Panelist Score | Long | 4 | ||
| DELETE Purple Panelist Score Evidence 1 | Text | 255 | ||
| DELETE Purple Panelist Score Evidence 2 | Text | 255 | ||
| DELETE Purple Panelist Score Evidence 3 | Text | 255 | ||
| DELETE Purple Panelist Score Evidence 4 | Text | 255 | ||
| DELETE Purple Panelist Score Evidence 5 | Text | 255 | ||
| Unused | Boolean | 1 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ |
Indexes
- Purple Panelists Scores$PrimaryKey [PRIMARY KEY] [UNIQUE]
- Purple Panelists Scores$Purple Panel Details ID
- Purple Panelists Scores$Purple Panel ID
- Purple Panelists Scores$Rubric Metric ID