thirdp_natural_person

127 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
bac_ins_f_au.instructor_id fk_bac_ins_f_au_on_instructor R
bac_ins_f_au.representative_id fk_bac_ins_f_au_on_representative R
bac_ins_f_au.requestor_id fk_bac_ins_f_au_on_requestor R
bac_ins_f_db_visit_person_present.person_id fk_bac_ins_f_db_visit_person_present_on_person R
ins_inspection_case_comment_contact.person_id fk_ins_inspection_case_comment_contact_on_person R
ins_inspection_comment_contact.person_id fk_ins_inspection_comment_contact_on_person R
ins_inspection_person_present.person_id fk_ins_inspection_person_present_on_person R
thirdp_legal_person.representative_id fk_thirdp_legal_person_on_representative R
thirdp_base_third_party.id fk_thirdp_natural_person_on_id R
first_name varchar 255 null
date_of_birth date 13 √ null
place_of_birth varchar 255 √ null
last_name varchar 255 null
civility_id uuid 2147483647 √ null
com_civility.id fk_thirdp_natural_person_on_civility R
deleted_by varchar 255 √ null
deleted_date timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_thirdp_natural_person Primary key Asc id
idx_thirdp_natural_person_first_name Performance Asc first_name
idx_thirdp_natural_person_last_name Performance Asc last_name

Relationships

Close relationships within degrees of separation