data_attachmentfile

48478 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('data_attachmentfile_id_seq'::regclass)
analytics_attachmenttracking.attachment_file_id analytics_attachment_attachment_file_id_be5b1f6c_fk_data_attaR
data_attachmentfile_tags.attachmentfile_id data_attachmentfile__attachmentfile_id_2f07157b_fk_data_attaR
data_attachmentnarrative.attachment_id data_attachmentnarra_attachment_id_2586f1f8_fk_data_attaR
data_attachmentocr.attachment_id data_attachmentocr_attachment_id_fd91a419_fk_data_attaR
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
external_created_at timestamptz 35,6 √ null
external_last_updated timestamptz 35,6 √ null
preview_image_url varchar 255 √ null
external_id varchar 255 null
source_type varchar 255 null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
text_content text 2147483647 null
allegation_id varchar 30 √ null
data_allegation.crid data_attachmentfile_allegation_id_1b6443a8_fk_data_alleR
downloads_count int4 10 null
views_count int4 10 null
show bool 1 null
notifications_count int4 10 null
pages int4 10 null
manually_updated bool 1 null
last_updated_by_id int4 10 √ null
auth_user.id data_attachmentfile_last_updated_by_id_061dfbf8_fk_auth_user_idR
pending_documentcloud_id varchar 255 √ null
upload_fail_attempts int4 10 null
reprocess_text_count int4 10 null
is_external_ocr bool 1 null
owner_id varchar 30 √ null
owner_type_id int4 10 √ null
django_content_type.id data_attachmentfile_owner_type_id_ca124790_fk_django_coR

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_allegation_id_1b6443a8 Performance Asc allegation_id
data_attachmentfile_allegation_id_1b6443a8_like Performance Asc allegation_id
data_attachmentfile_external_id_d823de40 Performance Asc external_id
data_attachmentfile_external_id_d823de40_like Performance Asc external_id
data_attachmentfile_file_type_28f6a0c3_like Performance Asc file_type
data_attachmentfile_last_updated_by_id_061dfbf8 Performance Asc last_updated_by_id
data_attachmentfile_original_url_a70b5f02_like Performance Asc original_url
data_attachmentfile_owner_id_owner_type_id_e_f16b8b6a_uniq Must be unique Asc/Asc/Asc/Asc owner_id + owner_type_id + external_id + source_type
data_attachmentfile_owner_type_id_ca124790 Performance Asc owner_type_id
data_attachmentfile_source_type_534b7b9f Performance Asc source_type
data_attachmentfile_source_type_534b7b9f_like Performance Asc source_type
data_attachmentfile_url_89b39fb4_like Performance Asc url

Relationships

Close relationships within degrees of separation