doc_page


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
check_automatic_result.page fk_check_automatic_result_page R
doc_check.page fk_doc_check_page R
sto_stored_file.page fk_sto_stored_file_page R
number INT 10 NULL
description TEXT 65535 NULL
check_notes TEXT 65535 NULL
status VARCHAR 255 NULL
digital_document VARCHAR 191 NULL
doc_digital_document.identifier fk_doc_page_digital_document 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()
sample VARCHAR 191 NULL
doc_sample.identifier fk_doc_page_sample R
piece VARCHAR 191 NULL
piece_number INT 10 NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier
fk_doc_page_digital_document Performance Asc digital_document
fk_doc_page_sample Performance Asc sample
idx_piece Performance Asc piece

Relationships