com_data_origin

9 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
add_city.best_confidence_origin_id fk_add_city_on_best_confidence_origin R
add_country.best_confidence_origin_id fk_add_country_on_best_confidence_origin R
add_zip_code.best_confidence_origin_id fk_add_zip_code_on_best_confidence_origin R
agd_appointment_duration.best_confidence_origin_id fk_agd_appointment_duration_on_best_confidence_origin R
agd_appointment_status.best_confidence_origin_id fk_agd_appointment_status_on_best_confidence_origin R
agd_appointment_time_slot.best_confidence_origin_id fk_agd_appointment_time_slot_on_best_confidence_origin R
agd_appointment_type.best_confidence_origin_id fk_agd_appointment_type_on_best_confidence_origin R
bac_inspection_connection_zone_type.best_confidence_origin_id fk_bacinspectionconnectionzonetype_on_bestconfidenceorigin R
bac_inspection_form_simple_list.best_confidence_origin_id fk_bac_inspection_form_simple_list_on_best_confidence_origin R
com_civility.best_confidence_origin_id fk_com_civility_on_best_confidence_origin R
com_data_origin.best_confidence_origin_id fk_com_data_origin_on_best_confidence_origin R
com_error_type.best_confidence_origin_id fk_com_error_type_on_best_confidence_origin R
com_link.best_confidence_origin_id fk_com_link_on_best_confidence_origin R
com_sentence_type.best_confidence_origin_id fk_com_sentence_type_on_best_confidence_origin R
com_setting.best_confidence_origin_id fk_com_setting_on_best_confidence_origin R
ins_inspection.best_confidence_origin_id fk_ins_inspection_on_best_confidence_origin R
ins_inspection_address.best_confidence_origin_id fk_ins_inspection_address_on_best_confidence_origin R
ins_inspection_attachment_type.best_confidence_origin_id fk_ins_inspection_attachment_type_on_best_confidence_origin R
ins_inspection_case.best_confidence_origin_id fk_ins_inspection_case_city_on_best_confidence_origin R
ins_inspection_case_attachment.best_confidence_origin_id fk_ins_inspection_case_attachment_on_best_confidence_origin R
ins_inspection_case_next_alert.best_confidence_origin_id fk_ins_inspection_case_next_alert_on_best_confidence_origin R
ins_inspection_case_report_template.best_confidence_origin_id fk_insinspectioncasereporttemplate_on_bestconfidenceorigin R
ins_inspection_case_status.best_confidence_origin_id fk_ins_inspection_case_status_on_best_confidence_origin R
ins_inspection_comment_origin.best_confidence_origin_id fk_ins_inspection_comment_origin_on_best_confidence_origin R
ins_inspection_connection_status.best_confidence_origin_id fk_ins_inspection_connection_status_on_best_confidence_origin R
ins_inspection_decision_type.best_confidence_origin_id fk_ins_inspection_decision_type_on_best_confidence_origin R
ins_inspection_decision_type_sentence.best_confidence_origin_id fk_insinspectiondecisiontypesentence_on_bestconfidenceorigin R
ins_inspection_department.best_confidence_origin_id fk_ins_inspection_department_on_best_confidence_origin R
ins_inspection_district.best_confidence_origin_id fk_ins_inspection_district_on_best_confidence_origin R
ins_inspection_evaluation_type.best_confidence_origin_id fk_ins_inspection_evaluation_type_on_best_confidence_origin R
ins_inspection_invoice_status.best_confidence_origin_id fk_ins_inspection_invoice_status_on_best_confidence_origin R
ins_inspection_invoice_type.best_confidence_origin_id fk_ins_inspection_invoice_type_on_best_confidence_origin R
ins_inspection_next_alert.best_confidence_origin_id fk_ins_inspection_next_alert_on_best_confidence_origin R
ins_inspection_parcel_type.best_confidence_origin_id fk_ins_inspection_parcel_type_on_best_confidence_origin R
ins_inspection_recipient_type.best_confidence_origin_id fk_ins_inspection_recipient_type_on_best_confidence_origin R
ins_inspection_request_status.best_confidence_origin_id fk_ins_inspection_request_status_on_best_confidence_origin R
ins_inspection_request_type.best_confidence_origin_id fk_ins_inspection_request_type_on_best_confidence_origin R
ins_inspection_stakeholder_type.best_confidence_origin_id fk_ins_inspection_stakeholder_type_on_best_confidence_origin R
ins_inspection_status.best_confidence_origin_id fk_ins_inspection_status_on_best_confidence_origin R
ins_inspection_type.best_confidence_origin_id fk_ins_inspection_type_on_best_confidence_origin R
ins_inspection_type_report_template.best_confidence_origin_id fk_insinspectiontypereporttemplate_on_bestconfidenceorigin R
ins_inspection_type_template_form.best_confidence_origin_id fk_ins_inspection_type_template_form_on_best_confidence_origin R
map_wms_tile_layer.best_confidence_origin_id fk_map_wms_tile_layer_on_best_confidence_origin R
seq_sequence_identifiant.best_confidence_origin_id fk_seq_sequence_identifiant_on_best_confidence_origin R
thirdp_base_third_party.best_confidence_origin_id fk_thirdp_base_third_party_on_best_confidence_origin R
thirdp_role.best_confidence_origin_id fk_thirdp_role_on_best_confidence_origin R
deleted_by varchar 255 √ null
deleted_date timestamp 29,6 √ null
code varchar 255 null
search_key varchar 255 null
name varchar 255 √ null
description varchar 2048 √ null
sort_name varchar 255 √ null
best_confidence_origin_id uuid 2147483647 √ null
com_data_origin.id fk_com_data_origin_on_best_confidence_origin R
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
confidence_level int4 10 √ null
color varchar 255 √ null
icon varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_com_data_origin Primary key Asc id
idx_com_data_origin_unq Must be unique Asc/Asc code + search_key
idx_com_data_origin_unq_name Must be unique Asc/Asc name + search_key

Relationships

Close relationships within degrees of separation