Backup Logs Table Schema (backup_logs)


Description

To store all the logs from backup and restore operations (by db logger)

backup_logs table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
backupid VARCHAR 32
backup_controllers.backupid backlogs_bac2_fk R

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

Table contained -1 rows

backup_logs table 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

backup_logs table relationships

Close relationships within degrees of separation