Vote
Tables (4)
User (Untitled)
- user_id (Key) — BIGINT — Primary key — NOT NULL
- authority (Field2) — VARCHAR(255)
- username (Field) — VARCHAR(255) — NOT NULL — 중복 불가
- nickname (Field3) — VARCHAR(255) — NOT NULL — 중복 불가
- password (Field4) — VARCHAR(255) — NOT NULL
- refersh_token (Field5) — VARCHAR(255)
UserVotes (Untitled4)
- user_vote_id (Key) — BIGINT — Primary key — NOT NULL — auto_increment
- user_id (Key2) — BIGINT — Foreign key → User.user_id — NOT NULL
- vote_id (Key3) — BIGINT — Foreign key → Vote.vote_id — auto_incresment
- item_id (Key4) — BIGINT — Foreign key → VoteItem.item_id — NOT NULL — auto
- create_time (Field4) — DATATIME(6) — NOT NULL — 투표한 시간
- updated_time (Field2) — DATETIME(6) — NOT NULL — auto
Vote (Untitled2)
- vote_id (Key) — BIGINT — Primary key — auto_incresment
- user_id (Key2) — BIGINT — Foreign key → User.user_id — NOT NULL
- title (Field) — VARCHAR(255) — NOT NULL — 중복 불가
- created_time (Field3) — DATETIME(6) — NOT NULL — auto
- updated_time (Field4) — DATETIME(6) — NOT NULL — auto
VoteItem (Untitled3)
- item_id (Key) — BIGINT — Primary key — NOT NULL — auto
- vote_id (Key2) — BIGINT — Foreign key → Vote.vote_id — auto_incresment
- item_name (Field2) — VARCHAR(255) — NOT NULL — 중복 불가
- count (Field3) — INT — default = 0