bac_ins_f_au_work_declaration

30 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
bac_ins_f_au.work_declaration_id fk_bac_ins_f_au_on_work_declaration R
deleted_by varchar 255 √ null
deleted_date timestamp 29,6 √ null
version int4 10 null
created_by varchar 255 √ null
created_date timestamp 29,6 √ null
last_modified_by varchar 255 √ null
last_modified_date timestamp 29,6 √ null
form_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_work_declaration_on_form_document R
form_document_comment varchar 2048 √ null
site_plan_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_work_declaration_on_site_plan_document R
site_plan_document_comment varchar 2048 √ null
ground_plan_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_work_declaration_on_ground_plan_document R
ground_plan_document_comment varchar 2048 √ null
section_plan_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_work_declaration_on_section_plan_document R
section_plan_document_comment varchar 2048 √ null
facade_roof_plan_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_work_declaration_on_facade_roof_plan_document R
facade_roof_plan_document_comment varchar 2048 √ null
external_appearance_drawing_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfauworkdeclaration_on_externalappearancedrawingdocumen R
external_appearance_drawing_document_comment varchar 2048 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_bac_ins_f_au_work_declaration Primary key Asc id
idx_bac_ins_f_au_work_declaration_external_appearance_drawing_d Performance Asc external_appearance_drawing_document_id
idx_bac_ins_f_au_work_declaration_facade_roof_plan_document Performance Asc facade_roof_plan_document_id
idx_bac_ins_f_au_work_declaration_form_document Performance Asc form_document_id
idx_bac_ins_f_au_work_declaration_ground_plan_document Performance Asc ground_plan_document_id
idx_bac_ins_f_au_work_declaration_section_plan_document Performance Asc section_plan_document_id
idx_bac_ins_f_au_work_declaration_site_plan_document Performance Asc site_plan_document_id

Relationships

Close relationships within degrees of separation