airbnb_clone

Tables (6)

Facilities

  • Long (facilityId) — NOT NULL — Primary key — NOT NULL
  • Long (houseId) — NOT NULL — Foreign key → House.Long — NOT NULL
  • FacilityType (facilityType) — NULL

House

  • Long (houseId) — NOT NULL — Primary key — NOT NULL
  • Long (memberId) — NOT NULL — Foreign key → Member.Long — NOT NULL
  • Category (category) — NOT NULL
  • LocalDateTime (createdAt) — NOT NULL
  • LocalDateTime (modifiedAt) — NOT NULL
  • String (title) — NOT NULL
  • String (nation) — NOT NULL
  • String (address) — NOT NULL
  • double (latitude) — NOT NULL
  • double (longitude) — NOT NULL
  • String (checkIn) — NOT NULL
  • String (checkOut) — NOT NULL
  • String (descript) — NOT NULL
  • double (starAvg) — NOT NULL

HouseImg

  • Long (houseImgId) — NOT NULL — Primary key — NOT NULL
  • Long (houseId) — NOT NULL — Foreign key → House.Long — NOT NULL
  • String (imgUrl) — NOT NULL

Member

  • Long (memberId) — NOT NULL — Primary key — NOT NULL
  • String (nickname) — NOT NULL
  • String (profileImgUrl) — NULL
  • Boolean (valid) — NOT NULL
  • LocalDateTime (createdAt) — NOT NULL

Review

  • Long (reviewId) — NOT NULL — Primary key — NOT NULL
  • Long (houseId) — NOT NULL — Foreign key → House.Long — NOT NULL
  • Long (memberId) — NOT NULL — Foreign key → Member.Long — NOT NULL
  • String (descript) — NOT NULL
  • int (star) — NOT NULL

Wish

  • Long (wishId) — NOT NULL — Primary key — NOT NULL
  • Long (memberId) — NOT NULL — Foreign key → Member.Long — NOT NULL
  • Long (houseId) — NOT NULL — Foreign key → House.Long — NOT NULL