TEAM11
Tables (8)
auth_info_tb (자체가입 유저)
- id (Key) — INT — Primary key — NOT NULL
- email (Field2) — VARCHAR(255)
- password (Field3) — VARCHAR(255)
- updated_date (Field4) — DATE
- created_date (Field5) — DATE
- user_id (Field) — INT
auth_social_login_tb (소셜로그인 유저)
- id (Key) — INT — Primary key — NOT NULL
- user_id (Field1) — INT
- oauth_code (Field2) — VARCHAR(255)
- token (Field3) — VARCHAR(255)
category_tb (카테고리)
- id (Key) — INT — Primary key — NOT NULL
- category_name (Field1) — INT
decision_tb (투표자)
- id (Key) — INT — Primary key — NOT NULL
- user_id (Field) — INT
- option_id (Field2) — INT
option_tb (선택지)
- id (Key) — INT — Primary key — NOT NULL
- option_name (Field2) — VARCHAR(255)
- option_count (Field3) — BIGINT
- vote_id (Field) — INT
user_tb (유저)
- id (Key) — INT — Primary key — NOT NULL
- user_nickname (Field) — VARCHAR(255)
- login_type (Field2) — ENUM
vote_comment_tb (댓글)
- id (Key) — INT — Primary key — NOT NULL
- vote_id (Field4) — INT
- comment_content (Field1) — VARCHAR(255)
- created_date (Field2) — DATE
- updated_date (Field3) — DATE
vote_tb (투표)
- id (Key) — INT — Primary key — NOT NULL
- category_id (Key2) — INT — Foreign key → category_tb.id — NOT NULL
- user_id (Field) — INT
- vote_title (Field2) — VARCHAR(255)
- vote_content (Field3) — VARCHAR(255)
- vote_end_date (Field4) — DATE
- created_date (Field5) — DATE
- vote_status (Field6) — ENUM
- vote_type (Field7) — ENUM