EMON

Tables (12)

ATTEND_HIST (수강정보)

  • SEQ (순번) — Primary key — NOT NULL
  • USER_AGENT_PK (회원PK)
  • COURSE_AGENT_PK (과정PK)
  • PASS_FLAG (수료여부)
  • ATTEND_VALID_FLAG (수강확정여부)
  • EMP_INS_FLAG (고용환급과정여부)
  • PROGRESS_RATE (최종진도율)
  • TOTAL_SCORE (총점)
  • CHANGE_STATE (변경상태)
  • REG_DATE (등록일시)

ATTEND_RSLT_CT_HIST (수강종료(콘텐츠) - 혼합훈련만 해당)

  • SEQ (순번) — Primary key — NOT NULL
  • USER_AGENT_PK (회원PK)
  • COURSE_AGENT_PK (과정 PK)
  • CLASS_AGENT_PK (수업 PK)
  • CONTENTS_AGENT_PK (콘텐츠 PK)
  • TOTAL_SCORE (총점)
  • PASS_FLAG (수료여부)
  • CHANGE_STATE (변경상태)
  • REG_DATE (등록일시)

CLASS_HIST (수업정보)

  • SEQ (순번) — Primary key — NOT NULL
  • COURSE_AGENT_PK (과정PK)
  • CLASS_AGENT_PK (수업PK)
  • FULL_SCORE (만점)
  • START_DT (수업시작일)
  • END_DT (수업종료일)
  • TRACSE_TME (HRD-Net 실시회차)
  • CHANGE_STATE (변경상태)
  • REG_DATE (등록일시)

CONTENTS_HIST (콘텐츠)

  • SEQ (순번) — Primary key — NOT NULL
  • COURSE_AGENT_PK (과정PK)
  • CONTENTS_AGENT_PK (콘텐츠 PK)
  • RMYN_TCMT_SEQ (HRD-Net 원격훈련 구분일련번호)
  • RMTN_TCMT_SECD (HRD-Net 원격훈련 구분코드)
  • TRNG_CRSN (콘텐츠명)
  • CHANGE_STATE (변경상태)
  • REG_DATE (등록일시)

SCORE_CT_HIST (성적이력(콘텐츠))

  • SEQ (순번) — Primary key — NOT NULL
  • USER_AGENT_PK (회원PK)
  • COURSE_AGENT_PK (과정PK)
  • CLASS_AGENT_PK (콘텐츠PK)
  • EVAL_TYPE (평가방법)
  • SUBMIT_DATE (평가/학습진도 시작일시)
  • SCORE (평가점수/누적진도율)
  • ACCESS_IP (접속IP)
  • SUBMIT_DUE_DT (제출마감일)
  • CHANGE_STATE (변경상태)
  • IS_COPIED_ANSWER (베낀답안여부)
  • EVAL_CD (평가코드)
  • CHASI (진도차시/평가횟수)
  • SCORE_TIME (학습시간 (초))
  • SUBMIT_DATE_END (평가/학습진도 종료일시)
  • REG_DATE (등록일시)

SCORE_HIST (성적정보)

  • SEQ (순번) — Primary key — NOT NULL
  • USER_AGENT_PK (회원PK)
  • CLASS_AGENT_PK (수업PK)
  • EVAL_TYPE (평가방법)
  • SUBMIT_DATE (평가 시작일시/종료일시)
  • SCORE (평가점수/누적진도율)
  • ACCESS_IP (접속 IP)
  • SUBMIT_DUE_DT (제출마감일)
  • CHASI (진도차시/평가 횟수)
  • START_END_FLAG (접속시작/종료구분)
  • IS_COPIED_ANSWER (베낀답안여부)
  • EVAL_CD (평가코드)
  • CHANGE_STATE (변경상태)
  • REG_DATE (등록일시)

USER_ LOGIN_HIST (회원 로그인)

  • SEQ (순번) — Primary key — NOT NULL
  • COURSE_AGENT_PK (과정 PK)
  • NAME (과정명)
  • SIMSA_CODE (심사과정코드)
  • POST_COURSE_FLAG (우편과정여부)
  • TRASE_ID (HRD-Net 훈련과정 ID)
  • CHANGE_STATE (변경상태)
  • REG_DATE (등록일시)

USER_HIST (회원정보)

  • SEQ (순번) — Primary key — NOT NULL
  • USER_AGENT_PK (회원PK)
  • USER_NAME (회원이름)
  • RES_NO (주민등록번호)
  • ENC_RES_NO (수강자 소속)
  • EMAIL (이메일)
  • MOBILE (핸드폰 번호)
  • NW_INO (비용수급사업장)
  • TRNEE_SE (훈련생 구분)
  • IRGLBR_SE (비정규직구분)
  • CHANGE_STATE (변경상태)
  • REG_DATE (등록일시)

Untitled (본인인증 이력 (mOTP 외))

  • Field (등록일시/인증일시)
  • Field (평가코드)
  • Field (평가방법)
  • Field (차시)
  • Field (과정코드)
  • Field (수업코드)
  • Field (사용자 ID)
  • Field (변경상태)

Untitled (단말정보 수집 (FDS))

  • Field (훈련기관)
  • Field (이용날짜)
  • Field (훈련생 ID)
  • Field (세션 ID)
  • Field (단말기정보)

Untitled (과정정보)

  • Key (순번) — Primary key — NOT NULL
  • Field (과정PK)
  • Field (과정명)
  • Field (심사과정코드)
  • Field (우편과정여부)
  • Field (HRD-Net 훈련과정 ID)
  • Field (변경상태)
  • Field (등록일시)

mOTP (본인인증 이력 (mOTP))

  • Field (이용날짜)
  • Field (평가코드)
  • Field (평가방법)
  • Field (차시(평가횟수))
  • Field (과정코드)
  • Field (수업코드)
  • Field (사용자 ID)
  • Field (세션 ID)