Java Board

Tables (5)

tBoard (Untitled)

  • 게시판 PK (nBoardSeq) — INT(10) — Primary key — NOT NULL
  • 회원PK (nUserSeq) — INT(10) — Foreign key → tUser.회원PK — NOT NULL
  • 제목 (sTitle) — VARCHAR(100)
  • 내용 (sContent) — TEXT
  • 좋아요 갯수 (nLikeCount) — INT(10)
  • 조회수 (nHitCount) — INT(10)
  • 댓글 갯수 (nCommentCount) — INT(10)

tComment (Untitled2)

  • 댓글PK (nCommentSeq) — INT(10) — Primary key — NOT NULL
  • 게시판 PK (nBoardSeq) — INT(10) — Foreign key → tBoard.게시판 PK — NOT NULL
  • 회원PK (nUserSeq) — INT(10) — Foreign key → tBoard.회원PK — NOT NULL
  • 내용 (sContent) — TEXT
  • 대댓글 (nReply) — INT(10)
  • 등록날짜 (dtCreateDate) — TIMESTAMP

tHit (Untitled3)

  • 회원PK (nUserSeq) — INT(10) — Foreign key → tUser.회원PK — NOT NULL
  • 게시판 PK (nBoardSeq) — INT(10) — Foreign key → tBoard.게시판 PK — NOT NULL

tLike (Untitled4)

  • 회원PK (nUserSeq) — INT(10) — Foreign key → tUser.회원PK — NOT NULL
  • 게시판 PK (nBoardSeq) — INT(10) — Foreign key → tBoard.게시판 PK — NOT NULL

tUser (Untitled5)

  • 회원PK (nUserSeq) — INT(10) — Primary key — NOT NULL
  • 회원아이디 (sId) — VARCHAR(50)
  • 비밀번호 (sPassword) — VARCHAR(300)
  • 이름 (sName) — VARCHAR(5)
  • 이메일 (sEmail) — VARCHAR(50)
  • 가입날짜 (dtCreateDate) — TIMESTAMP