Mentoree

Tables (8)

Board (수행보드)

  • board_id (PK) — Long — Primary key — NOT NULL
  • member_id (작성자) — Long — Foreign key → Member.member_id — NOT NULL
  • mission_id (해당미션) — Long — Foreign key → Mission.mission_id — NOT NULL
  • content (수행내용) — String

Category (카테고리)

  • category_id (PK) — Long — Primary key — NOT NULL
  • categoryName (분류명) — String

Member (회원)

  • member_id (PK) — Long — Primary key — NOT NULL
  • email (이메일) — String
  • userpassword (비밀번호) — String
  • memberName (이름) — String
  • nickname (닉네임) — String
  • oAuthId (OAuth) — String
  • link (경력소개) — String
  • role (권한) — Enum

MemberInterest (관심분야)

  • interest_id (PK) — Long — Primary key — NOT NULL
  • member_id (회원외래키) — Long — Foreign key → Member.member_id — NOT NULL
  • category_id (PK2) — Long — Foreign key → Category.category_id — NOT NULL

Mission (미션)

  • mission_id (PK) — Long — Primary key — NOT NULL
  • program_id (프로그램외래키) — Long — Foreign key → Program.program_id — NOT NULL
  • member_id (작성자) — Long — Foreign key → Member.member_id — NOT NULL
  • title (미션제목) — String
  • goal (미션목표) — String
  • content (미션내용) — String
  • dueDate (기한) — LocalDate

Participants (참가자)

  • participant_id (PK) — Long — Primary key — NOT NULL
  • member_id (회원외래키) — Long — Foreign key → Member.member_id — NOT NULL
  • program_id (프로그램외래키) — Long — Foreign key → Program.program_id — NOT NULL
  • role (역할) — Enum
  • isHost (호스트) — boolean
  • approval (승인여부) — booelan
  • message (요청메시지) — String
  • endDate (종료날짜) — LocalDate

Program (프로그램)

  • program_id (PK) — Long — Primary key — NOT NULL
  • programName (프로그램이름) — String
  • category_id (카테고리) — Long — Foreign key → Category.category_id — NOT NULL
  • goal (목표) — String
  • maxMember (최대모집인원) — Integer
  • curNum (현재인원) — Integer
  • description (프로그램설명) — String
  • dueDate (마감기한) — LocalDate
  • isOpen (모집여부) — boolean

Reply (댓글)

  • reply_id (PK) — Long — Primary key — NOT NULL
  • member_id (작성자) — Long — Foreign key → Member.member_id — NOT NULL
  • board_id (수행보드) — Long — Foreign key → Board.board_id — NOT NULL
  • content (댓글) — String