Table: project
Represents a code review project
Columns
NameTypeConstraintsDescription
systemidINTEGERNOT NULLSystem-generated primary key
nameVARCHAR (100)NOT NULLDisplay name for the project
ownerINTEGERNOT NULLThe SystemUser who created (and owns) the project
createdateTIMESTAMPNOT NULLCreation time of the project
directoryVARCHAR (200)NOT NULLDirectory (relative to JCR root) containing all project files
currentstatusVARCHAR (10)NOT NULLCurrent 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
originalfilesetINTEGERFileset with original versions of all files in the project, i.e. the before snapshot
modifiedfilesetINTEGERFileset with modified versions of all files in the project, i.e. the after snapshot
notesTEXTFree-form notes from the project owner, to assist reviewers
Primary key
NameColumnsDescription
pk_projectsystemid
Foreign keys
NameColumnsReferenced tableDescription
fk_project_systemuserownersystemuser
fk_project_originalfilesetoriginalfilesetfileset
fk_project_modifiedfilesetmodifiedfilesetfileset
Incoming foreign keys
NameColumnsReferencing tableDescription
fk_projectstatus_projectprojectprojectstatus
fk_projectthread_projectprojectprojectthread
fk_projectfile_projectprojectprojectfile

Schema diagram