id - int
name - varchar(255)
sku - varchar(100)
barcode - varchar(255)
description - text
image_path - varchar(255)
supplier_id - int
category_id - int
brand_id - int
unit_price - decimal(10,2)
cost_price - decimal(10,2)
safety_stock - int
replenish_unit - int
last_ordered_at - datetime
replenishment_unit - int
has_expiration_date - tinyint(1)
shelf_life_years - int
shelf_life_months - int
shelf_life_days - int
created_at - timestamp
created_by - int
updated_at - timestamp
updated_by - int
quantity - int
handling_status - varchar(20)
units_per_case - int
order_status - enum('none','ordered')