Database

Teambuilder uses an sqlite database managed through JS via Prisma. Tables include:

• User
• Partner
• Project
• Team
• TeamToStudent
• Student, and
• Semester

---

The Semester table

The Semester table is, as of May 2025, the only table used by the Demographics team for the demographics graph. All other tables are used by the Team Formation team. The Semester model contains the following fields:

  Id               String @id @default(uuid())
  Name             String
  Course           String
  Year             Int
  Sem              String
  African_American Int
  Asian            Int
  Hispanic         Int
  International    Int
  Other            Int
  White            Int
  Male             Int
  Female           Int
  Total            Int

Updating the Semester table using the import functionality on the Demographics page updates or creates an entry for every semester parsed from the spreadsheet, thus facilitating a quick transition if the database is ever lost.

(IN PROGRESS)