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 49453 from action
id
49453
user_id
5
op_type
5
act_user_id
5
repo_id
181
comment_id
0
is_deleted
0
ref_name
refs/heads/main
is_private
1
content
{"Commits":[{"Sha1":"ffa711d09
{"Commits":[{"Sha1":"ffa711d098acde40ac47760ebb5bb0dabbb8daf3","Message":"docs(subtitle-alignment): 服务端存音频在干净提交 1cc2b69 上的真实库验收证据(504 / 0,14 份迁移)\n\nCo-Authored-By: Claude Fable 5.2 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"hillao@juhailaoluodeMacBook-Pro.local","AuthorName":"juhailaoluo pro","CommitterEmail":"hillao@juhailaoluodeMacBook-Pro.local","CommitterName":"juhailaoluo pro","Timestamp":"2026-11-13T19:40:13-08:00"},{"Sha1":"1cc2b69517c3734261b9d872c94eff2fff3b47b6","Message":"feat(subtitle-alignment): 服务端存音频——每张工单一份,选文件后上传、别人打开自动取回;指纹不一致经确认可存\n\n用户答复「服务端存音频,保留页面限制」(PRD DEP09 的存储位置由此定)。\n\n- 两张表:work_order_audios(说明)与 work_order_audio_chunks(内容,1 MiB 一块),FORCE RLS,\n 租户角色只有读、插入、删除;迁移 20261113230000。\n- 接口:PUT / GET work-orders/:id/audio(原始字节,上限 100 MiB)与 GET …/audio/meta;\n 动作键 work_order.upload_audio,事件 work_order.audio_stored;每次存都留流转记录,与内容同一事务。\n- 规则(契约 assertAudioStorable):没存过任何状态可存,存过只在待对齐可换;\n 指纹与登记不一致时要上传方明确确认,确认后存入并单独记原因、留下上传方算出的指纹。\n- 页面:登记时选的文件自动上传;音频一行显示服务端状态;取音频的顺序是内存、浏览器、服务端;\n 指纹不一致的文件要再确认一次才上传。没有音频不能播放、下结论、签字的页面限制保留。\n- 原始字节只对存音频这一条路由开放,其余路由仍回 415。\n- 文档:对象归属登记、蓝图 §21、PRD DEP09 与第 19 节、README、派生回执、后端标准;\n 平台登记的 excludedActions 与应用清单已同步。\n\n存在数据库里而不是对象存储;没有删除入口(保留期限待 PRD D19);读取未单独授权。\n\nCo-Authored-By: Claude Fable 5.2 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"hillao@juhailaoluodeMacBook-Pro.local","AuthorName":"juhailaoluo pro","CommitterEmail":"hillao@juhailaoluodeMacBook-Pro.local","CommitterName":"juhailaoluo pro","Timestamp":"2026-11-13T19:39:01-08:00"}],"HeadCommit":{"Sha1":"ffa711d098acde40ac47760ebb5bb0dabbb8daf3","Message":"docs(subtitle-alignment): 服务端存音频在干净提交 1cc2b69 上的真实库验收证据(504 / 0,14 份迁移)\n\nCo-Authored-By: Claude Fable 5.2 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"hillao@juhailaoluodeMacBook-Pro.local","AuthorName":"juhailaoluo pro","CommitterEmail":"hillao@juhailaoluodeMacBook-Pro.local","CommitterName":"juhailaoluo pro","Timestamp":"2026-11-13T19:40:13-08:00"},"CompareURL":"luoanwu/juhai-karaoke-subtitle-alignment/compare/93f486b3b4daf4e87002281fae8f8c7f2d0ff6b4...ffa711d098acde40ac47760ebb5bb0dabbb8daf3","Len":2}
...
created_unix
1794627630
Delete
Cancel