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