bac_ins_f_db

28 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 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
deleted_by varchar 255 √ null
deleted_date timestamp 29,6 √ null
order_number varchar 255 √ null
request_date date 13 √ null
urbanism_authorization_inspection_id uuid 2147483647 √ null
ins_inspection.id fk_bac_ins_f_db_on_urbanism_authorization_inspection R
urbanism_authorization_request_reference varchar 255 √ null
urbanism_authorization_request_order_date date 13 √ null
connection_nature_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_db_on_connection_nature R
request_nature_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_db_on_request_nature R
building_type_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_db_on_building_type R
housing_type_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_db_on_housing_type R
usage_type_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_db_on_usage_type R
preliminary_visit_id uuid 2147483647 √ null
connection_lift_pump_required_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_db_on_connection_lift_pump_required R
requestor_id uuid 2147483647 √ null
thirdp_base_third_party.id fk_bac_ins_f_db_on_requestor R
request_origin_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_db_on_request_origin R
comment_ varchar 2000 √ null
provided_document_id uuid 2147483647 √ null
bac_ins_f_db_provided_doc.id fk_bac_ins_f_db_on_provided_document R
dates_id uuid 2147483647 √ null
bac_ins_f_db_dates.id fk_bac_ins_f_db_on_dates R
count_water_connection int4 10 √ null
count_wastewater_connection int4 10 √ null
count_rainwater_connection int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_bac_ins_f_db Primary key Asc id
idx_bac_ins_f_db_dates Performance Asc dates_id
idx_bac_ins_f_db_preliminary_visit Performance Asc preliminary_visit_id
idx_bac_ins_f_db_provided_document Performance Asc provided_document_id
idx_bac_ins_f_db_requestor Performance Asc requestor_id
idx_bac_ins_f_db_urbanism_auth_inspection Performance Asc urbanism_authorization_inspection_id

Relationships

Close relationships within degrees of separation