beanst1

Tables (9)

facility_image

  • image_id — INT(11) — NOT NULL
  • facility_id — INT(11) — Foreign key → hotel_facility.facility_id — NOT NULL
  • image_path — VARCHAR(255) — NOT NULL
  • is_main — CHAR(1)
  • display_order — INT(11)
  • created_at — DATETIME

faq

  • faq_no — INT(11) — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • question — VARCHAR(500) — NOT NULL
  • answer — TEXT — NOT NULL
  • sort_order — INT(11)
  • status — ENUM('ACTIVE','INACTIVE')
  • reg_date — DATETIME

hotel_facility

  • facility_id — INT(11) — NOT NULL
  • facility_type — VARCHAR(50) — NOT NULL
  • facility_name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • open_time — VARCHAR(50)
  • location — VARCHAR(100)
  • created_at — DATETIME
  • updated_at — DATETIME

qna

  • qna_no — INT(11) — NOT NULL
  • user_id — VARCHAR(50) — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • answer — TEXT
  • answer_date — DATETIME
  • status — ENUM('WAITING','ANSWERED')
  • view_count — INT(11)
  • reg_date — DATETIME

reservation

  • reservation_id — INT(11) — NOT NULL
  • user_id — VARCHAR(50) — NOT NULL
  • room_id — INT(11) — Foreign key → room.room_id — NOT NULL
  • room_name — VARCHAR(50) — Foreign key → room.room_name — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • check_in — DATE — NOT NULL
  • check_out — DATE — NOT NULL
  • adult_count — INT(11) — NOT NULL
  • child_count — INT(11) — NOT NULL
  • total_price — INT(11) — NOT NULL
  • status — INT(11)
  • created_at — TIMESTAMP

room

  • room_id — INT(11) — Foreign key → room_manage.room_id — NOT NULL
  • room_name — VARCHAR(50) — NOT NULL
  • base_capacity — INT(11)
  • max_capacity — INT(11)
  • base_price — INT(11) — NOT NULL
  • extra_charge — INT(11)

room_image

  • image_no — INT(11) — NOT NULL
  • room_id — INT(11) — Foreign key → room_manage.room_id
  • image_path — VARCHAR(255)
  • is_main — VARCHAR(255)
  • display_order — INT(11)
  • created_at — DATETIME

room_manage

  • room_id — INT(11) — NOT NULL
  • room_name — VARCHAR(50)
  • capacity — VARCHAR(50)
  • room_location — VARCHAR(50)
  • room_description — VARCHAR(100)
  • usage_time — VARCHAR(50)
  • amenity — VARCHAR(255)
  • minibar — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME

users

  • dataNum — INT(11) — NOT NULL
  • user_id — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(30)
  • role — VARCHAR(10) — NOT NULL
  • status — VARCHAR(15) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP