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)