정보시스템부인턴과제

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