PLUG_ERD_V2

Tables (3)

Comment

  • comment_id — auto increment — Primary key — NOT NULL
  • content — text — NOT NULL
  • parent_comment — int
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • member_id — varchar(10)
  • board_id — varchar(10) — NOT NULL
  • Clike_count — int

Member

  • Key (member_id) — varchar(10) — Primary key — NOT NULL
  • name — varchar(10) — NOT NULL
  • password — varchar(20) — NOT NULL
  • email — varchar(10) — NOT NULL
  • Field4 (gender) — varchar(10) — NOT NULL
  • state — varchar(10) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • user_no — auto increment — NOT NULL

Member info

  • user_no — auto increment — Primary key — NOT NULL
  • Key (member_id) — varchar(10) — Foreign key → Member.Key — NOT NULL
  • hobby — varchar(10) — NOT NULL
  • MBTI — varchar(10) — NOT NULL
  • Data1 — int — NOT NULL — 자기소개서 답변
  • Data2 — int — NOT NULL — 자기소개서 답변
  • DataN — int
  • Matching — boolean — NOT NULL
  • HashTag — varchar(10)