nextpick

Tables (17)

boards (게시판)

  • id (Key) — Not Null — Primary key — NOT NULL
  • member_id (회원 순번) — Not Null — Foreign key → members.id — NOT NULL
  • image_id (이미지 순번) — Not Null — Foreign key → images.id — NOT NULL
  • member_nickname (회원 닉네임) — Not Null
  • title (제목) — Not Null
  • content (내용) — Not Null
  • dtype (게시판 종류) — Not Null
  • view (조회수) — Not Null
  • like_count (좋아요수) — Not Null
  • create_at (생성 시간) — Not Null
  • modified_at (수정 시간) — Not Null

comments (댓글)

  • id (Key) — Not Null — Primary key — NOT NULL
  • board_id (게시판 순번) — Not Null — Foreign key → boards.id — NOT NULL
  • member_id (회원 순번) — Not Null — Foreign key → members.id — NOT NULL
  • parent_id (부모댓글 순번) — Foreign key → comments.id — NOT NULL
  • content (내용) — Not Null
  • create_at (생성 시간) — Not Null
  • modified_at (수정 시간) — Not Null

images (게시물 이미지)

  • id (Key) — Not Null — Primary key — NOT NULL
  • image_url (이미지 url) — Not Null

interview_feedbacks (면접 피드백)

  • id (Key) — Not Null — Primary key — NOT NULL
  • mentee (멘티) — Not Null — Foreign key → members.id — NOT NULL
  • mentor (멘토) — Not Null — Foreign key → members.id — NOT NULL
  • room_id (면접방 순번) — Not Null
  • content (피드백 내용) — Not Null
  • create_at (생성 시간) — Not Null

interview_rooms (면접방)

  • id (Key) — Not Null — Primary key — NOT NULL
  • member_id (멘토) — Not Null — Foreign key → members.id — NOT NULL
  • title (제목) — Not Null
  • uuid (방코드) — Not Null
  • category (카테고리) — Not Null

interview_times (면접 시간)

  • id (Key) — Not Null — Primary key — NOT NULL
  • member_id (멘토) — Not Null — Foreign key → members.id — NOT NULL
  • room_id (면접방 순번) — Not Null
  • start_time (시작 시간) — Not Null
  • end_time (종료 시간)

likes (좋아요)

  • id (Key) — Not Null — Primary key — NOT NULL
  • board_id (게시판 순번) — Not Null — Foreign key → boards.id — NOT NULL
  • member_id (회원 순번) — Not Null — Foreign key → members.id — NOT NULL

member_roles (회원 권한)

  • id (Key) — Not Null — Primary key — NOT NULL
  • member_id (회원 순번) — Not Null — Foreign key → members.id — NOT NULL
  • role_name (권한 이름) — Not Null

members (회원)

  • id (Key) — Not Null — Primary key — NOT NULL
  • name (이름) — Not Null
  • gender (성별) — Not Null
  • email (이메일) — Not Null
  • password (비밀번호) — Not Null
  • nickname (닉네임) — Not Null
  • guilty_score (유죄 점수) — Not Null
  • member_status (회원 상태) — Not Null
  • career (경력) — Not Null
  • occupation (직군) — Not Null
  • create_at (생성 시간) — Not Null
  • modified_at (수정 시간) — Not Null
  • member_type (회원 타입) — Not Null

mentor_feedbacks (멘토 피드백)

  • Key — Not Null — Primary key — NOT NULL
  • mentee (멘티) — Not Null — Foreign key → members.id — NOT NULL
  • mentor (멘토) — Not Null — Foreign key → members.id — NOT NULL
  • content (내용) — Not Null
  • create_at (생성 시간) — Not Null
  • star_rating (별점) — Not Null

participants (참여자)

  • id (Key) — Not Null — Primary key — NOT NULL
  • room_id (면접방 순번) — Not Null — Foreign key → interview_rooms.id — NOT NULL
  • member_id (참여자) — Not Null — Foreign key → members.id — NOT NULL

question_boards (면접 질문 게시판)

  • board_id (Key) — Not Null — Foreign key → boards.id — NOT NULL
  • category (카테고리) — Not Null

question_categories (질문 카테고리)

  • id (Key) — Not Null — Primary key — NOT NULL
  • name (카테고리 이름) — Not Null

question_lists (면접 질문 리스트)

  • id (Key) — Not Null — Primary key — NOT NULL
  • question_category_id (질문 카테고리) — Not Null — Foreign key → question_categories.id — NOT NULL
  • question (질문) — Not Null
  • answer (정답) — Not Null
  • correct_count (맞은수) — Not Null
  • wrong_count (틀린수) — Not Null
  • correct_rate (정답률) — Not Null
  • question_status (질문 상태) — Not Null

reports (신고)

  • id (Key) — Not Null — Primary key — NOT NULL
  • reporter (신고자) — Not Null — Foreign key → members.id — NOT NULL
  • respondent (신고대상) — Not Null — Foreign key → members.id — NOT NULL
  • content (신고 사유) — Not Null
  • create_at (생성 시간) — Not Null

review_boards (면접 후기)

  • board_id (Key) — Not Null — Foreign key → boards.id — NOT NULL

solves (푼 문제)

  • id (Key) — Not Null — Primary key — NOT NULL
  • question_list_id (면접 질문 순번) — Not Null — Foreign key → question_lists.id — NOT NULL
  • member_id (회원 순번) — Not Null — Foreign key → members.id — NOT NULL
  • correct (맞춤) — Not Null
  • my_answer (회원 대답)
  • create_at (생성 시간) — Not Null
  • modified_at (수정 시간) — Not Null