mentoring_AI
Tables (3)
COHORT_PROGRAM
- PROGRAM_ID — NUMBER
- COHORT_NO — NUMBER — NOT NULL
- PROGRAM_NAME — VARCHAR2(200) — NOT NULL
- YEAR — NUMBER
- STATUS — VARCHAR2(20)
- APPLY_START_AT — DATE
- APPLY_END_AT — DATE
- DESCRIPTION — VARCHAR2(2000)
- CREATED_AT — DATE
- UPDATED_AT — DATE
MENTEE_APPLICATION
- APPLICATION_ID — NUMBER
- PROGRAM_ID — NUMBER — Foreign key → COHORT_PROGRAM.PROGRAM_ID — NOT NULL
- APPLICANT_NAME — VARCHAR2(100) — NOT NULL
- APPLICANT_PHONE — VARCHAR2(30) — NOT NULL
- APPLICANT_EMAIL — VARCHAR2(200)
- ORG_NAME — VARCHAR2(200)
- ORG_TYPE — VARCHAR2(50)
- ITEM_NAME — VARCHAR2(300)
- ITEM_SUMMARY — VARCHAR2(1000)
- ITEM_DETAIL — VARCHAR2(4000)
- BIZ_STAGE — VARCHAR2(50)
- STATUS — VARCHAR2(20)
- SCORE_TOTAL — NUMBER
- MEMO_REVIEW — VARCHAR2(2000)
- CREATED_AT — DATE
- UPDATED_AT — DATE
NOTICE
- NOTICE_ID — NUMBER
- TITLE — VARCHAR2(300) — NOT NULL
- CONTENT — CLOB
- NOTICE_TYPE — VARCHAR2(30)
- IS_PINNED — CHAR(1)
- CREATED_AT — DATE
- UPDATED_AT — DATE