게시판 물리적 모델링

테이블 (3)

Member

  • Key (id) — INT — 기본 키
  • Field (acoount_name) — VARCHAR(50) — NOT NULL
  • Field (password) — VARCHAR(200) — NOT NULL
  • Field (birth) — DATETIME
  • Field (gender) — VARCHAR(1)
  • Field (regdate) — DATETIME — NOT NULL
  • Field

Untitled (Article)

  • Key (id) — INT — 기본 키 — NOT NULL
  • Key (member_id) — INT — 외래 키 → Member.Key
  • Field (title) — CARCHAR(400) — NOT NULL
  • Field (text) — CARCHAR(4000) — NOT NULL
  • Field (read_count) — INT — NOT NULL
  • Field (regdate) — DATETIME — NOT NULL

Untitled (Like)

  • Key (id) — INT — 기본 키 — NOT NULL
  • Key (member_id) — INT — 외래 키 → Member.Key — NOT NULL
  • Key (article_id) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (regdate) — DATETIME — NOT NULL