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