SQLite Web: jinse.db

id

Primary key. INTEGER

live_id

TEXT NOT NULL

title

TEXT

content

TEXT

content_prefix

TEXT

published_date

TEXT

link_name

TEXT

link

TEXT

grade

INTEGER

created_at

TEXT

created_at_unix

INTEGER

created_at_zh

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": "zencash", "symbol": "ZEN", "change_24h": 0.00360314, "price_usd": 10.9470754718507, "price_usd_format": {"data": "10.9471", "unit": ""}, "price_cny_format": {"data": "71.5025", "unit": ""}, "price_cny": 71.5025381888211}, {"slug": "blocktrade", "symbol": "BTT", "change_24h": -0.0258415, "price_usd": 0.0002981949569677, "price_usd_format": {"data": "0.00029819", "unit": ""}, "price_cny_format": {"data": "0.00194261", "unit": ""}, "price_cny": 0.0019426117808591}, {"slug": "btcd", "symbol": "BCD", "change_24h": -0.0111299, "price_usd": 0.4782992978069, "price_usd_format": {"data": "0.4783", "unit": ""}, "price_cny_format": {"data": "3.1272", "unit": ""}, "price_cny": 3.12724527447211}, {"slug": "waykichain", "symbol": "WICC", "change_24h": -0.0545116, "price_usd": 0.157514165408821, "price_usd_format": {"data": "0.1575", "unit": ""}, "price_cny_format": {"data": "1.0176", "unit": ""}, "price_cny": 1.01760494029357}, {"slug": "bytom", "symbol": "BTM", "change_24h": -0.0326857, "price_usd": 0.0541945263499595, "price_usd_format": {"data": "0.0542", "unit": ""}, "price_cny_format": {"data": "0.3524", "unit": ""}, "price_cny": 0.352418326620637}]}

TEXT

is_show_comment

INTEGER

is_forbid_comment

INTEGER

show_source_name

TEXT

vote_id

INTEGER

vote

TEXT

zan_status

TEXT

readings

TEXT

word_blocks

TEXT

raw_data

{"id": 214907, "content": "【金色热搜榜：ZEN居于榜首】根据金色财经排行榜数据显示，过去24小时内，ZEN搜索量高居榜首。具体前五名单如下：ZEN、BTT、BCD、WICC、BTM。", "content_prefix": "金色热搜榜：ZEN居于榜首", "link_name": "", "link": "", "grade": 4, "sort": "行情", "category": 0, "highlight_color": "", "images": [], "created_at": 1608976765, "created_at_zh": "2020-12-26", "attribute": "", "up_counts": 322, "down_counts": 267, "zan_status": "", "readings": [], "extra_type": 5, "extra": {"type": 7, "hotword": [{"slug": "zencash", "symbol": "ZEN", "change_24h": 0.00360314, "price_usd": 10.9470754718507, "price_usd_format": {"data": "10.9471", "unit": ""}, "price_cny_format": {"data": "71.5025", "unit": ""}, "price_cny": 71.5025381888211}, {"slug": "blocktrade", "symbol": "BTT", "change_24h": -0.0258415, "price_usd": 0.0002981949569677, "price_usd_format": {"data": "0.00029819", "unit": ""}, "price_cny_format": {"data": "0.00194261", "unit": ""}, "price_cny": 0.0019426117808591}, {"slug": "btcd", "symbol": "BCD", "change_24h": -0.0111299, "price_usd": 0.4782992978069, "price_usd_format": {"data": "0.4783", "unit": ""}, "price_cny_format": {"data": "3.1272", "unit": ""}, "price_cny": 3.12724527447211}, {"slug": "waykichain", "symbol": "WICC", "change_24h": -0.0545116, "price_usd": 0.157514165408821, "price_usd_format": {"data": "0.1575", "unit": ""}, "price_cny_format": {"data": "1.0176", "unit": ""}, "price_cny": 1.01760494029357}, {"slug": "bytom", "symbol": "BTM", "change_24h": -0.0326857, "price_usd": 0.0541945263499595, "price_usd_format": {"data": "0.0542", "unit": ""}, "price_cny_format": {"data": "0.3524", "unit": ""}, "price_cny": 0.352418326620637}]}, "prev": null, "next": null, "word_blocks": [], "is_show_comment": 1, "is_forbid_comment": 0, "comment_count": 21, "analyst_user": null, "show_source_name": "", "vote_id": 0, "vote": null, "date": "2020-12-26"}

TEXT

saved_at

TIMESTAMP (default CURRENT_TIMESTAMP

Update row 285054 in lives