5 rows


description of files, content is stored in sha1 file pool


Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_files_id_seq'::regclass)
contenthash varchar 40 ''::character varying
pathnamehash varchar 40 ''::character varying
contextid int8 19 null 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 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 Defined in XMLR


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