Tables


SchemaSpy Analysis of id-bac-demo.public

Generated on Mon Jun 30 12:54 UTC 2025

XML Representation
Insertion Order Deletion Order
TABLES 177
VIEWS 3
COLUMNS 3013
Constraints 565
Anomalies 9
Routines 0

Database Properties

Database Type: PostgreSQL - 16.8 (Debian 16.8-1.pgdg120+1)

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
bac_ins_f_dc_provided_document 1 7 16 99 Table
ins_inspection_decision_type 3 2 17 3 Table
ins_inspection_request_type 1 1 16 2 Table
ui_filter_configuration 0 0 8 0 Table
qrtz_paused_trigger_grps 0 0 2 0 Table
com_custom_field 0 1 14 452 Table
ins_inspection_attachment_type 3 1 16 9 Table
bac_ins_f_dc_private_domain 3 22 34 99 Table
ins_inspection_invoice_type 1 1 16 2 Table
emltmp_block_group 1 0 9 3 Table
add_zip_code 3 2 18 8 Table
ins_inspection_next_alert 0 1 17 4 Table
ins_inspection_form_empty 0 0 8 70 Table
ins_inspection_status 1 1 16 13 Table
ins_inspection_case_comment_contact 0 3 12 0 Table
bac_ins_f_ci 0 11 22 39 Table
ins_base_inspection_form 0 0 8 0 Table
ins_inspection_next_recommendation 1 1 10 264 Table
qrtz_fired_triggers 0 0 13 0 Table
dshbrd_template_group 1 0 9 1 Table
bac_ins_f_db_visit_person_present 0 3 12 0 Table
ins_inspection_comment_origin 2 1 16 7 Table
ui_setting 0 0 6 7 Table
emltmp_template_block 0 1 13 0 Table
thirdp_base_third_party 8 2 25 177 Table
audit_entity_log 0 0 14 0 Table
agd_appointment_status 1 1 16 8 Table
agd_appointment_type 1 1 16 2 Table
com_user 14 1 20 5 Table
ins_inspection_agent 0 2 10 264 Table
email_sending_message 1 0 25 0 Table
bac_ins_f_dc_anomaly 1 23 56 99 Table
agd_simple_appointment 0 1 1 0 Table
bac_ins_f_ci_water_fee 1 4 13 39 Table
ins_inspection_appointment 1 2 4 345 Table
bac_ins_f_dc 0 12 24 99 Table
bac_ins_f_dc_public_domain 3 12 24 99 Table
com_error_type 0 1 16 7 Table
map_wms_tile_layer 0 1 29 2 Table
bac_ins_f_db 0 11 28 28 Table
ins_inspection_type_report_template 0 5 20 17 Table
bac_ins_f_au_work_declaration 1 6 20 30 Table
bac_ins_f_ci_provided_document 1 16 25 39 Table
ins_inspection_case_report_template 0 4 19 1 Table
ins_inspection_comment 1 3 13 264 Table
bac_ins_f_ci_discharge_connection 1 5 16 39 Table
ins_inspection_district 1 1 16 0 Table
agd_appointment_time_slot 0 2 20 10 Table
bac_ins_f_db_provided_doc 1 7 26 28 Table
ins_inspection_recipient_type 2 1 16 5 Table
bac_ins_f_ci_water_origin_usage 1 3 15 39 Table
bac_ins_f_au_decision 1 2 22 30 Table
qrtz_triggers 12 3 16 2 Table
ins_inspection_comment_contact 0 3 12 0 Table
bac_ins_f_au 0 26 50 30 Table
agd_appointment_participant 0 2 10 345 Table
bac_ins_f_dc_public_domain_connection 0 14 32 1 Table
bac_ins_f_dc_private_domain_rainwater_installatio 0 8 19 4 Table
ins_inspection_parcel_type 1 1 16 3 Table
qrtz_calendars 0 0 3 0 Table
agd_base_appointment 3 2 13 345 Table
bac_ins_f_au_building_permit 1 16 34 30 Table
report_template 1 1 19 43 Table
bac_ins_f_db_visit 1 1 12 0 Table
dshbrd_dashboard_group 1 0 9 1 Table
audit_entity_snapshot 0 0 13 0 Table
com_data_origin 46 1 17 9 Table
ins_inspection_case_comment 1 3 13 176 Table
com_commons_settings 0 0 8 1 Table
com_sentence_type 0 1 16 0 Table
thirdp_base_third_party_comment 0 2 12 177 Table
audit_logged_attr 0 1 5 0 Table
persistent_logins 0 0 4 0 Table
oauth_refresh_token 1 0 3 0 Table
ui_table_presentation 0 0 12 0 Table
thirdp_role 1 1 16 2 Table
bac_algorithm_pfac_parameter 1 0 14 0 Table
com_login_history 0 0 4 5 Table
bac_ins_f_db_manhole 0 1 13 0 Table
ins_inspection 11 12 34 264 Table
report_execution 0 1 14 0 Table
agd_appointment_duration 0 2 18 1 Table
bac_ins_f_ci_activity 1 0 15 39 Table
bac_ins_f_dc_private_domain_wastewater_installati 0 8 19 9 Table
ins_inspection_connection_status 1 1 16 3 Table
sec_resource_policy 0 1 14 0 Table
databasechangelog 0 0 14 1176 Table
qrtz_job_details 3 0 10 2 Table
emltmp_template_attachment 0 1 11 0 Table
bac_ins_f_ci_pre_treatment_system 1 4 15 39 Table
com_data_exchange_report 0 1 20 0 Table
sec_resource_role 1 0 14 0 Table
bac_ins_f_ci_rain_water_discharge_inspection 0 5 17 0 Table
ins_inspection_case_attachment 0 4 18 0 Table
thirdp_legal_person 5 2 8 50 Table
ins_inspection_department 4 2 19 1 Table
dshbrd_persistent_dashboard 0 1 13 8 Table
bac_ins_f_dc_tests 1 6 16 99 Table
com_setting 0 2 20 6 Table
report_report 5 2 22 42 Table
add_country 1 1 16 247 Table
bac_ins_f_au_develop_permit 1 8 28 30 Table
sec_row_level_role 1 0 13 0 Table
thirdp_third_party_role 0 2 12 62 Table
bac_ins_f_ci_waste_water_discharge_inspection 0 5 17 0 Table
bac_bac_inspection_form_au_parcel 0 1 10 0 Table
ins_inspection_decision 2 2 12 867 Table
qrtz_simprop_triggers 0 3 14 0 Table
ins_inspection_evaluation_type 0 2 20 2 Table
ins_inspection_case_status 1 1 16 4 Table
seq_sequence_identifiant_value 0 1 9 2 Table
bac_ins_f_db_dates 1 1 15 28 Table
bac_ins_f_dc_private_domain_wastewater_drainage 1 16 29 99 Table
audit_logged_entity 1 0 6 0 Table
bac_ins_f_au_wastewater 1 2 13 30 Table
ins_inspection_case_parcel 0 3 11 126 Table
com_link 0 1 21 5 Table
bac_inspection_connection_zone_type 0 1 16 2 Table
ins_inspection_request_status 1 1 16 3 Table
com_search_key 0 0 10 320 Table
ins_inspection_address 2 3 22 176 Table
ins_inspection_type_template_form 1 2 18 2 Table
bac_ins_f_ci_waste_products 1 1 10 39 Table
sec_user_substitution 0 0 12 0 Table
bac_inspection_form_simple_list 341 1 16 180 Table
sec_role_assignment 0 0 11 7 Table
ins_inspection_department_user 0 2 8 0 Table
oauth_access_token 0 1 7 0 Table
bac_ins_f_au_demolition_permit 1 5 17 30 Table
ins_inspection_invoice 0 4 22 0 Table
thirdp_natural_person 8 2 8 127 Table
bac_ins_f_dc_building 1 27 55 99 Table
ins_inspection_case 7 9 25 176 Table
ins_inspection_stakeholder_type 5 1 19 13 Table
emltmp_email_template 2 2 22 1 Table
ins_inspection_type 6 3 22 10 Table
spatial_ref_sys 2 0 5 8500 Table
ins_inspection_decision_type_sentence 0 2 17 0 Table
email_sending_attachment 0 1 16 0 Table
ins_inspection_department_zip_code 0 2 8 8 Table
ins_inspection_case_stakeholder 0 3 16 435 Table
qrtz_blob_triggers 0 3 4 0 Table
bac_ins_f_ci_discharge_points 0 4 15 0 Table
emltmp_parameter_value 0 1 12 0 Table
ins_inspection_person_present 0 3 12 129 Table
qrtz_cron_triggers 0 3 5 2 Table
cad_parcel 2 0 23 29 Table
qrtz_scheduler_state 0 0 4 0 Table
ins_full_inspection_view_export 0 0 82 264 Table
bac_ins_f_ci_other 1 1 19 39 Table
qrtz_locks 0 0 2 1 Table
ins_inspection_request 1 5 23 0 Table
add_city 1 2 18 8 Table
bac_ins_f_au_urbanism_certificate 1 20 50 30 Table
bac_ins_f_dc_private_domain_rainwater_drainage 1 16 29 99 Table
bac_ins_f_ciicpe 1 1 14 39 Table
bac_ins_f_ci_non_domestic_effluent_type_discharge 1 16 26 39 Table
ins_inspection_case_connection 0 2 15 132 Table
bac_ins_f_ci_used_product 1 4 14 39 Table
bac_ins_f_dc_public_domain_connection_box 0 7 21 1 Table
emltmp_template_report 2 2 11 0 Table
ins_inspection_building 1 0 11 0 Table
report_group 1 0 12 5 Table
bac_ins_f_au_request_characteristic_area 0 2 17 0 Table
bac_ins_f_au_public_domain 1 9 22 30 Table
qrtz_simple_triggers 0 3 6 0 Table
ins_inspection_invoice_status 1 1 16 5 Table
sec_row_level_policy 0 1 15 0 Table
bac_ins_f_au_rainwater 1 3 15 30 Table
com_civility 3 1 16 6 Table
seq_sequence_identifiant 1 1 21 1 Table
bac_ins_f_au_request_characteristic 2 7 29 30 Table
bac_ins_f_dc_man_hole 1 4 13 99 Table
ins_inspection_case_next_alert 0 1 17 4 Table
databasechangeloglock 0 0 4 1 Table
emltmp_template_group 1 0 9 0 Table
dshbrd_widget_template 0 1 12 2 Table
geography_columns 0 1 7 0 View
ins_full_inspection_view 0 0 86 0 View
geometry_columns 0 1 7 0 View