Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT | 10 | √ | null |
|
|
Auto-incremented primary key. |
|
| content | TEXT | 65535 | null |
|
|
Feedback content. |
||
| image | MEDIUMBLOB | 16777215 | √ | null |
|
|
Optional interface screenshot. |
|
| page_url | TEXT | 65535 | null |
|
|
The URL of the page the user was looking at. |
||
| user_id | INT | 10 | √ | null |
|
|
Optional user id if user was logged in. |
|
| contact_email | VARCHAR | 255 | null |
|
|
Contact email address. |
||
| feedback_type | enum('question', 'data_error', 'general', 'bug', 'feature_request') | 15 | general |
|
|
The type of feedback. |
||
| severity | enum('low', 'medium', 'high') | 6 | medium |
|
|
The estimated severity of the issue. |
||
| is_new | BIT | 1 | 1 |
|
|
Indicates whether this is new feedback or has been seen before. |
||
| created_on | DATETIME | 19 | √ | CURRENT_TIMESTAMP |
|
|
When this database record has been created. |
|
| updated_on | TIMESTAMP | 19 | √ | CURRENT_TIMESTAMP |
|
|
When this database record has last been updated. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| is_new | Performance | Asc | is_new |