JavajoProject

Tables (3)

board (게시판)

  • boardnum (게시글번호) — int(11) — Primary key — NOT NULL
  • id (아이디) — varchar(45) — Foreign key → userinfo.id — NOT NULL
  • title (제목) — text
  • contents (글내용) — text
  • date (글작성시간) — datetime
  • count (조회수) — int(11)
  • status (글상태(삭제여부)) — int(11)

comment (댓글창)

  • commentseq (댓글순서대로번호) — int(11) — Primary key — NOT NULL
  • id (아이디) — varchar(45) — Foreign key → board.id — NOT NULL
  • boardnum (게시글번호) — varchar(45) — Foreign key → board.boardnum — NOT NULL
  • text (댓글내용) — text
  • commenttime (댓글작성시간) — datetime
  • replynum (원래댓글번호) — int(11)
  • groupnum (댓글그룹번호) — int(11)
  • ordernum (댓글순서) — int(11)
  • status (댓글삭제여부) — int(11)

userinfo (고객정보)

  • id (아이디) — varchar(45) — Primary key — NOT NULL
  • pw (비밀번호) — varchar(45)
  • name (이름) — varchar(45)
  • tel (휴대전화) — varchar(45)
  • email (이메일) — varchar(45)
  • status (가입상태) — int(11)