Column Dictionary
A B C D E I L M N O P R S T U
Column	Table	Type	Description
actioncomment	filecomment	TEXT	Comment made by the actioner about the actions taken (if any)
actioncomment	projectcomment	TEXT	Comment made by the actioner about the actions taken (if any)
actiondate	filecomment	TIMESTAMP	Time when any necessary action arising from the review meeting was updated
actiondate	projectcomment	TIMESTAMP	Time when any necessary action arising from the review meeting was updated
actioner	filecomment	INTEGER	Foreign key to the user who completed the required actions
actioner	projectcomment	INTEGER	Foreign key to the user who completed the required actions
actionscomplete	filecomment	CHAR (1)	Y if actioner has signed off on all required action
actionscomplete	projectcomment	CHAR (1)	Y if actioner has signed off on all required action
baseline	fileset	VARCHAR (500)	Name of baseline in source control (optional, but recommended)
changedate	projectstatus	TIMESTAMP	Time when the project status was changed
changedby	projectstatus	INTEGER	The SystemUser who changed the status of the project
changetype	projectfile	CHAR (1)	Type of change made to this file between original and new versions. Values are: C: Changed A: Added R: Removed
comment	filecomment	TEXT	The comment itself
comment	projectcomment	TEXT	The comment itself
createdate	filecomment	TIMESTAMP	Creation time of the comment
createdate	fileset	TIMESTAMP	Creation/last modification time of the file set
createdate	project	TIMESTAMP	Creation time of the project
createdate	projectcomment	TIMESTAMP	Creation time of the comment
currentstatus	project	VARCHAR (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
directory	fileset	VARCHAR (500)	Directory relative to JCR root containing all files
directory	project	VARCHAR (200)	Directory (relative to JCR root) containing all project files
email	systemuser	VARCHAR (100)	User's email address (currently not used)
enabled	systemuser	CHAR (1)	Contains Y if the user may log in, otherwise N
issuperuser	systemuser	CHAR (1)	Contains Y if this is the sole superuser, otherwise N
linenumber	filecomment	INTEGER	Line number in the file for this comment (1-based)
modifiedfileset	project	INTEGER	Fileset with modified versions of all files in the project, i.e. the after snapshot
name	project	VARCHAR (100)	Display name for the project
name	systemuser	VARCHAR (50)	Full name of the user
newstatus	projectstatus	VARCHAR (2)	New status of the project. See Project.currentStatus for details
notes	project	TEXT	Free-form notes from the project owner, to assist reviewers
notes	projectfile	TEXT	Free-form notes to assist reviewers
originalfileset	project	INTEGER	Fileset with original versions of all files in the project, i.e. the before snapshot
originalpath	projectfile	VARCHAR (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
owner	filecomment	INTEGER	Foreign key to the user who made this comment
owner	fileset	INTEGER	The SystemUser who created the file set
owner	project	INTEGER	The SystemUser who created (and owns) the project
owner	projectcomment	INTEGER	Foreign key to the user who made this comment
owner	projectthread	INTEGER	Foreign key to the user who started this thread
password	systemuser	VARCHAR (32)	User's password, salted with the username and MD5 hashed
path	projectfile	VARCHAR (500)	Relative path to the file within the file set for the project
project	projectfile	INTEGER	The project this file belongs to
project	projectstatus	INTEGER	The project whose state was changed
project	projectthread	INTEGER	The project this thread is against
projectfile	filecomment	INTEGER	The project file this comment is against
projectthread	projectcomment	INTEGER	The project thread this comment is against
reviewactionowner	filecomment	INTEGER	Foreign key to the user tasked with actioning the review decision
reviewactionowner	projectcomment	INTEGER	Foreign key to the user tasked with actioning the review decision
reviewcomment	filecomment	TEXT	Review comment (from the review meeting)
reviewcomment	projectcomment	TEXT	Review comment (from the review meeting)
reviewdate	filecomment	TIMESTAMP	Time when the review comment was added (at the review meeting)
reviewdate	projectcomment	TIMESTAMP	Time when the review comment was added (at the review meeting)
reviewdecision	filecomment	VARCHAR (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
reviewdecision	projectcomment	VARCHAR (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
reviewer	filecomment	INTEGER	Foreign key to the comment reviewer
reviewer	projectcomment	INTEGER	Foreign key to the comment reviewer
reviewpriority	projectfile	SMALLINT	Priority of this file (1-3, 3 is highest) for reviewing
systemid	filecomment	INTEGER	System-generated primary key
systemid	fileset	INTEGER	System-generated primary key
systemid	project	INTEGER	System-generated primary key
systemid	projectcomment	INTEGER	System-generated primary key
systemid	projectfile	INTEGER	System-generated primary key
systemid	projectstatus	INTEGER	System-generated primary key
systemid	projectthread	INTEGER	System-generated primary key
systemid	systemuser	INTEGER	System-generated primary key
threadtitle	projectthread	VARCHAR (100)	Title of the thread
username	systemuser	VARCHAR (20)	The name by which the user is identified to the system. Must be unique