erd1

Tables (6)

Hotel (호텔)

  • Key (hotel_id) — int — Primary key — NOT NULL
  • 호텔 이름 (title) — string
  • 호텔 설명 (description) — string
  • 호텔 위치 (Field) — int

Reserve (예약)

  • Key (reserve_id) — int — Primary key — NOT NULL
  • Key (room_id) — int — Foreign key → Room.Key — NOT NULL
  • Key (user_id) — int — Foreign key → User.Key — NOT NULL
  • 체크인 (check_in) — datetime
  • 체크아웃 (check_out) — datetime
  • 예약날짜 (reserve_date) — timestamp
  • 결제금액 (pay_amount) — string
  • 결제타입 (pay_type) — enum

Review (리뷰)

  • Key (review_id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → User.Key — NOT NULL
  • Key (hotel_id) — int — Foreign key → Hotel.Key — NOT NULL
  • 상세 평가 (description) — string
  • 별점 (starRating) — int

Room (룸)

  • Key (room_id) — int — Primary key — NOT NULL
  • Key (hotel_id) — int — Foreign key → Hotel.Key — NOT NULL
  • 룸 이름 (name) — string
  • 요금 (fee) — string

User (회원)

  • Key (user_id) — int — Primary key — NOT NULL
  • 비밀번호 (password) — string
  • 주소 (point x ,y) — int
  • 이름 (name) — string
  • 폰번호 (phone_num) — string
  • 가입날짜 (join_date) — timestamp
  • 상태 (user_status) — enum

WatchList (찜)

  • Key (watch_list_id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → User.Key — NOT NULL
  • Key (hotel_id) — int — Foreign key → Hotel.Key — NOT NULL