게시판 야호

테이블 (3)

Article (Untitled2)

  • id (Key) — INT — 기본 키 — NOT NULL
  • memder_id (Key2) — INT — 외래 키 → Member.id — 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

Like (Untitled3)

  • id (Key) — INT — 기본 키 — NOT NULL
  • member_id (Key2) — INT — 외래 키 → Member.id — NOT NULL
  • article_id (Key3) — INT — 외래 키 → Article.id — NOT NULL
  • regdate (Field) — 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