Table: Archive Submissions Status History
Primary Key: Submission
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Submission Status History ID | Long | 4 | ✓ | |
| Submission ID | Long | 4 | ||
| Submission Status ID | Long | 4 | ||
| Submission Status Notes | Text | 255 | ||
| Date Status Changed | DateTime | 8 | ||
| Status Modified By | Text | 255 |
Indexes
- Archive Submissions Status History$PrimaryKey [PRIMARY KEY] [UNIQUE]