정보시스템부인턴과제
테이블 (6)
소속부서 (hgrn)
- hgtc (hgrn_team_code) — character — 기본 키 — NOT NULL
- tcd (team_code) — character — 외래 키 → 팀.tcd — NOT NULL
- hgnm (hgrn_team_name) — character
직원 변동 이력 (change_history)
- sdate (score_date) — integer — 기본 키 — NOT NULL
- aid (agent_id) — integer — 기본 키
- ovl (old_value) — character
- nvl (new_value) — character
- cvl (change_value) — character
- cdate (change_date) — integer
직원정보 (employee)
- aid (agent_id) — integer — 기본 키
- tcd (team_code) — character — 외래 키 → 팀.tcd — NOT NULL
- anm (agent_name) — character
- sta (status) — character
- role — character
팀 (team)
- tcd (team_code) — character — 기본 키 — NOT NULL
- tnm (team_name) — character
평가 확정 목록 (evaluation_list)
- sdate (score_date) — integer — 기본 키 — NOT NULL
- aid (agent_id) — integer — 기본 키 — NOT NULL
- tcd (team_code) — character — 기본 키 — NOT NULL
- tsc (total_score) — integer
- rank (ranking) — integer
평가결과 (evaluation)
- sdate (score_date) — integer — 기본 키
- aid (agent_id) — integer — 기본 키
- tcd (team_code) — character — 기본 키
- sc1 (score1) — integer
- sc2 (score2) — integer
- isf (is_score_fixed) — boolean
- itfi (is_target_fixed) — boolean
- rank (ranking) — integer