1

Tables (4)

Attach (attachTable)

  • attachPK — Primary key — NOT NULL
  • boardPK — Foreign key → Board.boardPK — NOT NULL
  • 첨부파일위치 (attachPlace)
  • 파일이름 (attachName)
  • 파일원래이름 (attachOriginName)

Board (boardTable)

  • boardPK — Primary key — NOT NULL
  • userPK — Foreign key → User.userPK — NOT NULL
  • 게시판제목 (boardTitle)
  • 게시판내용 (boardContent)
  • 생성일 (boardDate)

User (usertable)

  • userPK — Primary key — NOT NULL
  • 권한 (userRole)
  • 유저이름 (userName)
  • 비밀번호 (userPassword)
  • 이메일 (userAddress)

comment (commentTable)

  • cmPK — Primary key — NOT NULL
  • boardPK — Foreign key → Board.boardPK — NOT NULL
  • userPK — Foreign key → User.userPK — NOT NULL
  • 댓글내용 (cmContent)
  • 작성일 (cmDate)