del_delivered_document


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
delivery VARCHAR 191 null
del_delivery.identifier fk_del_delivered_document_delivery R
digital_document VARCHAR 191 null
doc_digital_document.identifier fk_del_delivered_document_digital R
status VARCHAR 255 NULL
delivery_date DATE 10 NULL
nb_pages INT 10 NULL
total_length BIGINT 19 NULL
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()
check_slip VARCHAR 191 NULL
check_slip.identifier fk_check_slip_delivered_document R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier
fk_check_slip_delivered_document Performance Asc check_slip
idx_del_delivered_document_delivery Performance Asc delivery
idx_del_delivered_document_digital Performance Asc digital_document

Relationships