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

Close relationships within degrees of separation