dref_dreffile

7907 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('dref_dreffile_id_seq'::regclass)
dref_dref.assessment_report_id dref_dref_assessment_report_id_dcea7432_fk_dref_dreffile_idR
dref_dref.budget_file_id dref_dref_budget_file_id_3f1fe5b7_fk_dref_dreffile_idR
dref_dref.cover_image_id dref_dref_cover_image_id_1bb89e28_fk_dref_dreffile_idR
dref_dref.disaster_category_analysis_id dref_dref_disaster_category_an_b4518c58_fk_dref_drefR
dref_dref.event_map_id dref_dref_event_map_id_6ae73808_fk_dref_dreffile_idR
dref_dref.supporting_document_id dref_dref_supporting_document_id_9a35260a_fk_dref_dreffile_idR
dref_dref.targeting_strategy_support_file_id dref_dref_targeting_strategy_s_3fc2ba27_fk_dref_drefR
dref_dref_images.dreffile_id dref_dref_images_dreffile_id_459b9eff_fk_dref_dreffile_idR
dref_dreffinalreport.assessment_report_id dref_dreffinalreport_assessment_report_id_9dea4a31_fk_dref_drefR
dref_dreffinalreport.cover_image_id dref_dreffinalreport_cover_image_id_952ffee3_fk_dref_drefR
dref_dreffinalreport.event_map_id dref_dreffinalreport_event_map_id_2f01110e_fk_dref_dreffile_idR
dref_dreffinalreport.financial_report_id dref_dreffinalreport_financial_report_id_71c11a06_fk_dref_drefR
dref_dreffinalreport_images.dreffile_id dref_dreffinalreport_dreffile_id_fd6383de_fk_dref_drefR
dref_dreffinalreport_photos.dreffile_id dref_dreffinalreport_dreffile_id_a021dcc6_fk_dref_drefR
dref_drefoperationalupdate.assessment_report_id dref_drefoperational_assessment_report_id_8db93878_fk_dref_drefR
dref_drefoperationalupdate.budget_file_id dref_drefoperational_budget_file_id_f7796e11_fk_dref_drefR
dref_drefoperationalupdate.cover_image_id dref_drefoperational_cover_image_id_5ab0aaba_fk_dref_drefR
dref_drefoperationalupdate.event_map_id dref_drefoperational_event_map_id_dcc925b0_fk_dref_drefR
dref_drefoperationalupdate_images.dreffile_id dref_drefoperational_dreffile_id_2ce244b9_fk_dref_drefR
dref_drefoperationalupdate_photos.dreffile_id dref_drefoperational_dreffile_id_2e34a54a_fk_dref_drefR
file varchar 100 null
created_by_id int4 10 √ null
auth_user.id dref_dreffile_created_by_id_1a1c840a_fk_auth_user_idR
caption varchar 225 √ null
client_id varchar 50 √ null
caption_ar varchar 225 √ null
caption_en varchar 225 √ null
caption_es varchar 225 √ null
caption_fr varchar 225 √ null
translation_module_original_language varchar 2 null
translation_module_skip_auto_translation bool 1 null

Indexes

Constraint Name Type Sort Column(s)
dref_dreffile_pkey Primary key Asc id
dref_dreffile_created_by_id_1a1c840a Performance Asc created_by_id

Relationships

Close relationships within degrees of separation