hotel

Tables (4)

Booking (예약)

  • Key (booking_id) — Primary key — NOT NULL
  • 체크인 (check_in_date)
  • 체크아웃 (check_out_date)
  • 생성일 (created_at)
  • Key (user_id) — Foreign key → User.Key — NOT NULL
  • Key (room_id) — Foreign key → Room.Key — NOT NULL

Hotel (호텔)

  • Key (hotel_id) — Primary key — NOT NULL
  • 호텔명 (name)
  • 위치 (location)
  • 생성일 (created_at)
  • 이미지 (image)

Room (객실)

  • Key (room_id) — Primary key — NOT NULL
  • 룸타입 (room_type)
  • 1박가격 (price_per_night)
  • 이용가능 (is_available)
  • Key (hotel_id) — Foreign key → Hotel.Key — NOT NULL

User (사용자)

  • Key (user_id) — Primary key — NOT NULL
  • 이름 (name)
  • 이메일 (email)
  • 전화번호 (phone)
  • 생성일 (created_at)
  • Field