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