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 453153 in lives
id
Primary key.
INTEGER
live_id
5113
TEXT NOT NULL
title
早间数字货币行情梳理
TEXT
content
【早间数字货币行情梳理】根据Bitfinex交易平台数据显示, BTC最新成交价格100,911.49元,最高价达114,484.81元,最低价格97,760.90元,成交量6.91万,跌幅0.18%; ETH最新成交价格5,127.48元,最高价达5,601.59元,最低价格4,934.61元,成交量35.78万,涨幅1.92%; BCH最新成交价格25,545.42元,最高价达32,714.15元,最低价格22,594.84元,成交量16.86万,涨幅7.70%; ETC最新成交价格244.81元,最高价达252.99元,最低价格233.81元,成交量28.58万,涨幅1.29%; LTC最新成交价格1,941.88元,最高价达2,166.45元,最低价格1,849.41元,成交量45.40万,涨幅3.03%。
TEXT
content_prefix
早间数字货币行情梳理
TEXT
published_date
2017-12-22
TEXT
link_name
原文链接
TEXT
link
jinse.com
TEXT
grade
INTEGER
created_at
2017-12-22 03:03:18
TEXT
created_at_unix
INTEGER
created_at_zh
2017-12-22
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
null
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": 5113, "content": "【早间数字货币行情梳理】根据Bitfinex交易平台数据显示, \nBTC最新成交价格100,911.49元,最高价达114,484.81元,最低价格97,760.90元,成交量6.91万,跌幅0.18%; \nETH最新成交价格5,127.48元,最高价达5,601.59元,最低价格4,934.61元,成交量35.78万,涨幅1.92%; \nBCH最新成交价格25,545.42元,最高价达32,714.15元,最低价格22,594.84元,成交量16.86万,涨幅7.70%; \nETC最新成交价格244.81元,最高价达252.99元,最低价格233.81元,成交量28.58万,涨幅1.29%; \nLTC最新成交价格1,941.88元,最高价达2,166.45元,最低价格1,849.41元,成交量45.40万,涨幅3.03%。", "content_prefix": "早间数字货币行情梳理", "link_name": "原文链接", "link": "jinse.com", "grade": 3, "sort": "", "category": 0, "highlight_color": "", "images": [], "created_at": 1513882998, "created_at_zh": "2017-12-22", "attribute": "", "up_counts": 0, "down_counts": 0, "zan_status": "", "readings": [], "extra_type": 0, "extra": null, "prev": null, "next": null, "word_blocks": [], "is_show_comment": 0, "is_forbid_comment": 1, "comment_count": 0, "analyst_user": null, "show_source_name": "", "vote_id": 0, "vote": null, "date": "2017-12-22"}
TEXT
saved_at
TIMESTAMP (default CURRENT_TIMESTAMP
Update
Cancel