library_files

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
file_id bigserial 19 nextval('library_files_file_id_seq'::regclass)
library_file_settings.file_id library_file_settings_file_id_foreignC
context_id int8 19 null
servers.server_id library_files_context_idC
file_name varchar 255 null
original_file_name varchar 255 null
file_type varchar 255 null
file_size int8 19 null
type int2 5 null
date_uploaded timestamp 22 null
date_modified timestamp 22 null
submission_id int8 19 null
submissions.submission_id library_files_submission_id_foreignC
public_access int2 5 '0'::smallint

Indexes

Constraint Name Type Sort Column(s)
library_files_pkey Primary key Asc file_id
library_files_context_id Performance Asc context_id
library_files_submission_id Performance Asc submission_id

Relationships