sqlite-web 0.7.2
gitea.db
issue
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 769 in issue
id
Primary key.
INTEGER NOT NULL
repo_id
INTEGER
index
INTEGER
poster_id
INTEGER
original_author
TEXT
original_author_id
INTEGER
name
[Web前端] 按省市统计设备月度新增上线数量报表
TEXT
content
## 关联 Issue Related to laiqiaojie/jh-project#5 Related to laiqiaojie/jh-project#8 — 按省市统计设备月度新增上线数量报表（Web 前端） ## 变更说明 - 新增 页面组件 - 省份视图：横向柱状图展示各省份当月新增上线设备数，点击下钻城市 - 城市视图：横向柱状图展示选定省份各城市分布，面包屑返回全国 - 使用 CSS 自定义 bar（不引入 ECharts），保持项目依赖不变 - 更新 ：注册 device_online_stats 组件 - 更新 ：新增 路由规则 - **修复** ： 在父菜单 为空时拼出 双斜杠，导致路由匹配失败 - **修复** ： 同一根因的双斜杠问题 ## 测试说明 - 月份切换后图表重新加载 - 点击省份柱子进入城市视图，面包屑显示「全国 › XX省」 - 点击「全国」/「返回全国」返回省份视图 - 无数据月份显示空状态 - 点击「数据」顶部菜单 → 侧栏「设备上线分布」→ 组件正常渲染（已端到端验证） ## DB 变更（需手动执行） ## 产物归档 - Plan：（在 jh-project 仓库） - 设计文档： 🤖 Generated with [Claude Code](https://claude.com/claude-code)
TEXT
milestone_id
INTEGER
priority
INTEGER
is_closed
INTEGER
is_pull
INTEGER
num_comments
INTEGER
ref
TEXT
deadline_unix
INTEGER
created_unix
INTEGER
updated_unix
INTEGER
closed_unix
INTEGER
is_locked
INTEGER NOT NULL (default 0
content_version
INTEGER NOT NULL (default 0
time_estimate
INTEGER NOT NULL (default 0
Update
Cancel