Skip to content

Database Specification

jalfrey edited this page Jan 12, 2023 · 7 revisions

Database implementation:

  • Use SQLite as a local filesystem database on the client / communication with a local database connected to the network.

General Features:

  • Interact with third-party platforms tied to existing TU software.
  • Store a list of clubs that the user is associated with.
  • Store a list of building attributes

Use requirements:

  • Store a list of classes, building locations, and times with associated locations (https://www.geocod.io/upload/)
  • Store user profile attributes (name, major, profile picture, etc.)
  • Store the clubs that a user is associated with.
  • Sync with the primary system for updates.

Map requirements:

  • Sync with the students' schedule, calendar.
  • Search for building locations.
  • Current location with current direction.

Map design pane:

  • Integrated with a search pane, as well as a calendar tab.
  • Color scheme

EER Draft: Database Draft

Clone this wiki locally