onboarding
Tables (3)
Member (회원)
- userId (회원 아이디) — Primary key — NOT NULL
- userName (회원이름) — varchar
- userPassword (회원비번) — varchar
notice (게시판)
- noticeId (게시판번호) — int — Primary key — NOT NULL
- userId (회원 아이디) — Foreign key → Member.userId — NOT NULL
- noticeName (게시판제목) — varchar
- noticeContent (게시판내용) — BLOB
- regDate (작성일) — date
- noticeViews (조회수) — int
noticeFile (게시판파일)
- fileNum (파일번호) — int — Primary key — NOT NULL
- noticeId (게시판번호) — int — Foreign key → notice.noticeId — NOT NULL
- fileName (파일이름) — varchar