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