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