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 |