test
Tables (6)
Emoji
- id — BIGINT — NOT NULL
- content — VARCHAR(255)
Post
- id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- status — ENUM('active', 'closed')
- image_url — VARCHAR(255)
- deadline — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- view_count — INT
Reaction
- id — BIGINT — Primary key — NOT NULL
- emoji — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP
User
- id — BIGINT — Primary key — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- profile_image_url — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- user_id — VARCHAR(255) — NOT NULL
Vote
- id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- post_id — BIGINT — NOT NULL
- vote_option_id — BIGINT — 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 — NOT NULL