admin w&s

Tables (7)

equipments

  • Key (Field) — Primary key — NOT NULL
  • Field2 (id) — INT
  • Field3 (room_id) — INT
  • Field4 (has_projector) — BOOLEAN
  • Field5 (has_whiteboard) — BOOLEAN

notifications

  • Key (Field) — Primary key — NOT NULL
  • Field2 (id) — INT
  • Field3 (user_id) — INT
  • Field4 (reservation_id) — INT
  • Field5 (message) — VARCHAR(255)
  • Field6 (created_at) — DATETIME
  • Field7 (id_read) — BOOLEAN

reservation_participants

  • Key (Field) — Primary key — NOT NULL
  • Field2 (id) — INT
  • Field3 (reservation_id) — INT
  • Field4 (participant_id) — INT

reservations

  • Key (Field) — Primary key — NOT NULL
  • Field (id) — INT
  • Field2 (user_id) — INT
  • Field3 (room_id) — INT
  • Field4 (date) — DATE
  • Field5 (start_time) — TIME
  • Field6 (end_time) — TIME
  • Field7 (status) — ENUM('active','cancelled','expired')

rooms

  • Key (Field) — Primary key — NOT NULL
  • Field2 (id) — INT
  • Field3 (name) — VARCHAR(50)
  • Field4 (location) — VARCHAR(100)
  • Field5 (capacity) — INT

users

  • Key (Field) — Primary key — NOT NULL
  • (id) — INT
  • Field3 (name) — VARCHAR(50)
  • Field4 (email) — VARCHAR(100)
  • Field5 (password) — VARCHAR(255)
  • Field6 (role) — ENUM('student','admin')

waiting_list

  • Key (Field) — Primary key — NOT NULL
  • Field (id) — INT
  • Field2 (room_id) — INT
  • Field3 (user_id) — INT
  • Field4 (date) — DATE
  • Field5 (start_time) — TIME
  • Field6 (priority) — INT