Triple-ERD
Tables (7)
Photo
- PhotoId — UUID — Primary key — NOT NULL
- ReviewID (ReviewId) — UUID — Foreign key → Review.ReviewID — NOT NULL
- PlaceId — UUID — Foreign key → Review.PlaceId — NOT NULL
Place
- PlaceId — UUID — Primary key — NOT NULL
PlaceReviewCount
- ReviewCountId (reviewCountId) — LONG — Primary key — NOT NULL
- PlaceId — UUID — Foreign key → Place.PlaceId — NOT NULL
- reviewCount — INT
PointHistory
- HistroyId (HistoryId) — LONG — Primary key — NOT NULL
- UserId — UUID — Foreign key → Review.UserId — NOT NULL
- PlaceId — UUID — Foreign key → Review.PlaceId — NOT NULL
- Point (point) — BYTE
- PointType (pointType) — STRING
- LocalDataTime (expiredDate) — data
PointRemain
- RemainId (remainId) — LONG — Primary key — NOT NULL
- UserId — UUID — Foreign key → Review.UserId — NOT NULL
- PlaceId — UUID — Foreign key → Review.PlaceId — NOT NULL
- Point (point) — BYTE
- PointType (pointType) — STRING
- LocalDataTime (expiredDate) — data
Review
- ReviewID (ReviewId) — UUID — Primary key — NOT NULL
- UserId — UUID — Foreign key → User.UserId — NOT NULL
- PlaceId — UUID — Foreign key → Place.PlaceId — NOT NULL
User
- UserId — UUID — Primary key — NOT NULL