thirdp_base_third_party

177 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
bac_ins_f_db.requestor_id fk_bac_ins_f_db_on_requestor R
ins_inspection.requestor_id fk_ins_inspection_on_requestor R
ins_inspection_case_stakeholder.third_party_id fk_ins_inspection_case_stakeholder_on_third_party R
ins_inspection_invoice.third_party_id fk_ins_inspection_invoice_on_third_party R
thirdp_base_third_party_comment.third_party_id fk_thirdp_base_third_party_comment_on_third_party R
thirdp_legal_person.id fk_thirdp_legal_person_on_id R
thirdp_natural_person.id fk_thirdp_natural_person_on_id R
thirdp_third_party_role.third_party_id fk_thirdp_third_party_role_on_third_party C
party_type varchar 31 √ null
number_ int4 10 √ null
best_confidence_origin_id uuid 2147483647 √ null
com_data_origin.id fk_thirdp_base_third_party_on_best_confidence_origin R
extra varchar 255 √ null
street varchar 1024 null
zip_code_id uuid 2147483647 null
add_zip_code.id fk_thirdp_base_third_party_on_zip_code R
short_address varchar 2048 null
building varchar 255 √ null
apartment varchar 255 √ null
floor_ varchar 255 √ null
stair varchar 255 √ null
complement varchar 255 √ null
geometry varchar 100 √ 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
phone_number varchar 255 √ null
full_name varchar 255 √ null
mobile_number varchar 255 √ null
email varchar 255 √ null
external_reference_1 varchar 255 √ null
external_reference_2 varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_thirdp_base_third_party Primary key Asc id
idx_thirdp_base_third_party_email Performance Asc email
idx_thirdp_base_third_party_full_name Performance Asc full_name
idx_thirdp_base_third_party_mobile_phone Performance Asc mobile_number
idx_thirdp_base_third_party_street Performance Asc street
idx_thirdp_base_third_party_zip_code Performance Asc zip_code_id

Relationships

Close relationships within degrees of separation