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