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