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)