Project:Box identification: Difference between revisions

** creator_id (Reference ID) - As anyone will be able to create a new box record this would be handy for identifying one people aren't being excellent i.e. someone spams the create button.

** owner_id (Reference ID) - Who owns the box/contents. The idea is that this will only get updated on claiming the box so it will be possible to identify old owners if they left something in the box after disowning it.

** owned (BOOLEAN) - If the assign owner still wishes to own the box.

** active (BOOLEAN) - Overengineering at its finest, this serves no real purpose but is intended to take a particular box out of service. (Admin use only)

** location (Reference ID) - Where the box is located. Could be NULL, as in there's no valid place for it on the shelves.

* Storage Locations - A method for storing all valid storage locations. shelf and bay combine to create a UNIQUE key.

** shelf (Reference ID) - refers to a shelf unit

** bay (Reference ID) - refers to a shelf bay

** key (CHAR(2)) - Unique string representing unit

** x (INTEGER) - x-coord in pixels for positioning shelf unit marker on box location image.

** y (INTEGER) - y-coord in pixels for positioning shelf unit marker on box location image.

** orientation (INTEGER) - Orientation of the shelf unit for box location image. (N = 0, E = 1, S = 2, W = 3)

** key (CHAR(2)) - Unique string representing bay

** x (INTEGER) - x-coord in pixels for positioning shelf bay marker on box location image.

** y (INTEGER) - y-coord in pixels for positioning shelf bay marker on box location image.