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":"abd8cdd0283c96dc4a62fbf753d2aca2e68aa379","after":"89209aba1afe21133399ce0db0a47c2729c9a4b4","compare_url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/compare/abd8cdd0283c96dc4a62fbf753d2aca2e68aa379...89209aba1afe21133399ce0db0a47c2729c9a4b4","commits":[{"id":"89209aba1afe21133399ce0db0a47c2729c9a4b4","message":"feat: 新增门店管理模块，补充门店维度营销分析端点\n\n一、门店管理模块 (stores)\n- 门店 CRUD：创建、更新、删除、状态管理\n- 门店类型：旗舰店、标准店、加盟店、合作店、迷你店、快闪店\n- 状态机：pending → active → suspended/renovating → closed\n\n二、门店维度营销分析端点\n- GET /stores/:id/marketing-analytics - 门店营销分析（活动、直播、团购、订单汇总）\n- GET /stores/:id/roi-analytics - 门店 ROI 分析（投入产出比、渠道分解、同比环比）\n- GET /stores/:id/livestream-stats - 门店直播统计（场次、时长、观众、GMV）\n- GET /stores/:id/campaigns - 门店活动列表\n\n三、门店对比和排行\n- POST /stores/compare - 多门店横向对比\n- GET /stores/ranking - 门店排行榜（营收、订单、评分、直播GMV）\n\n四、门店营销配置\n- PATCH /stores/:id/marketing-config - 团购/直播/促销开关、平台配置、预算设置\n\n五、前端 API 模块\n- stores.ts：完整类型定义 + API 封装 + 状态配置 + 工具函数\n\n严格遵循8条开发红线\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/89209aba1afe21133399ce0db0a47c2729c9a4b4","author":{"name":"Claude","email":"noreply@anthropic.com","username":""},"committer":{"name":"Claude","email":"noreply@anthropic.com","username":""},"verification":null,"timestamp":"2026-01-11T07:36:12Z","added":["backend/src/modules/stores/index.ts","backend/src/modules/stores/store.controller.ts","backend/src/modules/stores/store.routes.ts","backend/src/modules/stores/store.schema.ts","backend/src/modules/stores/store.service.ts","frontend/src/api/modules/stores.ts"],"removed":[],"modified":["backend/src/shared/constants/modules.ts"]},{"id":"bd02a7f3eefc8d114499177151ddde0a410c4065","message":"feat: 完善 KTV 智慧营销域模块代码实现 - 19个后端模块 + 19个前端API模块\n\n一、分析类模块 (3个)\n- social-analytics: 社交媒体分析（账号概览、内容表现、粉丝画像、竞品对比、趋势分析）\n- content-analytics: 内容分析（表现概览、热门内容、分类表现、发布时间分析）\n- livestream-gifts: 直播礼物（礼物配置、赠送记录、礼物统计、排行榜）\n\n二、商家联盟域模块 (5个)\n- alliance-partners: 联盟商家（入驻审核、等级管理、状态机驱动）\n- alliance-agreements: 联盟协议（协议模板、审批流、续签终止）\n- alliance-campaigns: 联盟活动（多商家参与、效果追踪、奖励配置）\n- alliance-coupons: 联盟优惠券（发放核销、成本分摊、使用规则）\n- alliance-packages: 联盟套餐（多商家组合、分成模式、有效期管理）\n\n三、社群运营域模块 (4个)\n- community-materials: 社群素材（素材库、审核流程、使用追踪）\n- community-tasks: 社群任务（任务配置、执行管理、状态机驱动）\n- community-fission: 社群裂变（邀请奖励、拼团助力、排行榜）\n- community-bots: 社群机器人（多平台支持、自动回复、消息日志）\n\n四、团购运营域模块 (7个)\n- groupbuy-platforms: 团购平台（平台接入、同步配置、对账管理）\n- groupbuy-promotions: 团购促销（促销配置、状态管理、批量操作）\n- groupbuy-inventory: 团购库存（库存管理、预警机制、调拨盘点）\n- groupbuy-redemptions: 团购核销（券码验证、核销记录、统计分析）\n- groupbuy-reviews: 团购评价（评价管理、商家回复、审核分析）\n- groupbuy-commissions: 团购佣金（佣金规则、结算审批、对账报表）\n- groupbuy-influencers: 团购达人（招募审核、等级体系、带货数据）\n\n技术规范：\n- 后端：5层标准结构（schema/service/controller/routes/index）\n- 前端：完整 TypeScript 类型定义 + API 封装\n- 严格遵循8条开发红线（多租户隔离、状态机、事件驱动等）\n\n文件统计：\n- 后端模块：19个目录，95个文件\n- 前端API：19个TypeScript模块，总计约10,000+行代码\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/bd02a7f3eefc8d114499177151ddde0a410c4065","author":{"name":"Claude","email":"noreply@anthropic.com","username":""},"committer":{"name":"Claude","email":"noreply@anthropic.com","username":""},"verification":null,"timestamp":"2026-01-11T07:21:51Z","added":["backend/src/modules/alliance-agreements/alliance-agreement.controller.ts","backend/src/modules/alliance-agreements/alliance-agreement.routes.ts","backend/src/modules/alliance-agreements/alliance-agreement.schema.ts","backend/src/modules/alliance-agreements/alliance-agreement.service.ts","backend/src/modules/alliance-agreements/index.ts","backend/src/modules/alliance-campaigns/alliance-campaign.controller.ts","backend/src/modules/alliance-campaigns/alliance-campaign.routes.ts","backend/src/modules/alliance-campaigns/alliance-campaign.schema.ts","backend/src/modules/alliance-campaigns/alliance-campaign.service.ts","backend/src/modules/alliance-campaigns/index.ts","backend/src/modules/alliance-coupons/alliance-coupon.controller.ts","backend/src/modules/alliance-coupons/alliance-coupon.routes.ts","backend/src/modules/alliance-coupons/alliance-coupon.schema.ts","backend/src/modules/alliance-coupons/alliance-coupon.service.ts","backend/src/modules/alliance-coupons/index.ts","backend/src/modules/alliance-packages/alliance-package.controller.ts","backend/src/modules/alliance-packages/alliance-package.routes.ts","backend/src/modules/alliance-packages/alliance-package.schema.ts","backend/src/modules/alliance-packages/alliance-package.service.ts","backend/src/modules/alliance-packages/index.ts","backend/src/modules/alliance-partners/alliance-partner.controller.ts","backend/src/modules/alliance-partners/alliance-partner.routes.ts","backend/src/modules/alliance-partners/alliance-partner.schema.ts","backend/src/modules/alliance-partners/alliance-partner.service.ts","backend/src/modules/alliance-partners/index.ts","backend/src/modules/community-bots/community-bot.controller.ts","backend/src/modules/community-bots/community-bot.routes.ts","backend/src/modules/community-bots/community-bot.schema.ts","backend/src/modules/community-bots/community-bot.service.ts","backend/src/modules/community-bots/index.ts","backend/src/modules/community-fission/community-fission.controller.ts","backend/src/modules/community-fission/community-fission.routes.ts","backend/src/modules/community-fission/community-fission.schema.ts","backend/src/modules/community-fission/community-fission.service.ts","backend/src/modules/community-fission/index.ts","backend/src/modules/community-materials/community-material.controller.ts","backend/src/modules/community-materials/community-material.routes.ts","backend/src/modules/community-materials/community-material.schema.ts","backend/src/modules/community-materials/community-material.service.ts","backend/src/modules/community-materials/index.ts","backend/src/modules/community-tasks/community-task.controller.ts","backend/src/modules/community-tasks/community-task.routes.ts","backend/src/modules/community-tasks/community-task.schema.ts","backend/src/modules/community-tasks/community-task.service.ts","backend/src/modules/community-tasks/index.ts","backend/src/modules/content-analytics/content-analytics.controller.ts","backend/src/modules/content-analytics/content-analytics.routes.ts","backend/src/modules/content-analytics/content-analytics.schema.ts","backend/src/modules/content-analytics/content-analytics.service.ts","backend/src/modules/content-analytics/index.ts","backend/src/modules/groupbuy-commissions/groupbuy-commission.controller.ts","backend/src/modules/groupbuy-commissions/groupbuy-commission.routes.ts","backend/src/modules/groupbuy-commissions/groupbuy-commission.schema.ts","backend/src/modules/groupbuy-commissions/groupbuy-commission.service.ts","backend/src/modules/groupbuy-commissions/index.ts","backend/src/modules/groupbuy-influencers/groupbuy-influencer.controller.ts","backend/src/modules/groupbuy-influencers/groupbuy-influencer.routes.ts","backend/src/modules/groupbuy-influencers/groupbuy-influencer.schema.ts","backend/src/modules/groupbuy-influencers/groupbuy-influencer.service.ts","backend/src/modules/groupbuy-influencers/index.ts","backend/src/modules/groupbuy-inventory/groupbuy-inventory.controller.ts","backend/src/modules/groupbuy-inventory/groupbuy-inventory.routes.ts","backend/src/modules/groupbuy-inventory/groupbuy-inventory.schema.ts","backend/src/modules/groupbuy-inventory/groupbuy-inventory.service.ts","backend/src/modules/groupbuy-inventory/index.ts","backend/src/modules/groupbuy-platforms/groupbuy-platform.controller.ts","backend/src/modules/groupbuy-platforms/groupbuy-platform.routes.ts","backend/src/modules/groupbuy-platforms/groupbuy-platform.schema.ts","backend/src/modules/groupbuy-platforms/groupbuy-platform.service.ts","backend/src/modules/groupbuy-platforms/index.ts","backend/src/modules/groupbuy-promotions/groupbuy-promotion.controller.ts","backend/src/modules/groupbuy-promotions/groupbuy-promotion.routes.ts","backend/src/modules/groupbuy-promotions/groupbuy-promotion.schema.ts","backend/src/modules/groupbuy-promotions/groupbuy-promotion.service.ts","backend/src/modules/groupbuy-promotions/index.ts","backend/src/modules/groupbuy-redemptions/groupbuy-redemption.controller.ts","backend/src/modules/groupbuy-redemptions/groupbuy-redemption.routes.ts","backend/src/modules/groupbuy-redemptions/groupbuy-redemption.schema.ts","backend/src/modules/groupbuy-redemptions/groupbuy-redemption.service.ts","backend/src/modules/groupbuy-redemptions/index.ts","backend/src/modules/groupbuy-reviews/groupbuy-review.controller.ts","backend/src/modules/groupbuy-reviews/groupbuy-review.routes.ts","backend/src/modules/groupbuy-reviews/groupbuy-review.schema.ts","backend/src/modules/groupbuy-reviews/groupbuy-review.service.ts","backend/src/modules/groupbuy-reviews/index.ts","backend/src/modules/livestream-gifts/index.ts","backend/src/modules/livestream-gifts/livestream-gifts.controller.ts","backend/src/modules/livestream-gifts/livestream-gifts.routes.ts","backend/src/modules/livestream-gifts/livestream-gifts.schema.ts","backend/src/modules/livestream-gifts/livestream-gifts.service.ts","backend/src/modules/social-analytics/index.ts","backend/src/modules/social-analytics/social-analytics.controller.ts","backend/src/modules/social-analytics/social-analytics.routes.ts","backend/src/modules/social-analytics/social-analytics.schema.ts","backend/src/modules/social-analytics/social-analytics.service.ts","frontend/src/api/modules/alliance-agreements.ts","frontend/src/api/modules/alliance-campaigns.ts","frontend/src/api/modules/alliance-coupons.ts","frontend/src/api/modules/alliance-packages.ts","frontend/src/api/modules/alliance-partners.ts","frontend/src/api/modules/community-bots.ts","frontend/src/api/modules/community-fission.ts","frontend/src/api/modules/community-materials.ts","frontend/src/api/modules/community-tasks.ts","frontend/src/api/modules/content-analytics.ts","frontend/src/api/modules/groupbuy-commissions.ts","frontend/src/api/modules/groupbuy-influencers.ts","frontend/src/api/modules/groupbuy-inventory.ts","frontend/src/api/modules/groupbuy-platforms.ts","frontend/src/api/modules/groupbuy-promotions.ts","frontend/src/api/modules/groupbuy-redemptions.ts","frontend/src/api/modules/groupbuy-reviews.ts","frontend/src/api/modules/livestream-gifts.ts","frontend/src/api/modules/social-analytics.ts"],"removed":[],"modified":[]},{"id":"5c0e2a9ccc614bb1dac8ed3875f4eeddb1bed80d","message":"feat: 完善 modules.ts 模块元数据定义，覆盖全部142个已部署模块\n\n主要变更：\n1. 新增 ModuleCategory 类型：\n   - hr (人力资源域)\n   - marketing-customer (营销客户维度)\n   - ktv-content, ktv-social, ktv-geo, ktv-adflow, ktv-livestream, ktv-alliance, ktv-community, ktv-groupbuy (KTV智慧营销域)\n\n2. 补充缺失的模块定义：\n   - 营销客户维度：campaign-targets, segments, customer-marketing\n   - 系统核心模块：auth, scheduled-jobs, event-logs, event-subscriptions, realtime, ai-copilot\n   - 服务域：service, service-monitor\n   - 履约域：maintenance, workflow-generator\n   - 财务域：customer-profit\n   - HR域：hr\n\n3. 新增KTV智慧营销域模块（未来规划）：\n   - 内容管理、社交媒体、GEO优化、投流管理、直播运营、商家联盟、社群运营、团购运营等34个模块\n\n4. 清理重复模块定义：\n   - 删除 users, roles, departments, notifications, files, events, approvals, analytics, dashboard, reports, im 的重复定义\n\n模块统计：\n- 已部署模块：142个（全部覆盖）\n- 总定义模块：176个（含34个未来规划模块）\n\n严格遵循8条开发红线\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/5c0e2a9ccc614bb1dac8ed3875f4eeddb1bed80d","author":{"name":"Claude","email":"noreply@anthropic.com","username":""},"committer":{"name":"Claude","email":"noreply@anthropic.com","username":""},"verification":null,"timestamp":"2026-01-11T06:14:38Z","added":[],"removed":[],"modified":["backend/src/shared/constants/modules.ts"]},{"id":"b7ed9e35d5ce2b9182dd507c95aa9c675335c3b3","message":"feat: 营销模块客户/门店维度增强 - 活动定向、客户分群、营销分析\n\n核心功能：\n- 新增4个数据库表：campaign_targets、audience_segments、segment_members、campaign_performance\n- 新增3个后端模块：campaign-targets（活动定向）、segments（客户分群）、customer-marketing（营销分析）\n- 新增3个前端API模块，包含完整类型定义和工具函数\n- 新增18个权限配置，归入营销客户维度分组\n\n技术亮点：\n- 分群状态机：draft → active → paused → archived\n- 营销衍生指标：CTR、CVR、ROI、CPA、ROAS 自动计算\n- 多维度分析：客户、门店、活动、分群四个维度\n- 严格遵循8条开发红线\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/b7ed9e35d5ce2b9182dd507c95aa9c675335c3b3","author":{"name":"Claude","email":"noreply@anthropic.com","username":""},"committer":{"name":"Claude","email":"noreply@anthropic.com","username":""},"verification":null,"timestamp":"2026-01-11T06:00:53Z","added":["backend/src/modules/campaign-targets/index.ts","backend/src/modules/customer-marketing/index.ts","backend/src/modules/segments/index.ts","frontend/src/api/modules/campaign-targets.ts","frontend/src/api/modules/customer-marketing.ts","frontend/src/api/modules/segments.ts"],"removed":[],"modified":["backend/prisma/schema.prisma","backend/src/main.ts","backend/src/shared/constants/permissions.ts"]},{"id":"fb6039939f7601cf35179127a6b8205e787342aa","message":"feat: 完善社交账号、广告人群、广告报表等6个核心模块，严格遵循8条开发红线\n\n完善模块：\n- social-accounts: 8平台账号授权、数据同步、指标追踪、健康度评估\n- social-interactions: 6种互动类型、4种状态、情感分析、自动回复\n- livestream-analytics: 10+分析维度、房间/商品/主播/话术效果分析\n- livestream-scripts: 7种话术类型、6种场景、AI生成优化、结构化模板\n- ad-audiences: 6种人群类型、6种数据源、相似人群、规则验证\n- ad-reports: 8种报表API、10种指标计算、预算预警、效果建议\n\n特性：\n- 状态机驱动：所有状态变更通过POST动作接口\n- 类型安全：禁用any，完整类型定义与后端严格匹配\n- 四层架构：智库层/数链层/SOP层/IM层交互文档\n- 工具函数：格式化、验证、健康度计算、图表数据生成\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/fb6039939f7601cf35179127a6b8205e787342aa","author":{"name":"Claude","email":"noreply@anthropic.com","username":""},"committer":{"name":"Claude","email":"noreply@anthropic.com","username":""},"verification":null,"timestamp":"2026-01-11T05:02:28Z","added":[],"removed":[],"modified":["frontend/src/api/modules/ad-audiences.ts","frontend/src/api/modules/ad-reports.ts","frontend/src/api/modules/livestream-analytics.ts","frontend/src/api/modules/livestream-scripts.ts","frontend/src/api/modules/social-accounts.ts","frontend/src/api/modules/social-interactions.ts"]}],"total_commits":0,"head_commit":{"id":"89209aba1afe21133399ce0db0a47c2729c9a4b4","message":"feat: 新增门店管理模块，补充门店维度营销分析端点\n\n一、门店管理模块 (stores)\n- 门店 CRUD：创建、更新、删除、状态管理\n- 门店类型：旗舰店、标准店、加盟店、合作店、迷你店、快闪店\n- 状态机：pending → active → suspended/renovating → closed\n\n二、门店维度营销分析端点\n- GET /stores/:id/marketing-analytics - 门店营销分析（活动、直播、团购、订单汇总）\n- GET /stores/:id/roi-analytics - 门店 ROI 分析（投入产出比、渠道分解、同比环比）\n- GET /stores/:id/livestream-stats - 门店直播统计（场次、时长、观众、GMV）\n- GET /stores/:id/campaigns - 门店活动列表\n\n三、门店对比和排行\n- POST /stores/compare - 多门店横向对比\n- GET /stores/ranking - 门店排行榜（营收、订单、评分、直播GMV）\n\n四、门店营销配置\n- PATCH /stores/:id/marketing-config - 团购/直播/促销开关、平台配置、预算设置\n\n五、前端 API 模块\n- stores.ts：完整类型定义 + API 封装 + 状态配置 + 工具函数\n\n严格遵循8条开发红线\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/89209aba1afe21133399ce0db0a47c2729c9a4b4","author":{"name":"Claude","email":"noreply@anthropic.com","username":""},"committer":{"name":"Claude","email":"noreply@anthropic.com","username":""},"verification":null,"timestamp":"2026-01-11T07:36:12Z","added":["backend/src/modules/stores/index.ts","backend/src/modules/stores/store.controller.ts","backend/src/modules/stores/store.routes.ts","backend/src/modules/stores/store.schema.ts","backend/src/modules/stores/store.service.ts","frontend/src/api/modules/stores.ts"],"removed":[],"modified":["backend/src/shared/constants/modules.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":9503,"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-23T23:59:28+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 43 in action_run