orderpickingitem

5945 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
quantity DECIMAL 10,3 null
orderPicking_id VARCHAR 36 null
orderpicking.id FK_B934F647BA98F845R
offerItem_id VARCHAR 36 null
offeritem.id FK_B934F647FDB4FBE0R
serialNumber_id VARCHAR 36 null
productserialnumber.id FK_B934F647A907283BR
materialProduct_id VARCHAR 36 null
product.id FK_B934F6477FDBDE77R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_B934F6477FDBDE77 Performance Asc materialProduct_id
IDX_B934F647A907283B Performance Asc serialNumber_id
IDX_B934F647BA98F845 Performance Asc orderPicking_id
IDX_B934F647FDB4FBE0 Performance Asc offerItem_id

Relationships