inventorylocationitem

622 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
product_id VARCHAR 36 null
product.id FK_19ED39404584665AR
inventorylocation_id VARCHAR 36 null
inventorylocation.id FK_19ED394026E88475R
quantity DECIMAL 10,3 null
serialNumber_id VARCHAR 36 null
productserialnumber.id FK_19ED3940A907283BR
purchasePrice DECIMAL 10,4 null
sollQuantity DECIMAL 10,3 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_19ED394026E88475 Performance Asc inventorylocation_id
IDX_19ED39404584665A Performance Asc product_id
IDX_19ED3940A907283B Performance Asc serialNumber_id

Relationships