ins_inspection_type

10 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
ins_inspection.type_id fk_ins_inspection_on_type R
ins_inspection_decision_type.inspection_type_id fk_ins_inspection_decision_type_on_inspection_type R
ins_inspection_next_recommendation.next_inspection_type_id fk_ins_inspection_next_recommendation_on_next_inspection_type R
ins_inspection_type.effective_type_id fk_ins_inspection_type_on_effective_type R
ins_inspection_type_report_template.type_id fk_ins_inspection_type_report_template_on_type R
ins_inspection_type_template_form.inspection_type_id fk_ins_inspection_type_template_form_on_inspection_type R
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_ins_inspection_type_on_best_confidence_origin 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
default_template_id uuid 2147483647 √ null
ins_inspection_type_template_form.id fk_ins_inspection_type_on_default_template R
effective_type_id uuid 2147483647 √ null
ins_inspection_type.id fk_ins_inspection_type_on_effective_type R
is_visible bool 1 √ null
is_counter_inspection_available bool 1 √ true
is_form_tablet_available bool 1 √ true
days_before_deadline int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_ins_inspection_type Primary key Asc id
idx_ins_inspection_type_default_template Performance Asc default_template_id
idx_ins_inspection_type_effective_type Performance Asc effective_type_id
idx_ins_inspection_type_unq Must be unique Asc/Asc code + search_key
idx_ins_inspection_type_unq_name Must be unique Asc/Asc name + search_key

Relationships

Close relationships within degrees of separation