inventory-tracking

The fragment outlines a solid architectural aim for per-warehouse inventory with backorder support and consolidated availability. However, concrete security and correctness require explicit schema constraints, transactional guarantees, and robust input validation. The design should be implemented with strong database-level invariants (e.g., CHECK constraints, foreign keys, and transactional operations), explicit isolation levels, and well-defined APIs to prevent data corruption and ensure consistent views across consolidated and per-location data.