files

0 rows


Description

Generic information about individual files. Files are associated with application entities using linking tables such as accession_photos.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
submission_snapshots.file_id submission_snapshots_file_id_fkeyC
variable_image_values.file_id variable_image_values_file_id_fkeyR
batch_photos.file_id batch_photos_file_id_fkeyN
withdrawal_photos.file_id withdrawal_photos_photo_id_fkeyR
report_files.file_id report_files_file_id_fkeyC
report_photos.file_id report_photos_photo_id_fkeyC
thumbnails.file_id thumbnail_photo_id_fkeyR
accession_photos.file_id accession_photos_photo_id_fkeyR
observation_photos.file_id observation_photos_file_id_fkeyC
file_name text 2147483647 null
content_type text 2147483647 null
size int8 19 null
created_time timestamptz 35,6 null
modified_time timestamptz 35,6 null
created_by int8 19 √ null
users.id photos_user_id_fkeyR
storage_url text 2147483647 null
modified_by int8 19 null
users.id photos_modified_by_fkeyR
file_date date 13 √ null
width int4 10 √ null
height int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
photos_pkey Primary key Asc id
photos_storage_url_key Must be unique Asc storage_url

Check Constraints

Constraint Name Constraint
file_name_cannot_be_empty_string ((length(file_name) > 0))
content_type_cannot_be_empty_string ((length(content_type) > 0))

Relationships

Close relationships within degrees of separation