M&M ERD PUBLIC

Tables (13)

Copy Of Copy Of Copy Of Copy Of Untitled (MENTORING_HISTORY)

  • Key (MH_IDX) — NUMBER — Primary key — NOT NULL — 멘토링이력번호
  • Key (M_IDX) — NUMBER — Foreign key → Copy Of Copy Of Copy Of Untitled.Key — NOT NULL — 멘토링번호
  • Field2 (START_DATE) — DATE — NOT NULL — 시작일자
  • Field (END_DATE) — DATE — NOT NULL — 종료일자
  • Field3 (PRICE) — NUMBER — 진행가격
  • Field (STATE) — CHAR(1) — NOT NULL — 멘토링상태

Copy Of Copy Of Copy Of Untitled (MENTORING)

  • Key (M_IDX) — NUMBER — Primary key — NOT NULL — 멘토링번호
  • Key (TEE_IDX) — NUMBER — Foreign key — NOT NULL — 멘티유저번호
  • Key (MENTOR_IDX) — NUMBER — Foreign key → MENTOR_USER.Key — NOT NULL — 멘토유저번호

Copy Of Untitled2 (MENTOR_COMMENT)

  • Key (CO_IDX) — NUMBER — Primary key — NOT NULL — 댓글번호
  • Key (BD_IDX) — NUMBER — Foreign key → Untitled2.Key — NOT NULL — 게시글번호
  • Field (USER_IDX) — NUMBER — NOT NULL — 유저번호
  • Field (CO_CONTENT) — VARCHAR2(500 CHAR) — NOT NULL — 댓글내용
  • Field (REG_DATE) — DATE — NOT NULL — 댓글작성일
  • Field (REC_COUNT) — NUMBER — NOT NULL — 댓글추천수

Copy Of Untitled22 (USER_MENTEE)

  • Key (MENTEE_IDX) — NUMBER — Primary key — NOT NULL — 멘티유저번호
  • Key (USER_IDX) — NUMBER — Foreign key → Untitled.Key — NOT NULL — 유저번호
  • Field (SCHOOL_NAME) — VARCHAR2(10) — NOT NULL — 재학중인 학교
  • Field2 (MAJOR) — VARCHAR2(10) — NOT NULL — 계열
  • Field3 (GRADE) — NUMBER — NOT NULL — 학년
  • Field4 (HOPE_UNIVERSITY) — VARCHAR2(10) — 희망대학
  • Field (HOPE_MAJOR) — VARCHAR2(15) — 희망학과

MENTOR_USER (USER_MENTOR)

  • Key (MENTOR_IDX) — NUMBER — Primary key — NOT NULL — 멘토유저번호
  • Key (USER_IDX) — NUMBER — Foreign key → Untitled.Key — NOT NULL — 유저번호
  • Field (UNIVERSITY_NAME) — VARCHAR2(10) — NOT NULL — 학교명
  • Field2 (MAJOR) — VARCHAR2(15) — NOT NULL — 전공
  • Field3 (WANT_DAY) — VARCHAR2(20) — 원하는요일
  • Field (WANT_TIME) — VARCHAR2(20) — 원하는시간
  • Field (REQUIREMENT) — VARCHAR2(50) — 요구사항
  • Field2 (HISTORY) — VARCHAR2(100) — 이력사항
  • Field (MENTORING_CNT) — NUMBER — NOT NULL — 멘토링횟수

Untitled (USER)

  • Key (USER_IDX) — NUMBER — Primary key — NOT NULL — 유저번호
  • Field (USER_NAME) — VARCHAR2(5) — NOT NULL — 이름
  • Field (USER_ID) — VARCHAR2(15) — NOT NULL — 아이디
  • Field (PASSWORD) — VARCHAR2(30) — NOT NULL — 비밀번호
  • Field (EMAIL) — VARCHAR2(30) — NOT NULL — 이메일
  • Field (GENDER) — CHAR(1) — NOT NULL — 성별
  • Field3 (ADDRESS) — VARCHAR2(30) — NOT NULL — 주소
  • Field4 (PHONE) — NUMBER — NOT NULL — 연락처
  • Field5 (NICKNAME) — VARCHAR2(10) — 닉네임
  • Field2 (ROLE) — NUMBER — 역할
  • Field (JOIN_DATE) — DATE — NOT NULL — 가입일자
  • Field (IS_LEAVE) — NUMBER — NOT NULL — 탈퇴여부

