MVP

Tables (12)

kpi_evaluation

  • kpi_evaluation_id — bigserial — 인사
  • user_id — varchar(100) — NOT NULL — 피평가자
  • evaluator_id — varchar(100) — 평가자
  • year — varchar(4) — NOT NULL — 평가
  • org_unit_name — varchar(100) — 평가
  • level_name — varchar(100) — 평가
  • position_name — varchar(100) — 평가
  • manager — boolean — NOT NULL — 직책자
  • score — NUMERIC(5,2) — 종합
  • grade_code — varchar(30) — 종합
  • promotion_result — varchar(20) — 승진
  • kpi_evaluation_status — varchar(30) — NOT NULL — 진행
  • attachment_id — varchar(50) — 최종
  • created_date — timestamp — 생성
  • modified_date — timestamp — 수정
  • created_by — varchar(100) — 생성자
  • last_modified_by — varchar(100) — 수정자

kpi_evaluation_feedback

  • kpi_evaluation_feedback_id — bigserial — 피드백
  • kpi_evaluation_id — bigserial — NOT NULL — 인사
  • kpi_evaluator_id — varchar(100) — NOT NULL — 평가자
  • kpi_evaluation_target_id — varchar(100) — NOT NULL — 피평가자
  • kpi_evaluation_item_id — bigserial — NOT NULL — 평가
  • content — text — NOT NULL — 평가자
  • created_date — timestamp — 생성
  • modified_date — timestamp — 수정
  • created_by — varchar(100) — 생성자
  • last_modified_by — varchar(100) — 수정자

kpi_evaluation_item

  • kpi_evaluation_item_id — bigserial — 평가
  • year — varchar(4) — NOT NULL — 기준
  • evaluation_code — bigserial — NOT NULL — 평가
  • item_name — varchar(100) — NOT NULL — 평가
  • subject — varchar(30) — 평가
  • is_visible — boolean — 항목
  • created_date — timestamp — 생성
  • modified_date — timestamp — 수정
  • created_by — varchar(100) — 생성자
  • last_modified_by — varchar(100) — 수정자

kpi_evaluation_period

  • kpi_evaluation_period_id — bigserial — 기간
  • year — varchar(4) — NOT NULL — 기준
  • category_code — varchar(30) — NOT NULL — 카테고리
  • is_active — boolean — 활성
  • start_date — timestamp — 시작
  • end_date — timestamp — 종료
  • created_date — timestamp — 생성
  • modified_date — timestamp — 수정
  • created_by — varchar(100) — 생성자
  • last_modified_by — varchar(100) — 수정자

kpi_evaluation_result

  • kpi_evaluation_result_id — bigserial — 결과
  • year — varchar(4) — NOT NULL — 평가
  • scheduled_at — timestamp — 공개
  • status_code — varchar(30) — 결과
  • released_by — varchar(100) — 결과
  • attachment_id — varchar(50) — NOT NULL — 최종
  • created_date — timestamp — 생성
  • modified_date — timestamp — 수정
  • created_by — varchar(100) — 생성자
  • last_modified_by — varchar(100) — 수정자

kpi_evaluation_result_score

  • kpi_evaluation_result_score_id — bigserial — 점수
  • kpi_evaluation_result_id — bigserial — NOT NULL — 평가
  • kpi_evaluation_id — bigserial — NOT NULL — 인사
  • subject — varchar(30) — 점수
  • score — NUMERIC(5,2) — 항목별
  • created_date — timestamp — 생성
  • modified_date — timestamp — 수정
  • created_by — varchar(100) — 생성자
  • last_modified_by — varchar(100) — 수정자

kpi_evaluation_self

  • kpi_evaluation_self_id — bigserial — 자기평가
  • kpi_evaluation_id — bigserial — NOT NULL — 인사
  • kpi_evaluation_item_id — bigserial — NOT NULL — 평가
  • content — text — NOT NULL — 자기평가
  • created_date — timestamp — 생성
  • modified_date — timestamp — 수정
  • created_by — varchar(100) — 생성자
  • last_modified_by — varchar(100) — 수정자

kpi_evaluation_submission_policy

  • kpi_evaluation_submission_policy_id — bigserial — 제출
  • year — varchar(4) — NOT NULL — 기준
  • start_date — timestamp — NOT NULL — 부서원
  • end_date — timestamp — NOT NULL — 부서원
  • is_active — boolean — 활성화
  • created_date — timestamp — 생성
  • modified_date — timestamp — 수정
  • created_by — varchar(100) — 생성자
  • last_modified_by — varchar(100) — 수정자

kpi_evaluation_team

  • kpi_evaluation_team_id — bigserial — 부서
  • year — varchar(4) — NOT NULL — 평가
  • primary_evaluator_id — varchar(100) — 상위
  • evaluator_id — varchar(100) — 평가
  • org_unit_id — varchar(50) — 조직
  • attachment_id — varchar(50 — 부서

kpi_goal

  • goal_id — bigserial — 목표
  • year — varchar(4) — NOT NULL — 목표
  • user_id — varchar(100) — NOT NULL — 작성자
  • goal_status_code — varchar(30) — NOT NULL — 목표
  • attachment_id — varchar(50) — 첨부파일
  • reviewer_id — varchar(100) — 최종
  • reviewer_name — varchar(100) — 최종
  • reviewed_date — timestamp — 결재
  • review_comment — text — 결재
  • created_date — timestamp — 생성
  • modified_date — timestamp — 수정
  • created_by — varchar(100) — 생성자
  • last_modified_by — varchar(100) — 수정자

kpi_target_assignment

  • target_assignment_id — bigserial — 대상자
  • year — varchar(4) — NOT NULL — 대상
  • user_id — varchar(100) — NOT NULL — 피평가자
  • user_state_code — varchar(30) — NOT NULL — 피평가자
  • 1st_reviewer_id — varchar(100) — 1차
  • 2nd_reviewer_id — varchar(100) — 2차
  • 3rd_reviewer_id — varchar(100) — 3차
  • 1st_evaluator_id — varchar(100) — 1차
  • 2nd_evaluator_id — varchar(100) — 2차
  • 3rd_evaluator_id — varchar(100) — 3차
  • created_date — timestamp — 생성
  • modified_date — timestamp — 수정
  • created_by — varchar(100) — 생성자
  • last_modified_by — varchar(100) — 수정자

posts

  • board_no — bigint — Primary key — NOT NULL — 게시판
  • posts_no — bigint — Primary key — NOT NULL — 게시물
  • prefix — varchar(20) — 말머리
  • posts_title — varchar(100) — NOT NULL — 게시물
  • posts_content — text — NOT NULL — 게시물
  • posts_answer_content — text — 게시물
  • attachment_code — varchar(255) — 첨부파일
  • visibility_code — bigserial — 공개범위
  • read_count — int — NOT NULL — 조회
  • notice_at — boolean — NOT NULL — 공지
  • delete_at — boolean — NOT NULL — 삭제
  • hide_at — boolean — NOT NULL
  • created_by — varchar(100) — NOT NULL — 생성자
  • created_date — timestamp — NOT NULL — 생성
  • last_modified_by — varchar(100) — NOT NULL — 최종
  • modified_date — timestamp — NOT NULL — 수정