Project
테이블 (9)
TBJCHCRAPL
- (ENO) — VARCHAR2(8) — 기본 키 — NOT NULL
- (CHCR_NO) — NUMBER(7) — 기본 키 — NOT NULL
- (EMP_NM) — VARCHAR2(400) — NOT NULL
- (PSTN_DEPT_NM) — VARCHAR2(400) — NOT NULL
- (ENCO_DD) — VARCHAR2(8) — NOT NULL
- (CHCR_NM) — VARCHAR2(8) — NOT NULL
- (CHCR_BTH) — VARCHAR2(8) — NOT NULL
- (APL_DD) — VARCHAR2(8) — NOT NULL
- (APL_FQ) — NUMBER(25) — NOT NULL
- (CHCR_SEX) — VARCHAR2(1) — NOT NULL
- (CHCR_AGE) — NUMBER(25) — NOT NULL
- (USE_YN) — VARCHAR2(1) — NOT NULL
- (PSTN_DIV_NM) — VARCHAR2(400) — NOT NULL
- (PRG_STAT_NM) — VARCHAR2(400) — NOT NULL
TBJVALUE (TBJWGTD)
- (ENO) — VARCHAR2(8) — 기본 키 — NOT NULL
- (CHCR_NO) — NUMBER(7) — 기본 키 — NOT NULL
- (EMP_NM) — VARCHAR2(400) — NOT NULL
- (CHCR_CNT) — NUMBER(25) — NOT NULL
- (CJOB_YB_CNT) — VARCHAR2(25) — NOT NULL
- (APL_FQ) — NUMBER(25) — NOT NULL
- (CHCR_AGE) — NUMBER(25) — NOT NULL
- (USE_YN) — VARCHAR2(1) — NOT NULL
- (CHCR_BTH) — VARCHAR2(8) — NOT NULL
- (NRTR_DEPT_NM) — VARCHAR2(400) — NOT NULL
- (PRG_STAT_NM) — VARCHAR2(400) — NOT NULL
- (CHCR_NM) — VARCHAR2(8) — NOT NULL
교사 (TBJTEACHER)
- (NRTR_ENO) — VARCHAR2(8) — 기본 키 — NOT NULL
- (NRTR_EMP_NM) — VARCHAR2(400) — NOT NULL
- (NRTR_DEPT_NM) — VARCHAR2(400) — NOT NULL
- (NRTR_TELNO) — VARCHAR2(20) — NOT NULL
- (NRTR_BTH) — VARCHAR2(8) — NOT NULL
- (NRTR_SEX) — VARCHAR2(1) — NOT NULL
- (USE_YN) — VARCHAR2(1) — NOT NULL
- (PRG_STAT_NM) — VARCHAR2(400) — NOT NULL
어린이집 반 (TBJCHCRDEPT)
- (NRTR_DEPT_NM) — VARCHAR2(400) — 기본 키 — NOT NULL
- Key (NRTR_ENO) — VARCHAR2(8) — 기본 키 — NOT NULL
- (NRTR_DEPT_CNT) — VARCHAR2(8) — NOT NULL
- (CHCR_AGE) — NUMBER(25) — NOT NULL
- (USE_YN) — VARCHAR2(1) — NOT NULL
원아 (TBJCHCR)
- (CHCR_NO) — NUMBER(7) — 기본 키 — NOT NULL
- Key (CHCR_BTH) — VARCHAR2(8) — 기본 키 — NOT NULL
- Key (ENO) — VARCHAR2(8) — 기본 키 — NOT NULL
- (NRTR_DEPT_NM) — VARCHAR2(400) — NOT NULL
- (WIN_YN) — VARCHAR2(1) — NOT NULL
- (RS_TXT) — VARCHAR2(1000) — NOT NULL
- (APL_FQ) — NUMBER(25) — NOT NULL
- (APL_DD) — VARCHAR2(8) — NOT NULL
- (COT_DD) — VARCHAR2(8) — NOT NULL
- (USE_YN) — VARCHAR2(1) — NOT NULL
- (CHCR_SEX) — VARCHAR2(1) — NOT NULL
- (CHCR_AGE) — NUMBER(25) — NOT NULL
- (CHCR_NM) — VARCHAR2(8) — NOT NULL
- (PRG_STAT_NM) — VARCHAR2(400) — NOT NULL
원아 추첨 (TBJLOTTERY)
- (ENO) — VARCHAR2(8) — 기본 키 — NOT NULL
- (CHCR_NO) — NUMBER(7) — 기본 키 — NOT NULL
- (WGTD_TOTAL) — VARCHAR2 — NOT NULL
- (APL_FQ) — NUMBER(25) — NOT NULL
- (NRTR_DEPT_NM) — VARCHAR2(400) — NOT NULL
- (CHCR_NM) — VARCHAR2(8) — NOT NULL
- (CHCR_BTH) — VARCHAR2(8) — NOT NULL
- (CHCR_AGE) — NUMBER(25) — NOT NULL
- (USE_YN) — VARCHAR2(1) — NOT NULL
- (CHCR_CNT) — NUMBER(25) — NOT NULL
- (CJOB_YB_CNT) — VARCHAR2(25) — NOT NULL
추첨결과 (TBJRESULT)
- ENO — VARCHAR2(8) — 기본 키 — NOT NULL
- CHIL_CD (CHCR_NO) — NUMBER(7) — 기본 키 — NOT NULL
- (PASS_YN) — VARCHAR2(8) — NOT NULL
- (REASON) — VARCHAR2(10) — NOT NULL
- (NRTR_DEPT_NM) — VARCHAR2(400) — NOT NULL
- (CHCR_BTH) — VARCHAR2(8) — NOT NULL
- (CHIL_NM) — VARCHAR2(8) — NOT NULL
- (WGTD_TOTAL) — VARCHAR2 — NOT NULL
- (PRG_STAT_NM) — VARCHAR2(400) — NOT NULL
- (APL_DD) — VARCHAR2(8) — NOT NULL
- (EMP_NM) — VARCHAR2(400) — NOT NULL
- (APL_FQ) — NUMBER(25) — NOT NULL
- (CHCR_CNT) — NUMBER(25) — NOT NULL
- (CJOB_YB_CNT) — VARCHAR2(25) — NOT NULL
- (USE_YN) — VARCHAR2(1) — NOT NULL
픽업/휴원 신청 (TBJPICKAPL)
- (ENO) — VARCHAR2(8) — 기본 키 — NOT NULL
- (CHCR_NO) — NUMBER(7) — 기본 키 — NOT NULL
- (EMP_NM) — VARCHAR2(400) — NOT NULL
- (픽업시간) — VARCHAR2(8) — NOT NULL
- (VAC_STA_DD) — DATE — NOT NULL
- (VAR_END_DD) — DATE — NOT NULL
- (CHCR_NM) — VARCHAR2(8) — NOT NULL
- (REASON) — VARCHAR2(100) — NOT NULL
- (NRTR_DEPT_NM) — VARCHAR2(400) — NOT NULL
- (CHCR_BTH) — VARCHAR2(8) — NOT NULL
- (APL_TD_CD) — VARCHAR2(8) — NOT NULL
- (PRG_STAT_NM) — VARCHAR2(400) — NOT NULL
- Field (USE_YN) — VARCHAR2(1) — NOT NULL
학부모 (TBJEMP)
- (ENO) — VARCHAR2(8) — 기본 키 — NOT NULL
- (EMP_NM) — VARCHAR2(400) — NOT NULL
- (PSTN_DEPT_NM) — VARCHAR2(400) — NOT NULL
- (CHCR_AGE) — NUMBER(25) — NOT NULL
- (CHCR_SEX) — VARCHAR2(1) — NOT NULL
- (APL_FQ) — NUMBER(25) — NOT NULL
- (CHCR_NO) — NUMBER(7) — NOT NULL
- (CHCR_CNT) — NUMBER(25) — NOT NULL
- (USE_YN) — VARCHAR2(1) — NOT NULL
- Field (PRG_STAT_NM) — VARCHAR2(400) — NOT NULL