review
Tables (4)
attached_photo
- ID (attached_photo_id) — varchar(36) — Primary key — NOT NULL
- 리뷰ID (review_id) — varchar(36) — Foreign key → review.리뷰ID — NOT NULL
place
- 장소ID (place_id) — varchar(36) — Primary key — NOT NULL
- 리뷰수 (review_count) — int
point_history
- ID (id) — bigint — Primary key — NOT NULL
- 리뷰ID (review_id) — varchar(36) — Foreign key → review.리뷰ID — NOT NULL
- 포인트 (point) — tinyint
review
- 리뷰ID (review_id) — varchar(36) — Primary key — NOT NULL
- 내용 (content) — varchar(1000)
- 유저ID (user_id) — varchar(36)
- 장소ID (place_id) — varchar(36) — Foreign key → place.장소ID — NOT NULL
- 첫방문 (first_visit) — boolean
- 삭제여부 (deleted) — boolean