sqlite-web 0.7.2
gitea.db
action
Create
Query
access
access_token
action
action_artifact
action_run
action_run_index
action_run_job
action_runner
action_runner_token
action_schedule
action_schedule_spec
action_task
action_task_output
action_task_step
action_tasks_version
action_variable
app_state
attachment
auth_token
badge
branch
collaboration
comment
commit_status
commit_status_index
commit_status_summary
commit_sync_log
commit_sync_status
dbfs_data
dbfs_meta
deploy_key
email_address
email_hash
external_login_user
follow
gpg_key
gpg_key_import
hook_task
issue
issue_assignees
issue_content_history
issue_dependency
issue_index
issue_label
issue_pin
issue_user
issue_watch
label
language_stat
lfs_lock
lfs_meta_object
login_source
milestone
mirror
notice
notification
oauth2_application
oauth2_authorization_code
oauth2_grant
org_user
package
package_blob
package_blob_upload
package_cleanup_rule
package_file
package_property
package_version
project
project_board
project_issue
protected_branch
protected_tag
public_key
pull_auto_merge
pull_request
push_mirror
reaction
release
renamed_branch
repo_archiver
repo_hidden_file
repo_indexer_status
repo_license
repo_redirect
repo_topic
repo_transfer
repo_unit
repository
review
review_state
secret
session
sqlite_sequence
star
stopwatch
system_setting
task
team
team_invite
team_repo
team_unit
team_user
topic
tracked_time
two_factor
upload
user
user_badge
user_blocking
user_open_id
user_redirect
user_setting
version
watch
webauthn_credential
webhook
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Delete row 17110 from action
id
17110
user_id
5
op_type
5
act_user_id
5
repo_id
6
comment_id
0
is_deleted
0
ref_name
refs/heads/react-migration
is_private
0
content
{"Commits":[{"Sha1":"e005063b4
{"Commits":[{"Sha1":"e005063b444466a70a8b0bc6b257ee2097fac9cb","Message":"fix(field-contract): P2 第五批十五条全量收口——SLA/门店/获客三域整链 + 微修线\n\n三域并行修复（每条裁定附 prisma schema 列证据，范式：有真源后端真算、无真源失败关闭）：\n\nSLA 整链（服务#2/#3）：\n- getDashboardStats 重写为前端嵌套契约：current{running/atRisk/breaching}、last30Days\n 响应/解决达标率（诚实分母：未到期 pending 不计入不造数）、breachedByPriority、\n dailyTrend 近 7 日；保留旧扁平键兼容。live 实锤 running=306、解决达标率 22.7%\n- getComplianceReport 由时钟数组改报告对象（overall/byPriority/byType/daily 逐日骨架），\n 真消费 dateFrom/dateTo（此前完全忽略）；API 测试断言同步归真（旧断言锁定断链形状）\n\n门店域（门店#1-6）：\n- groupbuy-platforms：全局统计/平台列表真算（accounts 计数、settled_amount 合计、\n byPlatform 分桶、authorizedPlatforms 接 auth_status 真列）；店铺硬编码死指标\n （syncStatus/productCount/rating）删除；营收量纲修正（误按分除 100 → 元）；\n totalOrders 全仓无 writer 全线失败关闭；同步任务无持久化表 → tab/API/类型下线\n- livestream-groupbuy-conversion：实时卡 redemptions（conversion_tracks stage='redeemed'）\n 与 avgWatchDuration（viewer_tracks.watch_duration 有列有写链，纠正分诊「无列」误判）\n 真算；peakViewers 死零列失败关闭；关联表补 schedule 名称等 7 个物理列真源，\n 假时间戳/假 status 兜底删除；创建表单想象字段（商品 ID/置顶）删除\n\n获客域（获客#1/#2/#5）：\n- campaigns getDashboardData 扩展 12 键真算（byStatus/byChannel/byBusinessLine groupBy、\n 预算花费聚合、executingCampaigns、recentLeadsCount、dailyTrend 7 日桶）；live 实锤\n totalBudget=134.3 万、recentLeadsCount=31\n- channel-comparison 补 campaigns 计数与 avgRoi（cost=0 失败关闭）；impressions/clicks\n 无真源从前端契约删除\n- campaign-targets 无 Prisma 关系 → 二次查询拼装活动摘要（查不到 null 禁止伪造）；\n currentValue 无列 → 进度列失败关闭 '-'；abm 触点/评分 metadata 无写链 → nullable\n\n微修线（7 条）：\n- 门店系 page 回退 typo ×4（page ?? page_size 误回退，pageSize=50 会跳空页）\n- contracts 排序 order 别名（拦截器映射键此前被 Zod 剥离，升序静默回落 desc）\n- invoices「开票人」死字段三处删除（表无 issued_by 列，条件恒 false）\n- leads 保护期真实现（protect_until 真列 + 分配链真实写入；「保护期管理」由硬编码\n 空 stub 改真查询）；分配历史 protectUntil 假时间戳改读 leads 真值\n- tickets assign/escalate 补 crm_activities 操作日志 writer（activity_type 直映\n timeline type，「指派记录」「升级记录」两个恒空 Tab 从此有真源）\n- cash-flow payment-behaviors 孤儿 schema 删除（零引用死文件）\n- batch8 测试存量断言缺陷补 auth mock（Permission 包裹按钮自 wire 提交起未 mock）\n\n证据：双端类型检查干净；后端单测 640 文件/8803 全绿（三域新增/强化单测：SLA 4 条、\nplatforms/livestream 聚合断言、campaigns dashboard/channel/targets 拼装断言，含\nnot.toHaveProperty 防伪造键回潮守卫）；SLA API 真打 DB 12/12；前端相关域 RTL 全绿\n（含失败关闭断言与 createLink payload 精确匹配防想象字段回潮）；live curl 六端点\n真值/失败关闭行为实锤。分诊台账 P2 段全部标记收口，余 4 项无消费者观察 INFO 备案。\n\nCo-Authored-By: Claude Fable 5 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"luoguoguo@gmail.com","AuthorName":"luoguoguo","CommitterEmail":"luoguoguo@gmail.com","CommitterName":"luoguoguo","Timestamp":"2026-07-12T08:08:16-07:00"}],"HeadCommit":{"Sha1":"e005063b444466a70a8b0bc6b257ee2097fac9cb","Message":"fix(field-contract): P2 第五批十五条全量收口——SLA/门店/获客三域整链 + 微修线\n\n三域并行修复（每条裁定附 prisma schema 列证据，范式：有真源后端真算、无真源失败关闭）：\n\nSLA 整链（服务#2/#3）：\n- getDashboardStats 重写为前端嵌套契约：current{running/atRisk/breaching}、last30Days\n 响应/解决达标率（诚实分母：未到期 pending 不计入不造数）、breachedByPriority、\n dailyTrend 近 7 日；保留旧扁平键兼容。live 实锤 running=306、解决达标率 22.7%\n- getComplianceReport 由时钟数组改报告对象（overall/byPriority/byType/daily 逐日骨架），\n 真消费 dateFrom/dateTo（此前完全忽略）；API 测试断言同步归真（旧断言锁定断链形状）\n\n门店域（门店#1-6）：\n- groupbuy-platforms：全局统计/平台列表真算（accounts 计数、settled_amount 合计、\n byPlatform 分桶、authorizedPlatforms 接 auth_status 真列）；店铺硬编码死指标\n （syncStatus/productCount/rating）删除；营收量纲修正（误按分除 100 → 元）；\n totalOrders 全仓无 writer 全线失败关闭；同步任务无持久化表 → tab/API/类型下线\n- livestream-groupbuy-conversion：实时卡 redemptions（conversion_tracks stage='redeemed'）\n 与 avgWatchDuration（viewer_tracks.watch_duration 有列有写链，纠正分诊「无列」误判）\n 真算；peakViewers 死零列失败关闭；关联表补 schedule 名称等 7 个物理列真源，\n 假时间戳/假 status 兜底删除；创建表单想象字段（商品 ID/置顶）删除\n\n获客域（获客#1/#2/#5）：\n- campaigns getDashboardData 扩展 12 键真算（byStatus/byChannel/byBusinessLine groupBy、\n 预算花费聚合、executingCampaigns、recentLeadsCount、dailyTrend 7 日桶）；live 实锤\n totalBudget=134.3 万、recentLeadsCount=31\n- channel-comparison 补 campaigns 计数与 avgRoi（cost=0 失败关闭）；impressions/clicks\n 无真源从前端契约删除\n- campaign-targets 无 Prisma 关系 → 二次查询拼装活动摘要（查不到 null 禁止伪造）；\n currentValue 无列 → 进度列失败关闭 '-'；abm 触点/评分 metadata 无写链 → nullable\n\n微修线（7 条）：\n- 门店系 page 回退 typo ×4（page ?? page_size 误回退，pageSize=50 会跳空页）\n- contracts 排序 order 别名（拦截器映射键此前被 Zod 剥离，升序静默回落 desc）\n- invoices「开票人」死字段三处删除（表无 issued_by 列，条件恒 false）\n- leads 保护期真实现（protect_until 真列 + 分配链真实写入；「保护期管理」由硬编码\n 空 stub 改真查询）；分配历史 protectUntil 假时间戳改读 leads 真值\n- tickets assign/escalate 补 crm_activities 操作日志 writer（activity_type 直映\n timeline type，「指派记录」「升级记录」两个恒空 Tab 从此有真源）\n- cash-flow payment-behaviors 孤儿 schema 删除（零引用死文件）\n- batch8 测试存量断言缺陷补 auth mock（Permission 包裹按钮自 wire 提交起未 mock）\n\n证据：双端类型检查干净；后端单测 640 文件/8803 全绿（三域新增/强化单测：SLA 4 条、\nplatforms/livestream 聚合断言、campaigns dashboard/channel/targets 拼装断言，含\nnot.toHaveProperty 防伪造键回潮守卫）；SLA API 真打 DB 12/12；前端相关域 RTL 全绿\n（含失败关闭断言与 createLink payload 精确匹配防想象字段回潮）；live curl 六端点\n真值/失败关闭行为实锤。分诊台账 P2 段全部标记收口，余 4 项无消费者观察 INFO 备案。\n\nCo-Authored-By: Claude Fable 5 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"luoguoguo@gmail.com","AuthorName":"luoguoguo","CommitterEmail":"luoguoguo@gmail.com","CommitterName":"luoguoguo","Timestamp":"2026-07-12T08:08:16-07:00"},"CompareURL":"luoanwu/juhi-omni-knowledge-hub/compare/5ae992ef927153e78f5d698e12079bcd3c022f39...e005063b444466a70a8b0bc6b257ee2097fac9cb","Len":1}
...
created_unix
1783868903
Delete
Cancel