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) — 평가등급