호텔예약
테이블 (10)
Bookings
- booking_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → Users.user_id — NOT NULL
- room_id — INT — 외래 키 → Rooms.room_id — NOT NULL
- check_in_date — DATE — NOT NULL
- check_out_date — DATE — NOT NULL
- number_of_guests — INT — NOT NULL
- total_price — DECIMAL(10, 2) — NOT NULL
- status — ENUM('pending_payment', 'confirmed', 'cancelled_by_user', 'cancelled_by_owner', 'completed') — NOT NULL
- created_at — TIMESTAMP
ChatMessages
- message_id — INT — 기본 키 — NOT NULL
- chat_room_id — INT — 외래 키 → ChatRooms.chat_room_id — NOT NULL
- sender_id — INT — 외래 키 → Users.user_id — NOT NULL
- message_text — TEXT — NOT NULL
- sent_at — TIMESTAMP
- is_read — BOOLEAN
ChatRooms
- chat_room_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → Users.user_id — NOT NULL
- owner_id — INT — 외래 키 → Users.user_id — NOT NULL
- hotel_id — INT — 외래 키 → Hotels.hotel_id — NOT NULL
- created_at — TIMESTAMP
FacilitiesMaster
- facility_id — INT — 기본 키 — NOT NULL
- facility_name — VARCHAR(100) — NOT NULL
HotelFacilities
- hotel_id — INT — 외래 키 → Hotels.hotel_id — NOT NULL
- facility_id — INT — 외래 키 → FacilitiesMaster.facility_id — NOT NULL
Hotels
- hotel_id — INT — 기본 키 — NOT NULL
- owner_id — INT — 외래 키 → Users.user_id — NOT NULL
- hotel_name — VARCHAR(255) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- description — TEXT
- main_image_url — VARCHAR(255)
- check_in_time — TIME — NOT NULL
- check_out_time — TIME — NOT NULL
- status — ENUM('pending', 'approved', 'rejected', 'inactive') — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Payments
- payment_id — INT — 기본 키 — NOT NULL
- booking_id — INT — 외래 키 → Bookings.booking_id — NOT NULL
- payment_method — VARCHAR(50) — NOT NULL
- amount — DECIMAL(10, 2) — NOT NULL
- status — ENUM('completed', 'failed', 'refunded') — NOT NULL
- paid_at — TIMESTAMP
Reviews
- review_id — INT — 기본 키 — NOT NULL
- booking_id — INT — 외래 키 → Bookings.booking_id — NOT NULL
- user_id — INT — 외래 키 → Users.user_id — NOT NULL
- hotel_id — INT — 외래 키 → Hotels.hotel_id — NOT NULL
- rating — INT — NOT NULL
- comment — TEXT
- created_at — TIMESTAMP
Rooms
- room_id — INT — 기본 키 — NOT NULL
- hotel_id — INT — 외래 키 → Hotels.hotel_id — NOT NULL
- room_type_name — VARCHAR(100) — NOT NULL
- price_per_night — DECIMAL(10, 2) — NOT NULL
- max_occupancy — INT — NOT NULL
- description — TEXT
- room_image_url — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Users
- user_id — INT — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- user_name — VARCHAR(100) — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- user_role — ENUM('customer', 'owner', 'admin') — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- is_deleted — BOOLEAN