Skip to content

Latest commit

 

History

History

db

moveboxtracker database schema

database entity relationship diagram

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