thirdp_legal_person

50 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
bac_ins_f_au_building_permit.architect_id fk_bac_ins_f_au_building_permit_on_architect R
bac_ins_f_dc_public_domain.network_service_id fk_bac_ins_f_dc_public_domain_on_network_service R
bac_ins_f_dc_public_domain_connection.building_company_name_id fk_bacinsfdcpublicdomainconnection_on_buildingcompanyname R
bac_ins_f_dc_public_domain_connection_box.building_company_name_id fk_bacinsfdcpublicdomainconnectionbox_on_buildingcompanyname R
ins_inspection_department.department_id fk_ins_inspection_department_on_department R
thirdp_base_third_party.id fk_thirdp_legal_person_on_id R
name varchar 255 √ null
representative_id uuid 2147483647 √ null
thirdp_natural_person.id fk_thirdp_legal_person_on_representative R
role_representative varchar 255 √ null
siret_number varchar 255 null
corporate_name varchar 255 null
deleted_by varchar 255 √ null
deleted_date timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_thirdp_legal_person Primary key Asc id
idx_thirdp_legal_person_corporate_name Performance Asc corporate_name
idx_thirdp_legal_person_name Performance Asc name
idx_thirdp_legal_person_representative Performance Asc representative_id
idx_thirdp_legal_person_unq Must be unique Asc siret_number

Relationships

Close relationships within degrees of separation