files

0 rows


Description

description of files, content is stored in sha1 file pool

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
analytics_used_files.fileid analusedfile_fil2_fkR
file_conversion.destfileid fileconv_des2_fkR
file_conversion.sourcefileid fileconv_sou2_fkR
contenthash VARCHAR 40
pathnamehash VARCHAR 40
contextid BIGINT 19 null
context.id file_con2_fkR
component VARCHAR 100
filearea VARCHAR 50
itemid BIGINT 19 null
filepath VARCHAR 255
filename VARCHAR 255
userid BIGINT 19 √ null
user.id file_use2_fkR
filesize BIGINT 19 null
mimetype VARCHAR 100 √ null
status BIGINT 19 0
source LONGTEXT 2147483647 √ null
author VARCHAR 255 √ null
license VARCHAR 255 √ null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
sortorder BIGINT 19 0
referencefileid BIGINT 19 √ null
files_reference.id file_ref2_fkR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
file_comfilconite2_ix Performance Asc/Asc/Asc/Asc component + filearea + contextid + itemid
file_con3_ix Performance Asc contenthash
file_con5_ix Performance Asc contextid
file_lic2_ix Performance Asc license
file_pat2_uix Must be unique Asc pathnamehash
file_ref4_ix Performance Asc referencefileid
file_use4_ix Performance Asc userid

Relationships

Close relationships within degrees of separation