JPA

Tables (5)

Mileage (Untitled)

  • mileage_id (아이디) — UUID — Primary key — NOT NULL
  • user_id (유저아이디) — UUID — Foreign key → Users.user_id — NOT NULL
  • pint (포인트) — int
  • reson (적립이유) — varchar

Photo (Untitled3)

  • photo_id (사진이름) — UUID — Primary key — NOT NULL
  • review_id (리뷰아이디) — UUID — Foreign key → Review.review_id — NOT NULL

Place (Untitled5)

  • place_id (아이디) — UUID — Primary key — NOT NULL

Review (Untitled4)

  • review_id (아이디) — UUID — Primary key — NOT NULL
  • user_id (유저아이디) — UUID — Foreign key → Users.user_id — NOT NULL
  • place_id (장소 아이디) — UUID — Foreign key → Place.place_id — NOT NULL
  • content (내용) — varchar
  • point (해당리뷰 포인트) — int
  • status (리뷰상태) — varchar

Users (Untitled2)

  • user_id (아이디) — UUID — Primary key — NOT NULL
  • totalPoint (총 포인트) — int