ins_inspection_case_stakeholder

435 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
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_case_stakeholder_on_case R
third_party_id uuid 2147483647 null
thirdp_base_third_party.id fk_ins_inspection_case_stakeholder_on_third_party R
start_date date 13 null
end_date date 13 √ null
liable bool 1 √ null
current_ bool 1 √ null
full_name varchar 255 √ null
type_id uuid 2147483647 null
ins_inspection_stakeholder_type.id fk_ins_inspection_case_stakeholder_on_type R

Indexes

Constraint Name Type Sort Column(s)
pk_ins_inspection_case_stakeholder Primary key Asc id
idx_ins_inspection_case_stakeholder_case Performance Asc case_id
idx_ins_inspection_case_stakeholder_third_party Performance Asc third_party_id
idx_ins_inspection_case_stakeholder_type Performance Asc type_id

Relationships

Close relationships within degrees of separation