Untitled (TODO)

  • Key (TODO_IDX) — NUMBER — Primary key — NOT NULL — 일정번호
  • Key (USER_IDX) — NUMBER — Foreign key → Untitled.Key — NOT NULL — 유저번호
  • Field (START_DATE) — DATE — NOT NULL — 일정시작일
  • Field2 (END_DATE) — DATE — NOT NULL — 일정만료일
  • Field3 (TO_DO) — VARCHAR2(30 CHAR) — NOT NULL — 일정

Untitled (FREE_CHAT)

  • Field (CHAT_CNT) — NUMBER — 채팅횟수
  • Key (MENTOR_IDX) — NUMBER — Foreign key → MENTOR_USER.Key — NOT NULL — 멘토유저번호
  • Key (MENTEE_IDX) — NUMBER — Foreign key → Copy Of Untitled22.Key — NOT NULL — 멘티유저번호

Untitled2 (MENTOR_BOARD)

  • Key (BD_IDX) — NUMBER — Primary key — NOT NULL — 게시글번호
  • Field2 (TITLE) — VARCHAR2(50 CHAR) — NOT NULL — 게시글제목
  • Field (REG_DATE) — DATE — NOT NULL — 게시글작성일
  • (VIEW_COUNT) — NUMBER — NOT NULL — 게시글조회수
  • Field (REC_COUNT) — NUMBER — NOT NULL — 게시글추천수
  • Field (BD_CONTENT) — VARCHAR2(2000 CHAR) — NOT NULL — 게시글내용
  • Key (MENTOR_IDX) — NUMBER — Foreign key → MENTOR_USER.Key — NOT NULL — 멘토유저번호

Untitled2 (MENTEE_COMMENT)

  • Key (CO_IDX) — NUMBER — Primary key — NOT NULL — 댓글번호
  • Key (BD_IDX) — NUMBER — Foreign key → Untitled2.Key — NOT NULL — 게시글번호
  • Field (USER_IDX) — NUMBER — NOT NULL — 유저번호
  • Field (CO_CONTENT) — VARCHAR2(500 CHAR) — NOT NULL — 댓글내용
  • Field (REG_DATE) — DATE — NOT NULL — 댓글작성일
  • Field (REC_COUNT) — NUMBER — NOT NULL — 댓글추천수

Untitled2 (RATING)

  • Key (RATING_IDX) — NUMBER — Primary key — NOT NULL — 평가번호
  • Key (MENTOR_IDX) — NUMBER — Foreign key → MENTOR_USER.Key — NOT NULL — 멘토유저번호
  • Field (Kindness) — CHAR(1) — 친절함
  • Field2 (Communication) — CHAR(1) — 의사소통
  • Field3 (Professionalism) — CHAR(1) — 전문성
  • Field4 (process) — CHAR(1) — 수업진행방식
  • Field5 (time_appointment) — CHAR(1) — 시간약속이행
  • Field6 (explain) — CHAR(1) — 설명능력

Untitled2 (APPLY)

  • Key (M_IDX) — NUMBER — Foreign key → Copy Of Copy Of Copy Of Untitled.Key — NOT NULL — 멘토링번호
  • Field (EP_DATE) — DATE — NOT NULL — 신청만료일자
  • Field (MENTOR_IDX) — NUMBER — NOT NULL — 멘토유저번호

Untitled2 (MENTEE_BOARD)

  • Key (BD_IDX) — NUMBER — Primary key — NOT NULL — 게시글번호
  • Field2 (BD_TITLE) — VARCHAR2(50 CHAR) — NOT NULL — 게시글제목
  • Field (REG_DATE) — DATE — NOT NULL — 게시글작성일
  • (VIEW_COUNT) — NUMBER — NOT NULL — 게시글조회수
  • Field (REC_COUNT) — NUMBER — NOT NULL — 게시글추천수
  • Field (BD_CONTENT) — VARCHAR2(2000 CHAR) — NOT NULL — 게시글내용
  • Key (MENTEE_IDX) — NUMBER — Foreign key → Copy Of Untitled22.Key — NOT NULL — 멘티유저번호