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":"6a0c5f7bf734b351d9adc202dbdab62ec1d9a11d","after":"c544245db6731ba7a3f5a10edf7698967643f94d","compare_url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/compare/6a0c5f7bf734b351d9adc202dbdab62ec1d9a11d...c544245db6731ba7a3f5a10edf7698967643f94d","commits":[{"id":"c544245db6731ba7a3f5a10edf7698967643f94d","message":"Update treasury services and schema\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/c544245db6731ba7a3f5a10edf7698967643f94d","author":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"committer":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"verification":null,"timestamp":"2026-02-15T20:33:20+08:00","added":["backend/src/modules/treasury/treasury-utils.ts"],"removed":[],"modified":["backend/prisma/schema.prisma","backend/src/modules/treasury/bank-account.service.ts","backend/src/modules/treasury/index.ts","backend/src/modules/treasury/payment-request.service.ts","backend/src/modules/treasury/petty-cash.service.ts","backend/src/modules/treasury/treasury.controller.ts","backend/src/shared/services/base.service.ts"]},{"id":"dd0c5594efcd279494302481c573a338d1b8f130","message":"Summarize backend revenue changes\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/dd0c5594efcd279494302481c573a338d1b8f130","author":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"committer":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"verification":null,"timestamp":"2026-02-15T16:57:36+08:00","added":["backend/src/modules/revenue/event-integration.controller.ts","backend/src/modules/revenue/invoice-items.service.ts","backend/src/modules/revenue/sales-commission.controller.ts","backend/src/modules/revenue/sales-commission.routes.ts","backend/src/modules/revenue/sales-commission.schema.ts"],"removed":[],"modified":["backend/src/modules/products/services/product.service.ts","backend/src/modules/revenue/event-integration.service.ts","backend/src/modules/revenue/index.ts","backend/src/modules/revenue/invoice.service.ts","backend/src/modules/revenue/revenue.routes.ts","backend/src/modules/revenue/revenue.service.ts","backend/src/modules/revenue/sales-commission.service.ts"]},{"id":"8bef17ed49cc235f56ba20490e1cbcd69d5eef59","message":"Investigate repeated API debug logs\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/8bef17ed49cc235f56ba20490e1cbcd69d5eef59","author":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"committer":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"verification":null,"timestamp":"2026-02-15T16:52:17+08:00","added":[],"removed":[],"modified":["backend/src/modules/products/services/product.service.ts"]},{"id":"5fa423d8f446e7c8019b507e98ca29833e1efc9a","message":"Investigate repeated GET /im/unread‑\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/5fa423d8f446e7c8019b507e98ca29833e1efc9a","author":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"committer":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"verification":null,"timestamp":"2026-02-15T16:32:27+08:00","added":["backend/src/modules/revenue/ar-ledger.controller.ts","backend/src/modules/revenue/ar-ledger.routes.ts","backend/src/modules/revenue/ar-ledger.schema.ts","backend/src/modules/revenue/invoice.controller.ts","backend/src/modules/revenue/invoice.routes.ts","backend/src/modules/revenue/invoice.schema.ts","backend/src/modules/revenue/payment-shared.ts","backend/src/modules/revenue/payment-stats.service.ts","backend/src/modules/revenue/payment.controller.ts","backend/src/modules/revenue/payment.routes.ts","backend/src/modules/revenue/payment.schema.ts","backend/src/modules/revenue/payment.service.ts","backend/src/modules/treasury/bank-account.service.ts","backend/src/modules/treasury/bank-import.service.ts","backend/src/modules/treasury/behavior-analysis.service.ts","backend/src/modules/treasury/cash-forecast.service.ts","backend/src/modules/treasury/customer-balance.service.ts","backend/src/modules/treasury/daily-settlement.service.ts","backend/src/modules/treasury/index.ts","backend/src/modules/treasury/match-rules.service.ts","backend/src/modules/treasury/matching-engine.service.ts","backend/src/modules/treasury/payment-request.service.ts","backend/src/modules/treasury/petty-cash.service.ts","backend/src/modules/treasury/treasury-overview.service.ts","backend/src/modules/treasury/treasury.controller.ts","backend/src/modules/treasury/treasury.docs.ts","backend/src/modules/treasury/treasury.routes.ts","backend/src/modules/treasury/treasury.schema.ts","backend/src/modules/treasury/treasury.service.ts","backend/tests/api/revenue-ar-ledger-compat.test.ts","backend/tests/api/revenue-invoices-compat.test.ts","backend/tests/api/revenue-payments-compat.test.ts","backend/tests/api/treasury-compat.test.ts"],"removed":[],"modified":["backend/src/main.ts","backend/src/modules/campaigns/campaign.service.ts","backend/src/modules/customers/customer.service.ts","backend/src/modules/finance/finance.routes.ts","backend/src/modules/revenue/ar-ledger.service.ts","backend/src/modules/revenue/index.ts","backend/src/modules/revenue/invoice.service.ts","backend/src/modules/revenue/payment-plan.service.ts","backend/src/modules/revenue/payment-reconciliation.service.ts","backend/src/modules/revenue/payment-record.service.ts","backend/src/modules/revenue/payment-statement.service.ts","backend/src/modules/revenue/revenue-stats.service.ts","backend/src/modules/revenue/revenue.routes.ts","backend/src/routes/register-domain-routes.ts"]},{"id":"d1b7018ba9053ef12ea4dd9e8851fbb815925825","message":"Inspect unread stats logging\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/d1b7018ba9053ef12ea4dd9e8851fbb815925825","author":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"committer":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"verification":null,"timestamp":"2026-02-15T14:36:25+08:00","added":["backend/prisma/migrations/20260215000001_create_bank_accounts/migration.sql","backend/prisma/migrations/20260215000002_create_payment_requests/migration.sql","backend/prisma/migrations/20260215000003_migrate_bank_accounts_from_json/migration.sql","backend/prisma/migrations/20260215000004_migrate_payment_requests_from_tasks/migration.sql","backend/src/modules/disbursements/ap-ledger.service.ts","backend/src/modules/disbursements/disbursement-generation.service.ts","backend/src/modules/disbursements/disbursement-record.service.ts","backend/src/modules/disbursements/disbursement-workflow.service.ts","backend/src/modules/disbursements/expense-category.service.ts","backend/src/modules/disbursements/expense-claim.service.ts","backend/src/modules/expense/ap-ledger.service.ts","backend/src/modules/expense/disbursement.service.ts","backend/src/modules/expense/expense-category.service.ts","backend/src/modules/expense/expense-claim.service.ts","backend/src/modules/expense/expense.controller.ts","backend/src/modules/expense/expense.docs.ts","backend/src/modules/expense/expense.routes.ts","backend/src/modules/expense/expense.schema.ts","backend/src/modules/expense/expense.service.ts","backend/src/modules/expense/index.ts","backend/src/modules/expense/partner-commission.service.ts","backend/src/modules/expense/refund.service.ts"],"removed":[],"modified":["CLAUDE.md","backend/src/main.ts","backend/src/modules/alliance-partners/alliance-partner.service.ts","backend/src/modules/customers/customer.service.ts","backend/src/modules/disbursements/disbursement.service.ts","backend/src/modules/finance/finance.routes.ts","backend/src/modules/finance/finance.service.ts","backend/src/modules/finance/treasury.controller.ts","backend/src/modules/finance/treasury.service.ts","backend/src/modules/groupbuy-platforms/groupbuy-platform.schema.ts","backend/src/modules/groupbuy-platforms/groupbuy-platform.service.ts","backend/src/modules/payments/payment.controller.ts","backend/src/modules/payments/payment.service.test.ts","backend/src/routes/register-domain-routes.ts","reports/api-route-contract-audit.latest.json"]}],"total_commits":0,"head_commit":{"id":"c544245db6731ba7a3f5a10edf7698967643f94d","message":"Update treasury services and schema\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/c544245db6731ba7a3f5a10edf7698967643f94d","author":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"committer":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"verification":null,"timestamp":"2026-02-15T20:33:20+08:00","added":["backend/src/modules/treasury/treasury-utils.ts"],"removed":[],"modified":["backend/prisma/schema.prisma","backend/src/modules/treasury/bank-account.service.ts","backend/src/modules/treasury/index.ts","backend/src/modules/treasury/payment-request.service.ts","backend/src/modules/treasury/petty-cash.service.ts","backend/src/modules/treasury/treasury.controller.ts","backend/src/shared/services/base.service.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":true,"fork":false,"template":false,"parent":null,"mirror":false,"size":400889,"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-24T00:14:39+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 74 in action_run