Decide4Me
Tables (3)
users
- id — VARCHAR(36) — Primary key — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
- password — VARCHAR(30) — NOT NULL
- email — VARCHAR(40) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- last_login — DATETIME
- profile_image — TEXT
vote_options
- id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key — NOT NULL
- title — TEXT
- count — BIGINT
- index — INT
vote_participants
- id — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(36) — Foreign key → users.id — NOT NULL
- post_id — BIGINT — Foreign key — NOT NULL
- vote_option_id — BIGINT — Foreign key → vote_options.id — NOT NULL