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

Close relationships within degrees of separation