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