호텔예약

테이블 (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