study_jsp4

Tables (3)

board (게시판)

  • bno (게시판번호) — int — Primary key — NOT NULL
  • title (제목) — varchar(100)
  • writer (작성자) — varchar(100)
  • regdate (작성일) — datetime
  • content (내용) — text
  • readcount (조회수) — int
  • image (이미지경로) — text

comment (댓글)

  • cno (댓글번호) — int — Primary key — NOT NULL
  • bno (게시판번호) — int — Foreign key → board.bno — NOT NULL
  • writer (작성자) — varchar(100)
  • content (내용) — text
  • regdate (작성일) — datetime

member (회원)

  • id (아이디) — varchar(100 — Primary key — NOT NULL
  • password (패스워드) — varchar(100)
  • name (이름) — varchar(100)
  • email (이메일) — varchar(100)
  • phone (전화번호) — vharchar(11)
  • regdate (가입일) — datetime
  • lastlogin (마지막로그인) — datetime
  • auth (관리자권한) — char(1)