M&M ERD

Tables (13)

Copy Of Copy Of Copy Of Untitled (MENTORING_HISTORY)

  • Key (M_IDX) — NUMBER — Primary key — NOT NULL — 멘토링번호
  • Key (USER_IDX) — NUMBER — Foreign key → Untitled.Key — NOT NULL — 유저번호
  • Key (MENTOR_IDX) — NUMBER — Foreign key → MENTOR_USER.Key — NOT NULL — 멘토유저번호
  • Field (MENTOR_NAME) — VARCHAR2(30) — NOT NULL — 멘토 이름
  • Field (START_DATE) — DATE — NOT NULL — 시작일자
  • Field (END_DATE) — DATE — NOT NULL — 종료일자
  • Field (PRICE) — NUMBER — 진행가격
  • Field (STATE) — CHAR(1) — 멘토링 상태
  • Field (MENTEE_NAME) — VARCHAR2(30) — NOT NULL — 멘티이름
  • Field (EP_DATE) — Date — 저장만료일자

Copy Of Untitled2 (MENTOR_COMMENT)

  • Key (CO_IDX) — NUMBER — Primary key — NOT NULL — 댓글번호
  • Field (USER_ID) — VARCHAR2(30) — NOT NULL — 유저아이디
  • Field (CO_CONTENT) — VARCHAR2(500 CHAR) — NOT NULL — 댓글내용
  • Field (REG_DATE) — DATE — NOT NULL — 댓글작성일
  • Field (REC_COUNT) — NUMBER — NOT NULL — 댓글추천수
  • Field (DETAIL_DATE) — NOT NULL — 상세시간
  • Key (BD_IDX) — NUMBER — Foreign key → Untitled2.Key — 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(100) — NOT NULL — 재학중인 학교
  • Field2 (MAJOR) — VARCHAR2(100) — NOT NULL — 계열
  • Field3 (GRADE) — NUMBER — NOT NULL — 학년
  • Field4 (HOPE_UNIVERSITY) — VARCHAR2(300) — 희망대학
  • Field (HOPE_MAJOR) — VARCHAR2(300) — 희망학과
  • Field (IS_LEAVE) — NUMBER — 탈퇴여부

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(100) — NOT NULL — 학교명
  • Field (UNIVERSITY_TYPE) — VARCHAR2(30) — NOT NULL — 대학종류
  • Field (GRADE) — NUMBER — NOT NULL — 학년
  • Field2 (MAJOR) — VARCHAR2(100) — NOT NULL — 전공계열
  • Field3 (WANT_DAY) — VARCHAR2(300) — 원하는요일
  • Field (WANT_TIME) — VARCHAR2(300) — 원하는시간
  • Field (REQUIREMENT) — VARCHAR2(300) — 요구사항
  • Field2 (HISTORY) — VARCHAR2(300) — 이력사항
  • Field (MENTORING_CNT) — NUMBER — NOT NULL — 멘토링횟수
  • Field (PROFILE_IMG) — NUMBER — 프로필사진유무
  • Field (ACCOUNT_NUM) — VARCHAR2(40) — NOT NULL — 계좌번호
  • Field (BANK) — VARCHAR2(20) — NOT NULL — 은행
  • Field (IS_LEAVE) — NUMBER — 탈퇴여부

Untitled (MEMBER)

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

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 (TITLE) — VARCHAR2(30) — NOT NULL — 일정
  • Field (DONE) — CHAR(1) — NOT NULL — 일정완료
  • Field2 (COLOR) — VARCHAR2(10) — NOT NULL — 색상

Untitled (FILE_INFO)

  • Key (TYPE_IDX) — NUMBER — Foreign key → MENTOR_USER.Key — NOT NULL — 타입 idx
  • Field (FL_IDX) — NUMBER — NOT NULL — 파일 idx
  • Field (ORIGIN_FILE_NAME) — VARCHAR2(260CHAR) — NOT NULL — 원본파일명
  • Field2 (RENAME_FILE_NAME) — VARCHAR2(260CHAR) — NOT NULL — 저장파일명
  • Field (SAVE_PATH) — VARCHAR2(260CHAR) — NOT NULL — 저장경로
  • Field (IS_DEL) — NUMBER — 삭제여부

Untitled (APPLY_HISTORY)

  • Key (A_IDX) — NUMBER — Primary key — NOT NULL — 신청멘토링번호
  • Key (USER_IDX) — NUMBER — Foreign key → Untitled.Key — NOT NULL — 유저번호
  • Field (EP_DATE) — DATE — 신청만료일자
  • Field (MENTOR_IDX) — NUMBER — NOT NULL — 멘토유저번호
  • Field (MENTOR_NAME) — VARCHAR2(30) — NOT NULL — 멘토 이름
  • Field (REAPLLY_CNT) — NUMBER — NOT NULL — 재신청횟수
  • Field2 (APPLY_DATE) — DATE — NOT NULL — 신청일자
  • Field (MENTEE_NAME) — VARCHAR2(30) — NOT NULL — 멘티이름

Untitled (KAKAO_LOGIN)

  • Key (USER_IDX) — NUMBER — Foreign key → Untitled.Key — NOT NULL — 유저번호
  • Field (KAKAO_ID) — VARCHAR2(50) — NOT NULL — 카카오유니크아이디

Untitled2 (MENTOR_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 — 게시글내용
  • Field (USER_ID) — VARCHAR2(30) — NOT NULL — 유저아이디
  • Field (DETAIL_DATE) — VARCHAR2(20) — NOT NULL — 상세시간
  • Key (MENTOR_IDX) — NUMBER — Foreign key → MENTOR_USER.Key — NOT NULL — 멘토유저번호

Untitled2 (RATING)

  • Key (RATING_IDX) — NUMBER — Primary key — NOT NULL — 평가번호
  • Key (MENTOR_IDX) — NUMBER — Foreign key → MENTOR_USER.Key — NOT NULL — 멘토유저번호
  • Field (USER_IDX) — NUMBER — 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) — 설명능력
  • Field (USER_COMMENT) — VARCHAR2(300) — 유저코맨트

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 — 게시글내용
  • Field (USER_ID) — VARCHAR2(30) — NOT NULL — 유저아이디
  • Field (DETAIL_DATE) — VARCHAR2(20) — NOT NULL — 상세시간
  • Key (MENTEE_IDX) — NUMBER — Foreign key → Copy Of Untitled22.Key — NOT NULL — 멘티유저번호

Untitled2 (MENTEE_COMMENT)

  • Key (CO_IDX) — NUMBER — Primary key — NOT NULL — 댓글번호
  • Field (USER_ID) — VARCHAR2(30) — NOT NULL — 유저아이디
  • Field (CO_CONTENT) — VARCHAR2(500 CHAR) — NOT NULL — 댓글내용
  • Field (REG_DATE) — DATE — NOT NULL — 댓글작성일
  • Field (REC_COUNT) — NUMBER — NOT NULL — 댓글추천수
  • Field (DETAIL_DATE) — VARCHAR2(20) — NOT NULL — 상세시간
  • Key (BD_IDX) — NUMBER — Foreign key → Untitled2.Key — NOT NULL — 게시글번호