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