ins_inspection_case_attachment

0 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
best_confidence_origin_id uuid 2147483647 √ null
com_data_origin.id fk_ins_inspection_case_attachment_on_best_confidence_origin R
case_id uuid 2147483647 null
ins_inspection_case.id fk_ins_inspection_case_attachment_on_case R
inspection_id uuid 2147483647 √ null
ins_inspection.id fk_ins_inspection_case_attachment_on_inspection R
size_ int8 19 √ null
file_ varchar 1024 null
type_id uuid 2147483647 √ null
ins_inspection_attachment_type.id fk_ins_inspection_case_attachment_on_type R
comment_ varchar 2048 √ null
content_type varchar 255 √ null
name varchar 255 √ null
mailing_date timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_ins_inspection_case_attachment Primary key Asc id
idx_ins_inspection_case_attachment_case Performance Asc case_id
idx_ins_inspection_case_attachment_type Performance Asc type_id

Relationships

Close relationships within degrees of separation