mentoring
Tables (12)
EXPERTISE_TAG
- TAG_ID — NUMBER
- TAG_NAME — VARCHAR2(100) — NOT NULL
- CATEGORY — VARCHAR2(100)
MENTORING_MATCH
- MATCH_ID — NUMBER
- REQUEST_ID — NUMBER — Foreign key → MENTORING_REQUEST.REQUEST_ID — NOT NULL
- USER_ID — NUMBER — Foreign key → MENTOR_PROFILE.USER_ID — NOT NULL
- MATCHED_BY — NUMBER — Foreign key → USERS.USER_ID
- MATCHED_AT — DATE
- STATUS — VARCHAR2(20)
MENTORING_REPORT
- REPORT_ID — NUMBER
- MATCH_ID — NUMBER — Foreign key → MENTORING_MATCH.MATCH_ID — NOT NULL
- SESSION_ID — NUMBER — Foreign key → MENTORING_SESSION.SESSION_ID
- TITLE — VARCHAR2(200) — NOT NULL
- CONTENT — VARCHAR2(4000)
- CREATED_BY — NUMBER — Foreign key → USERS.USER_ID — NOT NULL
- CREATED_AT — DATE — NOT NULL
MENTORING_REQUEST
- REQUEST_ID — NUMBER
- PROGRAM_ID — NUMBER — Foreign key → PROGRAM.PROGRAM_ID — NOT NULL
- REQUESTER_ID — NUMBER — Foreign key → USERS.USER_ID — NOT NULL
- REQUEST_TYPE — VARCHAR2(20)
- TITLE — VARCHAR2(200) — NOT NULL
- CONTENT — VARCHAR2(2000)
- STATUS — VARCHAR2(20) — NOT NULL
- REQUESTED_AT — DATE — NOT NULL
MENTORING_SESSION
- SESSION_ID — NUMBER
- MATCH_ID — NUMBER — Foreign key → MENTORING_MATCH.MATCH_ID — NOT NULL
- SESSION_NO — NUMBER
- SESSION_DATE — DATE — NOT NULL
- START_TIME — DATE
- END_TIME — DATE
- MODE — VARCHAR2(20)
- LOCATION — VARCHAR2(200)
- SUMMARY — VARCHAR2(2000)
- ATTENDANCE_STATUS — VARCHAR2(20)
MENTOR_EXPERTISE
- MENTOR_EXPERTISE_ID — NUMBER
- USER_ID — NUMBER — Foreign key → MENTOR_PROFILE.USER_ID — NOT NULL
- TAG_ID — NUMBER — Foreign key → EXPERTISE_TAG.TAG_ID — NOT NULL
MENTOR_PROFILE
- USER_ID — NUMBER — Foreign key → USERS.USER_ID
- ORGANIZATION — VARCHAR2(200)
- RANK_OR_POSITION — VARCHAR2(100)
- CAREER_SUMMARY — VARCHAR2(1000)
- INTRODUCTION — VARCHAR2(2000)
- IS_ACTIVE — CHAR(1)
PARTICIPANT_PROFILE
- USER_ID — NUMBER — Foreign key → USERS.USER_ID
- UNIT_NAME — VARCHAR2(200)
- RANK — VARCHAR2(50)
- SERVICE_TYPE — VARCHAR2(50)
- SERVICE_NO — VARCHAR2(50)
PROGRAM
- PROGRAM_ID — NUMBER
- PROGRAM_NAME — VARCHAR2(200) — NOT NULL
- PROGRAM_TYPE — VARCHAR2(20) — NOT NULL
- COHORT_NO — VARCHAR2(20)
- START_DATE — DATE
- END_DATE — DATE
- DESCRIPTION — VARCHAR2(1000)
- IS_ACTIVE — CHAR(1)
ROLES
- ROLE_CODE — VARCHAR2(20)
- ROLE_NAME — VARCHAR2(100) — NOT NULL
- DESCRIPTION — VARCHAR2(200)
USERS
- USER_ID — NUMBER
- LOGIN_ID — VARCHAR2(50) — NOT NULL
- PASSWORD — VARCHAR2(200) — NOT NULL
- NAME — VARCHAR2(100) — NOT NULL
- EMAIL — VARCHAR2(200)
- PHONE — VARCHAR2(30)
- STATUS — VARCHAR2(20)
- CREATED_AT — DATE
- UPDATED_AT — DATE
USER_ROLES
- USER_ROLE_ID — NUMBER
- USER_ID — NUMBER — Foreign key → USERS.USER_ID — NOT NULL
- ROLE_CODE — VARCHAR2(20) — Foreign key → ROLES.ROLE_CODE — NOT NULL
- ASSIGNED_AT — DATE