Table: filecomment
Review comments made against lines in a file
Columns
Name	Type	Constraints	Description
systemid	INTEGER	NOT NULL	System-generated primary key
projectfile	INTEGER	NOT NULL	The project file this comment is against
linenumber	INTEGER	NOT NULL	Line number in the file for this comment (1-based)
owner	INTEGER	NOT NULL	Foreign key to the user who made this comment
createdate	TIMESTAMP	NOT NULL	Creation time of the comment
comment	TEXT	NOT NULL	The comment itself
reviewdate	TIMESTAMP		Time when the review comment was added (at the review meeting)
reviewcomment	TEXT		Review comment (from the review meeting)
reviewer	INTEGER		Foreign key to the comment reviewer
reviewdecision	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
reviewactionowner	INTEGER		Foreign key to the user tasked with actioning the review decision
actiondate	TIMESTAMP		Time when any necessary action arising from the review meeting was updated
actioncomment	TEXT		Comment made by the actioner about the actions taken (if any)
actioner	INTEGER		Foreign key to the user who completed the required actions
actionscomplete	CHAR (1)		Y if actioner has signed off on all required action
Primary key
Name	Columns		Description
pk_filecomment	systemid
Foreign keys
Name	Columns	Referenced table	Description
fk_filecomment_projectfile	projectfile	projectfile
fk_filecomment_systemuser_owner	owner	systemuser
fk_filecom_systemuser_reviewer	reviewer	systemuser
fk_filecom_systemuser_revaction	reviewactionowner	systemuser
fk_filecom_systemuser_actioner	actioner	systemuser
Indexes
Name	Columns		Description
in_filecomment_owner	owner
in_filecomment_reviewer	reviewer
in_filecomment_revaction	reviewactionowner
in_filecomment_actioner	actioner