data_attachmentfile


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('data_attachmentfile_id_seq'::regclass)
file_type varchar 10 null
title varchar 255 √ null
url varchar 255 null
additional_info jsonb 2147483647 null
tag varchar 50 null
original_url varchar 255 null
allegation_id int4 10 null
data_allegation.id data_attachmentfil_allegation_id_1b6443a8_fk_data_allegation_id R
created_at timestamptz 35,6 √ null
last_updated timestamptz 35,6 √ null
preview_image_url varchar 255 √ null

Table contained 3418 rows

Indexes

Constraint Name Type Sort Column(s)
data_attachmentfile_pkey Primary key Asc id
data_attachmentfile_196c2a24 Performance Asc original_url
data_attachmentfile_572d4e42 Performance Asc url
data_attachmentfile_68a7d484 Performance Asc file_type
data_attachmentfile_6d48f909 Performance Asc allegation_id
data_attachmentfile_allegation_id_e5c0e493_uniq Must be unique Asc/Asc allegation_id + original_url
data_attachmentfile_file_type_28f6a0c3_like Performance Asc file_type
data_attachmentfile_original_url_a70b5f02_like Performance Asc original_url
data_attachmentfile_url_89b39fb4_like Performance Asc url

Relationships

Close relationships within degrees of separation