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":"0644185f66987a1e83b3b5f1a3cc462024a1f61f","after":"c8076632765b6782be30f75613b7ab8e602662f4","compare_url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/compare/0644185f66987a1e83b3b5f1a3cc462024a1f61f...c8076632765b6782be30f75613b7ab8e602662f4","commits":[{"id":"c8076632765b6782be30f75613b7ab8e602662f4","message":"Add video calls module, BOM/treasury views, and governance wave0 docs\n\n- backend: Add video-calls module with controller, service, schema, docs\n- frontend: Add BOM, treasury, and channel-integrations CRUD views\n- frontend: Add warehouse-supply smoke tests and router updates\n- docs: Add global-governance-wave0-matrix and battle cards for 6 domains\n- e2e: Add e2e-probe.mjs and temp test scripts\n- shared: Add money utility and update models\n- Update various controllers, services, and API contracts\n\nCo-authored-by: Qwen-Coder \u003cqwen-coder@alibabacloud.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/c8076632765b6782be30f75613b7ab8e602662f4","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-09T09:56:39+08:00","added":["backend/src/modules/video-calls/video-call.controller.ts","backend/src/modules/video-calls/video-call.docs.ts","backend/src/modules/video-calls/video-call.mapper.ts","backend/src/modules/video-calls/video-call.routes.ts","backend/src/modules/video-calls/video-call.schema.ts","backend/src/modules/video-calls/video-call.service.ts","docs/plans/global-governance-wave0-matrix-2026-03-09.md","docs/plans/wave0-battle-cards/README.md","docs/plans/wave0-battle-cards/admin-communication.md","docs/plans/wave0-battle-cards/finance-expense-risk.md","docs/plans/wave0-battle-cards/growth-ops.md","docs/plans/wave0-battle-cards/service-extended.md","docs/plans/wave0-battle-cards/synergy-extended.md","docs/plans/wave0-battle-cards/warehouse-supply.md","e2e-probe.mjs","frontend/src/api/modules/channel-integrations.ts","frontend/src/views/__tests__/warehouse-supply-g4.smoke.test.ts","frontend/src/views/bom/Detail.vue","frontend/src/views/bom/Form.vue","frontend/src/views/channel-integrations/Detail.vue","frontend/src/views/channel-integrations/Form.vue","frontend/src/views/channel-integrations/Index.vue","frontend/src/views/treasury/Accounts.vue","frontend/src/views/treasury/CashForecast.vue","frontend/src/views/treasury/DailySettlement.vue","frontend/src/views/treasury/FundScheduling.vue","frontend/src/views/treasury/Index.vue","frontend/src/views/treasury/PaymentRequests.vue","gemini-e2e-temp/crm_sales_bomb.spec.mjs","gemini-e2e-temp/e2e-probe.mjs","gemini-e2e-temp/finance_ai_assault.spec.mjs","gemini-e2e-temp/package.json","gemini-e2e-temp/scm_scan.spec.mjs","shared/src/utils/money.ts"],"removed":[],"modified":["AGENTS.md","CLAUDE.md","GEMINI.md","README.md","backend/package.json","backend/prisma/seed.ts","backend/src/modules/content-creation/content-creation.service.ts","backend/src/modules/expense/expense.controller.ts","backend/src/modules/finance/finance-refunds.service.ts","backend/src/modules/finance/finance.controller.ts","backend/src/modules/groupbuy-campaigns/groupbuy-campaign.controller.ts","backend/src/modules/groupbuy-campaigns/groupbuy-campaign.service.ts","backend/src/modules/groupbuy-influencers/groupbuy-influencer.service.ts","backend/src/modules/groupbuy-settlements/groupbuy-settlement.service.ts","backend/src/modules/inventory/inventory.controller.ts","backend/src/modules/inventory/inventory.routes.ts","backend/src/modules/location-assessments/location-assessment.service.ts","backend/src/modules/projects/project.service.ts","backend/src/modules/scheduled-jobs/scheduled-jobs.controller.ts","backend/src/modules/scheduled-jobs/scheduled-jobs.routes.ts","backend/src/modules/users/user.service.ts","backend/src/routes/register-domain-routes.ts","backend/src/shared/process-core/process-adapter.ts","backend/src/shared/services/base.service.ts","backend/src/shared/state-machines/machines/content-creation.machine.ts","docs/contract-governance-3.0.md","docs/operations/contract-governance-3.0-multi-agent-runbook.md","docs/reports/governance-experience-2026-03-07.md","e2e/tests/fixtures/service-center-smoke.ts","frontend/package.json","frontend/src/api/index.ts","frontend/src/api/modules/departments.ts","frontend/src/api/modules/quotes.ts","frontend/src/api/modules/users.ts","frontend/src/router/index.ts","frontend/src/stores/im.ts","frontend/src/views/ai-agents/LeadCollector.vue","frontend/src/views/ai-agents/Tasks.vue","frontend/src/views/alliance-agreements/Form.vue","frontend/src/views/ar-ledger/Index.vue","frontend/src/views/bom/Index.vue","frontend/src/views/groupbuy-influencers/Form.vue","frontend/src/views/scheduled-jobs/Index.vue","frontend/src/views/tickets/components/gantt/TicketGanttChart.vue","mobile/src/stores/auth.ts","mobile/src/views/Leads.vue","package.json","pnpm-lock.yaml","reports/api-route-contract-audit.latest.json","reports/api-route-contract-audit.latest.md","reports/approval-governance.latest.json","reports/approval-governance.latest.md","reports/docs-single-source-audit.latest.json","reports/docs-single-source-audit.latest.md","reports/event-publishing-audit.latest.json","reports/event-publishing-audit.latest.md","shared/package.json","shared/src/types/models.ts","shared/src/utils/index.ts"]},{"id":"8367f2304531ebebb154a5303d39500e38870d5f","message":"Update governance docs and audits\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/8367f2304531ebebb154a5303d39500e38870d5f","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-09T08:22:59+08:00","added":[],"removed":[],"modified":["GEMINI.md","backend/src/modules/im/im.controller.ts","backend/src/modules/sample-requests/sample-request.routes.ts","backend/src/modules/suppliers/supplier.service.ts","docs/contract-governance-3.0.md","reports/api-route-contract-audit.latest.json","reports/api-route-contract-audit.latest.md","reports/approval-governance.latest.json","reports/approval-governance.latest.md","reports/docs-single-source-audit.latest.json","reports/docs-single-source-audit.latest.md","reports/event-publishing-audit.latest.json","reports/event-publishing-audit.latest.md"]},{"id":"9f66d3fc8beaa478d52c5ecc9a25e7e824f5825c","message":"Add acquisition CRUD guidance\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/9f66d3fc8beaa478d52c5ecc9a25e7e824f5825c","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-09T08:06:41+08:00","added":[],"removed":[],"modified":["AGENTS.md","CLAUDE.md","GEMINI.md","README.md","docs/contract-governance-3.0.md","docs/reports/governance-experience-2026-03-07.md"]},{"id":"e40a10d8167476869c78fea4e7181071cf95034e","message":"Document type regression progress\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/e40a10d8167476869c78fea4e7181071cf95034e","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-09T08:03:31+08:00","added":[],"removed":[],"modified":["AGENTS.md","CLAUDE.md","GEMINI.md","README.md","backend/src/modules/content-categories/content-category.service.ts","backend/src/shared/services/base.service.ts","docs/contract-governance-3.0.md","docs/reports/governance-experience-2026-03-07.md","reports/docs-single-source-audit.latest.json","reports/docs-single-source-audit.latest.md"]},{"id":"7d569cf7e2fcef7601218c9ed4c9a5ee35f6b642","message":"Fix frontend bugs add Playwright\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/7d569cf7e2fcef7601218c9ed4c9a5ee35f6b642","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-09T07:45:14+08:00","added":["output/playwright/content-category-debug.png"],"removed":[],"modified":["AGENTS.md","CLAUDE.md","GEMINI.md","README.md","backend/src/modules/ai-agents/ai-agent.controller.test.ts","docs/contract-governance-3.0.md"]}],"total_commits":0,"head_commit":{"id":"c8076632765b6782be30f75613b7ab8e602662f4","message":"Add video calls module, BOM/treasury views, and governance wave0 docs\n\n- backend: Add video-calls module with controller, service, schema, docs\n- frontend: Add BOM, treasury, and channel-integrations CRUD views\n- frontend: Add warehouse-supply smoke tests and router updates\n- docs: Add global-governance-wave0-matrix and battle cards for 6 domains\n- e2e: Add e2e-probe.mjs and temp test scripts\n- shared: Add money utility and update models\n- Update various controllers, services, and API contracts\n\nCo-authored-by: Qwen-Coder \u003cqwen-coder@alibabacloud.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/c8076632765b6782be30f75613b7ab8e602662f4","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-09T09:56:39+08:00","added":["backend/src/modules/video-calls/video-call.controller.ts","backend/src/modules/video-calls/video-call.docs.ts","backend/src/modules/video-calls/video-call.mapper.ts","backend/src/modules/video-calls/video-call.routes.ts","backend/src/modules/video-calls/video-call.schema.ts","backend/src/modules/video-calls/video-call.service.ts","docs/plans/global-governance-wave0-matrix-2026-03-09.md","docs/plans/wave0-battle-cards/README.md","docs/plans/wave0-battle-cards/admin-communication.md","docs/plans/wave0-battle-cards/finance-expense-risk.md","docs/plans/wave0-battle-cards/growth-ops.md","docs/plans/wave0-battle-cards/service-extended.md","docs/plans/wave0-battle-cards/synergy-extended.md","docs/plans/wave0-battle-cards/warehouse-supply.md","e2e-probe.mjs","frontend/src/api/modules/channel-integrations.ts","frontend/src/views/__tests__/warehouse-supply-g4.smoke.test.ts","frontend/src/views/bom/Detail.vue","frontend/src/views/bom/Form.vue","frontend/src/views/channel-integrations/Detail.vue","frontend/src/views/channel-integrations/Form.vue","frontend/src/views/channel-integrations/Index.vue","frontend/src/views/treasury/Accounts.vue","frontend/src/views/treasury/CashForecast.vue","frontend/src/views/treasury/DailySettlement.vue","frontend/src/views/treasury/FundScheduling.vue","frontend/src/views/treasury/Index.vue","frontend/src/views/treasury/PaymentRequests.vue","gemini-e2e-temp/crm_sales_bomb.spec.mjs","gemini-e2e-temp/e2e-probe.mjs","gemini-e2e-temp/finance_ai_assault.spec.mjs","gemini-e2e-temp/package.json","gemini-e2e-temp/scm_scan.spec.mjs","shared/src/utils/money.ts"],"removed":[],"modified":["AGENTS.md","CLAUDE.md","GEMINI.md","README.md","backend/package.json","backend/prisma/seed.ts","backend/src/modules/content-creation/content-creation.service.ts","backend/src/modules/expense/expense.controller.ts","backend/src/modules/finance/finance-refunds.service.ts","backend/src/modules/finance/finance.controller.ts","backend/src/modules/groupbuy-campaigns/groupbuy-campaign.controller.ts","backend/src/modules/groupbuy-campaigns/groupbuy-campaign.service.ts","backend/src/modules/groupbuy-influencers/groupbuy-influencer.service.ts","backend/src/modules/groupbuy-settlements/groupbuy-settlement.service.ts","backend/src/modules/inventory/inventory.controller.ts","backend/src/modules/inventory/inventory.routes.ts","backend/src/modules/location-assessments/location-assessment.service.ts","backend/src/modules/projects/project.service.ts","backend/src/modules/scheduled-jobs/scheduled-jobs.controller.ts","backend/src/modules/scheduled-jobs/scheduled-jobs.routes.ts","backend/src/modules/users/user.service.ts","backend/src/routes/register-domain-routes.ts","backend/src/shared/process-core/process-adapter.ts","backend/src/shared/services/base.service.ts","backend/src/shared/state-machines/machines/content-creation.machine.ts","docs/contract-governance-3.0.md","docs/operations/contract-governance-3.0-multi-agent-runbook.md","docs/reports/governance-experience-2026-03-07.md","e2e/tests/fixtures/service-center-smoke.ts","frontend/package.json","frontend/src/api/index.ts","frontend/src/api/modules/departments.ts","frontend/src/api/modules/quotes.ts","frontend/src/api/modules/users.ts","frontend/src/router/index.ts","frontend/src/stores/im.ts","frontend/src/views/ai-agents/LeadCollector.vue","frontend/src/views/ai-agents/Tasks.vue","frontend/src/views/alliance-agreements/Form.vue","frontend/src/views/ar-ledger/Index.vue","frontend/src/views/bom/Index.vue","frontend/src/views/groupbuy-influencers/Form.vue","frontend/src/views/scheduled-jobs/Index.vue","frontend/src/views/tickets/components/gantt/TicketGanttChart.vue","mobile/src/stores/auth.ts","mobile/src/views/Leads.vue","package.json","pnpm-lock.yaml","reports/api-route-contract-audit.latest.json","reports/api-route-contract-audit.latest.md","reports/approval-governance.latest.json","reports/approval-governance.latest.md","reports/docs-single-source-audit.latest.json","reports/docs-single-source-audit.latest.md","reports/event-publishing-audit.latest.json","reports/event-publishing-audit.latest.md","shared/package.json","shared/src/types/models.ts","shared/src/utils/index.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":1095017,"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-09T09:55:33+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 4005 in action_run