moveboxtracker
moveboxtracker database schema
database entity relationship diagram
database table definitions
These tables are defined in the project’s database.
- batch_move: each batch of boxes moved, time and destination
- box_scan: code scan event for a box being entered into a move batch
- image: storage of optional images (as database blobs) for moving_box and item records
- item: description of one of multiple items in a box, optional image
- location: name of a location, such as origin, storage, destination, etc
- move_project: overall project info including title, primary user and lost&found contact
- moving_box: box info including origin/destination room, current location, optional image
- room: name of origin/destination room
- uri_user: name of a user as a namespace for URIs for scanning, who did each scan