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":"e926f391dc14e2cc2b180c71114e6a20d20abed5","after":"2186d56d658fcaab3ff5ca5880742254dc8c4545","compare_url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/compare/e926f391dc14e2cc2b180c71114e6a20d20abed5...2186d56d658fcaab3ff5ca5880742254dc8c4545","commits":[{"id":"2186d56d658fcaab3ff5ca5880742254dc8c4545","message":"feat(dogfooding): 建立7天内部吃狗粮测试启动包\n\n## 核心产出\n\n### 测试文档体系\n- docs/dogfooding/README.md: 整体索引 + 启动 SOP\n- docs/dogfooding/accounts.md: 测试账号清单（租户A 8角色 + 租户B 2角色）\n- docs/dogfooding/metrics-dashboard.md: 每日实时指标看板（Bug趋势/模块分布/全链路状态）\n\n### 7天分日测试脚本\n- day-1: 基础验证（登录/线索/渠道）\n- day-2: 线索全流程 + 渠道深度\n- day-3: 商机 + 报价 + 审批流\n- day-4: 合同 + 订单 + 发货（Lead→Cash 链路首次跑通）\n- day-5: 财务 + 工单 + 续费\n- day-6: 门店 + 团购 + 社区任务（Store→Redemption 链路首次跑通）\n- day-7: 性能测试 + 多租户隔离验证 + 总结\n\n### 反馈收集机制\n- .gitea/ISSUE_TEMPLATE/bug_report.md: Bug 上报模板（P0~P3 等级/复现步骤/环境信息）\n- .gitea/ISSUE_TEMPLATE/feature_request.md: 改进建议模板\n- docs/dogfooding/templates/bug-report.md: Markdown 离线版\n- docs/dogfooding/templates/daily-report.md: 日报模板（9项打分维度）\n- docs/dogfooding/templates/final-report.md: 7天总结报告模板\n\n### 种子数据脚本\n- backend/scripts/seed-dogfood.ts: 完整种子数据脚本\n  - 2个租户（dogfood-a/dogfood-b）\n  - 8个测试账号（SDR/AE/CS/OPS/FIN/MGR/QA/DEV角色）\n  - 10条渠道 + 20家企业客户 + 100条线索\n  - 30个商机 + 10张报价 + 50个产品 + 3本价格目录\n  - 5家门店 + 3个团购活动 + 2个社区 + 10个社区任务\n\n## 7天验收指标\n- Lead→Cash 链路完整记录 ≥1条\n- Store→Redemption 链路完整记录 ≥1条\n- P0 Bug 当日修复率 100%，P1 Bug 48h修复率 ≥80%\n- 页面首屏 \u003c3s，API响应 \u003c500ms\n- 多租户数据隔离 0泄露，测试账号日活率 ≥80%\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/2186d56d658fcaab3ff5ca5880742254dc8c4545","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-27T13:05:12+08:00","added":[".gitea/ISSUE_TEMPLATE/bug_report.md",".gitea/ISSUE_TEMPLATE/feature_request.md","backend/scripts/seed-dogfood.ts","docs/dogfooding/README.md","docs/dogfooding/accounts.md","docs/dogfooding/daily/day-1.md","docs/dogfooding/daily/day-2.md","docs/dogfooding/daily/day-3.md","docs/dogfooding/daily/day-4.md","docs/dogfooding/daily/day-5.md","docs/dogfooding/daily/day-6.md","docs/dogfooding/daily/day-7.md","docs/dogfooding/metrics-dashboard.md","docs/dogfooding/templates/bug-report.md","docs/dogfooding/templates/daily-report.md","docs/dogfooding/templates/final-report.md"],"removed":[],"modified":[]}],"total_commits":0,"head_commit":{"id":"2186d56d658fcaab3ff5ca5880742254dc8c4545","message":"feat(dogfooding): 建立7天内部吃狗粮测试启动包\n\n## 核心产出\n\n### 测试文档体系\n- docs/dogfooding/README.md: 整体索引 + 启动 SOP\n- docs/dogfooding/accounts.md: 测试账号清单（租户A 8角色 + 租户B 2角色）\n- docs/dogfooding/metrics-dashboard.md: 每日实时指标看板（Bug趋势/模块分布/全链路状态）\n\n### 7天分日测试脚本\n- day-1: 基础验证（登录/线索/渠道）\n- day-2: 线索全流程 + 渠道深度\n- day-3: 商机 + 报价 + 审批流\n- day-4: 合同 + 订单 + 发货（Lead→Cash 链路首次跑通）\n- day-5: 财务 + 工单 + 续费\n- day-6: 门店 + 团购 + 社区任务（Store→Redemption 链路首次跑通）\n- day-7: 性能测试 + 多租户隔离验证 + 总结\n\n### 反馈收集机制\n- .gitea/ISSUE_TEMPLATE/bug_report.md: Bug 上报模板（P0~P3 等级/复现步骤/环境信息）\n- .gitea/ISSUE_TEMPLATE/feature_request.md: 改进建议模板\n- docs/dogfooding/templates/bug-report.md: Markdown 离线版\n- docs/dogfooding/templates/daily-report.md: 日报模板（9项打分维度）\n- docs/dogfooding/templates/final-report.md: 7天总结报告模板\n\n### 种子数据脚本\n- backend/scripts/seed-dogfood.ts: 完整种子数据脚本\n  - 2个租户（dogfood-a/dogfood-b）\n  - 8个测试账号（SDR/AE/CS/OPS/FIN/MGR/QA/DEV角色）\n  - 10条渠道 + 20家企业客户 + 100条线索\n  - 30个商机 + 10张报价 + 50个产品 + 3本价格目录\n  - 5家门店 + 3个团购活动 + 2个社区 + 10个社区任务\n\n## 7天验收指标\n- Lead→Cash 链路完整记录 ≥1条\n- Store→Redemption 链路完整记录 ≥1条\n- P0 Bug 当日修复率 100%，P1 Bug 48h修复率 ≥80%\n- 页面首屏 \u003c3s，API响应 \u003c500ms\n- 多租户数据隔离 0泄露，测试账号日活率 ≥80%\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/2186d56d658fcaab3ff5ca5880742254dc8c4545","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-27T13:05:12+08:00","added":[".gitea/ISSUE_TEMPLATE/bug_report.md",".gitea/ISSUE_TEMPLATE/feature_request.md","backend/scripts/seed-dogfood.ts","docs/dogfooding/README.md","docs/dogfooding/accounts.md","docs/dogfooding/daily/day-1.md","docs/dogfooding/daily/day-2.md","docs/dogfooding/daily/day-3.md","docs/dogfooding/daily/day-4.md","docs/dogfooding/daily/day-5.md","docs/dogfooding/daily/day-6.md","docs/dogfooding/daily/day-7.md","docs/dogfooding/metrics-dashboard.md","docs/dogfooding/templates/bug-report.md","docs/dogfooding/templates/daily-report.md","docs/dogfooding/templates/final-report.md"],"removed":[],"modified":[]},"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":481263,"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-27T13:05:11+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 1135 in action_run