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