metor

Tables (8)

admin (Untitled3)

  • admin_id (관리자 아이디) — int — Primary key — NOT NULL
  • admin_name (관리자 이름) — VARCHAR(20)
  • admin_password (관리자 비밀번호) — VARCHAR(255)
  • admin_level (관리자 등급(권한)) — VARCHAR(20)

board_coach (Untitled5)

  • coach_id (멘토멘티 게시글 번호) — int — Primary key — NOT NULL
  • member_id (유저 아이디) — int — Foreign key → member.member_id — NOT NULL
  • mentor_id (멘토 아이디) — int — Foreign key → mentor.mentor_id — NOT NULL
  • coach_title (글 제목) — VARCHAR(255)
  • coach_content (글 내용) — CLOB
  • coach_date (멘토글 등록일) — Date
  • coach_tier (멘토(글작성자) 티어) — VARCHAR(20)
  • coach_url (멘토 홍보 영상) — VARCHAR(500)

coach_tag (멘토 멘티 태그)

  • tag_id (태그 id) — int — Primary key — NOT NULL
  • tag_name (태그 이름) — VARCHAR(50)

coach_tag_map (멘토멘티 매핑)

  • tag_id (태그 id) — int — Foreign key → coach_tag.tag_id — NOT NULL
  • coach_id (멘토멘티 게시글 번호) — int — Foreign key → board_coach.coach_id — NOT NULL

member (회원)

  • member_id (유저 아이디) — int — Primary key — NOT NULL
  • member_email (이메일) — VARCHAR(255)
  • member_name (닉네임) — VARCHAR(255)
  • member_password (비밀번호) — VARCHAR(255)
  • member_reg (가입일자) — Date
  • member_login_provider (SNS 연동 카테고리) — VARCHAR(20)
  • member_sns_id (sns 계정 고유 아이디) — BIGINT

mentor (Untitled2)

  • mentor_id (멘토 아이디) — int — Primary key — NOT NULL
  • admin_id (관리자 아이디) — int — Foreign key → admin.admin_id — NOT NULL
  • member_id (유저 아이디) — int — Foreign key → member.member_id — NOT NULL
  • coach_carrer (멘토 커리어(스펙 작성)) — CLOB
  • mentor_status (멘토 승인 상태) — VARCHAR(20)
  • mentor_date (멘토 등록 날짜) — Date
  • mentor_file (파일 첨부) — BIGINT

mentoring_session (Untitled)

  • session_id (멘토링 번호) — int — Primary key — NOT NULL
  • coach_id (멘토멘티 게시글 번호) — int — Foreign key → board_coach.coach_id — NOT NULL
  • member_id (유저 아이디(멘티)) — int — Foreign key → member.member_id — NOT NULL
  • session_date (멘토멘티 매칭 날짜) — Date
  • session_status (멘토멘티 매칭 상태) — VARCHAR(20)

review (멘토멘티 글 후기)

  • review_id (리뷰 번호) — int — Primary key — NOT NULL
  • session_id (멘토링 번호) — int — Foreign key → mentoring_session.session_id — NOT NULL
  • member_id (유저 아이디(멘티)) — int — Foreign key → member.member_id — NOT NULL
  • review_rate (평점) — int
  • review_date (리뷰 작성일) — DATE
  • review_content (리뷰 내용) — CLOB