doc_physical_document


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
check_automatic_result.physical_document fk_check_automatic_result_physical_document R
doc_physical_document_digital.physical_document fk_doc_physical_document_digital_digital R
total_page INT 10 NULL
status VARCHAR 255 NULL
doc_unit VARCHAR 191 NULL
doc_unit.identifier fk_doc_physical_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
train VARCHAR 191 NULL
train_train.identifier fk_doc_physical_document_train_train R
name VARCHAR 191 NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier
fk_doc_physical_document_doc_unit Performance Asc doc_unit
fk_doc_physical_document_train_train Performance Asc train

Relationships