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":"b93d37ac75fcac068cb96cd72f7760cf3f9ee0f9","after":"d96c65b28668f885c01649e4d31f5f9676cfe863","compare_url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/compare/b93d37ac75fcac068cb96cd72f7760cf3f9ee0f9...d96c65b28668f885c01649e4d31f5f9676cfe863","commits":[{"id":"d96c65b28668f885c01649e4d31f5f9676cfe863","message":"Fix missing TasksPending view import\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/d96c65b28668f885c01649e4d31f5f9676cfe863","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-19T13:46:35+08:00","added":[],"removed":[],"modified":["backend/src/modules/ad-audiences/ad-audience.schema.ts","backend/src/modules/ad-audiences/ad-audience.service.ts","backend/src/modules/ad-campaigns/ad-campaigns.docs.ts","backend/src/modules/ad-campaigns/ad-campaigns.service.ts","backend/src/modules/ad-creatives/ad-creative.controller.ts","backend/src/modules/ad-creatives/ad-creative.docs.ts","backend/src/modules/ad-creatives/ad-creative.routes.ts","backend/src/modules/ad-creatives/ad-creative.schema.ts","backend/src/modules/ad-creatives/ad-creative.service.ts","backend/src/modules/crm-activities/crm-activity.schema.ts","backend/src/modules/leads/lead.controller.ts","backend/src/modules/leads/lead.routes.ts","backend/src/modules/leads/lead.service.ts"]},{"id":"7ee51d863143a09ac5f44aca0fae0e2ec78d7153","message":"Fix missing TasksPending view import\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/7ee51d863143a09ac5f44aca0fae0e2ec78d7153","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-19T13:28:00+08:00","added":["backend/prisma/migrations/20260219000000_add_agent_audit_tables/migration.sql","backend/src/modules/campaigns/campaign-asset.service.ts","backend/src/modules/revenue/sales-commission-record.service.ts","backend/src/modules/revenue/sales-commission-settlement.service.ts","backend/src/modules/ticket-workflows/ticket-workflow.controller.ts","backend/src/modules/ticket-workflows/ticket-workflow.routes.ts","backend/src/shared/services/agent-audit.service.ts","backend/src/shared/types/agent-audit.ts","docs/AI_AGENT_QUICKSTART.md","docs/AI_AGENT_VISIBILITY_OPTIMIZATION.md","docs/PROJECT_PHOENIX_PLAN.md","frontend/src/types/process.ts","reports/modules.rescan.2026-02-19.err","reports/modules.rescan.2026-02-19.json","reports/modules.rescan4.2026-02-19.err","reports/modules.rescan4.2026-02-19.json","reports/permission.audit.live.2026-02-19.err","reports/permission.audit.live.2026-02-19.json","reports/permission.audit.rescan.2026-02-19.err","reports/permission.audit.rescan.2026-02-19.json","reports/permission.audit.rescan2.2026-02-19.err","reports/permission.audit.rescan2.2026-02-19.json","reports/permission.audit.rescan4.2026-02-19.err","reports/permission.audit.rescan4.2026-02-19.json","reports/vitest.backend.rescan.2026-02-19.json","reports/vitest.backend.rescan2.2026-02-19.json","reports/vitest.backend.rescan4.2026-02-19.json","scripts/performance/apply-optimization-indexes.sql"],"removed":[],"modified":["CLAUDE.md","GEMINI.md","README.md","REFACTOR_TASKS.md","backend/REFACTOR_REPORT.md","backend/prisma/schema.prisma","backend/scripts/audit-permission-security.ts","backend/src/consumers/campaign-effectiveness.consumer.ts","backend/src/modules/ad-placement/ad-creative.routes.ts","backend/src/modules/ai-agents/ai-agent-im.routes.ts","backend/src/modules/auth/auth.compat.routes.ts","backend/src/modules/campaign-analytics/campaign-analytics.routes.ts","backend/src/modules/campaigns/campaign-effectiveness.service.ts","backend/src/modules/campaigns/campaign.controller.ts","backend/src/modules/campaigns/campaign.service.ts","backend/src/modules/contract-templates/contract-template.controller.ts","backend/src/modules/contract-templates/contract-template.service.ts","backend/src/modules/contracts/contract.compat.routes.ts","backend/src/modules/contracts/contract.controller.ts","backend/src/modules/contracts/contract.routes.ts","backend/src/modules/contracts/contract.service.test.ts","backend/src/modules/contracts/contract.service.ts","backend/src/modules/cost-allocation/cost-allocation.compat.routes.ts","backend/src/modules/customers/customer-export.service.ts","backend/src/modules/customers/customer.controller.ts","backend/src/modules/customers/customer.service.ts","backend/src/modules/departments/department.compat.routes.ts","backend/src/modules/departments/department.routes.ts","backend/src/modules/departments/department.service.ts","backend/src/modules/finance/finance.service.ts","backend/src/modules/hr/attendance/leaves/leave.routes.ts","backend/src/modules/hr/attendance/overtime/overtime.routes.ts","backend/src/modules/hr/payroll/payroll.routes.ts","backend/src/modules/hr/training/exams/exam.routes.ts","backend/src/modules/inventory/inventory.controller.ts","backend/src/modules/inventory/inventory.routes.ts","backend/src/modules/inventory/inventory.service.ts","backend/src/modules/invoices/invoice.routes.ts","backend/src/modules/invoices/invoice.service.test.ts","backend/src/modules/invoices/invoice.service.ts","backend/src/modules/landing-pages/landing-page-public.compat.routes.ts","backend/src/modules/leads/lead.controller.ts","backend/src/modules/leads/lead.service.test.ts","backend/src/modules/leads/lead.service.ts","backend/src/modules/marketing-chatbot/marketing-chatbot.public.compat.routes.ts","backend/src/modules/marketing-forms/marketing-form-public.compat.routes.ts","backend/src/modules/marketing-timeslots/marketing-timeslots.controller.ts","backend/src/modules/marketing-timeslots/marketing-timeslots.service.ts","backend/src/modules/marketing/marketing-campaign.service.ts","backend/src/modules/marketing/marketing.controller.ts","backend/src/modules/marketing/marketing.routes.ts","backend/src/modules/marketing/marketing.service.ts","backend/src/modules/opportunities/opportunity-analytics.service.ts","backend/src/modules/opportunities/opportunity-competitor.service.ts","backend/src/modules/opportunities/opportunity-team.service.ts","backend/src/modules/opportunities/opportunity.controller.ts","backend/src/modules/opportunities/opportunity.routes.ts","backend/src/modules/opportunities/opportunity.service.ts","backend/src/modules/orders/order.service.test.ts","backend/src/modules/orders/order.service.ts","backend/src/modules/price-books/price-book.controller.ts","backend/src/modules/price-books/price-book.routes.ts","backend/src/modules/price-books/price-book.service.ts","backend/src/modules/process/process-task.routes.ts","backend/src/modules/products/controllers/product.controller.ts","backend/src/modules/products/controllers/sku.controller.ts","backend/src/modules/products/routes/sku.routes.ts","backend/src/modules/products/services/index.ts","backend/src/modules/products/services/product.service.ts","backend/src/modules/products/services/sku.service.ts","backend/src/modules/projects/project.service.ts","backend/src/modules/quotes/quote.controller.ts","backend/src/modules/quotes/quote.routes.ts","backend/src/modules/quotes/quote.service.test.ts","backend/src/modules/quotes/quote.service.ts","backend/src/modules/revenue/ar-ledger.service.ts","backend/src/modules/revenue/invoice.service.ts","backend/src/modules/revenue/payment-terms.service.ts","backend/src/modules/revenue/payment.service.ts","backend/src/modules/revenue/revenue-recognition.controller.ts","backend/src/modules/revenue/revenue-recognition.service.ts","backend/src/modules/revenue/revenue.controller.ts","backend/src/modules/revenue/revenue.mapper.ts","backend/src/modules/roles/role.service.ts","backend/src/modules/social-accounts/social-account.compat.routes.ts","backend/src/modules/stores/store.controller.ts","backend/src/modules/stores/store.mapper.ts","backend/src/modules/stores/store.service.ts","backend/src/modules/supplier-payments/supplier-payments.compat.routes.ts","backend/src/modules/tickets/ticket.controller.ts","backend/src/modules/tickets/ticket.routes.ts","backend/src/modules/tickets/ticket.schema.ts","backend/src/modules/tickets/ticket.service.ts","backend/src/modules/users/user.compat.routes.ts","backend/src/modules/users/user.routes.ts","backend/src/modules/users/user.service.ts","backend/src/modules/web-tracking/web-tracking-public.compat.routes.ts","backend/src/routes/register-domain-routes.ts","backend/src/shared/constants/permissions.ts","backend/src/shared/services/base.service.ts","backend/src/shared/utils/biz-code.ts","docs/ACTION-PLAN-2026.md","docs/ALIGNMENT_REPORT_2026.md","frontend/src/api/factory.ts","frontend/src/api/modules/contracts.ts","frontend/src/api/modules/leads.ts","frontend/src/api/modules/opportunities.ts","frontend/src/api/modules/orders.ts","frontend/src/api/modules/quotes.ts","frontend/src/types/ai-agent.ts","frontend/src/types/index.ts","frontend/src/views/ai-agents/IMConversations.vue","frontend/src/views/ai-agents/IMIntegrationSettings.vue","frontend/src/views/ai-agents/IMQueue.vue","frontend/src/views/ai-agents/components/AgentModelManager.vue","frontend/src/views/hr/attendance/components/LeavesTab.vue","frontend/src/views/meddpicc-analyses/Index.vue","frontend/src/views/process-designer/Designer.vue","frontend/src/views/renewal-tasks/Index.vue","frontend/src/views/users/components/UserForm.vue","reports/api-route-contract-audit.latest.json","reports/api-route-contract-audit.latest.md","reports/event-publishing-audit.latest.json","reports/missing-events-audit.latest.json","reports/missing-events-audit.latest.md","reports/state-machine-integration-audit.latest.json","reports/state-machine-integration-audit.latest.md"]},{"id":"a3927308ef0917d5dec9f40d78e446933a0fb79f","message":"Fix missing ai agents TasksPending\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/a3927308ef0917d5dec9f40d78e446933a0fb79f","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-19T00:32:55+08:00","added":[],"removed":[],"modified":["backend/src/modules/leads/lead.service.ts","backend/src/modules/opportunities/opportunity.service.ts","backend/src/modules/serial-numbers/sn.service.ts","backend/src/modules/tenant-configs/tenant-config.service.ts","backend/src/modules/tickets/ticket-interactions.service.ts","backend/src/modules/tickets/ticket-operations.service.ts","backend/src/modules/tickets/ticket-queries.service.ts","backend/src/modules/tickets/ticket.controller.ts","reports/vitest.backend.latest.json"]},{"id":"806f9199b965314766348d1986a0b911eefe9f78","message":"Fix missing TasksPending view import\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/806f9199b965314766348d1986a0b911eefe9f78","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-18T21:07:28+08:00","added":["docs/reports/PROJECT_DEEP_ANALYSIS_2026-02-18.md","reports/vitest.backend.latest.json","深度分析项目执行方案.md"],"removed":[],"modified":["backend/src/modules/ai-agents/ai-agent.service.ts","backend/src/modules/alliance-merchants/alliance-merchant.service.ts","backend/src/modules/alliance-products/alliance-product.service.ts","backend/src/modules/community-members/community-member.service.ts","backend/src/modules/departments/department.service.ts","backend/src/modules/finance/finance.controller.ts","backend/src/modules/finance/finance.routes.ts","backend/src/modules/fulfillment/acceptance-automation.service.ts","backend/src/modules/inventory/services/inventory-warehouse.service.ts","backend/src/modules/payments/payment-reconciliation.controller.ts","backend/src/modules/payments/payment-reconciliation.service.ts","backend/src/modules/payments/payment-record.controller.ts","backend/src/modules/payments/payment-stats.controller.ts","backend/src/modules/payments/payment.routes.ts","backend/src/modules/price-books/index.ts","backend/src/modules/price-books/price-book.service.ts","backend/src/modules/process-designer/process-designer.routes.ts","backend/src/modules/products/services/category.service.ts","backend/src/modules/products/services/sku.service.ts","backend/src/modules/projects/project.service.ts","backend/src/modules/quotes/quote.service.ts","backend/src/modules/revenue/invoice.routes.ts","backend/src/modules/revenue/payment-terms.service.ts","backend/src/modules/revenue/payment.routes.ts","backend/src/modules/rma/rma.service.ts","backend/src/modules/social-accounts/social-account.controller.ts","backend/src/modules/social-accounts/social-account.routes.ts","backend/src/modules/tickets/ticket-queries.service.ts","backend/src/modules/users/user.service.ts","backend/src/shared/state-machines/utils/transitions.ts","frontend/src/views/ai-agents/components/AgentModelManager.vue","reports/api-route-contract-audit.latest.json","reports/api-route-contract-audit.latest.md","reports/state-machine-integration-audit.latest.json","reports/state-machine-integration-audit.latest.md","获客中心与门店运营深度分析报告.md","门店运营深度思考.md"]},{"id":"5440eca0fa0e07a317f90fcd71c33a45eff2cbdc","message":"Fix missing TasksPending view import\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/5440eca0fa0e07a317f90fcd71c33a45eff2cbdc","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-18T19:06:46+08:00","added":["backend/src/modules/payments/payment-plan.controller.ts","backend/src/modules/payments/payment-reconciliation.controller.ts","backend/src/modules/payments/payment-record.controller.ts","backend/src/modules/payments/payment-statement.controller.ts","backend/src/modules/payments/payment-stats.controller.ts"],"removed":["backend/src/modules/payments/payment.controller.ts"],"modified":["backend/src/modules/bom/bom.controller.ts","backend/src/modules/bom/bom.service.ts","backend/src/modules/campaign-drafts/campaign-draft.controller.ts","backend/src/modules/campaign-drafts/campaign-draft.service.ts","backend/src/modules/campaign-library/campaign-library.controller.ts","backend/src/modules/campaign-library/campaign-library.service.ts","backend/src/modules/payments/payment.routes.ts","backend/src/modules/resource-requests/resource-request.controller.ts","backend/src/modules/resource-requests/resource-request.service.ts","backend/src/modules/revenue/ar-ledger.controller.ts","backend/src/modules/revenue/ar-ledger.service.ts","backend/src/modules/revenue/invoice.controller.ts","backend/src/modules/revenue/invoice.routes.ts","backend/src/modules/revenue/invoice.service.ts","backend/src/modules/revenue/payment-terms.service.ts","backend/src/modules/sample-requests/sample-request.controller.ts","backend/src/modules/stores/store.controller.ts"]}],"total_commits":0,"head_commit":{"id":"d96c65b28668f885c01649e4d31f5f9676cfe863","message":"Fix missing TasksPending view import\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/d96c65b28668f885c01649e4d31f5f9676cfe863","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-19T13:46:35+08:00","added":[],"removed":[],"modified":["backend/src/modules/ad-audiences/ad-audience.schema.ts","backend/src/modules/ad-audiences/ad-audience.service.ts","backend/src/modules/ad-campaigns/ad-campaigns.docs.ts","backend/src/modules/ad-campaigns/ad-campaigns.service.ts","backend/src/modules/ad-creatives/ad-creative.controller.ts","backend/src/modules/ad-creatives/ad-creative.docs.ts","backend/src/modules/ad-creatives/ad-creative.routes.ts","backend/src/modules/ad-creatives/ad-creative.schema.ts","backend/src/modules/ad-creatives/ad-creative.service.ts","backend/src/modules/crm-activities/crm-activity.schema.ts","backend/src/modules/leads/lead.controller.ts","backend/src/modules/leads/lead.routes.ts","backend/src/modules/leads/lead.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":469553,"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:25:01+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 80 in action_run