bac_ins_f_dc

99 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
meteo_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_on_meteo R
building_id uuid 2147483647 √ null
bac_ins_f_dc_building.id fk_bac_ins_f_dc_on_building R
inspection_type_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_on_inspection_type R
amount_pfac varchar 255 √ null
counter_inspection_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_on_counter_inspection R
previous_inspection date 13 √ null
previous_inspection_anomalies_to_be_corrected varchar 255 √ null
passage_through_private_property_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_on_passage_through_private_property R
written_authorisation_from_owner_provided_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_on_written_authorisation_from_owner_provided R
comment_ varchar 2048 √ null
public_domain_id uuid 2147483647 √ null
bac_ins_f_dc_public_domain.id fk_bac_ins_f_dc_on_public_domain R
man_hole_id uuid 2147483647 √ null
bac_ins_f_dc_man_hole.id fk_bac_ins_f_dc_on_man_hole R
private_domain_id uuid 2147483647 √ null
bac_ins_f_dc_private_domain.id fk_bac_ins_f_dc_on_private_domain R
tests_id uuid 2147483647 √ null
bac_ins_f_dc_tests.id fk_bac_ins_f_dc_on_tests R
anomaly_id uuid 2147483647 √ null
bac_ins_f_dc_anomaly.id fk_bac_ins_f_dc_on_anomaly R
provided_documents_id uuid 2147483647 √ null
bac_ins_f_dc_provided_document.id fk_bac_ins_f_dc_on_provided_documents R

Indexes

Constraint Name Type Sort Column(s)
pk_bac_ins_f_dc Primary key Asc id
idx_bac_ins_f_dc_anomaly Performance Asc anomaly_id
idx_bac_ins_f_dc_building Performance Asc building_id
idx_bac_ins_f_dc_inspection_type Performance Asc inspection_type_id
idx_bac_ins_f_dc_meteo Performance Asc meteo_id
idx_bac_ins_f_dc_passage_through_private_property Performance Asc passage_through_private_property_id
idx_bac_ins_f_dc_private_domain Performance Asc private_domain_id
idx_bac_ins_f_dc_provided_documents Performance Asc provided_documents_id
idx_bac_ins_f_dc_public_domain Performance Asc public_domain_id
idx_bac_ins_f_dc_writtenauthorisationfromownerprovide Performance Asc written_authorisation_from_owner_provided_id

Relationships

Close relationships within degrees of separation