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