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