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