evaluation

Tables (3)

evaluation_judge (Untitled2)

  • judge_empno (Key) — varchar2(8) — Primary key — NOT NULL — 평가위원 사원번호
  • name (Field) — varchar2(50) — NOT NULL — 평가위원 이름
  • deptcode (Field2) — varchar2(7) — NOT NULL — 평가위원 근무부서
  • password (Field3) — 패스워드

evaluation_people (Untitled)

  • empno (Key2) — varchar2(8) — Primary key — NOT NULL — 평가대상자 사원번호
  • judge_empno (Key) — varchar2(8) — Foreign key → evaluation_judge.judge_empno — NOT NULL — 평가위원 사원번호
  • name (Field2) — varchar(50) — NOT NULL — 평가대상자 이름
  • deptcode (Field4) — varchar2(7) — NOT NULL — 평가대상자 현 근무부서
  • job_gubun (Field3) — varchar2(5) — NOT NULL — 구분(보직자,비보직자)
  • gradecode (Field) — 직위
  • titlecode (Field5) — 직책
  • evaluation_score (Field6) — 평가점수
  • evaluation_yn (Field7) — 평가유무

evaluation_score (Untitled3)

  • empno (Key) — Primary key — NOT NULL — 평가대상자
  • evaluation_gubun (Field) — 평가역량구분
  • evaluation01 (Field2) — 평가항목01
  • evaluation01 (Field3) — 평가항목02
  • evaluation03 (Field4) — 평가항목03
  • Field5 — 평가항목04
  • Field6 — 평가항목05
  • evaluation_year (Field7) — 평가년도
  • evaluation_seq (Field8) — 평가차수
  • evaluation_score (Field9) — 평가점수
  • evaluation_grade (Field10) — 평가등급