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)