app_files_reference

0 rows


Description

Store files references

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_files_reference_id_seq'::regclass)
app_files.referencefileid Defined in XMLR
repositoryid int8 19 null
app_repository_instances.id Defined in XMLR
lastsync int8 19 null
reference text 2147483647 null
referencehash varchar 40 ''::character varying

Indexes

Constraint Name Type Sort Column(s)
app_filerefe_id_pk Primary key Asc id
app_filerefe_refrep_uix Must be unique Asc/Asc referencehash + repositoryid
app_filerefe_rep_ix Performance Asc repositoryid

Relationships