doc_digital_document


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
check_automatic_result.digital_document fk_check_automatic_result_digital_document R
del_delivered_document.digital_document fk_del_delivered_document_digital R
doc_global_check.digital_document fk_doc_check_digital_document R
doc_page.digital_document fk_doc_page_digital_document R
doc_physical_document_digital.digital_document fk_doc_physical_document_digital_physical R
doc_sample.digital_document fk_doc_sample_digital_document R
total_delivery INT 10 NULL
status VARCHAR 255 NULL
doc_unit VARCHAR 191 NULL
doc_unit.identifier fk_doc_digital_document_doc_unit 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()
digital_id VARCHAR 191 NULL
major_error_rate DOUBLE 22 NULL
minor_error_rate DOUBLE 22 NULL
check_notes VARCHAR 2000 NULL
delivery_date DATE 10 NULL
total_length BIGINT 19 NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier
fk_doc_digital_document_doc_unit Performance Asc doc_unit

Relationships