Table: fileset
Represents a set of files that can be used by one or more review projects.
Each set can be either uploaded as a tarball, or extracted from source control
Columns
NameTypeConstraintsDescription
systemidINTEGERNOT NULLSystem-generated primary key
ownerINTEGERNOT NULLThe SystemUser who created the file set
createdateTIMESTAMPNOT NULLCreation/last modification time of the file set
directoryVARCHAR (500)Directory relative to JCR root containing all files
baselineVARCHAR (500)Name of baseline in source control (optional, but recommended)
Primary key
NameColumnsDescription
pk_filesetsystemid
Foreign keys
NameColumnsReferenced tableDescription
fk_fileset_systemuserownersystemuser
Incoming foreign keys
NameColumnsReferencing tableDescription
fk_project_originalfilesetoriginalfilesetproject
fk_project_modifiedfilesetmodifiedfilesetproject

Schema diagram