Table: projectcomment
Review comments made against a project thread
Columns
Name	Type	Constraints	Description
systemid	INTEGER	NOT NULL	System-generated primary key
projectthread	INTEGER	NOT NULL	The project thread this comment is against
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_projectcomment	systemid
Foreign keys
Name	Columns	Referenced table	Description
fk_projectcomment_projectthread	projectthread	projectthread
fk_projectcomment_systemuser_owner	owner	systemuser
fk_projectcom_systemuser_reviewer	reviewer	systemuser
fk_projectcom_systemuser_revaction	reviewactionowner	systemuser
fk_projectcom_systemuser_actioner	actioner	systemuser
Indexes
Name	Columns		Description
in_projectcomment_projectthread	projectthread
in_projectcomment_owner	owner
in_projectcomment_reviewer	reviewer
in_projectcomment_revaction	reviewactionowner
in_projectcomment_actioner	actioner