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 — 게시글번호