bac_ins_f_au

30 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
urbanism_authorization_type_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_on_urbanism_authorization_type R
reference_type varchar 255 √ null
reference_code_city varchar 255 √ null
reference_year int4 10 √ null
reference_code_ref varchar 255 √ null
reference_suffix varchar 255 √ null
application_date date 13 √ null
registration_date date 13 √ null
order_date date 13 √ null
site_opening_date date 13 √ null
completion_date date 13 √ null
refusal_or_cancellation_order_date date 13 √ null
decision_nature_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_on_decision_nature R
connection_possible_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_on_connection_possible R
work_declaration_id uuid 2147483647 √ null
bac_ins_f_au_work_declaration.id fk_bac_ins_f_au_on_work_declaration R
develop_permit_id uuid 2147483647 √ null
bac_ins_f_au_develop_permit.id fk_bac_ins_f_au_on_develop_permit R
building_permit_id uuid 2147483647 √ null
bac_ins_f_au_building_permit.id fk_bac_ins_f_au_on_building_permit R
urbanism_certificate_id uuid 2147483647 √ null
bac_ins_f_au_urbanism_certificate.id fk_bac_ins_f_au_on_urbanism_certificate R
demolition_permit_id uuid 2147483647 √ null
bac_ins_f_au_demolition_permit.id fk_bac_ins_f_au_on_demolition_permit R
has_subdivision_permit_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_on_has_subdivision_permit R
has_modification_permit_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_on_has_modification_permit_reason R
has_transfer_permit_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_on_has_transfer_permit_reason R
has_other_permit_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_on_has_other_permit_reason R
project_description_comment varchar 2048 √ null
work_type_comment varchar 2048 √ null
destination_comment varchar 2048 √ null
destination_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_on_destination R
instructor_id uuid 2147483647 √ null
thirdp_natural_person.id fk_bac_ins_f_au_on_instructor R
requestor_id uuid 2147483647 √ null
thirdp_natural_person.id fk_bac_ins_f_au_on_requestor R
requestor_communication_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_on_requestor_communication R
representative_id uuid 2147483647 √ null
thirdp_natural_person.id fk_bac_ins_f_au_on_representative R
survey_origin_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_on_survey_origin R
existing_urbanism_certificate_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_on_existing_urbanism_certificate R
land_in_subdivision_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_on_land_in_subdivision R
land_in_concerted_development_zone_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_on_land_in_concerted_development_zone R
land_legal_status_comment varchar 2048 √ null
request_characteristics_id uuid 2147483647 √ null
bac_ins_f_au_request_characteristic.id fk_bac_ins_f_au_on_request_characteristics R
public_domain_id uuid 2147483647 √ null
bac_ins_f_au_public_domain.id fk_bac_ins_f_au_on_public_domain R
wastewater_id uuid 2147483647 √ null
bac_ins_f_au_wastewater.id fk_bac_ins_f_au_on_wastewater R
rainwater_id uuid 2147483647 √ null
bac_ins_f_au_rainwater.id fk_bac_ins_f_au_on_rainwater R
decision_id uuid 2147483647 √ null
bac_ins_f_au_decision.id fk_bac_ins_f_au_on_decision R
comment varchar 2048 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_bac_ins_f_au Primary key Asc id
idx_bac_ins_f_au_building_permit Performance Asc building_permit_id
idx_bac_ins_f_au_connection_possible Performance Asc connection_possible_id
idx_bac_ins_f_au_decision Performance Asc decision_id
idx_bac_ins_f_au_decision_nature Performance Asc decision_nature_id
idx_bac_ins_f_au_demolition_permit Performance Asc demolition_permit_id
idx_bac_ins_f_au_destination Performance Asc destination_id
idx_bac_ins_f_au_existing_urbanism_certificate Performance Asc existing_urbanism_certificate_id
idx_bac_ins_f_au_has_modification_permit_reason Performance Asc has_modification_permit_id
idx_bac_ins_f_au_has_other_permit_reason Performance Asc has_other_permit_id
idx_bac_ins_f_au_has_subdivision_permit Performance Asc has_subdivision_permit_id
idx_bac_ins_f_au_has_transfer_permit_reason Performance Asc has_transfer_permit_id
idx_bac_ins_f_au_instructor Performance Asc instructor_id
idx_bac_ins_f_au_land_in_concerted_development_zone Performance Asc land_in_concerted_development_zone_id
idx_bac_ins_f_au_land_in_subdivision Performance Asc land_in_subdivision_id
idx_bac_ins_f_au_public_domain Performance Asc public_domain_id
idx_bac_ins_f_au_rainwater Performance Asc rainwater_id
idx_bac_ins_f_au_representative Performance Asc representative_id
idx_bac_ins_f_au_request_characteristics Performance Asc request_characteristics_id
idx_bac_ins_f_au_requestor Performance Asc requestor_id
idx_bac_ins_f_au_requestor_communication Performance Asc requestor_communication_id
idx_bac_ins_f_au_survey_origin Performance Asc survey_origin_id
idx_bac_ins_f_au_urbanism_authorization_type Performance Asc urbanism_authorization_type_id
idx_bac_ins_f_au_urbanism_certificate Performance Asc urbanism_certificate_id
idx_bac_ins_f_au_wastewater Performance Asc wastewater_id

Relationships

Close relationships within degrees of separation