Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| comment_id | INT | 10 | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
||
| comment_type_id | INT | 10 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
| comment_type | VARCHAR | 50 | √ |
|
|
This could include ‘germinatebase’ or ‘markers’ to define the table that the comment relates to. |
||
| comment_foreign_id | INT | 10 | 0 |
|
|
Relates to the UID of the table to which the comment relates |
||
| user_id | INT | 10 | √ | null |
|
|
Foreign key to Gatekeeper users (Gatekeeper users.id). |
|
| user_name | CHAR | 0 |
|
|
||||
| comment_content | MEDIUMTEXT | 16777215 | null |
|
|
The comment content. |
||
| updated_on | TIMESTAMP | 26 | √ | null |
|
|
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record. |