COMMENT
This table holds the details of the comments for the particular approval record.
Column Descriptions:
| Name | Type | Description |
|---|---|---|
| COMMENT_ID | INT4 NOT NULL | The unique identifier for the comment |
| APPROVAL_ID | INT4 NOT NULL | Reference for the approval record for which the comment is added. |
| CREATED_BY | INT4 NOT NULL | User Id of the user who added the comment. |
| COMMENT | TEXT | Content of the comment. |
| COMMENT_USER_DETAILS | JSONB |
User details of the administrator who added this comment. Structure of jsonb : { "userFirstName": First name of the administrator, "userLastName": Last name of the administrator, "userLogonId": Logon Id of the administrator } |
| CREATED_TIME | TIMESTAMP | Time when the comment is created |
| UPDATED_TIME | TIMESTAMP | Time when the comment is updated |
Indexes:
| Name | Column Names | Type |
|---|---|---|
| COMMENT_PKEY | COMMENT_ID | Primary Key |
Constrained by parent tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
|---|---|---|---|---|
| COMMENT_APPROVAL_ID_FKEY | APPROVAL_ID | APPROVAL | APPROVAL_ID | Simple |