심평원

테이블 (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)