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": 173526, "content": "【TokenBetter平台POC（PotatoCoin）日内涨幅18.84%】据TokenBetter行情显示，截止今日16:00（UTC+8），TokenBetter平台内创新区币种POC（PotatoCoin）快速上涨，日内涨幅为18.84%，现报0.4402USDT。行情波动较大，请注意风险控制。 \nPOC作为全球社交支付公链，同时也是东南亚加密社交软件POTATO的生态代币。POTATO社交APP旨在为全球社交行业解决全维度支付、自由社交、个人隐私、财富共识、信任机制等问题，同时也利用POC公链的P2P交易能力为支付、社交、娱乐内容所有者提供去中心化的内容分发和价值传递的平台。", "content_prefix": "TokenBetter平台POC（PotatoCoin）日内涨幅18.84%", "link_name": "", "link": "", "grade": 4, "sort": "", "category": 0, "highlight_color": "", "images": [{"width": 997, "height": 767, "thumbnail": "https://img.jinse.com/3545264_live-rb.png", "url": "https://img.jinse.com/3545264_live-rb.png"}], "created_at": 1592467931, "created_at_zh": "2020-06-18", "attribute": "", "up_counts": 271, "down_counts": 2, "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-06-18"}

TEXT

saved_at

TIMESTAMP (default CURRENT_TIMESTAMP

Update row 325133 in lives