record_files

-1 rows


Description

Table to hold metadata of the file related to the datasets

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('record_files_id_seq'::regclass)
record_id int4 10 null
records.id record_files_record_id_fkeyC
name text 2147483647 null
checksum text 2147483647 null
file_extension_id int4 10 null
file_extensions.id record_files_file_extension_id_fkeyR
size_bytes int8 19 null
general_type text 2147483647 null
specific_type text 2147483647 null
created_at timestamp 29,6 now()
updated_at timestamp 29,6 now()

Indexes

Constraint Name Type Sort Column(s)
record_files_pkey Primary key Asc id

Check Constraints

Constraint Name Constraint
record_files_general_type_check ((general_type = ANY (ARRAY['image'::text, 'document'::text, 'tabularData'::text, 'dataCube'::text, 'dataCollection'::text, 'metadata'::text])))

Relationships

Close relationships within degrees of separation