평가관리_MVP
테이블 (15)
attachment
- attachment_id — varchar(50)
- attachment_linked_id — varchar(50)
- download_count — bigint
- entity_id — varchar(50)
- entity_name — varchar(200)
- file_type_value — varchar(100)
- delete_at — boolean
- original_file_name — varchar(200) — NOT NULL
- physical_file_name — varchar(200) — NOT NULL
- attachment_size — bigint
- management_code — varchar(13)
- board_no — bigint
- posts_no — bigint
- project_code — varchar(50)
- created_date — timestamp
- modified_date — timestamp
- created_by — varchar(100)
- last_modified_by — varchar(100)
code
- code_no — bigserial
- code_id — varchar(30) — NOT NULL
- code_name — varchar(500) — NOT NULL
- code_description — varchar(500)
- parent_code_id — varchar(30)
- sort_seq — smallint
- readonly_at — boolean — NOT NULL
- use_at — boolean — NOT NULL
- created_date — timestamp
- modified_date — timestamp
- created_by — varchar(100)
- last_modified_by — varchar(100)
kpi_evaluation
- kpi_evaluation_id — bigserial
- user_id — varchar(100) — 외래 키 → user.user_id — 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) — 외래 키 → code.code_id
- promotion_result — varchar(20)
- kpi_evaluation_status — varchar(30) — 외래 키 → code.code_id — NOT NULL
- attachment_id — varchar(50) — 외래 키 → attachment.attachment_id
- 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 — bigint — 외래 키 → kpi_evaluation.kpi_evaluation_id — NOT NULL
- kpi_evaluator_id — varchar(100) — NOT NULL
- kpi_evaluation_target_id — varchar(100) — NOT NULL
- kpi_evaluation_item_id — bigint — 외래 키 → kpi_evaluation_item.kpi_evaluation_item_id — 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 — bigint — 외래 키 → code.code_no — 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) — 외래 키 → code.code_id — 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) — 외래 키 → code.code_id
- released_by — varchar(100)
- attachment_id — varchar(50) — 외래 키 → attachment.attachment_id — 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 — bigint — 외래 키 → kpi_evaluation_result.kpi_evaluation_result_id — NOT NULL
- kpi_evaluation_id — bigint — 외래 키 → kpi_evaluation.kpi_evaluation_id — 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 — bigint — 외래 키 → kpi_evaluation.kpi_evaluation_id — NOT NULL
- kpi_evaluation_item_id — bigint — 외래 키 → kpi_evaluation_item.kpi_evaluation_item_id — 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
- year — varchar(4) — 기본 키 — NOT NULL
- kpi_evaluation_team_id — bigserial
- primary_evaluator_id — varchar(100) — 외래 키 → user.user_id
- evaluator_id — varchar(100) — 외래 키 → user.user_id
- org_unit_id — varchar(50)
- attachment_id — varchar(50) — 외래 키 → attachment.attachment_id
- status_code — bigint — 외래 키 → code.code_no — NOT NULL
- submitted_at — timestamp
- can_submit — boolean — NOT NULL
- created_date — timestamp
- modified_date — timestamp
- created_by — varchar(100)
- last_modified_by — varchar(100)
kpi_goal
- goal_id — bigserial
- year — varchar(4) — NOT NULL
- user_id — varchar(100) — 외래 키 → user.user_id — NOT NULL
- goal_status_code — varchar(30) — 외래 키 → code.code_id — NOT NULL
- attachment_id — varchar(50) — 외래 키 → attachment.attachment_id
- reviewer_id — varchar(100)
- reviewer_name — varchar(100)
- reviewed_date — timestamp
- review_comment — text — ex
- 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) — 외래 키 → user.user_id — NOT NULL
- user_state_code — varchar(30) — 외래 키 → code.code_id — NOT NULL
- 1st_reviewer_id — varchar(100) — 외래 키 → user.user_id
- 2nd_reviewer_id — varchar(100) — 외래 키 → user.user_id
- 3rd_reviewer_id — varchar(100) — 외래 키 → user.user_id
- 1st_evaluator_id — varchar(100) — 외래 키 → user.user_id
- 2nd_evaluator_id — varchar(100) — 외래 키 → user.user_id
- 3rd_evaluator_id — varchar(100) — 외래 키 → user.user_id
- created_date — timestamp
- modified_date — timestamp
- created_by — varchar(100)
- last_modified_by — varchar(100)
posts
- board_no — bigint — 기본 키 — NOT NULL
- posts_no — bigint — 기본 키 — 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 — bigint — 외래 키 → code.code_no
- 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
user
- user_no — bigserial
- user_id — varchar(100) — NOT NULL
- user_name — varchar(50) — NOT NULL
- email — varchar(100) — NOT NULL
- encrypted_password — varchar(100)
- user_state_code — varchar(30) — 외래 키 → code.code_id
- emp_no — varchar(20)
- org_unit_id — varchar(50)
- org_unit_name — varchar(100)
- position_name — varchar(100)
- level_name — varchar(100)
- manager — boolean
- created_date — timestamp
- modified_date — timestamp
- created_by — varchar(100)
- last_modified_by — varchar(100)