AI Mentoring

Tables (12)

FILE_ATTACHMENT

  • FILE_ID — INT — Primary key
  • ENTITY_TYPE — VARCHAR(50)
  • ENTITY_ID — INT
  • FILE_NAME — VARCHAR(300)
  • FILE_PATH — VARCHAR(1000)
  • CONTENT_TYPE — VARCHAR(200)
  • FILE_SIZE — INT
  • NOTE — VARCHAR(1000)
  • CREATED_AT — DATE
  • CREATED_BY — INT

MENTEE_PROFILE

  • MENTEE_ID — INT — Primary key
  • USER_ID — INT
  • ORG_ID — INT
  • RANK — VARCHAR(50)
  • POSITION — VARCHAR(100)
  • NOTE — VARCHAR(4000)
  • CREATED_AT — DATE
  • CREATED_BY — INT
  • UPDATED_AT — DATE
  • UPDATED_BY — INT

MENTORING_MATCH

  • MATCH_ID — INT — Primary key
  • REQUEST_ID — INT
  • MENTOR_ID — INT
  • IS_LEAD — CHAR(1)
  • STATUS — VARCHAR(20)
  • MATCHED_AT — DATE
  • NOTE — VARCHAR(4000)
  • CREATED_AT — DATE
  • CREATED_BY — INT
  • UPDATED_AT — DATE
  • UPDATED_BY — INT

MENTORING_REQUEST

  • REQUEST_ID — INT — Primary key
  • MENTEE_ID — INT
  • ORG_ID — INT
  • TITLE — VARCHAR(300)
  • FIELD_CATEGORY — VARCHAR(100)
  • CURRENT_STATUS — VARCHAR(4000)
  • NEED_DESCRIPTION — VARCHAR(4000)
  • PREFERRED_MODE — VARCHAR(20)
  • PREFERRED_TIME — VARCHAR(400)
  • SECURITY_CONSTRAINT — VARCHAR(4000)
  • STATUS — VARCHAR(20)
  • REQUEST_DATE — DATE
  • MATCHED_DATE — DATE
  • COMPLETED_DATE — DATE
  • CREATED_AT — DATE
  • CREATED_BY — INT
  • UPDATED_AT — DATE
  • UPDATED_BY — INT

MENTORING_SESSION

  • SESSION_ID — INT — Primary key
  • MATCH_ID — INT
  • SESSION_DATE — DATE
  • DURATION_MIN — INT
  • MODE — VARCHAR(20)
  • LOCATION — VARCHAR(300)
  • SUMMARY — VARCHAR(4000)
  • NEXT_ACTION — VARCHAR(4000)
  • CREATED_AT — DATE
  • CREATED_BY — INT
  • UPDATED_AT — DATE
  • UPDATED_BY — INT

MENTOR_PROFILE

  • MENTOR_ID — INT — Primary key
  • USER_ID — INT
  • ORG_ID — INT
  • POSITION — VARCHAR(100)
  • SHORT_INTRO — VARCHAR(300)
  • BIO — VARCHAR(4000)
  • CAREER_SUMMARY — VARCHAR(4000)
  • SECURITY_LEVEL — VARCHAR(50)
  • MAX_SESSIONS_PM — INT
  • IS_ACTIVE — CHAR(1)
  • CREATED_AT — DATE
  • CREATED_BY — INT
  • UPDATED_AT — DATE
  • UPDATED_BY — INT

MENTOR_SKILL

  • MENTOR_ID — INT — Primary key
  • SKILL_CODE — VARCHAR(50)
  • LEVEL — VARCHAR(20)
  • NOTE — VARCHAR(1000)
  • CREATED_AT — DATE
  • CREATED_BY — INT
  • UPDATED_AT — DATE
  • UPDATED_BY — INT

ORG

  • ORG_ID — INT — Primary key
  • ORG_NAME — VARCHAR(200)
  • ORG_TYPE — VARCHAR(50)
  • REGION — VARCHAR(100)
  • NOTE — VARCHAR(4000)
  • UPDATED_AT — DATE
  • CREATED_AT — DATE
  • CREATED_BY — INT
  • UPDATED_BY — INT

REQUEST_SKILL

  • REQUEST_ID — INT — Primary key
  • SKILL_CODE — VARCHAR(50)
  • CREATED_AT — DATE
  • CREATED_BY — INT
  • UPDATED_AT — DATE
  • UPDATED_BY — INT

RESULT_REPORT

  • REPORT_ID — INT — Primary key
  • REQUEST_ID — INT
  • REPORT_TYPE — VARCHAR(20)
  • TITLE — VARCHAR(300)
  • CONTENT — TEXT
  • SUBMITTED_BY — INT
  • SUBMITTED_AT — DATE
  • CONFIRMED_BY — INT
  • CONFIRMED_AT — DATE
  • VERSION_NO — VARCHAR(20)
  • IS_FINAL — CHAR(1)
  • CREATED_AT — DATE
  • CREATED_BY — INT
  • UPDATED_AT — DATE
  • UPDATED_BY — INT

SKILL_CODE

  • SKILL_CODE — VARCHAR(50) — Primary key
  • SKILL_NAME — VARCHAR(200)
  • CATEGORY — VARCHAR(100)
  • DESCRIPTION — VARCHAR(4000)
  • IS_ACTIVE — CHAR(1)
  • SORT_ORDER — INT
  • CREATED_AT — DATE
  • CREATED_BY — INT
  • UPDATED_AT — DATE
  • UPDATED_BY — INT

USERS

  • USER_ID — INT — Primary key
  • LOGIN_ID — VARCHAR(50)
  • PASSWORD_HASH — VARCHAR(200)
  • NAME — VARCHAR(100)
  • EMAIL — VARCHAR(200)
  • PHONE — VARCHAR(30)
  • ROLE_CODE — VARCHAR(20)
  • STATUS — VARCHAR(20)
  • CREATED_AT — DATE
  • CREATED_BY — INT
  • UPDATED_AT — DATE
  • UPDATED_BY — INT