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