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":"c8076632765b6782be30f75613b7ab8e602662f4","after":"a827624730a039637887a7c3f1fb7f5c813cb3ec","compare_url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/compare/c8076632765b6782be30f75613b7ab8e602662f4...a827624730a039637887a7c3f1fb7f5c813cb3ec","commits":[{"id":"a827624730a039637887a7c3f1fb7f5c813cb3ec","message":"feat: Add finance OS AI views and knowledge base components\n\n- Add finance AI views (AutoCollectionEngine, AutoCreditAdjustment, DefaultProbabilityModel, ROIEvaluation)\n- Add cash management views (AccountManagement, CashHealth, DailySettlement, Forecast3090, FundPool, FundScheduling, PaymentRequests)\n- Add profit analysis views (AssetDepreciation, CityProfit, EmotionROI, IOCurve, PaybackPeriod, ProductProfit, ProfitEngine)\n- Add risk control views (AbnormalProfit, CreditLimit, CreditScore, FreezeMechanism, OverdueForecast, RiskControl, TaxRisk)\n- Add knowledge base components (KnowledgeCapture, KnowledgeFeedback)\n- Update video calls module with improved form and list UI\n- Refactor channel integrations, opportunities, purchase orders, quotes API\n- Update approval governance and route contract audit reports\n\nCo-authored-by: Qwen-Coder \u003cqwen-coder@alibabacloud.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/a827624730a039637887a7c3f1fb7f5c813cb3ec","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-10T10:11:48+08:00","added":[".claude/worktrees/exciting-mahavira","frontend/src/views/finance-os/ai/AutoCollectionEngine.vue","frontend/src/views/finance-os/ai/AutoCreditAdjustment.vue","frontend/src/views/finance-os/ai/DefaultProbabilityModel.vue","frontend/src/views/finance-os/ai/FinanceAI.vue","frontend/src/views/finance-os/ai/ROIEvaluation.vue","frontend/src/views/finance-os/cash/AccountManagement.vue","frontend/src/views/finance-os/cash/CashHealth.vue","frontend/src/views/finance-os/cash/DailySettlement.vue","frontend/src/views/finance-os/cash/Forecast3090.vue","frontend/src/views/finance-os/cash/FundPool.vue","frontend/src/views/finance-os/cash/FundScheduling.vue","frontend/src/views/finance-os/cash/PaymentRequests.vue","frontend/src/views/finance-os/profit/AssetDepreciation.vue","frontend/src/views/finance-os/profit/CityProfit.vue","frontend/src/views/finance-os/profit/EmotionROI.vue","frontend/src/views/finance-os/profit/IOCurve.vue","frontend/src/views/finance-os/profit/PaybackPeriod.vue","frontend/src/views/finance-os/profit/ProductProfit.vue","frontend/src/views/finance-os/profit/ProfitEngine.vue","frontend/src/views/finance-os/risk/AbnormalProfit.vue","frontend/src/views/finance-os/risk/CreditLimit.vue","frontend/src/views/finance-os/risk/CreditScore.vue","frontend/src/views/finance-os/risk/FreezeMechanism.vue","frontend/src/views/finance-os/risk/OverdueForecast.vue","frontend/src/views/finance-os/risk/RiskControl.vue","frontend/src/views/finance-os/risk/TaxRisk.vue","frontend/src/views/knowledge-base/KnowledgeCapture.vue","frontend/src/views/knowledge-base/KnowledgeFeedback.vue"],"removed":["e2e/test-results/.last-run.json","e2e/test-results/results.json"],"modified":["backend/src/main.ts","backend/src/modules/ai-agents/ai-agent.service.ts","backend/src/modules/approvals/approval.service.test.ts","backend/src/modules/approvals/approval.service.ts","backend/src/modules/bom/bom.service.ts","backend/src/modules/payments/payment-record.service.ts","backend/src/modules/payments/payment.service.test.ts","backend/src/modules/serial-numbers/sn.service.ts","backend/src/modules/video-calls/video-call.routes.ts","e2e/playwright-report/index.html","frontend/src/api/modules/channel-integrations.ts","frontend/src/api/modules/opportunities.ts","frontend/src/api/modules/purchase-orders.ts","frontend/src/api/modules/quotes.ts","frontend/src/api/modules/video-calls.ts","frontend/src/views/ai-agents/Metrics.vue","frontend/src/views/finance-os/ai/AutoFundScheduling.vue","frontend/src/views/finance-os/ai/CashForecastModel.vue","frontend/src/views/finance-os/cash/CashControlTower.vue","frontend/src/views/finance-os/expense/CostAnomaly.vue","frontend/src/views/finance-os/expense/CostCenter.vue","frontend/src/views/finance-os/expense/ExpenseApprovalFlow.vue","frontend/src/views/finance-os/expense/NodeCost.vue","frontend/src/views/finance-os/expense/ProjectCost.vue","frontend/src/views/finance-os/revenue/AutoCollectionCenter.vue","frontend/src/views/finance-os/revenue/PriceTypes.vue","frontend/src/views/finance-os/revenue/RecognitionRules.vue","frontend/src/views/video-calls/Form.vue","frontend/src/views/video-calls/Index.vue","frontend/vite.config.ts","reports/api-route-contract-audit.latest.json","reports/api-route-contract-audit.latest.md","reports/approval-governance.latest.json","reports/approval-governance.latest.md"]},{"id":"280bb3927069d31d0dfeb19caf98ce774dd2651d","message":"feat(supply-chain): finish wave 1, 4, 5, 6 with complete type safety\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/280bb3927069d31d0dfeb19caf98ce774dd2651d","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-09T15:25:41+08:00","added":["backend/src/modules/purchase-orders/purchase-order.controller.ts","backend/src/modules/purchase-orders/purchase-order.docs.ts","backend/src/modules/purchase-orders/purchase-order.routes.ts","backend/src/modules/purchase-orders/purchase-order.schema.ts","backend/src/modules/purchase-orders/purchase-order.service.ts","frontend/src/api/modules/purchase-orders.ts","frontend/src/views/cost-allocation/Form.vue","frontend/src/views/customer-balance/Form.vue","frontend/src/views/purchase-orders/Detail.vue","frontend/src/views/purchase-orders/Form.vue","frontend/src/views/purchase-orders/Index.vue","frontend/src/views/tickets/Gantt.vue","frontend/src/views/video-calls/Form.vue","frontend/src/views/video-calls/Index.vue"],"removed":[],"modified":["backend/src/modules/supply-chain/purchase-order.service.ts","backend/src/routes/register-domain-routes.ts","frontend/src/api/modules/video-calls.ts","frontend/src/router/index.ts","frontend/src/views/channel-integrations/Form.vue","frontend/src/views/channel-integrations/Index.vue"]}],"total_commits":0,"head_commit":{"id":"a827624730a039637887a7c3f1fb7f5c813cb3ec","message":"feat: Add finance OS AI views and knowledge base components\n\n- Add finance AI views (AutoCollectionEngine, AutoCreditAdjustment, DefaultProbabilityModel, ROIEvaluation)\n- Add cash management views (AccountManagement, CashHealth, DailySettlement, Forecast3090, FundPool, FundScheduling, PaymentRequests)\n- Add profit analysis views (AssetDepreciation, CityProfit, EmotionROI, IOCurve, PaybackPeriod, ProductProfit, ProfitEngine)\n- Add risk control views (AbnormalProfit, CreditLimit, CreditScore, FreezeMechanism, OverdueForecast, RiskControl, TaxRisk)\n- Add knowledge base components (KnowledgeCapture, KnowledgeFeedback)\n- Update video calls module with improved form and list UI\n- Refactor channel integrations, opportunities, purchase orders, quotes API\n- Update approval governance and route contract audit reports\n\nCo-authored-by: Qwen-Coder \u003cqwen-coder@alibabacloud.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/a827624730a039637887a7c3f1fb7f5c813cb3ec","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-10T10:11:48+08:00","added":[".claude/worktrees/exciting-mahavira","frontend/src/views/finance-os/ai/AutoCollectionEngine.vue","frontend/src/views/finance-os/ai/AutoCreditAdjustment.vue","frontend/src/views/finance-os/ai/DefaultProbabilityModel.vue","frontend/src/views/finance-os/ai/FinanceAI.vue","frontend/src/views/finance-os/ai/ROIEvaluation.vue","frontend/src/views/finance-os/cash/AccountManagement.vue","frontend/src/views/finance-os/cash/CashHealth.vue","frontend/src/views/finance-os/cash/DailySettlement.vue","frontend/src/views/finance-os/cash/Forecast3090.vue","frontend/src/views/finance-os/cash/FundPool.vue","frontend/src/views/finance-os/cash/FundScheduling.vue","frontend/src/views/finance-os/cash/PaymentRequests.vue","frontend/src/views/finance-os/profit/AssetDepreciation.vue","frontend/src/views/finance-os/profit/CityProfit.vue","frontend/src/views/finance-os/profit/EmotionROI.vue","frontend/src/views/finance-os/profit/IOCurve.vue","frontend/src/views/finance-os/profit/PaybackPeriod.vue","frontend/src/views/finance-os/profit/ProductProfit.vue","frontend/src/views/finance-os/profit/ProfitEngine.vue","frontend/src/views/finance-os/risk/AbnormalProfit.vue","frontend/src/views/finance-os/risk/CreditLimit.vue","frontend/src/views/finance-os/risk/CreditScore.vue","frontend/src/views/finance-os/risk/FreezeMechanism.vue","frontend/src/views/finance-os/risk/OverdueForecast.vue","frontend/src/views/finance-os/risk/RiskControl.vue","frontend/src/views/finance-os/risk/TaxRisk.vue","frontend/src/views/knowledge-base/KnowledgeCapture.vue","frontend/src/views/knowledge-base/KnowledgeFeedback.vue"],"removed":["e2e/test-results/.last-run.json","e2e/test-results/results.json"],"modified":["backend/src/main.ts","backend/src/modules/ai-agents/ai-agent.service.ts","backend/src/modules/approvals/approval.service.test.ts","backend/src/modules/approvals/approval.service.ts","backend/src/modules/bom/bom.service.ts","backend/src/modules/payments/payment-record.service.ts","backend/src/modules/payments/payment.service.test.ts","backend/src/modules/serial-numbers/sn.service.ts","backend/src/modules/video-calls/video-call.routes.ts","e2e/playwright-report/index.html","frontend/src/api/modules/channel-integrations.ts","frontend/src/api/modules/opportunities.ts","frontend/src/api/modules/purchase-orders.ts","frontend/src/api/modules/quotes.ts","frontend/src/api/modules/video-calls.ts","frontend/src/views/ai-agents/Metrics.vue","frontend/src/views/finance-os/ai/AutoFundScheduling.vue","frontend/src/views/finance-os/ai/CashForecastModel.vue","frontend/src/views/finance-os/cash/CashControlTower.vue","frontend/src/views/finance-os/expense/CostAnomaly.vue","frontend/src/views/finance-os/expense/CostCenter.vue","frontend/src/views/finance-os/expense/ExpenseApprovalFlow.vue","frontend/src/views/finance-os/expense/NodeCost.vue","frontend/src/views/finance-os/expense/ProjectCost.vue","frontend/src/views/finance-os/revenue/AutoCollectionCenter.vue","frontend/src/views/finance-os/revenue/PriceTypes.vue","frontend/src/views/finance-os/revenue/RecognitionRules.vue","frontend/src/views/video-calls/Form.vue","frontend/src/views/video-calls/Index.vue","frontend/vite.config.ts","reports/api-route-contract-audit.latest.json","reports/api-route-contract-audit.latest.md","reports/approval-governance.latest.json","reports/approval-governance.latest.md"]},"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":1161980,"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-10T10:10:32+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 4263 in action_run