sqlite-web 0.7.2
gitea.db
action_run
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
Update row 13612 in action_run
id
Primary key.
INTEGER NOT NULL
title
feat: 更新项目配置和脚本
TEXT
repo_id
INTEGER
owner_id
INTEGER
workflow_id
health-check.yml
TEXT
index
INTEGER
trigger_user_id
INTEGER
schedule_id
INTEGER
ref
refs/heads/main
TEXT
commit_sha
2e3188c85a6cfc38ac7d3643b1cbbfc2e3e850d0
TEXT
is_fork_pull_request
INTEGER
need_approval
INTEGER
approved_by
INTEGER
event
push
TEXT
event_payload
{"ref":"refs/heads/main","before":"9d69e1960ec649a49c0c6f307c0fc197f47ee4c4","after":"2e3188c85a6cfc38ac7d3643b1cbbfc2e3e850d0","compare_url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/compare/9d69e1960ec649a49c0c6f307c0fc197f47ee4c4...2e3188c85a6cfc38ac7d3643b1cbbfc2e3e850d0","commits":[{"id":"2e3188c85a6cfc38ac7d3643b1cbbfc2e3e850d0","message":"feat: 更新项目配置和脚本\n\nCo-authored-by: Qwen-Coder \u003cqwen-coder@alibabacloud.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/2e3188c85a6cfc38ac7d3643b1cbbfc2e3e850d0","author":{"name":"Mluo","email":"mluo@MluodeMacBook-Air.local","username":""},"committer":{"name":"Mluo","email":"mluo@MluodeMacBook-Air.local","username":""},"verification":null,"timestamp":"2026-04-12T21:30:41+08:00","added":[],"removed":[],"modified":["backend/Dockerfile","docker-compose.prod.yml","docker-compose.yml","e2e/.auth/admin.json","e2e/test-results/create-verify-all-report.json","frontend/Dockerfile","frontend/package.json","frontend/vite.config.ts","scripts/post-deploy-verify.sh","scripts/restart-dev.sh","scripts/start-all.sh"]},{"id":"83f8b781d7305c9badf23edd7d8523a626a5a18c","message":"Improve governance guidance and audit coverage\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/83f8b781d7305c9badf23edd7d8523a626a5a18c","author":{"name":"Mluo","email":"mluo@MluodeMacBook-Air.local","username":""},"committer":{"name":"Mluo","email":"mluo@MluodeMacBook-Air.local","username":""},"verification":null,"timestamp":"2026-04-12T12:31:56+08:00","added":["backend/scripts/generate-phantom-modules.ts","backend/src/modules/abm-marketing/abm-marketing.controller.ts","backend/src/modules/abm-marketing/abm-marketing.docs.ts","backend/src/modules/abm-marketing/abm-marketing.routes.ts","backend/src/modules/abm-marketing/abm-marketing.schema.ts","backend/src/modules/abm-marketing/abm-marketing.service.ts","backend/src/modules/ad-analytics/ad-analytics.controller.ts","backend/src/modules/ad-analytics/ad-analytics.docs.ts","backend/src/modules/ad-analytics/ad-analytics.routes.ts","backend/src/modules/ad-analytics/ad-analytics.schema.ts","backend/src/modules/ad-analytics/ad-analytics.service.ts","backend/src/modules/attribution-models/attribution-models.controller.ts","backend/src/modules/attribution-models/attribution-models.docs.ts","backend/src/modules/attribution-models/attribution-models.routes.ts","backend/src/modules/attribution-models/attribution-models.schema.ts","backend/src/modules/attribution-models/attribution-models.service.ts","backend/src/modules/attribution-reports/attribution-reports.controller.ts","backend/src/modules/attribution-reports/attribution-reports.docs.ts","backend/src/modules/attribution-reports/attribution-reports.routes.ts","backend/src/modules/attribution-reports/attribution-reports.schema.ts","backend/src/modules/attribution-reports/attribution-reports.service.ts","backend/src/modules/channel-integrations/channel-integrations.controller.ts","backend/src/modules/channel-integrations/channel-integrations.docs.ts","backend/src/modules/channel-integrations/channel-integrations.routes.ts","backend/src/modules/channel-integrations/channel-integrations.schema.ts","backend/src/modules/channel-integrations/channel-integrations.service.ts","backend/src/modules/customer-segmentation/customer-segmentation.controller.ts","backend/src/modules/customer-segmentation/customer-segmentation.docs.ts","backend/src/modules/customer-segmentation/customer-segmentation.routes.ts","backend/src/modules/customer-segmentation/customer-segmentation.schema.ts","backend/src/modules/customer-segmentation/customer-segmentation.service.ts","backend/src/modules/lead-assignment/lead-assignment.controller.ts","backend/src/modules/lead-assignment/lead-assignment.docs.ts","backend/src/modules/lead-assignment/lead-assignment.routes.ts","backend/src/modules/lead-assignment/lead-assignment.schema.ts","backend/src/modules/lead-assignment/lead-assignment.service.ts","backend/src/modules/lead-scoring/lead-scoring.controller.ts","backend/src/modules/lead-scoring/lead-scoring.docs.ts","backend/src/modules/lead-scoring/lead-scoring.routes.ts","backend/src/modules/lead-scoring/lead-scoring.schema.ts","backend/src/modules/lead-scoring/lead-scoring.service.ts","backend/src/modules/local-events/local-events.controller.ts","backend/src/modules/local-events/local-events.docs.ts","backend/src/modules/local-events/local-events.routes.ts","backend/src/modules/local-events/local-events.schema.ts","backend/src/modules/local-events/local-events.service.ts","backend/src/modules/local-promotion/local-promotion.controller.ts","backend/src/modules/local-promotion/local-promotion.docs.ts","backend/src/modules/local-promotion/local-promotion.routes.ts","backend/src/modules/local-promotion/local-promotion.schema.ts","backend/src/modules/local-promotion/local-promotion.service.ts","backend/src/modules/member-benefits/member-benefits.controller.ts","backend/src/modules/member-benefits/member-benefits.docs.ts","backend/src/modules/member-benefits/member-benefits.routes.ts","backend/src/modules/member-benefits/member-benefits.schema.ts","backend/src/modules/member-benefits/member-benefits.service.ts","backend/src/modules/member-levels/member-levels.controller.ts","backend/src/modules/member-levels/member-levels.docs.ts","backend/src/modules/member-levels/member-levels.routes.ts","backend/src/modules/member-levels/member-levels.schema.ts","backend/src/modules/member-levels/member-levels.service.ts","backend/src/modules/member-points/member-points.controller.ts","backend/src/modules/member-points/member-points.docs.ts","backend/src/modules/member-points/member-points.routes.ts","backend/src/modules/member-points/member-points.schema.ts","backend/src/modules/member-points/member-points.service.ts","backend/src/modules/members/members.controller.ts","backend/src/modules/members/members.docs.ts","backend/src/modules/members/members.routes.ts","backend/src/modules/members/members.schema.ts","backend/src/modules/members/members.service.ts","backend/src/modules/notification-configs/notification-configs.controller.ts","backend/src/modules/notification-configs/notification-configs.docs.ts","backend/src/modules/notification-configs/notification-configs.routes.ts","backend/src/modules/notification-configs/notification-configs.schema.ts","backend/src/modules/notification-configs/notification-configs.service.ts","backend/src/modules/product-categories/product-categories.controller.ts","backend/src/modules/product-categories/product-categories.docs.ts","backend/src/modules/product-categories/product-categories.routes.ts","backend/src/modules/product-categories/product-categories.schema.ts","backend/src/modules/product-categories/product-categories.service.ts","backend/src/modules/qr-codes/qr-codes.controller.ts","backend/src/modules/qr-codes/qr-codes.docs.ts","backend/src/modules/qr-codes/qr-codes.routes.ts","backend/src/modules/qr-codes/qr-codes.schema.ts","backend/src/modules/qr-codes/qr-codes.service.ts","backend/src/modules/social-matrix/social-matrix.controller.ts","backend/src/modules/social-matrix/social-matrix.docs.ts","backend/src/modules/social-matrix/social-matrix.routes.ts","backend/src/modules/social-matrix/social-matrix.schema.ts","backend/src/modules/social-matrix/social-matrix.service.ts","backend/src/modules/store-configs/store-configs.controller.ts","backend/src/modules/store-configs/store-configs.docs.ts","backend/src/modules/store-configs/store-configs.routes.ts","backend/src/modules/store-configs/store-configs.schema.ts","backend/src/modules/store-configs/store-configs.service.ts","backend/src/modules/supplier-center/supplier-center.controller.ts","backend/src/modules/supplier-center/supplier-center.docs.ts","backend/src/modules/supplier-center/supplier-center.routes.ts","backend/src/modules/supplier-center/supplier-center.schema.ts","backend/src/modules/supplier-center/supplier-center.service.ts","backend/src/modules/utm-tracking/utm-tracking.controller.ts","backend/src/modules/utm-tracking/utm-tracking.docs.ts","backend/src/modules/utm-tracking/utm-tracking.routes.ts","backend/src/modules/utm-tracking/utm-tracking.schema.ts","backend/src/modules/utm-tracking/utm-tracking.service.ts","backend/src/modules/video-analytics/video-analytics.controller.ts","backend/src/modules/video-analytics/video-analytics.docs.ts","backend/src/modules/video-analytics/video-analytics.routes.ts","backend/src/modules/video-analytics/video-analytics.schema.ts","backend/src/modules/video-analytics/video-analytics.service.ts","backend/src/modules/video-content/video-content.controller.ts","backend/src/modules/video-content/video-content.docs.ts","backend/src/modules/video-content/video-content.routes.ts","backend/src/modules/video-content/video-content.schema.ts","backend/src/modules/video-content/video-content.service.ts","backend/src/modules/video-publishing/video-publishing.controller.ts","backend/src/modules/video-publishing/video-publishing.docs.ts","backend/src/modules/video-publishing/video-publishing.routes.ts","backend/src/modules/video-publishing/video-publishing.schema.ts","backend/src/modules/video-publishing/video-publishing.service.ts","backend/src/modules/workflow-designer/workflow-designer.controller.ts","backend/src/modules/workflow-designer/workflow-designer.docs.ts","backend/src/modules/workflow-designer/workflow-designer.routes.ts","backend/src/modules/workflow-designer/workflow-designer.schema.ts","backend/src/modules/workflow-designer/workflow-designer.service.ts"],"removed":[],"modified":["backend/prisma/schema/customers.prisma","backend/prisma/schema/marketing.prisma","backend/prisma/schema/stores.prisma","backend/prisma/schema/system.prisma","backend/prisma/schema/workflow.prisma","backend/src/modules/groupbuy-pricing/groupbuy-pricing.service.ts","backend/src/modules/lead-scoring-ai/lead-scoring-ai.service.ts","backend/src/modules/marketing-chatbot/marketing-chatbot.service.ts","backend/src/modules/sample-requests/sample-request.service.ts","backend/src/modules/sms-marketing/sms-marketing.service.ts","backend/src/modules/tickets/ticket.service.ts","backend/src/routes/register-domain-routes.ts","e2e/.auth/admin.json","e2e/helpers/create-payloads.ts","e2e/test-results/create-verify-all-report.json","e2e/tests/create-forms/create-verify-all.spec.ts","scripts/acceptance/api_acceptance.mjs","scripts/e2e-health-check.sh","scripts/harness/module-manifests.json","scripts/healthcheck.sh","scripts/post-deploy-verify.sh","scripts/pre-deploy-check.sh","scripts/status.sh"]},{"id":"5d02d3ff4d71ee63ba8c3bd03fe70b152daa2c33","message":"Refactor governance baselines and remove obsolete module code\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/5d02d3ff4d71ee63ba8c3bd03fe70b152daa2c33","author":{"name":"Mluo","email":"mluo@MluodeMacBook-Air.local","username":""},"committer":{"name":"Mluo","email":"mluo@MluodeMacBook-Air.local","username":""},"verification":null,"timestamp":"2026-04-11T17:16:05+08:00","added":["e2e/helpers/create-catalog.ts","e2e/playwright-report/data/1c59ef9c594dee5d50479214a3d23db8b2206c59.png","e2e/playwright-report/data/80392828a7bc35bcb324bde0306238e4448f4c7f.md","e2e/test-results/.last-run.json","e2e/test-results/create-verify-all-report.json","e2e/tests/create-forms/create-verify-all.spec.ts","shared/create-route-catalog.ts"],"removed":["e2e/playwright-report/data/25cbc99c63faba33dad311c373b5dc24591abec3.png","e2e/playwright-report/data/b8fdc6a93eb8f0836725688053076f4ff601006f.md","e2e/test-results/create-ui-all-report.json"],"modified":["backend/src/modules/rma/rma.service.ts","e2e/.auth/admin.json","e2e/helpers/create-payloads.ts","e2e/playwright-report/index.html","e2e/tests/create-forms/create-all.spec.ts","e2e/tests/create-forms/create-ui-all.spec.ts","e2e/tests/create-forms/create-ui-fill-submit.spec.ts","frontend/src/api/modules/alliance-referrals.ts","frontend/src/api/modules/approval-templates.ts","frontend/src/router/__tests__/create-route-catalog.test.ts","frontend/src/views/ai-agents/skill-library/Form.vue","frontend/src/views/alliance-referrals/Form.vue","frontend/src/views/alliance-referrals/Index.vue","frontend/src/views/approval-configs/Form.vue","frontend/src/views/approval-templates/Form.vue","frontend/src/views/assets/Form.vue","reports/enum-consistency-audit.latest.json","reports/field-payload-audit.latest.json","reports/formrules-zod-audit.latest.json","reports/response-columns-audit.latest.json","reports/type-debt-audit.latest.json"]},{"id":"1b6a3f7493a79f95a2db09aff9c57350ae135c1b","message":"Harden create form coverage and fix broken create flows\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/1b6a3f7493a79f95a2db09aff9c57350ae135c1b","author":{"name":"Mluo","email":"mluo@MluodeMacBook-Air.local","username":""},"committer":{"name":"Mluo","email":"mluo@MluodeMacBook-Air.local","username":""},"verification":null,"timestamp":"2026-04-11T13:18:09+08:00","added":["e2e/playwright-report/data/25cbc99c63faba33dad311c373b5dc24591abec3.png","e2e/playwright-report/data/b8fdc6a93eb8f0836725688053076f4ff601006f.md","e2e/test-results/create-ui-all-report.json","e2e/tests/create-forms/create-ui-fill-submit.spec.ts","frontend/src/router/__tests__/create-route-catalog.test.ts"],"removed":[],"modified":["e2e/.auth/admin.json","e2e/package.json","e2e/playwright-report/index.html","e2e/tests/create-forms/create-ui-all.spec.ts","frontend/src/api/modules/ad-reports.ts","frontend/src/api/modules/alliance-referrals.ts","frontend/src/api/modules/approval-templates.ts","frontend/src/views/ad-creatives/Form.vue","frontend/src/views/ad-reports/Form.vue","frontend/src/views/ai-agents/skill-library/Form.vue","frontend/src/views/alliance-campaigns/Form.vue","frontend/src/views/alliance-coupons/Form.vue","frontend/src/views/alliance-packages/Form.vue","frontend/src/views/alliance-products/Form.vue","frontend/src/views/alliance-referrals/Form.vue","frontend/src/views/approval-templates/Form.vue","frontend/src/views/assets/Form.vue"]},{"id":"e224c0ecaa34df97ef5acd412d614a7362bfa6c3","message":"Harden harness reporting and add regression tests\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/e224c0ecaa34df97ef5acd412d614a7362bfa6c3","author":{"name":"Mluo","email":"mluo@MluodeMacBook-Air.local","username":""},"committer":{"name":"Mluo","email":"mluo@MluodeMacBook-Air.local","username":""},"verification":null,"timestamp":"2026-04-11T08:45:25+08:00","added":["e2e/tests/create-forms/create-ui-all.spec.ts","scripts/harness/finding-id.ts","scripts/harness/report.test.ts"],"removed":["e2e/test-results/.last-run.json","e2e/test-results/create-all-report.json"],"modified":["e2e/.auth/admin.json","e2e/helpers/create-payloads.ts","e2e/playwright-report/index.html","e2e/tests/create-forms/create-all.spec.ts","package.json","reports/enum-consistency-audit.latest.json","reports/field-payload-audit.latest.json","reports/formrules-zod-audit.latest.json","reports/response-columns-audit.latest.json","reports/type-debt-audit.latest.json","scripts/harness/cli.ts","scripts/harness/doctor.ts","scripts/harness/fix.ts","scripts/harness/orchestrator.ts","scripts/harness/reflect.ts","scripts/harness/report.ts","scripts/harness/types.ts"]}],"total_commits":0,"head_commit":{"id":"2e3188c85a6cfc38ac7d3643b1cbbfc2e3e850d0","message":"feat: 更新项目配置和脚本\n\nCo-authored-by: Qwen-Coder \u003cqwen-coder@alibabacloud.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/2e3188c85a6cfc38ac7d3643b1cbbfc2e3e850d0","author":{"name":"Mluo","email":"mluo@MluodeMacBook-Air.local","username":""},"committer":{"name":"Mluo","email":"mluo@MluodeMacBook-Air.local","username":""},"verification":null,"timestamp":"2026-04-12T21:30:41+08:00","added":[],"removed":[],"modified":["backend/Dockerfile","docker-compose.prod.yml","docker-compose.yml","e2e/.auth/admin.json","e2e/test-results/create-verify-all-report.json","frontend/Dockerfile","frontend/package.json","frontend/vite.config.ts","scripts/post-deploy-verify.sh","scripts/restart-dev.sh","scripts/start-all.sh"]},"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/avatar/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":false,"fork":false,"template":false,"mirror":false,"size":5204609,"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,"branch_count":4,"open_issues_count":0,"open_pr_counter":1,"release_counter":0,"default_branch":"main","archived":false,"created_at":"2026-02-23T23:57:52+08:00","updated_at":"2026-04-03T10:01:27+08:00","archived_at":"1970-01-01T08:00:00+08:00","permissions":{"admin":true,"push":true,"pull":true},"has_code":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,"allow_manual_merge":false,"autodetect_manual_merge":false,"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","topics":[],"licenses":[]},"pusher":{"id":5,"login":"luoanwu","login_name":"","source_id":0,"full_name":"","email":"5+luoanwu@noreply.localhost","avatar_url":"https://gitea.g-hi.com/avatar/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":"5+luoanwu@noreply.localhost","avatar_url":"https://gitea.g-hi.com/avatar/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
schedule
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
Cancel