productserialnumber

104 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
inventorylocationitem.serialNumber_id FK_19ED3940A907283BR
orderpickingitem.serialNumber_id FK_B934F647A907283BR
orderreturnitem.otherSerialNumber_id FK_3E24DCDF14EEE983R
orderreturnitem.serialNumber_id FK_3E24DCDFA907283BR
picklistitem.serialNumber_id FK_B631308CA907283BR
vendororderitemdelivery.serialNumber_id FK_61BB1806A907283BR
warehousebooking.serialNumber_id FK_FC6BD52CA907283BR
product_id VARCHAR 36 null
product.id FK_8E69D9E94584665AR
serialNumber VARCHAR 64 null
stock DECIMAL 10,3 null
deletedAt DATETIME 19 null
bestBeforeDate DATE 10 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_8E69D9E94584665A Performance Asc product_id

Relationships