| Table: projectstatus | |||
| Records the history of status changes to each project | |||
| Columns | |||
| Name | Type | Constraints | Description |
| systemid | INTEGER | NOT NULL | System-generated primary key |
| project | INTEGER | NOT NULL | The project whose state was changed |
| changedby | INTEGER | NOT NULL | The SystemUser who changed the status of the project |
| changedate | TIMESTAMP | NOT NULL | Time when the project status was changed |
| newstatus | VARCHAR (2) | NOT NULL | New status of the project. See Project.currentStatus for details |
| Primary key | |||
| Name | Columns | Description | |
| pk_projectstatus | systemid | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| fk_projectstatus_project | project | project | |
| fk_projectstatus_changedBy | changedby | systemuser | |