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