① sys_user 用户账号
id, username, password_hash, real_name, position (职位展示), department_id, superior_id (直属上级), role (EMPLOYEE/SUPER_ADMIN), created_at
② sys_department 部门/分组
id, name, parent_id (树形), leader_id, sort_order
③ assessment_period 考核周期
id, name, start_date, end_date, status (DRAFT→OKR_ALIGN→EXECUTING→ASSESSING→ARCHIVED), created_by
④ okr_objective 目标 O
id, period_id, user_id, dept_id, type (DEPT/PERSONAL), title, status, version, snapshot_json (归档快照), reviewed_by, reviewed_at
⑤ kr_key_result 关键结果 KR
id, objective_id, title, target_value, current_value, status (NOT_STARTED/IN_PROGRESS/COMPLETED/BLOCKED), weight
⑥ kr_progress_log KR 进度更新
id, kr_id, old_value, new_value, old_status, new_status, remark, updated_by, created_at
⑦ kpi_template KPI 模板
id, name, category, items_json (指标项列表), created_by
⑧ kpi_config 个人 KPI 配置
id, period_id, user_id, items_json, version, snapshot_json, locked_at
⑨ performance_score 绩效打分
id, period_id, user_id, evaluator_id, okr_score (0-40), kpi_score (0-60), bonus (加分), penalty (扣分), total, grade (S/A/B/C), type (SELF/SUPERIOR/FINAL), comments_json
⑩ performance_feedback 面谈反馈
id, period_id, user_id, superior_id, interview_notes, highlights, issues, improvements, employee_feedback
⑪ operation_log 操作日志
id, operator_id, action, entity_type, entity_id, old_data_json, new_data_json, ip, created_at
⑫ audit_correction 修正记录
id, performance_id, correction_type, old_values_json, new_values_json, reason, operated_by, created_at