FINGOLF_패키지 리뷰 관련

테이블 (5)

pkg_review

  • pr_id — int — 기본 키 — NOT NULL
  • pid — int — NOT NULL
  • review_title — varchar(45) — NOT NULL
  • review_content — varchar(500) — NOT NULL
  • review_score — int — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • author_id — int — NOT NULL

pkg_review_images

  • pri_id — int — 기본 키 — NOT NULL
  • pr_id — int — 외래 키 → pkg_review.pr_id — NOT NULL
  • image_path — varchar(45) — NOT NULL
  • created_at — datetime
  • updated_at — datetime

pkg_review_tag

  • prt_id — int — 기본 키 — NOT NULL
  • pr_id — int — 외래 키 → pkg_review.pr_id — NOT NULL
  • tag_id — int — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • reaction — int

pkg_review_tag_item

  • prti_id — int — 기본 키 — NOT NULL
  • tag_name — varchar(45) — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • positive_text — varchar(45)

pkg_review_tag_reaction

  • prtr_id — int — 기본 키 — NOT NULL
  • prti_id (prti_id2) — int — 외래 키 → pkg_review_tag_item.prti_id — NOT NULL
  • reaction_text — varchar(45) — NOT NULL
  • reaction — int — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • memo — varchar(45)