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