e_cap_2026_1_1
Tables (8)
admins
- admin_id — INT
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- department — VARCHAR(100)
- created_at — TIMESTAMP
answers
- answer_id — integer — NOT NULL
- admin_id — integer — NOT NULL
- content — text — NOT NULL
- created_at — datetime — NOT NULL
meeting_rooms
- room_id — INT
- room_name — VARCHAR(100) — NOT NULL
- location — VARCHAR(100) — NOT NULL
- capacity — INT — NOT NULL
- room_status — VARCHAR(20) — NOT NULL
- admin_id — INT — Foreign key → admins.admin_id
qna_mappings
- mapping_id — integer — NOT NULL
- question_id — integer — NOT NULL
- answer_id — integer — NOT NULL
- created_at — datetime — NOT NULL
questions
- question_id — integer — NOT NULL
- user_id — integer — NOT NULL
- title — varchar(200) — NOT NULL
- content — text — NOT NULL
- created_at — datetime — NOT NULL
reservations
- reservation_id — INT
- user_id — INT — Foreign key → users.user_id — NOT NULL
- room_id — INT — Foreign key → meeting_rooms.room_id — NOT NULL
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
- purpose — VARCHAR(255)
- reservation_status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP
room_equipment
- equipment_id — INT
- room_id — INT — Foreign key → meeting_rooms.room_id — NOT NULL
- equipment_name — VARCHAR(100) — NOT NULL
- quantity — INT — NOT NULL
users
- user_id — INT
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- department — VARCHAR(100)
- phone — VARCHAR(20)
- role — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP