airbnb-clone

Tables (5)

List (목록)

  • user (Key) — Foreign key → User.Key — NOT NULL
  • room (Key2) — Foreign key → Room.host — NOT NULL
  • name (Field) — char

Reivew (리뷰)

  • user (Key) — Foreign key → User.Key — NOT NULL
  • room (Key2) — Foreign key → Room.host — NOT NULL
  • review (후기) — text
  • accuracy (Field) — int
  • communication (Field2) — int
  • cleanliness (Field3) — int
  • location (Field4) — int
  • check_in (Field5) — int
  • value (Field6) — int

Reservation (예약)

  • guest (Key) — Foreign key → User.Key — NOT NULL
  • room (Key2) — Foreign key → Room.host — NOT NULL
  • status (Field) — char
  • check_in (Field2) — date
  • check_out (Field3) — date

Room (숙소)

  • host (Key) — Foreign key → User.Key — NOT NULL
  • name (이름) — char
  • description (상세설명) — text
  • country (나라)
  • city (도시) — char
  • price (가격) — int
  • address (주소) — char
  • guests (숙박 인원) — int
  • beds (침대 개수) — int
  • bedrooms (침실 수) — int
  • baths (화장실 개수) — int
  • check_in (체크인 시간)
  • check_out (체크아웃 시간)
  • instant_book (즉시 예약) — boolean
  • room_type (룸 타입)
  • amenities (어메니티)
  • facility (Field)
  • house_rules (Field2)

User (회원)

  • Key — Primary key — NOT NULL
  • avatar (이미지) — image
  • gender (성별) — char
  • bio (Field2) — text
  • birthdate (생일) — date
  • language (언어) — char
  • currency (화폐) — char
  • superhost (사용자 인증) — boolean