Data Models - MobileApps-Cascadia/campus-directions-ios GitHub Wiki

Table Name: QR_CODES
Data Model: QRCode
Parameters Data Type Constraints/Notes
qrId (PrimaryKey) String Required. Reference to location of QR sign on campus.
qrName String Name of location.
lat Float Latitude measured in degrees. Latitude of QR sign.
lng Float Longitude measured in degrees. Longitude of QR sign.

Table Name: BUILDINGS
Data Model: Building
Parameters Data Type Constraints/Notes
buildingId (PrimaryKey) String Required. Building Code.
buildingName String Required. Building name sometimes equals buildingId.
lat Float Latitude measured in degrees.
lng Float Longitude measured in degrees.
rooms Array List of Room(s).

Additional Data Model

Data Model: Room
Parameters Data Type Constraints/Notes
roomId String Required. AKA Room number.
roomName String
floorNumber Integer