classbooking

Tables (7)

Building (Untitled3)

  • building_id (Key) — String — Primary key — NOT NULL
  • name (Field) — String

Regular_Class (Untitled5)

  • class_id (Key) — String — Primary key — NOT NULL
  • semester_id (Key2) — String — Foreign key → semester.semester_id — NOT NULL
  • room_id (Key3) — String — Foreign key → Room.room_id — NOT NULL
  • building_id (Key22) — String — Foreign key → Room.building_id — NOT NULL
  • user_id (Key32) — String — Foreign key → Room.user_id — NOT NULL
  • semester_id (Field) — String
  • room_id (Field2) — String
  • day_of_week (Field3) — String
  • start_time (Field4) — time
  • end_time (Field5) — time
  • subject_name (Field6) — String
  • professor_name (Field7) — String

Reservation (Untitled4)

  • reservation_id (Key) — String — Primary key — NOT NULL
  • user_id (Key2) — String — Foreign key → User.user_id — NOT NULL
  • room_id (Field) — String
  • user_id (Field2) — String
  • processed_id (Field3) — String
  • reservaition_id (Field4) — data
  • start_time (Field5) — time
  • end_time (Field6) — time
  • purpose (Field7) — String
  • headcount (Field8) — int
  • Field9 — string
  • reject_reason (Field10) — string

Room (Untitled2)

  • room_id (Key) — String — Primary key — NOT NULL
  • building_id (Key2) — String — Foreign key → Building.building_id — NOT NULL
  • user_id (Key3) — String — Foreign key → User.user_id — NOT NULL
  • buliding_id (Field) — String
  • manager_id (Field2) — String
  • floor (Field3) — String
  • room_no (Field4) — String
  • room_type (Field5) — String
  • capacity (Field6) — int
  • notice (Field7) — String

User (Untitled)

  • user_id (Key) — String — Primary key — NOT NULL
  • email (Field) — String
  • passward (Field2) — String
  • name (Field3) — String
  • department (Field4) — String
  • student_staff_no (Field5) — String
  • role (Field6) — String

favorite (Untitled7)

  • user_id (Key) — String — Foreign key → User.user_id — NOT NULL
  • room_id (Key2) — String — Foreign key → Room.room_id — NOT NULL
  • building_id (Key22) — String — Foreign key → Room.building_id — NOT NULL
  • user_id (Key3) — String — Foreign key → Room.user_id — NOT NULL
  • user_id (Field) — String
  • room_id (Field2) — String

semester (Untitled6)

  • semester_id (Key) — String — Primary key — NOT NULL
  • name (Field) — String
  • start_date (Field2) — date
  • end_date (Field3) — date