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":"a7c22fc0f5e2d113210bb58646dcdbf7381be245","after":"e15e357a819170a89dbcfd25fe33ea58972ae0ff","compare_url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/compare/a7c22fc0f5e2d113210bb58646dcdbf7381be245...e15e357a819170a89dbcfd25fe33ea58972ae0ff","commits":[{"id":"e15e357a819170a89dbcfd25fe33ea58972ae0ff","message":"feat: 新增 P1 优先级状态机（AI Agent、AI 任务、广告计划、选址评估）\n\n- ai-agent: 管理 AI Agent 员工生命周期（未激活→活跃→训练中→已暂停）\n- ai-task: 管理 AI 任务执行流程（待处理→处理中→已完成/失败/已取消）\n- ad-campaign: 管理广告投放全流程（草稿→待审批→已批准→投放中→已完成）\n- location-assessment: 管理门店选址评估（草稿→已提交→评审中→实地勘察→待审批→已批准）\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/e15e357a819170a89dbcfd25fe33ea58972ae0ff","author":{"name":"Claude","email":"noreply@anthropic.com","username":""},"committer":{"name":"Claude","email":"noreply@anthropic.com","username":""},"verification":null,"timestamp":"2026-01-25T22:55:03Z","added":["backend/src/shared/state-machines/machines/ad-campaign.machine.ts","backend/src/shared/state-machines/machines/ai-agent.machine.ts","backend/src/shared/state-machines/machines/ai-task.machine.ts","backend/src/shared/state-machines/machines/location-assessment.machine.ts"],"removed":[],"modified":["backend/src/shared/state-machines/index.ts","backend/src/shared/state-machines/utils/transitions.ts"]},{"id":"1ca105d537327f10bfa4ff7b4dd263c21711a3d5","message":"feat: 新增团购商品、团购核销、社媒发布状态机\n\n- groupbuy-product: 管理团购商品生命周期（草稿→审核→上架→下架/售罄/过期）\n- groupbuy-redemption: 管理券码核销流程（待核销→已核销/已退款/已过期）\n- social-post: 管理社媒内容发布（草稿→定时→发布中→已发布/失败）\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/1ca105d537327f10bfa4ff7b4dd263c21711a3d5","author":{"name":"Claude","email":"noreply@anthropic.com","username":""},"committer":{"name":"Claude","email":"noreply@anthropic.com","username":""},"verification":null,"timestamp":"2026-01-25T22:46:38Z","added":["backend/src/shared/state-machines/machines/groupbuy-product.machine.ts","backend/src/shared/state-machines/machines/groupbuy-redemption.machine.ts","backend/src/shared/state-machines/machines/social-post.machine.ts"],"removed":[],"modified":["backend/src/shared/state-machines/index.ts","backend/src/shared/state-machines/utils/transitions.ts"]},{"id":"e8d10339466d1d493d672174bb25eaaf804f5fa7","message":"feat: 新增联盟商家、培训场次、联盟结算状态机\n\n- 新增 alliance-partner.machine.ts (联盟商家状态机)\n  - 状态：pending → approved → active → suspended/terminated\n  - 支持审批、激活、冻结、终止等操作\n\n- 新增 training-session.machine.ts (培训场次状态机)\n  - 状态：pending → enrolling → in_progress → completed\n  - 支持报名开放、开始、完成、取消等操作\n\n- 新增 alliance-settlement.machine.ts (联盟结算状态机)\n  - 状态：pending → confirmed → approved → paid\n  - 支持确认、审批、支付、拒绝等操作\n\n- 更新 index.ts 导出新状态机\n- 更新 transitions.ts 添加转换验证函数\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/e8d10339466d1d493d672174bb25eaaf804f5fa7","author":{"name":"Claude","email":"noreply@anthropic.com","username":""},"committer":{"name":"Claude","email":"noreply@anthropic.com","username":""},"verification":null,"timestamp":"2026-01-25T22:40:37Z","added":["backend/src/shared/state-machines/machines/alliance-partner.machine.ts","backend/src/shared/state-machines/machines/alliance-settlement.machine.ts","backend/src/shared/state-machines/machines/training-session.machine.ts"],"removed":[],"modified":["backend/src/shared/state-machines/index.ts","backend/src/shared/state-machines/utils/transitions.ts"]},{"id":"986b5900952c599b9590cce0b9d832ab58f86504","message":"feat: 新增团购扩展状态机\n\n- 新增 groupbuy-influencer.machine.ts (团购达人状态机)\n- 新增 groupbuy-commission.machine.ts (团购佣金状态机)\n- 新增 groupbuy-promotion.machine.ts (团购促销状态机)\n- 更新 index.ts 导出新状态机\n- 更新 transitions.ts 添加转换验证函数\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/986b5900952c599b9590cce0b9d832ab58f86504","author":{"name":"Claude","email":"noreply@anthropic.com","username":""},"committer":{"name":"Claude","email":"noreply@anthropic.com","username":""},"verification":null,"timestamp":"2026-01-25T22:35:57Z","added":["backend/src/shared/state-machines/machines/groupbuy-commission.machine.ts","backend/src/shared/state-machines/machines/groupbuy-influencer.machine.ts","backend/src/shared/state-machines/machines/groupbuy-promotion.machine.ts"],"removed":[],"modified":["backend/src/shared/state-machines/index.ts","backend/src/shared/state-machines/utils/transitions.ts"]},{"id":"43e15382c2d1217602fc7ef10114983770e23e14","message":"feat: 新增 HR 模块和资产管理状态机\n\n- 新增 leave-request.machine.ts (请假申请状态机)\n- 新增 overtime-request.machine.ts (加班申请状态机)\n- 新增 serial-number.machine.ts (序列号/资产状态机)\n- 更新 index.ts 导出新状态机\n- 更新 transitions.ts 添加转换验证函数\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/43e15382c2d1217602fc7ef10114983770e23e14","author":{"name":"Claude","email":"noreply@anthropic.com","username":""},"committer":{"name":"Claude","email":"noreply@anthropic.com","username":""},"verification":null,"timestamp":"2026-01-25T22:28:50Z","added":["backend/src/shared/state-machines/machines/leave-request.machine.ts","backend/src/shared/state-machines/machines/overtime-request.machine.ts","backend/src/shared/state-machines/machines/serial-number.machine.ts"],"removed":[],"modified":["backend/src/shared/state-machines/index.ts","backend/src/shared/state-machines/utils/transitions.ts"]}],"total_commits":0,"head_commit":{"id":"e15e357a819170a89dbcfd25fe33ea58972ae0ff","message":"feat: 新增 P1 优先级状态机（AI Agent、AI 任务、广告计划、选址评估）\n\n- ai-agent: 管理 AI Agent 员工生命周期（未激活→活跃→训练中→已暂停）\n- ai-task: 管理 AI 任务执行流程（待处理→处理中→已完成/失败/已取消）\n- ad-campaign: 管理广告投放全流程（草稿→待审批→已批准→投放中→已完成）\n- location-assessment: 管理门店选址评估（草稿→已提交→评审中→实地勘察→待审批→已批准）\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/e15e357a819170a89dbcfd25fe33ea58972ae0ff","author":{"name":"Claude","email":"noreply@anthropic.com","username":""},"committer":{"name":"Claude","email":"noreply@anthropic.com","username":""},"verification":null,"timestamp":"2026-01-25T22:55:03Z","added":["backend/src/shared/state-machines/machines/ad-campaign.machine.ts","backend/src/shared/state-machines/machines/ai-agent.machine.ts","backend/src/shared/state-machines/machines/ai-task.machine.ts","backend/src/shared/state-machines/machines/location-assessment.machine.ts"],"removed":[],"modified":["backend/src/shared/state-machines/index.ts","backend/src/shared/state-machines/utils/transitions.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":26375,"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:00:13+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 49 in action_run