productserialnumber

257 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
inventorylocationitem.serialNumber_id FK_19ED3940A907283BR
materialpicklistitem.serialNumber_id FK_4B90B07AA907283BR
orderpickingitem.serialNumber_id FK_B934F647A907283BR
orderreturnitem.otherSerialNumber_id FK_3E24DCDF14EEE983R
orderreturnitem.serialNumber_id FK_3E24DCDFA907283BR
picklistitem.serialNumber_id FK_B631308CA907283BR
picklistreservation.serialNumber_id FK_D296DC42A907283BR
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
price DECIMAL 10,4 null
priceSurchage DECIMAL 10,4 null
note LONGTEXT 2147483647 null

Indexes

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

Relationships