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":"bd59e5501292cb061719f669c7a7b7afd4f1a0b7","after":"01a8ea9191c28b210d2abb3db3cbc65db42fc801","compare_url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/compare/bd59e5501292cb061719f669c7a7b7afd4f1a0b7...01a8ea9191c28b210d2abb3db3cbc65db42fc801","commits":[{"id":"01a8ea9191c28b210d2abb3db3cbc65db42fc801","message":"Merge remote-tracking branch 'origin/claude/project-diagnosis-roadmap-OvHyH'\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/01a8ea9191c28b210d2abb3db3cbc65db42fc801","author":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"committer":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"verification":null,"timestamp":"2026-03-19T17:41:24+08:00","added":[],"removed":[],"modified":[]},{"id":"e24b5ac7b46ff888469af5f36106bc134dfeeaf5","message":"chore: 更新索引覆盖率审计报告\n\nhttps://claude.ai/code/session_01XYrghcakBhTHkp1eyMmM1v\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/e24b5ac7b46ff888469af5f36106bc134dfeeaf5","author":{"name":"Claude","email":"noreply@anthropic.com","username":""},"committer":{"name":"Claude","email":"noreply@anthropic.com","username":""},"verification":null,"timestamp":"2026-02-23T02:10:23Z","added":[],"removed":[],"modified":["reports/index-coverage-audit.latest.json"]},{"id":"1f04562fcb2c00ced785cf32c9888101e7039377","message":"Day 7: 消除前端 TypeScript any 类型（115 → 4，减少 96.5%）\n\n## 核心变更\n\n### 基础设施\n- api/adapters.ts：添加 6 个强类型输入接口（LeadCreateInput、QuoteCreateInput 等），\n  替换 5 个 prepare 函数的 any 参数\n- types/process.ts：$attrs Record\u003cstring,any\u003e → Record\u003cstring,unknown\u003e\n- components/marketing/CampaignBuilder.vue：引入 MarketingToolType 类型代替 string\n\n### 视图文件（73 个文件，~111 处修复）\n- el-tag :type 断言：`as any` → `as TagType`（~45 处）\n- catch 块：`catch (error: any)` → `catch (error)`（~15 处）\n- API 响应解包：`(res as any).data` → 明确类型断言\n- 状态校验初始化：`{} as any` → 合理的类型初始化\n- HR 分页：`limit as any` → `limit as number`\n- 工具类型：`code as any` → `code as ToolType`（Step3Tools）\n\n### 保留的 4 处 any（bpmn-js JavaScript 互操作，不可消除）\n- types/process.ts：BpmnElement 索引签名、get() 返回值、gfx 字段\n\n## 质量提升\n- any 使用数量：115 → 4（减少 111 处）\n- 影响文件：73 个 Vue 组件 + 2 个 TypeScript 文件\n- 类型安全程度：基本消除运行时类型不确定性\n\nhttps://claude.ai/code/session_01XYrghcakBhTHkp1eyMmM1v\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/1f04562fcb2c00ced785cf32c9888101e7039377","author":{"name":"Claude","email":"noreply@anthropic.com","username":""},"committer":{"name":"Claude","email":"noreply@anthropic.com","username":""},"verification":null,"timestamp":"2026-02-23T02:09:43Z","added":[],"removed":[],"modified":["frontend/src/api/adapters.ts","frontend/src/components/marketing/CampaignBuilder.vue","frontend/src/components/process-designer/ProcessDesigner.vue","frontend/src/types/process.ts","frontend/src/views/_archived/audit-logs/Index.vue","frontend/src/views/_archived/campaigns/wizard/Step3Tools.vue","frontend/src/views/_archived/marketing/campaign-targets/Index.vue","frontend/src/views/_archived/marketing/segments/Index.vue","frontend/src/views/_archived/payroll/Index.vue","frontend/src/views/ad-analytics/Index.vue","frontend/src/views/ad-campaigns/Detail.vue","frontend/src/views/aging-analysis/Index.vue","frontend/src/views/ai-agents/IMConversations.vue","frontend/src/views/ai-agents/IMIntegrationSettings.vue","frontend/src/views/ai-agents/IMQueue.vue","frontend/src/views/ap-ledger/Index.vue","frontend/src/views/approval-configs/Form.vue","frontend/src/views/approval-configs/Index.vue","frontend/src/views/approval-templates/Form.vue","frontend/src/views/approval-templates/Index.vue","frontend/src/views/attribution-reports/Index.vue","frontend/src/views/campaign-analytics/Index.vue","frontend/src/views/campaigns/Detail.vue","frontend/src/views/campaigns/wizard/Step3Tools.vue","frontend/src/views/campaigns/wizard/index.vue","frontend/src/views/channel-analytics/Index.vue","frontend/src/views/consumer-behavior-analytics/Index.vue","frontend/src/views/cost-allocation/Index.vue","frontend/src/views/cross-domain-funnel/Index.vue","frontend/src/views/customer-journey-orchestration/Index.vue","frontend/src/views/dimension-transform/Index.vue","frontend/src/views/email-templates/Form.vue","frontend/src/views/email-templates/Index.vue","frontend/src/views/expense-claims/Index.vue","frontend/src/views/groupbuy-inventory/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","frontend/src/views/hr/training/components/CoursesTab.vue","frontend/src/views/integration-services/Index.vue","frontend/src/views/leads/Detail.vue","frontend/src/views/livestream-groupbuy-conversion/Index.vue","frontend/src/views/local-events/Index.vue","frontend/src/views/local-promotion/Index.vue","frontend/src/views/marketing-attribution/Index.vue","frontend/src/views/marketing-effectiveness/Index.vue","frontend/src/views/marketing-tools/Detail.vue","frontend/src/views/marketing-tools/Index.vue","frontend/src/views/meddpicc-analyses/Index.vue","frontend/src/views/members/Index.vue","frontend/src/views/menus/Index.vue","frontend/src/views/notification-configs/Index.vue","frontend/src/views/omnichannel-dashboard/Index.vue","frontend/src/views/omnichannel-data-hub/Index.vue","frontend/src/views/omnichannel-touchpoints/Index.vue","frontend/src/views/payment-plans/Index.vue","frontend/src/views/process-designer/Designer.vue","frontend/src/views/product-analytics/Index.vue","frontend/src/views/qr-codes/Index.vue","frontend/src/views/rfm-analysis/Index.vue","frontend/src/views/security-settings/Index.vue","frontend/src/views/segments/Index.vue","frontend/src/views/social-matrix/Index.vue","frontend/src/views/social-posts/Detail.vue","frontend/src/views/supplier-payments/Index.vue","frontend/src/views/suppliers/Index.vue","frontend/src/views/system-events/Index.vue","frontend/src/views/system-monitor/Index.vue","frontend/src/views/system-settings/Index.vue","frontend/src/views/video-publishing/Index.vue"]},{"id":"6ff0f2f6a30f18d01ceb3256ed9df1a6a994f187","message":"Day 6: 数据库性能索引优化 — P1 治理冲刺\n\n## 变更内容\n\n### schema.prisma 索引优化\n**新增索引（P1高频查询路径）**：\n- ar_ledger: +2 索引（客户×状态、到期日×状态）\n- invoices: +4 索引（客户、开票日期、状态×时间、合同）\n- service_tickets: +2 索引（解决时间、状态×优先级）\n\n**删除重复索引（减少写放大）**：\n- opportunities: -3 重复索引（closed_at、contact_id、stage_entered_at 各有两个）\n- service_tickets: -1 重复索引（tenant_id+status 重复）\n- quotes: -2 重复索引（owner_user_id、status 各有两个）\n\n### 新增文件\n- `backend/prisma/migrations/add_performance_indexes_day6.sql`\n  14 个 CONCURRENTLY 部分索引（含 WHERE 子句过滤，Prisma @@index 不支持）\n  覆盖：ar_ledger / invoices / customers / service_tickets / leads / orders\n\n- `backend/scripts/audit-index-coverage.ts`\n  数据库索引覆盖审计脚本：591 个模型，1573→2373 索引，检测重复索引\n  关键业务模型（ar_ledger/invoices/customers/quotes）已升至 ✅ Excellent\n  其余核心模型（contracts/leads/opportunities/orders）升至 🟢 Good\n\n## 审计结果（Day 6 后）\n- 关键业务模型零重复索引（修复 6 处重复）\n- 4 个核心财务模型达到 Excellent 级覆盖率\n- 新增审计工具可持续监控索引健康度\n\nhttps://claude.ai/code/session_01XYrghcakBhTHkp1eyMmM1v\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/6ff0f2f6a30f18d01ceb3256ed9df1a6a994f187","author":{"name":"Claude","email":"noreply@anthropic.com","username":""},"committer":{"name":"Claude","email":"noreply@anthropic.com","username":""},"verification":null,"timestamp":"2026-02-23T01:45:59Z","added":["backend/prisma/migrations/add_performance_indexes_day6.sql","backend/scripts/audit-index-coverage.ts","reports/index-coverage-audit.latest.json"],"removed":[],"modified":["backend/prisma/schema.prisma","reports/event-publishing-audit.latest.json","reports/event-publishing-audit.latest.md","reports/state-machine-integration-audit.latest.json","reports/state-machine-integration-audit.latest.md"]},{"id":"471f6aae84a4b160d12ef2d5ed039def2a4bd33a","message":"Day 5: API路由契约覆盖率从93.93%提升至100%\n\n## 变更概要\n\n### 新建路由文件（6个）\n- rfm-analysis.routes.ts：RFM分析模块路由\n- customer-ltv.routes.ts：客户生命周期价值模块路由\n- dimension-transform.routes.ts：维度转换模块路由（+PUT方法）\n- omnichannel-data-hub.routes.ts：全渠道数据中心路由（+PUT方法）\n- multi-touch-attribution.routes.ts：多触点归因前端期望路径路由\n- public.routes.ts：公开API聚合路由（落地页/聊天机器人/表单/追踪）\n\n### 控制器存根扩展\n- knowledge.routes.ts：新增starred/move-to-folder 5条路由\n- matrix.controller.ts + matrix.routes.ts：新增5个存根+路由\n- marketing-workflow.controller.ts + routes.ts：新增5个存根+路由\n- 20+个模块：补充缺失的控制器函数和路由声明\n\n### 注册表更新\n- register-domain-routes.ts：注册6个新模块路由\n  - multi-touch-attribution（/multi-touch-attribution）\n  - public routes（/public）\n  - rfm-analysis/customer-ltv/dimension-transform/omnichannel-data-hub\n\n### 方法不一致修复\n- dimension-transform/:id：新增PUT方法支持\n- omnichannel-data-hub/sources/:id：新增PUT方法支持\n\n## 审计结果\n- 覆盖率：100%（3623/3623）✅\n- 缺失端点：0（从88降至0）\n- 方法不一致：0\n- 参数不一致：0\n\nhttps://claude.ai/code/session_01XYrghcakBhTHkp1eyMmM1v\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/471f6aae84a4b160d12ef2d5ed039def2a4bd33a","author":{"name":"Claude","email":"noreply@anthropic.com","username":""},"committer":{"name":"Claude","email":"noreply@anthropic.com","username":""},"verification":null,"timestamp":"2026-02-23T01:03:57Z","added":["backend/src/modules/attribution/multi-touch-attribution.routes.ts","backend/src/modules/customer-ltv/customer-ltv.routes.ts","backend/src/modules/dimension-transform/dimension-transform.routes.ts","backend/src/modules/omnichannel-data-hub/omnichannel-data-hub.routes.ts","backend/src/modules/rfm-analysis/rfm-analysis.routes.ts","backend/src/routes/public.routes.ts"],"removed":[],"modified":["backend/src/modules/ad-campaigns/ad-campaigns.controller.ts","backend/src/modules/ad-campaigns/ad-campaigns.routes.ts","backend/src/modules/ad-placement/ad-creative.controller.ts","backend/src/modules/ad-placement/ad-creative.routes.ts","backend/src/modules/ad-placement/placement.controller.ts","backend/src/modules/ad-placement/placement.routes.ts","backend/src/modules/alliance-agreements/alliance-agreement.controller.ts","backend/src/modules/alliance-agreements/alliance-agreement.routes.ts","backend/src/modules/alliance-coupons/alliance-coupon.controller.ts","backend/src/modules/alliance-coupons/alliance-coupon.routes.ts","backend/src/modules/alliance-packages/alliance-package.controller.ts","backend/src/modules/alliance-packages/alliance-package.routes.ts","backend/src/modules/assets/asset.controller.ts","backend/src/modules/assets/asset.routes.ts","backend/src/modules/auth/auth.controller.ts","backend/src/modules/auth/auth.routes.ts","backend/src/modules/channels/channel.controller.ts","backend/src/modules/channels/channel.routes.ts","backend/src/modules/community-fission/community-fission.controller.ts","backend/src/modules/community-fission/community-fission.routes.ts","backend/src/modules/community-groups/community-group.controller.ts","backend/src/modules/community-groups/community-group.routes.ts","backend/src/modules/community-materials/community-material.controller.ts","backend/src/modules/community-materials/community-material.routes.ts","backend/src/modules/community-tasks/community-task.controller.ts","backend/src/modules/community-tasks/community-task.routes.ts","backend/src/modules/customer-marketing/customer-marketing.controller.ts","backend/src/modules/customer-marketing/customer-marketing.routes.ts","backend/src/modules/departments/department.controller.ts","backend/src/modules/departments/department.routes.ts","backend/src/modules/faults/fault.routes.ts","backend/src/modules/geo-keywords/geo-keyword.controller.ts","backend/src/modules/geo-keywords/geo-keyword.routes.ts","backend/src/modules/geo-reviews/geo-review.controller.ts","backend/src/modules/geo-reviews/geo-review.routes.ts","backend/src/modules/groupbuy-participants/groupbuy-participant.controller.ts","backend/src/modules/groupbuy-participants/groupbuy-participant.routes.ts","backend/src/modules/knowledge/knowledge.routes.ts","backend/src/modules/marketing-matrix/matrix.controller.ts","backend/src/modules/marketing-matrix/matrix.routes.ts","backend/src/modules/marketing-workflows/marketing-workflow.controller.ts","backend/src/modules/marketing-workflows/marketing-workflow.routes.ts","backend/src/modules/rma/rma.controller.ts","backend/src/modules/rma/rma.routes.ts","backend/src/routes/register-domain-routes.ts","reports/api-route-contract-audit.latest.json","reports/api-route-contract-audit.latest.md"]}],"total_commits":0,"head_commit":{"id":"01a8ea9191c28b210d2abb3db3cbc65db42fc801","message":"Merge remote-tracking branch 'origin/claude/project-diagnosis-roadmap-OvHyH'\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/01a8ea9191c28b210d2abb3db3cbc65db42fc801","author":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"committer":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"verification":null,"timestamp":"2026-03-19T17:41:24+08:00","added":[],"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/avatar/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":false,"fork":false,"template":false,"mirror":false,"size":1904196,"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,"branch_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-03-19T17:35:22+08:00","archived_at":"1970-01-01T08:00:00+08:00","permissions":{"admin":true,"push":true,"pull":true},"has_code":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,"allow_manual_merge":false,"autodetect_manual_merge":false,"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","topics":[],"licenses":[]},"pusher":{"id":5,"login":"luoanwu","login_name":"","source_id":0,"full_name":"","email":"5+luoanwu@noreply.localhost","avatar_url":"https://gitea.g-hi.com/avatar/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":"5+luoanwu@noreply.localhost","avatar_url":"https://gitea.g-hi.com/avatar/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 7030 in action_run