sqlite-web 0.7.2
jinse.db
lives
Create
Query
lives
sqlite_sequence
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Update row 254203 in lives
id
Primary key.
INTEGER
live_id
247230
TEXT NOT NULL
title
金色热搜榜：ZSC居于榜首
TEXT
content
【金色热搜榜：ZSC居于榜首】根据金色财经排行榜数据显示，过去24小时内，ZSC搜索量高居榜首。具体前五名单如下：ZSC、MUSK、AE、DDD、BIX。
TEXT
content_prefix
金色热搜榜：ZSC居于榜首
TEXT
published_date
2021-05-12
TEXT
link_name
TEXT
link
TEXT
grade
INTEGER
created_at
2021-05-12 17:59:12
TEXT
created_at_unix
INTEGER
created_at_zh
2021-05-12
TEXT
updated_at
TEXT
source
TEXT
category
INTEGER
reading
INTEGER (default 0
flag
TEXT
attribute
TEXT
up_counts
INTEGER
down_counts
INTEGER
comment_count
INTEGER
highlight_color
TEXT
images
[]
TEXT
extra_type
INTEGER
extra
{"type": 7, "hotword": [{"slug": "zeusshield", "symbol": "ZSC", "change_24h": -0.0239754, "price_usd": 0.000471589589915, "price_usd_format": {"data": "0.00047159", "unit": ""}, "price_cny_format": {"data": "0.00304503", "unit": ""}, "price_cny": 0.003045033896931}, {"slug": "musk", "symbol": "MUSK", "change_24h": -0.120239, "price_usd": 0.0023960784603646, "price_usd_format": {"data": "0.00239608", "unit": ""}, "price_cny_format": {"data": "0.0155", "unit": ""}, "price_cny": 0.0154614012371831}, {"slug": "aeternity", "symbol": "AE", "change_24h": 0.00434955, "price_usd": 0.354046139918339, "price_usd_format": {"data": "0.354", "unit": ""}, "price_cny_format": {"data": "2.2864", "unit": ""}, "price_cny": 2.28639198636065}, {"slug": "scry", "symbol": "DDD", "change_24h": -0.252367, "price_usd": 0.0083148959187978, "price_usd_format": {"data": "0.0083149", "unit": ""}, "price_cny_format": {"data": "0.0536", "unit": ""}, "price_cny": 0.0535609961053061}, {"slug": "bixtoken", "symbol": "BIX", "change_24h": 0.0381779, "price_usd": 0.212127199535344, "price_usd_format": {"data": "0.2121", "unit": ""}, "price_cny_format": {"data": "1.3735", "unit": ""}, "price_cny": 1.37353623946953}]}
TEXT
is_show_comment
INTEGER
is_forbid_comment
INTEGER
show_source_name
TEXT
vote_id
INTEGER
vote
null
TEXT
zan_status
TEXT
readings
[]
TEXT
word_blocks
[]
TEXT
raw_data
{"id": 247230, "content": "【金色热搜榜：ZSC居于榜首】根据金色财经排行榜数据显示，过去24小时内，ZSC搜索量高居榜首。具体前五名单如下：ZSC、MUSK、AE、DDD、BIX。", "content_prefix": "金色热搜榜：ZSC居于榜首", "link_name": "", "link": "", "grade": 4, "sort": "行情", "category": 2, "highlight_color": "", "images": [], "created_at": 1620813552, "created_at_zh": "2021-05-12", "attribute": "", "up_counts": 118, "down_counts": 28, "zan_status": "", "readings": [], "extra_type": 5, "extra": {"type": 7, "hotword": [{"slug": "zeusshield", "symbol": "ZSC", "change_24h": -0.0239754, "price_usd": 0.000471589589915, "price_usd_format": {"data": "0.00047159", "unit": ""}, "price_cny_format": {"data": "0.00304503", "unit": ""}, "price_cny": 0.003045033896931}, {"slug": "musk", "symbol": "MUSK", "change_24h": -0.120239, "price_usd": 0.0023960784603646, "price_usd_format": {"data": "0.00239608", "unit": ""}, "price_cny_format": {"data": "0.0155", "unit": ""}, "price_cny": 0.0154614012371831}, {"slug": "aeternity", "symbol": "AE", "change_24h": 0.00434955, "price_usd": 0.354046139918339, "price_usd_format": {"data": "0.354", "unit": ""}, "price_cny_format": {"data": "2.2864", "unit": ""}, "price_cny": 2.28639198636065}, {"slug": "scry", "symbol": "DDD", "change_24h": -0.252367, "price_usd": 0.0083148959187978, "price_usd_format": {"data": "0.0083149", "unit": ""}, "price_cny_format": {"data": "0.0536", "unit": ""}, "price_cny": 0.0535609961053061}, {"slug": "bixtoken", "symbol": "BIX", "change_24h": 0.0381779, "price_usd": 0.212127199535344, "price_usd_format": {"data": "0.2121", "unit": ""}, "price_cny_format": {"data": "1.3735", "unit": ""}, "price_cny": 1.37353623946953}]}, "prev": null, "next": null, "word_blocks": [], "is_show_comment": 1, "is_forbid_comment": 0, "comment_count": 0, "analyst_user": null, "show_source_name": "", "vote_id": 0, "vote": null, "date": "2021-05-12"}
TEXT
saved_at
TIMESTAMP (default CURRENT_TIMESTAMP
Update
Cancel