ins_inspection_case_report_template

1 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
code varchar 255 null
name varchar 255 √ null
description varchar 2048 √ null
sort_name varchar 255 √ null
search_key varchar 255 null
best_confidence_origin_id uuid 2147483647 √ null
com_data_origin.id fk_insinspectioncasereporttemplate_on_bestconfidenceorigin R
icon varchar 255 √ null
color varchar 255 √ 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
attachment_type_id uuid 2147483647 √ null
ins_inspection_attachment_type.id fk_ins_inspection_case_report_template_on_attachment_type R
report_id uuid 2147483647 √ null
report_report.id fk_ins_inspection_case_report_template_on_report R
recipient_type_id uuid 2147483647 √ null
ins_inspection_recipient_type.id fk_ins_inspection_case_report_template_on_recipient_type R

Indexes

Constraint Name Type Sort Column(s)
pk_ins_inspection_case_report_template Primary key Asc id
idx_ins_inspection_case_report_template_attachment_type Performance Asc attachment_type_id
idx_ins_inspection_case_report_template_recipient_type Performance Asc recipient_type_id
idx_ins_inspection_case_report_template_report Performance Asc report_id
idx_inspection_case_report_template_unq Must be unique Asc/Asc code + search_key
idx_inspection_case_report_template_unq_name Must be unique Asc/Asc name + search_key

Relationships

Close relationships within degrees of separation