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