0 rows


To store the backup_controllers as they are used


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
backupid VARCHAR 32
backup_logs.backupid backlogs_bac2_fkR
operation VARCHAR 20 backup
type VARCHAR 10
itemid BIGINT 19 null
format VARCHAR 20
interactive SMALLINT 5 null
purpose SMALLINT 5 null
userid BIGINT 19 null backcont_use2_fkR
status SMALLINT 5 null
execution SMALLINT 5 null
executiontime BIGINT 19 null
checksum VARCHAR 32
timecreated BIGINT 19 null
timemodified BIGINT 19 null
progress DECIMAL 15,14 0.00000000000000
controller LONGTEXT 2147483647 null


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
backcont_bac2_uix Must be unique Asc backupid
backcont_typite2_ix Performance Asc/Asc type + itemid
backcont_use4_ix Performance Asc userid
backcont_useite2_ix Performance Asc/Asc userid + itemid