ins_inspection

264 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
bac_ins_f_db.urbanism_authorization_inspection_id fk_bac_ins_f_db_on_urbanism_authorization_inspection R
ins_inspection.linked_inspection_id fk_ins_inspection_on_linked_inspection R
ins_inspection_agent.inspection_id fk_ins_inspection_agent_on_inspection R
ins_inspection_appointment.inspection_id fk_ins_inspection_appointment_on_inspection R
ins_inspection_case.current_inspection_id fk_ins_inspection_case_on_current_inspection R
ins_inspection_case.last_inspection_id fk_ins_inspection_case_on_last_inspection R
ins_inspection_case.next_inspection_id fk_ins_inspection_case_on_next_inspection R
ins_inspection_case_attachment.inspection_id fk_ins_inspection_case_attachment_on_inspection R
ins_inspection_comment.inspection_id fk_ins_inspection_comment_on_inspection R
ins_inspection_invoice.inspection_id fk_ins_inspection_invoice_on_inspection R
ins_inspection_person_present.inspection_id fk_ins_inspection_person_present_on_inspection R
deleted_by varchar 255 √ null
deleted_date timestamp 29,6 √ 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
case_id uuid 2147483647 null
ins_inspection_case.id fk_ins_inspection_on_case R
linked_inspection_id uuid 2147483647 √ null
ins_inspection.id fk_ins_inspection_on_linked_inspection R
counter_inspection bool 1 √ null
type_id uuid 2147483647 null
ins_inspection_type.id fk_ins_inspection_on_type R
service_decision_id uuid 2147483647 √ null
ins_inspection_department.id fk_ins_inspection_on_service_decision R
manager_decision_id uuid 2147483647 √ null
ins_inspection_decision.id fk_ins_inspection_on_manager_decision R
agent_decision_id uuid 2147483647 √ null
ins_inspection_decision.id fk_ins_inspection_on_agent_decision R
provisional_inspection_date timestamp 29,6 √ null
last_appointment_id uuid 2147483647 √ null
ins_inspection_appointment.id fk_ins_inspection_on_last_appointment R
form_id uuid 2147483647 null
status_id uuid 2147483647 null
ins_inspection_status.id fk_ins_inspection_on_status R
inspection_date timestamp 29,6 √ null
requestor_id uuid 2147483647 √ null
thirdp_base_third_party.id fk_ins_inspection_on_requestor R
request_id uuid 2147483647 √ null
ins_inspection_request.id fk_ins_inspection_on_request R
next_inspection_recommendation_id uuid 2147483647 √ null
ins_inspection_next_recommendation.id fk_ins_inspection_on_next_inspection_recommendation R
number int4 10 null
reference varchar 255 null
external_reference_1 varchar 255 √ null
external_reference_2 varchar 255 √ null
best_confidence_origin_id uuid 2147483647 √ null
com_data_origin.id fk_ins_inspection_on_best_confidence_origin R
person_presents_comment varchar 2048 √ null
due_date date 13 √ null
note varchar 255 √ null
auto_due_date date 13 √ null
mailing_date timestamp 29,6 √ null
request_date timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_ins_inspection Primary key Asc id
idx_ins_inspection_case Performance Asc case_id
idx_ins_inspection_case_number Must be unique Asc/Asc case_id + number
idx_ins_inspection_form Performance Asc form_id
idx_ins_inspection_last_appointment Performance Asc last_appointment_id
idx_ins_inspection_linked_inspection Performance Asc linked_inspection_id
idx_ins_inspection_reference Must be unique Asc reference
idx_ins_inspection_request Performance Asc request_id
idx_ins_inspection_requestor Performance Asc requestor_id
idx_ins_inspection_service_decision Performance Asc service_decision_id
idx_ins_inspection_status Performance Asc status_id
idx_ins_inspection_type Performance Asc type_id

Relationships

Close relationships within degrees of separation