ins_inspection_case_comment_contact

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
person_id uuid 2147483647 √ null
thirdp_natural_person.id fk_ins_inspection_case_comment_contact_on_person R
type_id uuid 2147483647 √ null
ins_inspection_stakeholder_type.id fk_ins_inspection_case_comment_contact_on_type R
comment_ varchar 2048 √ 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
inspection_case_comment_id uuid 2147483647 √ null
ins_inspection_case_comment.id fk_insinspectioncasecommentcontact_on_inspectioncasecomment R

Indexes

Constraint Name Type Sort Column(s)
pk_ins_inspection_case_comment_contact Primary key Asc id
idx_ins_inspection_case_comment_contact_inspection_case Performance Asc inspection_case_comment_id
idx_ins_inspection_case_comment_contact_person Performance Asc person_id
idx_ins_inspection_case_comment_contact_type Performance Asc type_id

Relationships

Close relationships within degrees of separation