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

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": 178588, "content": "【分析师：8月份比特币价格超过1万美元的几率为90%】加密货币分析师Timothy Peterson在推特上表示，8月份比特币价格超过1万美元的几率为90%。其分享的一张图表显示，比特币看起来已经越过了最低价格，并在一段时间内持续上涨。 \n其他分析师观察到的山寨币市场的稳定也是价格即将回升的一个重要信号。山寨币预计不会很快停止上涨，事实上，许多交易员和分析师认为，山寨币季已从本月开始，并可能持续整个月，一直走高，直到比特币出现重大价格波动。比特币在9300美元和9400美元的阻力位遭到强烈的价格拒绝，这是比特币面临的最大挑战之一。（Zycrypto）", "content_prefix": "分析师：8月份比特币价格超过1万美元的几率为90%", "link_name": "原文链接", "link": "https://zycrypto.com/analyst-theres-a-90-chance-that-bitcoin-price-will-soar-past-10000-come-august/", "grade": 4, "sort": "", "category": 0, "highlight_color": "", "images": [{"width": 1099, "height": 735, "thumbnail": "https://img.jinse.com/jinse_1594713867508921887_live-m.png", "url": "https://img.jinse.com/jinse_1594713867508921887_live-m.png"}], "created_at": 1594713827, "created_at_zh": "2020-07-14", "attribute": "", "up_counts": 228, "down_counts": 159, "zan_status": "", "readings": [], "extra_type": 0, "extra": null, "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": "2020-07-14"}

TEXT

saved_at

TIMESTAMP (default CURRENT_TIMESTAMP

Update row 320227 in lives