ins_inspection_request

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
ins_inspection.request_id fk_ins_inspection_on_request 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
inspection_address_id uuid 2147483647 √ null
ins_inspection_address.id fk_ins_inspection_request_on_inspection_address R
inspection_request_type_id uuid 2147483647 √ null
ins_inspection_request_type.id fk_ins_inspection_request_on_inspection_request_type R
identity_scan_path varchar 255 √ null
status_id uuid 2147483647 √ null
ins_inspection_request_status.id fk_ins_inspection_request_on_status R
status_date timestamp 29,6 √ null
status_maker_id uuid 2147483647 √ null
com_user.id fk_ins_inspection_request_on_status_maker R
status_comment varchar 2048 √ null
first_name varchar 255 √ null
last_name varchar 255 √ null
civility_id uuid 2147483647 √ null
com_civility.id fk_ins_inspection_request_on_civility R
phone_number varchar 255 √ null
email varchar 255 √ null
owner_address varchar 255 √ null
birthday date 13 √ null
birth_location varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_ins_inspection_request Primary key Asc id
idx_ins_inspection_request_civility Performance Asc civility_id
idx_ins_inspection_request_inspection_address Performance Asc inspection_address_id
idx_ins_inspection_request_inspection_request_type Performance Asc inspection_request_type_id
idx_ins_inspection_request_status Performance Asc status_id
idx_ins_inspection_request_status_maker Performance Asc status_maker_id

Relationships

Close relationships within degrees of separation