ins_inspection_case_comment

176 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
ins_inspection_case_comment_contact.inspection_case_comment_id fk_insinspectioncasecommentcontact_on_inspectioncasecomment R
comment_ varchar 4096 null
date_ date 13 null
user_id uuid 2147483647 √ null
com_user.id fk_ins_inspection_case_comment_on_user R
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_comment_on_case R
origin_id uuid 2147483647 √ null
ins_inspection_comment_origin.id fk_ins_inspection_case_comment_on_origin R
deleted_by varchar 255 √ null
deleted_date timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_ins_inspection_case_comment Primary key Asc id
idx_ins_inspection_case_comment_case Performance Asc case_id
idx_ins_inspection_case_comment_origin Performance Asc origin_id

Relationships

Close relationships within degrees of separation