vote_project

Tables (9)

age_group_result (Untitled3)

  • id (age_group_result_id) — bigint — Primary key — NOT NULL
  • id (vote_id) — bigint — Foreign key → vote.id — NOT NULL
  • id (category_id) — bigint — Foreign key → vote.id — NOT NULL
  • age_group (Field) — Enum
  • optionA_percentage (Field2) — float
  • optionB_percentage (Field3) — float

category (Untitled7)

  • id (category_id) — bigint — Primary key — NOT NULL
  • category_type (Field) — Enum

gender_result (Untitled4)

  • id (gender_result) — bigint — Primary key — NOT NULL
  • id (vote_id) — bigint — Foreign key → vote.id — NOT NULL
  • id (category_id) — bigint — Foreign key → vote.id — NOT NULL
  • gender (Field) — Enum
  • optionA_percentage (Field2) — float
  • optionB_percentage (Field3) — float

mbti_result (Untitled5)

  • id (mbti_result_id) — bigint — Primary key — NOT NULL
  • id (vote_id) — bigint — Foreign key → vote.id — NOT NULL
  • id (category_id) — bigint — Foreign key → vote.id — NOT NULL
  • mbti (Field) — Enum
  • optionA_percentage (Field2) — float
  • optionB_percentage (Field3) — float

total_result (Untitled6)

  • id (total_result_it) — bigint — Primary key — NOT NULL
  • id (vote_id) — bigint — Foreign key → vote.id — NOT NULL
  • id (category_id) — bigint — Foreign key → vote.id — NOT NULL
  • optionA_percentage (Field) — float
  • optionB_percentage (Field2) — float
  • total_votes (Field3) — int

user (Untitled8)

  • id (user_id) — bigint — Primary key — NOT NULL
  • name (Field) — String
  • age (Field2) — int
  • mbti (Field3) — Enum
  • gender (Field4) — Enum
  • coin (Field5) — int
  • email (Field6) — String

user_vote (Untitled9)

  • id (user_vote_id) — bigint — Primary key — NOT NULL
  • id (user_id) — bigint — Foreign key → user.id — NOT NULL
  • id (vote_id2) — bigint — Foreign key → vote.id — NOT NULL
  • id (category_id) — bigint — Foreign key → vote.id — NOT NULL

vote (Untitled)

  • id (vote_id) — bigint — Primary key — NOT NULL
  • id (category_id) — bigint — Foreign key → category.id — NOT NULL
  • question (Field) — String
  • status (Field2) — Enum

vote_option (Untitled2)

  • id (vote_option_id) — bigint — Primary key — NOT NULL
  • id (vote_id) — bigint — Foreign key → vote.id — NOT NULL
  • id (category_id) — bigint — Foreign key → vote.id — NOT NULL
  • option_text (Field) — String