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