Relative Content

Tag Archive for databasedatabase-designdatabase-schema

Parent-Child relationships where parent and child tables may change based on settings

I am developing a Warehouse Management System. Each Warehouse can specify storage locations by varying degrees of specificity: Zone, Aisle, Row, Rack, Shelf, Bin. While Bin is always required because it is the final location, some Warehouses may not need the other location types. For example, some Warehouses may not have racking, so they don’t need Rack or Shelf location types. The user can enable/disable location types for each Warehouse.