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 — 수정