semiproject

테이블 (3)

게시판 (Board)

  • Key (board_id) — int — 기본 키 — NOT NULL
  • Key (member_id) — varchar(100) — 외래 키 → 회원.Key — NOT NULL
  • Field (board_title) — VARCHAR(200) — NOT NULL
  • Field (board_author) — VARCHAR(50) — NOT NULL
  • Field (board_publisher) — VARCHAR(100)
  • Field (board_content) — TEXT — NOT NULL
  • Field (board_views) — INT
  • Field (board_regdate) — DATETIME

댓글 (Comment)

  • Key (comment_id) — INT — 기본 키 — NOT NULL
  • Key (board_id) — int — 외래 키 → 게시판.Key — NOT NULL
  • Key (member_id) — varchar(100) — 외래 키 → 게시판.Key — NOT NULL
  • Field (comment_content) — TEXT — NOT NULL
  • Field (comment_regdate) — DATETIME

회원 (Member)

  • Key (member_id) — INT — 기본 키 — NOT NULL
  • Field (member_pw) — varchar(100) — NOT NULL
  • Field (member_name) — varchar(100) — NOT NULL
  • Field (member_email) — varchar(100) — NOT NULL
  • Field (member_tel) — varchar(100)
  • Field (member_regdate) — DATETIME
  • Field (member_loginId) — VARCHAR(20) — NOT NULL