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)