| Table: project | |||
| Represents a code review project | |||
| Columns | |||
| Name | Type | Constraints | Description |
| systemid | INTEGER | NOT NULL | System-generated primary key |
| name | VARCHAR (100) | NOT NULL | Display name for the project |
| owner | INTEGER | NOT NULL | The SystemUser who created (and owns) the project |
| createdate | TIMESTAMP | NOT NULL | Creation time of the project |
| directory | VARCHAR (200) | NOT NULL | Directory (relative to JCR root) containing all project files |
| currentstatus | VARCHAR (10) | NOT NULL | Current status of the project. Values are: SI: Setup - initial SD: Setup - generating diffs SF: Setup - selecting files RP: Review - preparation RM: Review - meeting C: Complete |
| originalfileset | INTEGER | Fileset with original versions of all files in the project, i.e. the before snapshot | |
| modifiedfileset | INTEGER | Fileset with modified versions of all files in the project, i.e. the after snapshot | |
| notes | TEXT | Free-form notes from the project owner, to assist reviewers | |
| Primary key | |||
| Name | Columns | Description | |
| pk_project | systemid | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| fk_project_systemuser | owner | systemuser | |
| fk_project_originalfileset | originalfileset | fileset | |
| fk_project_modifiedfileset | modifiedfileset | fileset | |
| Incoming foreign keys | |||
| Name | Columns | Referencing table | Description |
| fk_projectstatus_project | project | projectstatus | |
| fk_projectthread_project | project | projectthread | |
| fk_projectfile_project | project | projectfile | |