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 |