정기안전보건교육 평가

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