Column Dictionary
A B C D E I L M N O P R S T U
ColumnTableTypeDescription
actioncommentfilecommentTEXTComment made by the actioner about the actions taken (if any)
actioncommentprojectcommentTEXTComment made by the actioner about the actions taken (if any)
actiondatefilecommentTIMESTAMPTime when any necessary action arising from the review meeting was updated
actiondateprojectcommentTIMESTAMPTime when any necessary action arising from the review meeting was updated
actionerfilecommentINTEGERForeign key to the user who completed the required actions
actionerprojectcommentINTEGERForeign key to the user who completed the required actions
actionscompletefilecommentCHAR (1)Y if actioner has signed off on all required action
actionscompleteprojectcommentCHAR (1)Y if actioner has signed off on all required action
baselinefilesetVARCHAR (500)Name of baseline in source control (optional, but recommended)
changedateprojectstatusTIMESTAMPTime when the project status was changed
changedbyprojectstatusINTEGERThe SystemUser who changed the status of the project
changetypeprojectfileCHAR (1)Type of change made to this file between original and new versions. Values are:
C: Changed
A: Added
R: Removed
commentfilecommentTEXTThe comment itself
commentprojectcommentTEXTThe comment itself
createdatefilecommentTIMESTAMPCreation time of the comment
createdatefilesetTIMESTAMPCreation/last modification time of the file set
createdateprojectTIMESTAMPCreation time of the project
createdateprojectcommentTIMESTAMPCreation time of the comment
currentstatusprojectVARCHAR (10)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
directoryfilesetVARCHAR (500)Directory relative to JCR root containing all files
directoryprojectVARCHAR (200)Directory (relative to JCR root) containing all project files
emailsystemuserVARCHAR (100)User's email address (currently not used)
enabledsystemuserCHAR (1)Contains Y if the user may log in, otherwise N
issuperusersystemuserCHAR (1)Contains Y if this is the sole superuser, otherwise N
linenumberfilecommentINTEGERLine number in the file for this comment (1-based)
modifiedfilesetprojectINTEGERFileset with modified versions of all files in the project, i.e. the after snapshot
nameprojectVARCHAR (100)Display name for the project
namesystemuserVARCHAR (50)Full name of the user
newstatusprojectstatusVARCHAR (2)New status of the project. See Project.currentStatus for details
notesprojectTEXTFree-form notes from the project owner, to assist reviewers
notesprojectfileTEXTFree-form notes to assist reviewers
originalfilesetprojectINTEGERFileset with original versions of all files in the project, i.e. the before snapshot
originalpathprojectfileVARCHAR (500)Optional relative path to the original version of the file within the original file set for the project. Used when the file has been renamed or moved
ownerfilecommentINTEGERForeign key to the user who made this comment
ownerfilesetINTEGERThe SystemUser who created the file set
ownerprojectINTEGERThe SystemUser who created (and owns) the project
ownerprojectcommentINTEGERForeign key to the user who made this comment
ownerprojectthreadINTEGERForeign key to the user who started this thread
passwordsystemuserVARCHAR (32)User's password, salted with the username and MD5 hashed
pathprojectfileVARCHAR (500)Relative path to the file within the file set for the project
projectprojectfileINTEGERThe project this file belongs to
projectprojectstatusINTEGERThe project whose state was changed
projectprojectthreadINTEGERThe project this thread is against
projectfilefilecommentINTEGERThe project file this comment is against
projectthreadprojectcommentINTEGERThe project thread this comment is against
reviewactionownerfilecommentINTEGERForeign key to the user tasked with actioning the review decision
reviewactionownerprojectcommentINTEGERForeign key to the user tasked with actioning the review decision
reviewcommentfilecommentTEXTReview comment (from the review meeting)
reviewcommentprojectcommentTEXTReview comment (from the review meeting)
reviewdatefilecommentTIMESTAMPTime when the review comment was added (at the review meeting)
reviewdateprojectcommentTIMESTAMPTime when the review comment was added (at the review meeting)
reviewdecisionfilecommentVARCHAR (50)Action required on this comment, as decided in the review meeting. Values are:
NA: No action required
CI: Comment incorrect
UF: Urgent fix required
FR: Fix before release
ER: Raise ER
DR: Raise DR
reviewdecisionprojectcommentVARCHAR (50)Action required on this comment, as decided in the review meeting. Values are:
NA: No action required
CI: Comment incorrect
UF: Urgent fix required
FR: Fix before release
ER: Raise ER
DR: Raise DR
reviewerfilecommentINTEGERForeign key to the comment reviewer
reviewerprojectcommentINTEGERForeign key to the comment reviewer
reviewpriorityprojectfileSMALLINTPriority of this file (1-3, 3 is highest) for reviewing
systemidfilecommentINTEGERSystem-generated primary key
systemidfilesetINTEGERSystem-generated primary key
systemidprojectINTEGERSystem-generated primary key
systemidprojectcommentINTEGERSystem-generated primary key
systemidprojectfileINTEGERSystem-generated primary key
systemidprojectstatusINTEGERSystem-generated primary key
systemidprojectthreadINTEGERSystem-generated primary key
systemidsystemuserINTEGERSystem-generated primary key
threadtitleprojectthreadVARCHAR (100)Title of the thread
usernamesystemuserVARCHAR (20)The name by which the user is identified to the system. Must be unique