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 — 멘티유저번호