Table: filecomment
Review comments made against lines in a file
Columns
NameTypeConstraintsDescription
systemidINTEGERNOT NULLSystem-generated primary key
projectfileINTEGERNOT NULLThe project file this comment is against
linenumberINTEGERNOT NULLLine number in the file for this comment (1-based)
ownerINTEGERNOT NULLForeign key to the user who made this comment
createdateTIMESTAMPNOT NULLCreation time of the comment
commentTEXTNOT NULLThe comment itself
reviewdateTIMESTAMPTime when the review comment was added (at the review meeting)
reviewcommentTEXTReview comment (from the review meeting)
reviewerINTEGERForeign key to the comment reviewer
reviewdecisionVARCHAR (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
reviewactionownerINTEGERForeign key to the user tasked with actioning the review decision
actiondateTIMESTAMPTime when any necessary action arising from the review meeting was updated
actioncommentTEXTComment made by the actioner about the actions taken (if any)
actionerINTEGERForeign key to the user who completed the required actions
actionscompleteCHAR (1)Y if actioner has signed off on all required action
Primary key
NameColumnsDescription
pk_filecommentsystemid
Foreign keys
NameColumnsReferenced tableDescription
fk_filecomment_projectfileprojectfileprojectfile
fk_filecomment_systemuser_ownerownersystemuser
fk_filecom_systemuser_reviewerreviewersystemuser
fk_filecom_systemuser_revactionreviewactionownersystemuser
fk_filecom_systemuser_actioneractionersystemuser
Indexes
NameColumnsDescription
in_filecomment_ownerowner
in_filecomment_reviewerreviewer
in_filecomment_revactionreviewactionowner
in_filecomment_actioneractioner

Schema diagram