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 309777 in lives
id
Primary key.
INTEGER
live_id
189323
TEXT NOT NULL
title
市值前百种币44涨56跌
TEXT
content
【市值前百种币44涨56跌】金色财经行情显示，BTC今日价格在11715.41-11562.78美元之间波动，市场整体下行。市值前百币种44涨56跌，其中涨幅前三的币种分别为：XUC涨幅65.31%，CVT涨幅43.4%，FXC涨幅34.41%；跌幅前三的币种为：GNT跌幅-10.9%，SEELE跌幅-9.57%，XEM跌幅-7.19%。
TEXT
content_prefix
市值前百种币44涨56跌
TEXT
published_date
2020-08-31
TEXT
link_name
TEXT
link
TEXT
grade
INTEGER
created_at
2020-08-31 19:10:46
TEXT
created_at_unix
INTEGER
created_at_zh
2020-08-31
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
{"head_text": "金色财经行情显示，市场整体下行。市值前百币种44涨56跌。", "bottom_text": "", "title": "市值前百种币44涨56跌", "coins": [{"name": "XUC", "price": "$4.74", "plate_name": "", "currency": "$", "direction": "up", "list": [{"name": "24H涨幅", "value": "65.31", "direction": "up"}, {"name": "成交量", "value": "455.92", "direction": ""}, {"name": "最高价", "value": "$5.14", "direction": ""}, {"name": "最低价", "value": "$2.86", "direction": ""}], "slug": "exchange-union"}, {"name": "CVT", "price": "$0.11", "plate_name": "", "currency": "$", "direction": "up", "list": [{"name": "24H涨幅", "value": "43.4", "direction": "up"}, {"name": "成交量", "value": "5375.97", "direction": ""}, {"name": "最高价", "value": "$0.14", "direction": ""}, {"name": "最低价", "value": "$0.07", "direction": ""}], "slug": "cybervein"}, {"name": "FXC", "price": "$0.01", "plate_name": "", "currency": "$", "direction": "up", "list": [{"name": "24H涨幅", "value": "34.41", "direction": "up"}, {"name": "成交量", "value": "22580.73", "direction": ""}, {"name": "最高价", "value": "$0.01", "direction": ""}, {"name": "最低价", "value": "$0.01", "direction": ""}], "slug": "flexacoin"}, {"name": "GNT", "price": "$0.14", "plate_name": "", "currency": "$", "direction": "down", "list": [{"name": "24H跌幅", "value": "10.9", "direction": "down"}, {"name": "成交量", "value": "19073.09", "direction": ""}, {"name": "最高价", "value": "$0.15", "direction": ""}, {"name": "最低价", "value": "$0.13", "direction": ""}], "slug": "golem-network-tokens"}, {"name": "SEELE", "price": "$0.01", "plate_name": "", "currency": "$", "direction": "down", "list": [{"name": "24H跌幅", "value": "9.57", "direction": "down"}, {"name": "成交量", "value": "550805.84", "direction": ""}, {"name": "最高价", "value": "$0.01", "direction": ""}, {"name": "最低价", "value": "$0.01", "direction": ""}], "slug": "seele"}, {"name": "XEM", "price": "$0.14", "plate_name": "", "currency": "$", "direction": "down", "list": [{"name": "24H跌幅", "value": "7.19", "direction": "down"}, {"name": "成交量", "value": "190733.21", "direction": ""}, {"name": "最高价", "value": "$0.15", "direction": ""}, {"name": "最低价", "value": "$0.12", "direction": ""}], "slug": "nem"}]}
TEXT
is_show_comment
INTEGER
is_forbid_comment
INTEGER
show_source_name
TEXT
vote_id
INTEGER
vote
{"vote_id": 217, "title": "今天跌多涨少，会影响你的投资决策吗？", "is_limit_time": 1, "end_time": "2020-08-31 23:00:00", "is_multiple": 2, "state": 3, "created_at": "2020-08-31 19:10:43", "is_vote": false, "is_pk": 0, "option": [{"option_id": "1598872243675000", "vote_id": 217, "title": "赚钱变难了，我准备溜了", "is_vote": false, "count": 12, "total": "55%"}, {"option_id": "1598872243679000", "vote_id": 217, "title": "不怕，我买的赚钱就行", "is_vote": false, "count": 3, "total": "14%"}, {"option_id": "1598872243683000", "vote_id": 217, "title": "我跟着大饼走", "is_vote": false, "count": 7, "total": "32%"}]}
TEXT
zan_status
TEXT
readings
[]
TEXT
word_blocks
[]
TEXT
raw_data
{"id": 189323, "content": "【市值前百种币44涨56跌】金色财经行情显示，BTC今日价格在11715.41-11562.78美元之间波动，市场整体下行。市值前百币种44涨56跌，其中涨幅前三的币种分别为：XUC涨幅65.31%，CVT涨幅43.4%，FXC涨幅34.41%；跌幅前三的币种为：GNT跌幅-10.9%，SEELE跌幅-9.57%，XEM跌幅-7.19%。", "content_prefix": "市值前百种币44涨56跌", "link_name": "", "link": "", "grade": 4, "sort": "", "category": 0, "highlight_color": "", "images": [], "created_at": 1598872246, "created_at_zh": "2020-08-31", "attribute": "", "up_counts": 131, "down_counts": 210, "zan_status": "", "readings": [], "extra_type": 1, "extra": {"head_text": "金色财经行情显示，市场整体下行。市值前百币种44涨56跌。", "bottom_text": "", "title": "市值前百种币44涨56跌", "coins": [{"name": "XUC", "price": "$4.74", "plate_name": "", "currency": "$", "direction": "up", "list": [{"name": "24H涨幅", "value": "65.31", "direction": "up"}, {"name": "成交量", "value": "455.92", "direction": ""}, {"name": "最高价", "value": "$5.14", "direction": ""}, {"name": "最低价", "value": "$2.86", "direction": ""}], "slug": "exchange-union"}, {"name": "CVT", "price": "$0.11", "plate_name": "", "currency": "$", "direction": "up", "list": [{"name": "24H涨幅", "value": "43.4", "direction": "up"}, {"name": "成交量", "value": "5375.97", "direction": ""}, {"name": "最高价", "value": "$0.14", "direction": ""}, {"name": "最低价", "value": "$0.07", "direction": ""}], "slug": "cybervein"}, {"name": "FXC", "price": "$0.01", "plate_name": "", "currency": "$", "direction": "up", "list": [{"name": "24H涨幅", "value": "34.41", "direction": "up"}, {"name": "成交量", "value": "22580.73", "direction": ""}, {"name": "最高价", "value": "$0.01", "direction": ""}, {"name": "最低价", "value": "$0.01", "direction": ""}], "slug": "flexacoin"}, {"name": "GNT", "price": "$0.14", "plate_name": "", "currency": "$", "direction": "down", "list": [{"name": "24H跌幅", "value": "10.9", "direction": "down"}, {"name": "成交量", "value": "19073.09", "direction": ""}, {"name": "最高价", "value": "$0.15", "direction": ""}, {"name": "最低价", "value": "$0.13", "direction": ""}], "slug": "golem-network-tokens"}, {"name": "SEELE", "price": "$0.01", "plate_name": "", "currency": "$", "direction": "down", "list": [{"name": "24H跌幅", "value": "9.57", "direction": "down"}, {"name": "成交量", "value": "550805.84", "direction": ""}, {"name": "最高价", "value": "$0.01", "direction": ""}, {"name": "最低价", "value": "$0.01", "direction": ""}], "slug": "seele"}, {"name": "XEM", "price": "$0.14", "plate_name": "", "currency": "$", "direction": "down", "list": [{"name": "24H跌幅", "value": "7.19", "direction": "down"}, {"name": "成交量", "value": "190733.21", "direction": ""}, {"name": "最高价", "value": "$0.15", "direction": ""}, {"name": "最低价", "value": "$0.12", "direction": ""}], "slug": "nem"}]}, "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": 217, "vote": {"vote_id": 217, "title": "今天跌多涨少，会影响你的投资决策吗？", "is_limit_time": 1, "end_time": "2020-08-31 23:00:00", "is_multiple": 2, "state": 3, "created_at": "2020-08-31 19:10:43", "is_vote": false, "is_pk": 0, "option": [{"option_id": "1598872243675000", "vote_id": 217, "title": "赚钱变难了，我准备溜了", "is_vote": false, "count": 12, "total": "55%"}, {"option_id": "1598872243679000", "vote_id": 217, "title": "不怕，我买的赚钱就行", "is_vote": false, "count": 3, "total": "14%"}, {"option_id": "1598872243683000", "vote_id": 217, "title": "我跟着大饼走", "is_vote": false, "count": 7, "total": "32%"}]}, "date": "2020-08-31"}
TEXT
saved_at
TIMESTAMP (default CURRENT_TIMESTAMP
Update
Cancel