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