Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||
| backupid | VARCHAR | 32 |
|
|
backupid the log record belongs to |
|||||
| loglevel | SMALLINT | 5 | null |
|
|
level of the log (debug…error) |
||||
| message | LONGTEXT | 2147483647 | null |
|
|
text logged |
||||
| timecreated | BIGINT | 19 | null |
|
|
timestamp this log entry was created |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| backlogs_bac_ix | Performance | Asc | backupid |
| backlogs_bacid_uix | Must be unique | Asc/Asc | backupid + id |