Skip to content

Discuss Database schema

Study Room schema:

  • id
  • Room number
  • building
  • capacity
  • accessibility
  • whiteboard
  • restrictions

Study Room Bookings schema:

  • id
  • study room id
  • date
  • start time
  • end time
  • user

User schema:

  • id
  • first name
  • last name
  • email
  • password
  • study room preferences
  • favourites
Edited by Iman Ahsan