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":"c569bab58bc56fef3a84171d89184f43afccb7e8","after":"7dc512ef391cd91c82f3c5cd31f3983edd557887","compare_url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/compare/c569bab58bc56fef3a84171d89184f43afccb7e8...7dc512ef391cd91c82f3c5cd31f3983edd557887","commits":[{"id":"7dc512ef391cd91c82f3c5cd31f3983edd557887","message":"Refactor 多模块服务、控制器及新增客户旅程、审批模板、旅程编排功能\n\nCo-authored-by: Qwen-Coder \u003cqwen-coder@alibabacloud.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/7dc512ef391cd91c82f3c5cd31f3983edd557887","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-04T17:17:42+08:00","added":["backend/current_test_summary.txt","backend/scripts/analyze-backend-only-endpoints.ts","backend/src/modules/approval-templates/approval-template.routes.ts","backend/src/modules/customer-journey/customer-journey.routes.ts","backend/src/modules/journey-orchestration/journey-orchestration.routes.ts","backend/tests-integration/rls-policy-automation.test.ts","docs/plans/p0-table-partitioning-implementation-plan-2026-03-04.md","docs/plans/stabilization-sprint-p1-p2-plan-2026-03-04.md","reports/backend-only-endpoints-analysis.latest.json","reports/backend-only-endpoints-analysis.latest.md"],"removed":[],"modified":["backend/.env.example","backend/package.json","backend/scripts/audit-route-contract.ts","backend/src/config/env.ts","backend/src/config/kafka.ts","backend/src/consumers/ai-agent-task-processor.consumer.ts","backend/src/consumers/marketing-workflow-executor.consumer.ts","backend/src/main.ts","backend/src/modules/ad-campaigns/ad-campaigns.service.ts","backend/src/modules/ai-agents/services/ai-agent-im-message-processor.service.ts","backend/src/modules/ai-agents/services/lead-collector.service.ts","backend/src/modules/ai-agents/services/multi-agent-collaboration.service.ts","backend/src/modules/alliance-packages/alliance-package.controller.ts","backend/src/modules/assets/asset.service.ts","backend/src/modules/commissions/commission.service.ts","backend/src/modules/community-analytics/community-analytics.controller.ts","backend/src/modules/community-gamification/community-gamification.service.ts","backend/src/modules/dictionaries/dictionary.docs.ts","backend/src/modules/geo-reviews/geo-review.service.ts","backend/src/modules/hr/attendance/schedules/schedule.service.ts","backend/src/modules/hr/benefits/enrollments/enrollment.service.ts","backend/src/modules/hr/training/competency/competency.service.ts","backend/src/modules/hr/training/courses/course.controller.ts","backend/src/modules/hr/training/enrollments/enrollment.service.ts","backend/src/modules/hr/training/exams/exam.service.ts","backend/src/modules/hr/training/learning/learning.service.ts","backend/src/modules/hr/training/plans/plan.service.ts","backend/src/modules/hr/training/questions/question.service.ts","backend/src/modules/hr/training/sessions/session.service.ts","backend/src/modules/invoices/invoice.controller.ts","backend/src/modules/lead-scoring-ai/lead-scoring-ai.service.ts","backend/src/modules/livestream-interactions/livestream-realtime.service.ts","backend/src/modules/livestream-products/index.ts","backend/src/modules/livestream-scripts/livestream-script.service.ts","backend/src/modules/marketing-automation/workflow-action.service.ts","backend/src/modules/marketing-automation/workflow-trigger.service.ts","backend/src/modules/marketing-chatbot/marketing-chatbot.service.ts","backend/src/modules/marketing-content/marketing-content.logic.ts","backend/src/modules/menus/menu.docs.ts","backend/src/modules/products/services/product.service.test.ts","backend/src/modules/quotes/quote.service.ts","backend/src/modules/renewals/renewal.service.ts","backend/src/modules/search/search.controller.ts","backend/src/modules/sms-marketing/sms-marketing.service.ts","backend/src/modules/social-analytics/social-analytics.controller.ts","backend/src/modules/social-analytics/social-analytics.service.ts","backend/src/modules/stage-knowledge/stage-knowledge.controller.ts","backend/src/modules/supply-chain/supplier-management.service.ts","backend/src/modules/targets/target.service.ts","backend/src/modules/web-tracking/web-tracking.service.ts","backend/src/modules/workflow-generator/templates/actions.hbs","backend/src/modules/workflow-generator/templates/guards.hbs","backend/src/modules/workflow-generator/utils/transformer.ts","backend/src/modules/workflow-generator/workflow-generator.service.ts","backend/src/shared/services/outbox-processor-example.service.ts","frontend/src/api/client.ts","mobile/.env.development","mobile/vite.config.ts","package.json","reports/api-route-contract-audit.latest.json","reports/api-route-contract-audit.latest.md","reports/event-publishing-audit.latest.json","reports/event-publishing-audit.latest.md","reports/route-registration-audit.latest.json","reports/route-registration-audit.latest.md","reports/state-machine-integration-audit.latest.json","reports/state-machine-integration-audit.latest.md","shared/src/api/client.ts","shared/src/utils/common.ts"]}],"total_commits":0,"head_commit":{"id":"7dc512ef391cd91c82f3c5cd31f3983edd557887","message":"Refactor 多模块服务、控制器及新增客户旅程、审批模板、旅程编排功能\n\nCo-authored-by: Qwen-Coder \u003cqwen-coder@alibabacloud.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/7dc512ef391cd91c82f3c5cd31f3983edd557887","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-04T17:17:42+08:00","added":["backend/current_test_summary.txt","backend/scripts/analyze-backend-only-endpoints.ts","backend/src/modules/approval-templates/approval-template.routes.ts","backend/src/modules/customer-journey/customer-journey.routes.ts","backend/src/modules/journey-orchestration/journey-orchestration.routes.ts","backend/tests-integration/rls-policy-automation.test.ts","docs/plans/p0-table-partitioning-implementation-plan-2026-03-04.md","docs/plans/stabilization-sprint-p1-p2-plan-2026-03-04.md","reports/backend-only-endpoints-analysis.latest.json","reports/backend-only-endpoints-analysis.latest.md"],"removed":[],"modified":["backend/.env.example","backend/package.json","backend/scripts/audit-route-contract.ts","backend/src/config/env.ts","backend/src/config/kafka.ts","backend/src/consumers/ai-agent-task-processor.consumer.ts","backend/src/consumers/marketing-workflow-executor.consumer.ts","backend/src/main.ts","backend/src/modules/ad-campaigns/ad-campaigns.service.ts","backend/src/modules/ai-agents/services/ai-agent-im-message-processor.service.ts","backend/src/modules/ai-agents/services/lead-collector.service.ts","backend/src/modules/ai-agents/services/multi-agent-collaboration.service.ts","backend/src/modules/alliance-packages/alliance-package.controller.ts","backend/src/modules/assets/asset.service.ts","backend/src/modules/commissions/commission.service.ts","backend/src/modules/community-analytics/community-analytics.controller.ts","backend/src/modules/community-gamification/community-gamification.service.ts","backend/src/modules/dictionaries/dictionary.docs.ts","backend/src/modules/geo-reviews/geo-review.service.ts","backend/src/modules/hr/attendance/schedules/schedule.service.ts","backend/src/modules/hr/benefits/enrollments/enrollment.service.ts","backend/src/modules/hr/training/competency/competency.service.ts","backend/src/modules/hr/training/courses/course.controller.ts","backend/src/modules/hr/training/enrollments/enrollment.service.ts","backend/src/modules/hr/training/exams/exam.service.ts","backend/src/modules/hr/training/learning/learning.service.ts","backend/src/modules/hr/training/plans/plan.service.ts","backend/src/modules/hr/training/questions/question.service.ts","backend/src/modules/hr/training/sessions/session.service.ts","backend/src/modules/invoices/invoice.controller.ts","backend/src/modules/lead-scoring-ai/lead-scoring-ai.service.ts","backend/src/modules/livestream-interactions/livestream-realtime.service.ts","backend/src/modules/livestream-products/index.ts","backend/src/modules/livestream-scripts/livestream-script.service.ts","backend/src/modules/marketing-automation/workflow-action.service.ts","backend/src/modules/marketing-automation/workflow-trigger.service.ts","backend/src/modules/marketing-chatbot/marketing-chatbot.service.ts","backend/src/modules/marketing-content/marketing-content.logic.ts","backend/src/modules/menus/menu.docs.ts","backend/src/modules/products/services/product.service.test.ts","backend/src/modules/quotes/quote.service.ts","backend/src/modules/renewals/renewal.service.ts","backend/src/modules/search/search.controller.ts","backend/src/modules/sms-marketing/sms-marketing.service.ts","backend/src/modules/social-analytics/social-analytics.controller.ts","backend/src/modules/social-analytics/social-analytics.service.ts","backend/src/modules/stage-knowledge/stage-knowledge.controller.ts","backend/src/modules/supply-chain/supplier-management.service.ts","backend/src/modules/targets/target.service.ts","backend/src/modules/web-tracking/web-tracking.service.ts","backend/src/modules/workflow-generator/templates/actions.hbs","backend/src/modules/workflow-generator/templates/guards.hbs","backend/src/modules/workflow-generator/utils/transformer.ts","backend/src/modules/workflow-generator/workflow-generator.service.ts","backend/src/shared/services/outbox-processor-example.service.ts","frontend/src/api/client.ts","mobile/.env.development","mobile/vite.config.ts","package.json","reports/api-route-contract-audit.latest.json","reports/api-route-contract-audit.latest.md","reports/event-publishing-audit.latest.json","reports/event-publishing-audit.latest.md","reports/route-registration-audit.latest.json","reports/route-registration-audit.latest.md","reports/state-machine-integration-audit.latest.json","reports/state-machine-integration-audit.latest.md","shared/src/api/client.ts","shared/src/utils/common.ts"]},"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":false,"fork":false,"template":false,"parent":null,"mirror":false,"size":1091946,"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-03-04T17:15:34+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 2613 in action_run