게시판 물리적 모델링

테이블 (3)

Article (Untitled2)

  • id (Key) — INT — 기본 키 — NOT NULL
  • title (Field) — VARCHAR(400) — NOT NULL
  • text (Field2) — VARCHAR(4000) — NOT NULL
  • read_count (Field3) — INT — NOT NULL
  • regdate (Field4) — DATETIME — NOT NULL
  • id (Key2) — INT — 외래 키 → Member.id — NOT NULL

Like (Untitled3)

  • id (Key) — INT — 기본 키 — NOT NULL
  • member_id (Field) — INT — NOT NULL
  • article_id (Field2) — INT — NOT NULL
  • regdate (Field3) — DATETIME — NOT NULL

Member (Untitled)

  • id (Key) — INT — 기본 키 — NOT NULL
  • account_name (Field) — VARCHAR(50) — NOT NULL
  • password (Field2) — VARCHAR(200) — NOT NULL
  • birth (Field3) — DATETIME
  • gender (Field4) — VARCHAR(1)
  • regdate (Field5) — DATETIME — NOT NULL