Balance_Board ERD
Tables (7)
comment (Untitled2)
- comment_id (Key) — INT(10) — Primary key — NOT NULL
- user_id (Key2) — INT(10) — Foreign key → user.user_id — NOT NULL
- post_id (Key3) — INT(10) — Foreign key → post.post_id — NOT NULL
- content (Field2) — VARCHAR(255)
post (Untitled3)
- post_id (Key) — INT(10) — Primary key — NOT NULL
- user_id (Key3) — INT(10) — Foreign key → user.user_id — NOT NULL
- vote_id (Key2) — INT(10) — Foreign key → vote.vote_id — NOT NULL
- category (Field7) — ENUM
- title (Field) — VARCHAR(255)
- content (Field2) — TEXT
- comment_count (Field3) — INT(10)
- vote_count (Field4) — INT(10)
- like_count (Field8) — INT(10)
- hate_count (Field9) — INT(10)
- updated (Field6) — TIMESTAMP
- created (Field5) — TIMESTAMP
refresh_token (Untitled7)
- refresh_token_id (Key) — INT(10) — Primary key — NOT NULL
- token (Field) — VARCHAR(255)
- user_id (Field2) — INT(10)
tag (Untitled6)
- tag_id (Key) — INT(10) — Primary key — NOT NULL
- tag_name (Field) — VARCHAR(100)
- post_id (Key2) — INT(10) — Foreign key → post.post_id — NOT NULL
user (Untitled)
- user_id (Key) — INT(10) — Primary key — NOT NULL
- provider_id (Field) — VARCHAR(100)
- provider (Field2) — VARCHAR(100)
- email (Field3) — VARCHAR(255)
- nickname (Field4) — VARCHAR(255)
- birth_year (Field5) — VARCHAR(100)
- gender (Field6) — VARCHAR(100)
- role (Field8) — VARCHAR(100)
- withdrawn (Field9) — BOOLEAN
- withdrawn_date (Field10) — TIMESTAMP
- level (Field7) — ENUM
- experiencePoints (Field13) — INT(10)
- created (Field11) — TIMESTAMP
- updated (Field12) — TIMESTAMP
vote (Untitled4)
- vote_id (Key) — INT(10) — Primary key — NOT NULL
- option1 (Field) — VARCHAR(255)
- option2 (Field2) — VARCHAR(255)
- option1_count (Field3) — INT(10)
- option2_count (Field4) — INT(10)
vote_member (Untitled5)
- vote_member_id (Key) — INT(10) — Primary key — NOT NULL
- vote_id (Key3) — INT(10) — Foreign key → vote.vote_id — NOT NULL
- user_id (Key2) — INT(10) — Foreign key → user.user_id — NOT NULL
- voted_option (Field) — VARCHAR(255)