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