평가관리_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)