Back
/*
Table: prodPhysicalLocation

Columns:
    upc varchar
    store_id smallint
    section smallint
    subsection smallint
    shelf_set smallint
    shelf smallint
    location int

Depends on:
    products (table)

Use:
Storing physical location of products within a store.

Section and/or subsection represents a set of shelves.
In a lot of cases this would be one side of an aisle but
it could also be an endcap or a cooler or something against
a wall that isn't formally an aisle. A store can use either
or both. For example, section could map to aisle numbering
and subsection could indicate the left or right side of
that aisle. Another option would be to map section to a
super department (e.g., grocery) and subsection to an aisle-side
within that department.

"Shelf set" is a division within a subsection. It could be
one physical shelving unit or a freezer door.

Shelf indicates the vertical shelf location. Bottom to
top numbering is recommended.

Location is the horizontal location on the shelf.
*/
Back