del_multi_lots_delivery


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
del_delivery.multi_lots_delivery fk_delivery_multi_delivery R
label VARCHAR 255 NULL
description VARCHAR 255 NULL
delivery_payment INT 10 NULL
delivery_status INT 10 NULL
delivery_method INT 10 NULL
reception_date DATE 10 null
folder_path VARCHAR 255 NULL
digitizing_notes VARCHAR 255 NULL
control_notes VARCHAR 255 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()
train_id VARCHAR 191 NULL
selected_by_train BIT 1 b'0'

Indexes

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

Relationships