files_file


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('files_file_id_seq'::regclass)
difs_debuginformationfile.file_id difs_debuginformationfile_file_id_0f375ae8_fk_files_file_id R
files_fileblobindex.file_id files_fileblobindex_file_id_3be1680c_fk_files_file_id R
releases_releasefile.file_id releases_releasefile_file_id_c31c0d06_fk_files_file_id R
created timestamptz 35,6 null
name text 2147483647 null
headers jsonb 2147483647 √ null
size int4 10 √ null
checksum varchar 40 √ null
type varchar 64 null
blob_id int8 19 √ null
files_fileblob.id files_file_blob_id_ac0e8c7e_fk_files_fileblob_id R

Indexes

Constraint Name Type Sort Column(s)
files_file_pkey Primary key Asc id
files_file_blob_id_ac0e8c7e Performance Asc blob_id
files_file_checksum_cfc180a4 Performance Asc checksum
files_file_checksum_cfc180a4_like Performance Asc checksum
files_file_created_f8bb89d7 Performance Asc created

Check Constraints

Constraint Name Constraint
files_file_size_check ((size >= 0))

Relationships

Close relationships within degrees of separation