게시판

테이블 (3)

board

  • bno — int — 기본 키 — NOT NULL
  • title — varchar(100) — NOT NULL
  • writer — varchar(100) — NOT NULL
  • content — text
  • readcount — int
  • image_file — text
  • reg_date — datetime
  • id — varchar(100) — 외래 키 → member.id — NOT NULL

member

  • id — varchar(100) — 기본 키 — NOT NULL
  • Password — varchar(100) — NOT NULL
  • Email — varchar(100) — NOT NULL
  • Age — int — NOT NULL
  • Reg_date — datetime
  • Last_login — datetime

reply

  • rno — int — 기본 키 — NOT NULL
  • user_id — varchar(100) — NOT NULL
  • board_bno — int — NOT NULL
  • content — text
  • reg_date — datetime
  • id (id2) — varchar(100) — 외래 키 → member.id — NOT NULL
  • bno (bno2) — int — 외래 키 → board.bno — NOT NULL