답정너 db 구조
테이블 (6)
Post
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → User.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- status — ENUM('active', 'closed')
- image_url — VARCHAR(255)
- expires_at — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- view_count
Reaction
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → User.id — NOT NULL
- created_at — TIMESTAMP
- post_id — BIGINT — 외래 키 → Post.id — NOT NULL
- emoji_id — BIGINT — 외래 키 → emoji.id — NOT NULL
User
- id — BIGINT — 기본 키 — NOT NULL
- user_id — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- profile_image_url — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Vote
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → User.id — NOT NULL
- post_id — BIGINT — 외래 키 → Post.id — NOT NULL
- vote_option_ids — BIGINT — 외래 키 → VoteOption.id — NOT NULL
- created_at — TIMESTAMP
VoteOption
- id — BIGINT — 기본 키 — NOT NULL
- option_text — VARCHAR(255) — NOT NULL
- vote_count — INT
- created_at — TIMESTAMP
- post_id — BIGINT — 외래 키 → Post.id — NOT NULL
emoji
- id — BIGINT — 기본 키 — NOT NULL
- content