app_files

5 rows


Description

description of files, content is stored in sha1 file pool

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_files_id_seq'::regclass)
app_file_conversion.destfileid Defined in XMLR
app_file_conversion.sourcefileid Defined in XMLR
contenthash varchar 40 ''::character varying
pathnamehash varchar 40 ''::character varying
contextid int8 19 null
app_context.id Defined in XMLR
component varchar 100 ''::character varying
filearea varchar 50 ''::character varying
itemid int8 19 null
filepath varchar 255 ''::character varying
filename varchar 255 ''::character varying
userid int8 19 √ null
app_user.id Defined in XMLR
filesize int8 19 null
mimetype varchar 100 √ null
status int8 19 0
source text 2147483647 √ null
author varchar 255 √ null
license varchar 255 √ null
timecreated int8 19 null
timemodified int8 19 null
sortorder int8 19 0
referencefileid int8 19 √ null
app_files_reference.id Defined in XMLR

Indexes

Constraint Name Type Sort Column(s)
app_file_id_pk Primary key Asc id
app_file_comfilconite_ix Performance Asc/Asc/Asc/Asc component + filearea + contextid + itemid
app_file_con2_ix Performance Asc contextid
app_file_con_ix Performance Asc contenthash
app_file_pat_uix Must be unique Asc pathnamehash
app_file_ref_ix Performance Asc referencefileid
app_file_use_ix Performance Asc userid

Relationships

Close relationships within degrees of separation