123

Tables (7)

APPLICATION_STATUS_CODE

  • STATUS_CODE — VARCHAR2(20) — Primary key
  • STATUS_NAME — VARCHAR2(100) — NOT NULL

COHORT_PROGRAM

  • PROGRAM_ID — NUMBER(10) — Primary key
  • COHORT_NO — NUMBER(4) — NOT NULL
  • PROGRAM_NAME — VARCHAR2(200) — NOT NULL
  • YEAR — NUMBER(4)
  • PROGRAM_STATUS_CODE — VARCHAR2(20) — Foreign key → PROGRAM_STATUS_CODE.STATUS_CODE — NOT NULL
  • APPLY_START_AT — DATE
  • APPLY_END_AT — DATE
  • DESCRIPTION — VARCHAR2(2000)
  • CREATED_AT — DATE
  • UPDATED_AT — DATE
  • STATUS_CODE (STATUS_CODE2) — VARCHAR2(20) — Foreign key → PROGRAM_STATUS_CODE.STATUS_CODE

MENTEE_APPLICATION

  • APPLICATION_ID — NUMBER(10) — Primary key
  • PROGRAM_ID — NUMBER(10) — 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_CODE — VARCHAR2(20) — Foreign key → ORG_TYPE_CODE.ORG_TYPE_CODE
  • APPLICATION_STATUS_CODE — VARCHAR2(20) — Foreign key → APPLICATION_STATUS_CODE.STATUS_CODE
  • CREATED_AT — DATE
  • UPDATED_AT — DATE
  • PROGRAM_ID (PROGRAM_ID2) — NUMBER(10) — Foreign key → COHORT_PROGRAM.PROGRAM_ID
  • STATUS_CODE (STATUS_CODE2) — VARCHAR2(20) — Foreign key → COHORT_PROGRAM.STATUS_CODE
  • STATUS_CODE (STATUS_CODE3) — VARCHAR2(20) — Foreign key → APPLICATION_STATUS_CODE.STATUS_CODE
  • ORG_TYPE_CODE (ORG_TYPE_CODE2) — VARCHAR2(20) — Foreign key → ORG_TYPE_CODE.ORG_TYPE_CODE

NOTICE

  • NOTICE_ID — NUMBER(10) — Primary key
  • TITLE — VARCHAR2(300) — NOT NULL
  • CONTENT — CLOB
  • NOTICE_TYPE_CODE — VARCHAR2(20) — Foreign key → NOTICE_TYPE_CODE.NOTICE_TYPE_CODE
  • IS_PINNED — CHAR(1)
  • CREATED_AT — DATE
  • UPDATED_AT — DATE
  • NOTICE_TYPE_CODE (NOTICE_TYPE_CODE2) — VARCHAR2(20) — Foreign key → NOTICE_TYPE_CODE.NOTICE_TYPE_CODE

NOTICE_TYPE_CODE

  • NOTICE_TYPE_CODE — VARCHAR2(20) — Primary key
  • NOTICE_TYPE_NAME — VARCHAR2(100) — NOT NULL

ORG_TYPE_CODE

  • ORG_TYPE_CODE — VARCHAR2(20) — Primary key
  • ORG_TYPE_NAME — VARCHAR2(100) — NOT NULL

PROGRAM_STATUS_CODE

  • STATUS_CODE — VARCHAR2(20) — Primary key
  • STATUS_NAME — VARCHAR2(100) — NOT NULL