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": 182217, "content": "【ZBG“火箭计划”首场抢购2分53秒结束】据ZBG官网消息，ZBG“火箭计划”重新启动，首期活动时间2020年7月31日14:00—2020年8月9日14:00为期十天，本期项目为GDFC。今日14时上线后，第一场抢购结束仅用时2分53秒。开盘价0.2QC，现价0.8QC，涨幅达300%。 \n据悉，火箭计划是ZBG的品牌活动，始创于2018年10月，距今已举办超百场，备受用户好评。ZBG火箭计划活动每日设定一定的涨跌阈值，用户可在交易盘口进行抢购，到达阈值即停盘，待第二天重新开启抢购。 \n更多详情请咨询ZBG官网客服。", "content_prefix": "ZBG“火箭计划”首场抢购2分53秒结束", "link_name": "原文链接", "link": "zbg.com", "grade": 4, "sort": "", "category": 0, "highlight_color": "", "images": [{"width": 1157, "height": 570, "thumbnail": "https://img.jinse.com/jinse_1596180403575471368_live-rb.png", "url": "https://img.jinse.com/jinse_1596180403575471368_live-rb.png"}], "created_at": 1596180358, "created_at_zh": "2020-07-31", "attribute": "", "up_counts": 259, "down_counts": 1, "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-31"}

TEXT

saved_at

TIMESTAMP (default CURRENT_TIMESTAMP

Update row 316687 in lives