Inventory data model

Core records:

• ProductCategory: category hierarchy for the product master.
• Supplier: supplier master with preferred-supplier approval metadata.
• Product: internal product master used by quotes, inventory, reservations, warranties, and future store sync.
• InventoryItem: stock quantity or serial item at a location, project, or installed-system placeholder.
• StockLocation: warehouse, office, van, supplier, project site, or customer-site location.
• StockMovement: explicit movement log. Movements do not automatically mutate quantities in Sprint 10.
• StockReservation: manual reservation against product, quote item, quote, project, and/or company.
• ProductPriceHistory: created when cost or selling price changes.
• ProductAlias: alternate names from BOQ, quote, supplier, store, staff, import, or other sources.
• ProductDocument: placeholder metadata for datasheets or manuals without Google Drive integration.

Important relationships:

• QuoteItem.productId links a BOQ item to a product.
• StockReservation can link to QuoteItem, Quote, Project, and Company.
• InventoryItem can link to Project and InstalledSystem for readiness.
• WarrantyRecord.productId prepares support warranty records for product/serial traceability.