게시판 물리적 모델링

테이블 (3)

Member

  • Key (id) — 기본 키 — NOT NULL
  • Field (account_name) — VARCHAR(50) — NOT NULL
  • Field (passoword) — VARCHAR(200) — NOT NULL
  • Field — DATETIME
  • Field2 (gender) — VARCHAR(1)
  • Field2 (regdate) — DATETIME — NOT NULL

Untitled2 (Article)

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

Untitled2 (LIke)

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