airbnb

Tables (6)

Image (Untitled)

  • Key (image_id) — Long — Primary key — NOT NULL
  • 방 (room_id) — Long — Foreign key → Room.Key — NOT NULL
  • 이름 (name) — varchar(300)
  • url — varchar(300)

Location (지역)

  • Key (location_id) — Long — Primary key — NOT NULL
  • 지역이름 (name) — varchar(30)

Member (회원)

  • Key (member_id) — Long — Primary key — NOT NULL
  • 회원이름 (name) — varchar(30)

Reservation (예약)

  • Key (reservation_id) — Long — Primary key — NOT NULL
  • Key (member_id) — Long — Foreign key → Member.Key — NOT NULL
  • Key (room_id) — Long — Foreign key → Room.Key — NOT NULL
  • 체크인 (checkIn) — varchar(30)
  • 체크아웃 (checkOut) — varchar(30)
  • 호스트 이름 (hostName) — varchar(30)
  • 게스트 (guest) — Long
  • 어린이 (kid) — Long
  • 결제요금 (payment) — Long

Review (리뷰)

  • Key (review_id) — Long — Primary key — NOT NULL
  • Key (room_id) — Long — Foreign key → Room.Key — NOT NULL
  • 평점 (rating)

Room (숙소)

  • Key (room_id) — Long — Primary key — NOT NULL
  • 지역 (location_id) — Long — Foreign key → Location.Key — NOT NULL
  • 숙소이름 (name) — varchar(30)
  • 숙소설명 (description) — varchar(30)
  • 가구설명 (furnitureDescription) — varchar(30)
  • 잔여 방 개수 (remainingRoomCount) — Long
  • 가격 (price) — Long
  • 할인 (discount) — Long
  • 청소비 (cleaningFee) — Long
  • 서비스 수수료 (serviceCharge) — Long
  • 숙박세 (lodgingTax) — Long