e_2
Tables (8)
admins
- admin_id — INTEGER
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- department — VARCHAR(100)
- created_at — TIMESTAMP
answers
- answer_id — INTEGER
- admin_id — INT — Foreign key → admins.admin_id — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
meeting_rooms
- room_id — INTEGER
- 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
- question_id — INT — Foreign key → questions.question_id — NOT NULL
- answer_id — INT — Foreign key → answers.answer_id — NOT NULL
- created_at — DATETIME
questions
- question_id — INTEGER
- user_id — INT — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
reservations
- reservation_id — INTEGER
- 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 — INTEGER
- room_id — INT — Foreign key → meeting_rooms.room_id — NOT NULL
- equipment_name — VARCHAR(100) — NOT NULL
- quantity — INT — NOT NULL
users
- user_id — INTEGER
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- department — VARCHAR(100)
- phone — VARCHAR(20)
- role — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP