SQLite Web: gitea.db

id

Primary key. INTEGER NOT NULL

title

TEXT

repo_id

INTEGER

owner_id

INTEGER

workflow_id

TEXT

index

INTEGER

trigger_user_id

INTEGER

schedule_id

INTEGER

ref

TEXT

commit_sha

TEXT

is_fork_pull_request

INTEGER

need_approval

INTEGER

approved_by

INTEGER

event

TEXT

event_payload

{"ref":"refs/heads/main","before":"0000000000000000000000000000000000000000","after":"d169207d2a046f90cf861f8e805b45d3855fddc3","compare_url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/compare/359a39b51f412a500e8e8e68555eacc56680d0e0...d169207d2a046f90cf861f8e805b45d3855fddc3","commits":[{"id":"d169207d2a046f90cf861f8e805b45d3855fddc3","message":"feat(db): 添加福利管理模块数据库迁移\n\n- 创建 hr_benefit_plans 福利计划表\n- 创建 hr_benefit_enrollments 福利登记表\n- 创建 hr_benefit_claims 福利申领表\n- 配置 RLS 多租户隔离策略\n\n🤖 Generated with [Claude Code](https://claude.com/claude-code)\n\nCo-Authored-By: Claude Opus 4.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/d169207d2a046f90cf861f8e805b45d3855fddc3","author":{"name":"hi.laoluo","email":"hi.laoluo@hilaoluodeMacBook-Pro.local","username":""},"committer":{"name":"hi.laoluo","email":"hi.laoluo@hilaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-01-03T18:47:22+08:00","added":["backend/prisma/migrations/20260103200000_add_hr_benefits/migration.sql"],"removed":[],"modified":[]},{"id":"e2dd1f5474b144ee91733881c5a05e97396c8e54","message":"Merge remote-tracking branch 'origin/claude/add-benefits-management-BgwFU'\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/e2dd1f5474b144ee91733881c5a05e97396c8e54","author":{"name":"hi.laoluo","email":"hi.laoluo@hilaoluodeMacBook-Pro.local","username":""},"committer":{"name":"hi.laoluo","email":"hi.laoluo@hilaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-01-03T18:40:54+08:00","added":["backend/src/modules/hr/benefits/claims/claim.routes.ts","backend/src/modules/hr/benefits/claims/claim.schema.ts","backend/src/modules/hr/benefits/enrollments/enrollment.routes.ts","backend/src/modules/hr/benefits/enrollments/enrollment.schema.ts","backend/src/modules/hr/benefits/index.ts","backend/src/modules/hr/benefits/plans/plan.routes.ts","backend/src/modules/hr/benefits/plans/plan.schema.ts","frontend/src/api/modules/hr-benefits.ts","frontend/src/views/hr/benefits/Index.vue","frontend/src/views/hr/benefits/components/ClaimsTab.vue","frontend/src/views/hr/benefits/components/EnrollmentsTab.vue","frontend/src/views/hr/benefits/components/PlansTab.vue"],"removed":[],"modified":["backend/prisma/schema.prisma","backend/src/modules/hr/index.ts","backend/src/shared/constants/events.ts","backend/src/shared/constants/permissions.ts","frontend/src/router/index.ts"]},{"id":"a052eedc796d1fc44b3cc64de9429ddd84b59e87","message":"fix(frontend): 完善前端视图和权限检查\n\n- 修复续费状态映射与后端一致 (open→pending, quoted→negotiating)\n- 修复知识热力图组件 chartReady 引用问题\n- 添加 SWOT 业务编码前缀支持\n- 修复 SWOT 服务中的类型问题\n\n🤖 Generated with [Claude Code](https://claude.com/claude-code)\n\nCo-Authored-By: Claude Opus 4.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/a052eedc796d1fc44b3cc64de9429ddd84b59e87","author":{"name":"hi.laoluo","email":"hi.laoluo@hilaoluodeMacBook-Pro.local","username":""},"committer":{"name":"hi.laoluo","email":"hi.laoluo@hilaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-01-03T18:34:43+08:00","added":[],"removed":[],"modified":["backend/src/modules/knowledge/knowledge.routes.ts","backend/src/modules/swot-analyses/swot.service.ts","backend/src/shared/utils/biz-code.ts","frontend/src/api/modules/renewals.ts","frontend/src/views/im/Index.vue","frontend/src/views/knowledge/components/KnowledgeHeatmap.vue","frontend/src/views/renewals/Detail.vue","frontend/src/views/renewals/Form.vue","frontend/src/views/renewals/Index.vue"]},{"id":"d8de20002b217cbfcabe0883191b758a3aa8af00","message":"fix(frontend): 完善前端视图和权限检查\n\n修复内容:\n- 修复 formatNumber/formatMoney 函数未处理 undefined/null 导致的渲染崩溃\n- 添加广告创意/A/B测试/预算预警的统计接口\n- 修复序列号详情接口 Prisma select+include 语法错误\n- 修复交付验收列表 orders 为 null 时的空引用错误\n- 统一用户缓存失效使用 userCache.invalidateUser()\n- 完善 seed.ts 权限数据\n\n影响文件:\n- frontend: RoiAnalysis, Index, BudgetAlerts, Sessions, marketing 等视图\n- backend: ad-creative.routes, placement.routes, sn.routes, fulfillment.routes\n- backend: auth.service, auth.controller, user.routes\n- backend: prisma/seed.ts\n\n🤖 Generated with [Claude Code](https://claude.com/claude-code)\n\nCo-Authored-By: Claude Opus 4.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/d8de20002b217cbfcabe0883191b758a3aa8af00","author":{"name":"hi.laoluo","email":"hi.laoluo@hilaoluodeMacBook-Pro.local","username":""},"committer":{"name":"hi.laoluo","email":"hi.laoluo@hilaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-01-03T18:21:51+08:00","added":[],"removed":[],"modified":["backend/prisma/seed.ts","backend/src/modules/ad-placement/ad-creative.routes.ts","backend/src/modules/ad-placement/placement.routes.ts","backend/src/modules/auth/auth.controller.ts","backend/src/modules/auth/auth.service.ts","backend/src/modules/fulfillment/fulfillment.routes.ts","backend/src/modules/serial-numbers/sn.routes.ts","backend/src/modules/users/user.routes.ts","frontend/src/views/ad-placement/BudgetAlerts.vue","frontend/src/views/ad-placement/Index.vue","frontend/src/views/ad-placement/RoiAnalysis.vue","frontend/src/views/finance/Index.vue","frontend/src/views/livestream/Sessions.vue","frontend/src/views/marketing-matrix/Index.vue","frontend/src/views/marketing/Index.vue","frontend/src/views/renewal-tasks/Detail.vue"]},{"id":"47e29a8c67322cf0bcd9a022cecd04eb289f9bed","message":"feat(hr): 添加福利管理模块\n\n新增功能：\n- 福利计划管理：社保、公积金、商业保险、补贴等福利方案配置\n- 员工福利登记：员工参保登记、批量登记、终止登记\n- 福利申领：报销、理赔、提取申请及审批流程\n\n后端变更：\n- 添加 hr_benefit_plans、hr_benefit_enrollments、hr_benefit_claims 数据库模型\n- 添加福利管理权限定义（benefit-plan、benefit-enrollment、benefit-claim）\n- 添加福利管理事件类型（HR_BENEFIT_EVENTS）\n- 创建 benefits 模块（plans、enrollments、claims 三个子模块）\n\n前端变更：\n- 添加 hr-benefits API 模块\n- 添加福利管理视图（Index.vue 及三个选项卡组件）\n- 添加福利管理路由配置\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/47e29a8c67322cf0bcd9a022cecd04eb289f9bed","author":{"name":"Claude","email":"noreply@anthropic.com","username":""},"committer":{"name":"Claude","email":"noreply@anthropic.com","username":""},"verification":null,"timestamp":"2026-01-03T09:39:22Z","added":["backend/src/modules/hr/benefits/claims/claim.routes.ts","backend/src/modules/hr/benefits/claims/claim.schema.ts","backend/src/modules/hr/benefits/enrollments/enrollment.routes.ts","backend/src/modules/hr/benefits/enrollments/enrollment.schema.ts","backend/src/modules/hr/benefits/index.ts","backend/src/modules/hr/benefits/plans/plan.routes.ts","backend/src/modules/hr/benefits/plans/plan.schema.ts","frontend/src/api/modules/hr-benefits.ts","frontend/src/views/hr/benefits/Index.vue","frontend/src/views/hr/benefits/components/ClaimsTab.vue","frontend/src/views/hr/benefits/components/EnrollmentsTab.vue","frontend/src/views/hr/benefits/components/PlansTab.vue"],"removed":[],"modified":["backend/prisma/schema.prisma","backend/src/modules/hr/index.ts","backend/src/shared/constants/events.ts","backend/src/shared/constants/permissions.ts","frontend/src/router/index.ts"]}],"total_commits":0,"head_commit":{"id":"d169207d2a046f90cf861f8e805b45d3855fddc3","message":"feat(db): 添加福利管理模块数据库迁移\n\n- 创建 hr_benefit_plans 福利计划表\n- 创建 hr_benefit_enrollments 福利登记表\n- 创建 hr_benefit_claims 福利申领表\n- 配置 RLS 多租户隔离策略\n\n🤖 Generated with [Claude Code](https://claude.com/claude-code)\n\nCo-Authored-By: Claude Opus 4.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/d169207d2a046f90cf861f8e805b45d3855fddc3","author":{"name":"hi.laoluo","email":"hi.laoluo@hilaoluodeMacBook-Pro.local","username":""},"committer":{"name":"hi.laoluo","email":"hi.laoluo@hilaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-01-03T18:47:22+08:00","added":["backend/prisma/migrations/20260103200000_add_hr_benefits/migration.sql"],"removed":[],"modified":[]},"repository":{"id":6,"owner":{"id":5,"login":"luoanwu","login_name":"","source_id":0,"full_name":"","email":"law@g-hi.com","avatar_url":"https://gitea.g-hi.com/avatars/627574a890388a2aadc80ab38d22f3a0","html_url":"https://gitea.g-hi.com/luoanwu","language":"","is_admin":false,"last_login":"0001-01-01T00:00:00Z","created":"2026-01-30T16:28:30+08:00","restricted":false,"active":false,"prohibit_login":false,"location":"","website":"","description":"","visibility":"public","followers_count":0,"following_count":0,"starred_repos_count":0,"username":"luoanwu"},"name":"juhi-omni-knowledge-hub","full_name":"luoanwu/juhi-omni-knowledge-hub","description":"巨嗨全域智库 - B2B RevOps 全生命周期平台","empty":false,"private":true,"fork":false,"template":false,"parent":null,"mirror":false,"size":27,"language":"","languages_url":"https://gitea.g-hi.com/api/v1/repos/luoanwu/juhi-omni-knowledge-hub/languages","html_url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub","url":"https://gitea.g-hi.com/api/v1/repos/luoanwu/juhi-omni-knowledge-hub","link":"","ssh_url":"git@gitea.g-hi.com:luoanwu/juhi-omni-knowledge-hub.git","clone_url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub.git","original_url":"https://github.com/laoluojuhai/juhi-omni-knowledge-hub.git","website":"","stars_count":0,"forks_count":0,"watchers_count":1,"open_issues_count":0,"open_pr_counter":0,"release_counter":0,"default_branch":"main","archived":false,"created_at":"2026-02-23T23:57:52+08:00","updated_at":"2026-02-23T23:59:12+08:00","archived_at":"1970-01-01T08:00:00+08:00","permissions":{"admin":true,"push":true,"pull":true},"has_issues":true,"internal_tracker":{"enable_time_tracker":true,"allow_only_contributors_to_track_time":true,"enable_issue_dependencies":true},"has_wiki":true,"has_pull_requests":true,"has_projects":true,"projects_mode":"all","has_releases":true,"has_packages":true,"has_actions":true,"ignore_whitespace_conflicts":false,"allow_merge_commits":true,"allow_rebase":true,"allow_rebase_explicit":true,"allow_squash_merge":true,"allow_fast_forward_only_merge":true,"allow_rebase_update":true,"default_delete_branch_after_merge":false,"default_merge_style":"merge","default_allow_maintainer_edit":false,"avatar_url":"","internal":false,"mirror_interval":"","object_format_name":"sha1","mirror_updated":"0001-01-01T00:00:00Z","repo_transfer":null},"pusher":{"id":5,"login":"luoanwu","login_name":"","source_id":0,"full_name":"","email":"luoanwu@noreply.localhost","avatar_url":"https://gitea.g-hi.com/avatars/627574a890388a2aadc80ab38d22f3a0","html_url":"https://gitea.g-hi.com/luoanwu","language":"","is_admin":false,"last_login":"0001-01-01T00:00:00Z","created":"2026-01-30T16:28:30+08:00","restricted":false,"active":false,"prohibit_login":false,"location":"","website":"","description":"","visibility":"public","followers_count":0,"following_count":0,"starred_repos_count":0,"username":"luoanwu"},"sender":{"id":5,"login":"luoanwu","login_name":"","source_id":0,"full_name":"","email":"luoanwu@noreply.localhost","avatar_url":"https://gitea.g-hi.com/avatars/627574a890388a2aadc80ab38d22f3a0","html_url":"https://gitea.g-hi.com/luoanwu","language":"","is_admin":false,"last_login":"0001-01-01T00:00:00Z","created":"2026-01-30T16:28:30+08:00","restricted":false,"active":false,"prohibit_login":false,"location":"","website":"","description":"","visibility":"public","followers_count":0,"following_count":0,"starred_repos_count":0,"username":"luoanwu"}}

TEXT

trigger_event

TEXT

status

INTEGER

version

INTEGER (default 0

started

INTEGER

stopped

INTEGER

previous_duration

INTEGER

created

INTEGER

updated

INTEGER

raw_concurrency

TEXT

concurrency_group

TEXT NOT NULL (default ''

concurrency_cancel

INTEGER NOT NULL (default FALSE

Update row 40 in action_run