Inventory Management Schema

Tables

products

• product_id (PRIMARY KEY)
• product_name
• sku
• category
• unit_cost
• reorder_point (minimum stock level before reordering)
• discontinued (boolean)

warehouses

• warehouse_id (PRIMARY KEY)
• warehouse_name
• location
• capacity