check_automatic_result


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
message TEXT 65535 √ NULL
result VARCHAR 255 null
check_type VARCHAR 191 √ NULL
check_automatic_type.identifier fk_check_automatic_result_check R
digital_document VARCHAR 191 √ NULL
doc_digital_document.identifier fk_check_automatic_result_digital_document R
doc_unit VARCHAR 191 √ NULL
doc_unit.identifier fk_check_automatic_result_doc_unit R
page VARCHAR 191 √ NULL
doc_page.identifier fk_check_automatic_result_page R
version BIGINT 19 null
created_by VARCHAR 191 'system'
last_modified_by VARCHAR 191 'system'
created_date TIMESTAMP 19 current_timestamp()
last_modified_date TIMESTAMP 19 current_timestamp()
delivery VARCHAR 191 √ NULL
del_delivery.identifier fk_check_automatic_result_delivery R
physical_document VARCHAR 191 √ NULL
doc_physical_document.identifier fk_check_automatic_result_physical_document R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier
fk_check_automatic_result_check Performance Asc check_type
fk_check_automatic_result_delivery Performance Asc delivery
fk_check_automatic_result_digital_document Performance Asc digital_document
fk_check_automatic_result_doc_unit Performance Asc doc_unit
fk_check_automatic_result_page Performance Asc page
fk_check_automatic_result_physical_document Performance Asc physical_document

Relationships

Close relationships within degrees of separation