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