Backup Trusted Files Table Schema (backup_trusted_files)


Description

List of files that are trusted

backup_trusted_files table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
contenthash VARCHAR 40

SHA1 has of the file content, the same as in files table
filesize BIGINT 19 null
backupid VARCHAR 32 √ null

id of the backup if known
timeadded BIGINT 19 null

when was this content hash registered as secure
userid BIGINT 19 null
user.id backtrusfile_use2_fk R

logged in user at the time of registration

Table contained -1 rows

backup_trusted_files table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
backtrusfile_con_uix Must be unique Asc contenthash
backtrusfile_use_ix Performance Asc userid

backup_trusted_files table relationships

Close relationships within degrees of separation