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