정기안전보건교육 평가
테이블 (3)
T (오답 테이블)
- CMPNY_DIV (Key) — VARCHAR2(40) — 기본 키 — NOT NULL
- QUIZ_NUM (Key2) — NUMBER(11) — 기본 키 — NOT NULL
- EMPNO (Key3) — VARCHAR2(80) — 기본 키 — NOT NULL
- EMP_INPUT_ANSWER (Field) — VARCHAR2(1)
- TEST_DATE (Field2) — DATE
- ASGN_CD (Field3) — VARCHAR2(80)
- ASGN_NM (Field4) — VARCHAR2(400)
- DEPT_CD (Field5) — VARCHAR2(80)
- DEPT_NM (Field6) — VARCHAR2(400)
TQZ1010A01 (퀴즈 테이블)
- CMPNY_DIV (Key) — VARCHAR2(40) — 기본 키 — NOT NULL
- QUIZ_NUM (Key2) — NUMBER(11) — 기본 키 — NOT NULL
- QUIZ_MAIN (Field11) — VARCHAR2(400)
- QUIZ_CHOICE (Field12) — VARCHAR2(100)
- QUIZ_ANSWER (Field8) — VARCHAR2(100)
- QUIZ_POINT (Field13) — NUMBER(11)
- ASGN_CD (Field) — VARCHAR2(80)
- ASGN_NM (Field2) — VARCHAR2(400)
- DEPT_CD (Field9) — VARCHAR2(80)
- DEPT_NM (Field10) — VARCHAR2(400)
- USE_YN (Field3) — VARCHAR2(1)
- INSERT_USER_ID (Field4) — VARCHAR2(80)
- INSERT_DATE (Field5) — DATE
- UPDATE_USER_ID (Field6) — VARCHAR2(80)
- UPDATE_DATE (Field7) — DATE
Untitled (성적 테이블)
- CMPNY_DIV (Key) — VARCHAR2(40) — 기본 키 — NOT NULL
- EMPNO (Key2) — VARCHAR2(80) — 기본 키 — NOT NULL
- ASGN_CD (Field) — VARCHAR2(80)
- ASGN_NM (Field2) — VARCHAR2(400)
- DEPT_CD (Field3) — VARCHAR2(80)
- DEPT_NM (Field4) — VARCHAR2(400)
- GRADE (Field5) — NUMBER(11)
- TEST_DATE (Field6) — DATE