유저게시판

테이블 (3)

Board (CopyOfUntitled)

  • bnum (key) — 기본 키 — NOT NULL
  • writer (Key2) — varchar — 외래 키 → Member.ID — NOT NULL
  • title (Field2) — varcahr — NOT NULL
  • write_date (Field3) — datetime
  • post (Field4) — text — NOT NULL
  • count (Field5) — int
  • imgfile (Field) — varchar

Comment (Untitled2)

  • cnum (Key) — int — 기본 키 — NOT NULL
  • bnum (key) — 외래 키 → Board.bnum — NOT NULL
  • writer (Key2) — varchar — 외래 키 → Member.ID — NOT NULL
  • comment (Field3) — text — NOT NULL
  • reg_date (Field4) — datetime

Member (Untitled)

  • ID (Key) — varchar — 기본 키 — NOT NULL
  • password (Field) — varchar — NOT NULL
  • email (Field2) — varchar — NOT NULL
  • age (Field3) — int
  • reg_date (Field4) — datetime
  • last_login (Field5) — datetime