file

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('file_id_seq'::regclass)
unique_id varchar 2147483647 null
original_filename varchar 2147483647 null
user_id int4 10 √ null
user.id file_user_id_fkeyR
template_id int4 10 √ null
template.id file_template_id_fkeyR
application_serial varchar 2147483647 √ null
application.serial file_application_serial_fkeyR
application_response_id int4 10 √ null
application_response.id file_application_response_id_fkeyR
file_path varchar 2147483647 null
thumbnail_path varchar 2147483647 √ null
mimetype varchar 2147483647 √ null
submitted bool 1 √ false
timestamp timestamptz 35,6 √ CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
file_pkey Primary key Asc id
file_unique_id_key Must be unique Asc unique_id

Relationships

Close relationships within degrees of separation