_게시판

테이블 (7)

article

  • article_id — Binary(16) — 기본 키 — NOT NULL
  • member_id — Binary(16) — 외래 키 → member.member_id — NOT NULL — pk
  • title — varchar(500) — NOT NULL
  • content — text — NOT NULL
  • views — bigInt — NOT NULL
  • owner — Binary(16) — NOT NULL
  • created_at — smalldatetime — NOT NULL
  • updated_at — smalldatetime — NOT NULL
  • category — varChar(255) — 외래 키 → category.category — NOT NULL

category

  • category — varChar(255) — 기본 키 — NOT NULL

comment

  • comment_id — Binary(16) — 기본 키 — NOT NULL
  • article_id — NOT NULL
  • parent (parnet) — BInary(16) — 대댓글의 주소
  • parent_depth — int — 대댓글 위치
  • comment — vharchar(1000) — NOT NULL
  • Field
  • member_id — Binary(16) — 외래 키 → member.member_id — NOT NULL — pk
  • article_id (article_id2) — Binary(16) — 외래 키 → article.article_id — NOT NULL

like

  • article_id (article_id2) — Binary(16) — 외래 키 → article.article_id — NOT NULL
  • member_id — Binary(16) — 외래 키 → article.member_id — NOT NULL — pk
  • created_at — smalldatetime

member

  • member_id — Binary(16) — 기본 키 — NOT NULL — pk
  • email — varchar(255) — NOT NULL
  • password — varchar(500) — NOT NULL
  • nickname — varchar(255) — NOT NULL
  • created_at (createa_at) — smalldatetime — NOT NULL
  • updated_at — smalldatetime — NOT NULL

role

  • role — varchar(255) — 기본 키 — NOT NULL

user_role

  • member_id (member_id2) — Binary(16) — 외래 키 → member.member_id — NOT NULL — pk
  • role (role2) — varchar(255) — 외래 키 → role.role — NOT NULL