심평원
테이블 (7)
CONSULT_CMPET_DGN_ITM
- CONSULT_CMPET_DGN_ITM_NO — NUMBER — 기본 키 — NOT NULL
- CMPET_DGN_ITM_DIV_CD — VARCHAR2(2)
- CMPET_DGN_ITM_AREA_CD — VARCHAR2(2)
- CMPET_DGN_ITM_CD — VARCHAR2(2)
- DGN_ITM_NO — NUMBER
- ITM_CN — VARCHAR2(2000)
- USE_YN — VARCHAR2(1)
CONSULT_CMPET_DGN_RESP
- CONSULT_CMPET_DGN_RESP_NO — NUMBER — 기본 키 — NOT NULL
- CONSULT_CMPET_DGN_ITM_NO — NUMBER — 외래 키 → CONSULT_CMPET_DGN_ITM.CONSULT_CMPET_DGN_ITM_NO — NOT NULL
- CONSULT_APLY_NO
- CMPET_DGN_TP_CD — VARCHAR2(2)
- ANS_VAL — NUMBER
- INP_ID — VARCHAR2(15)
- REG_DATE — DATE
- MOD_ID — VARCHAR2(15)
- MOD_DATE — DATE
CONSULT_INFO
- CONSULT_INFO_NO — NUMBER — 기본 키 — NOT NULL
- CONSULT_YEAR — VARCHAR2(4)
- TGT_NM — VARCHAR2(50)
- CONSULT_NM — VARCHAR2(200)
- CONSULT_TP_CD — VARCHAR2(2)
- INP_ID — VARCHAR2(15)
- REG_DATE — DATE
- MOD_ID — VARCHAR2(15)
- MOD_DATE — DATE
CONSULT_INFO_ASGN
- CONSULT_INFO_ASGN_NO — NUMBER — 기본 키 — NOT NULL
- CONSULT_MEMBER_NO — NUMBER
- CONSULT_APLY_NO — NUMBER
- CONSULT_MEMBER_TP_CD — VARCHAR2(2)
- INP_ID — VARCHAR2(15)
- REG_DATE — DATE
- MOD_ID — VARCHAR2(15)
- MOD_DATE — DATE
- CONSULT_APLY_NO (CONSULT_APLY_NO2) — 외래 키 → 컨설팅신청.CONSULT_APLY_NO — NOT NULL
- CONSULT_CMPET_DGN_RESP_NO — NUMBER — 외래 키 → 컨설팅신청.CONSULT_CMPET_DGN_RESP_NO — NOT NULL
- CONSULT_CMPET_DGN_ITM_NO — NUMBER — 외래 키 → 컨설팅신청.CONSULT_CMPET_DGN_ITM_NO — NOT NULL
CONSULT_INFO_SESS
- CONSULT_INFO_SESS_NO — NUMBER — 기본 키 — NOT NULL
- CONSULT_INFO_NO — NUMBER — 기본 키 — NOT NULL
- CONSULT_INFO_NO (CONSULT_INFO_NO2) — NUMBER — 외래 키 → CONSULT_INFO.CONSULT_INFO_NO — NOT NULL
- CONSULT_NM — VARCHAR2(200)
- CONSULT_SESS_NO — NUMBER
- CONSULT_SESS_TP_CD — VARCHAR2(2)
- ACC_ST_DT — DATE
- ACC_ED_DT — DATE
- INP_ID — VARCHAR2(15)
- REG_DATE — DATE
- MOD_ID — VARCHAR2(15)
- MOD_DATE — DATE
컨설트공통코드 (CONSULT_COMM_CD)
- GRP_CD_ID — VARCHAR2(50) — 기본 키 — NOT NULL
- CD_ID — VARCHAR2(10) — 기본 키 — NOT NULL
- CD_NM — VARCHAR2(200)
- CD_CN — VARCHAR2(4000)
- USE_YN — VARCHAR2(1)
- SORT_OR — NUMBER
- HGRK_GRP_CD_ID — VARCHAR2(50)
- HGRK_CD_ID — VARCHAR2(10)
- CTT_INS_CD — VARCHAR2(200)
- CTT_INS_CD_NM — VARCHAR2(200)
- REF_VAL_1 — VARCHAR2(50)
- REF_VAL_2 — VARCHAR2(50)
- REF_VAL_3 — VARCHAR2(50)
- REF_VAL_4 — VARCHAR2(50)
- REF_VAL_5 — VARCHAR2(50)
컨설팅신청 (CONSULT_APLY)
- CONSULT_APLY_NO — 기본 키 — NOT NULL
- CONSULT_CMPET_DGN_RESP_NO — NUMBER — 외래 키 → CONSULT_CMPET_DGN_RESP.CONSULT_CMPET_DGN_RESP_NO — NOT NULL
- CONSULT_CMPET_DGN_ITM_NO — NUMBER — 외래 키 → CONSULT_CMPET_DGN_RESP.CONSULT_CMPET_DGN_ITM_NO — NOT NULL
- CONSULT_INFO_SESS_NO (CONSULT_INFO_SESS_NO2) — NUMBER — 외래 키 → CONSULT_INFO_SESS.CONSULT_INFO_SESS_NO — NOT NULL
- CONSULT_INFO_NO (CONSULT_INFO_NO2) — NUMBER — 외래 키 → CONSULT_INFO_SESS.CONSULT_INFO_NO — NOT NULL
- CONSULT_INFO_NO (CONSULT_INFO_NO22) — NUMBER — 외래 키 → CONSULT_INFO_SESS.CONSULT_INFO_NO — NOT NULL
- CONSULT_INST_MEMBER_NO — NUMBER
- TRN_INST_MNG_NO — VARCHAR2(20)
- CONSULT_ST_CD — VARCHAR2(2)
- CONSULT_APLY_STEP_CD — VARCHAR2(2)
- CONSULT_MTH_CD — VARCHAR2(2)
- ZOOM_URL — VARCHAR2(100)
- NCS_JOB_CODE — VARCHAR2(10)
- NCS_JOB_CODE_NM — VARCHAR2(100)
- INST_MAIN_TRN_BIZ_CD1 — VARCHAR2(2)
- INST_MAIN_TRN_BIZ_CD2 — VARCHAR2(2)
- INST_MAIN_TRN_BIZ_CN — VARCHAR2(100)
- CONSULT_PRGM_STEP_CD — VARCHAR2(400)
- CONSULT_PRGM_AREA1 — VARCHAR2(400)
- CONSULT_PRGM_AREA2 — VARCHAR2(2)
- CONSULT_DT — DATE
- CONSULT_ST_TIME — TIMESTAMP
- CONSULT_HOPE_DT1 — TIMESTAMP
- CONSULT_HOPE_DT2 — TIMESTAMP
- CONSULT_HOPE_DT3 — TIMESTAMP
- CONSULT_HOPE_ST_TIME — TIMESTAMP
- CONSULT_HOPE_ED_TIME — TIMESTAMP
- CONSULT_HOPE_MTH_CD — VARCHAR2(2)
- CONSULT_HOPE_CRS_CNT — NUMBER
- ETC_REQ_CONT — VARCHAR2(2000)
- APLY_QUAL_REQ_CD — VARCHAR2(2)
- WRITNG_CONT1 — VARCHAR2(4000)
- WRITNG_CONT2 — VARCHAR2(1000)
- WRITNG_CONT3 — VARCHAR2(1000)
- ATCH_FILE_ID — CHAR(20)
- INP_ID — VARCHAR2(15)
- REG_DATE — DATE
- MOD_ID — VARCHAR2(15)
- MOD_DATE — DATE
- APLY_ROUND — NUMBER(10,0)