orderpicking

4947 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
orderpickingitem.orderPicking_id FK_B934F647BA98F845R
order_id VARCHAR 36 null
orders.id FK_395899738D9F6D38R
created DATETIME 19 null
updated DATETIME 19 null
orderPickingNumber INT 10 null
pickList_id VARCHAR 36 null
picklist.id FK_395899733F473D40R
client_id VARCHAR 36 null
client.id FK_3958997319EB6921R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_3958997319EB6921 Performance Asc client_id
IDX_395899733F473D40 Performance Asc pickList_id
IDX_395899738D9F6D38 Performance Asc order_id

Relationships