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": 206198, "content": "【币安疑似出现Bug BTC短时最高价达到82000美元】11月19日消息，币安平台BTC和稳定币TUSD的交易对价格疑似出现错误。11月17日14:00，1小时价格图表上出现一个极长的蜡烛，开盘16626.38 TUSD，高点达到82000 TUSD，60分钟后收盘价为16635.61 TUSD。而考虑到这段时间内交易量并没有多大幅度上升，且假设是某个交易员出现人为错误，但要想达到该价格，需要大量资金转手，实际上也会耗尽BTC/TUSD交易对的流动性。因此综合考虑，币安出现Bug是最有可能的。但目前就此事币安未作回应。（注：TUSD为可和美元1:1兑换的稳定币）（Decrypt）", "content_prefix": "币安疑似出现Bug BTC短时最高价达到82000美元", "link_name": "", "link": "", "grade": 4, "sort": "", "category": 0, "highlight_color": "", "images": [{"width": 1092, "height": 752, "thumbnail": "https://img.jinse.com/jinse_1605746073104723974_live-rb.png", "url": "https://img.jinse.com/jinse_1605746073104723974_live-rb.png"}], "created_at": 1605745768, "created_at_zh": "2020-11-19", "attribute": "精选", "up_counts": 176, "down_counts": 204, "zan_status": "", "readings": [], "extra_type": 0, "extra": null, "prev": null, "next": null, "word_blocks": [], "is_show_comment": 1, "is_forbid_comment": 0, "comment_count": 35, "analyst_user": null, "show_source_name": "", "vote_id": 0, "vote": null, "date": "2020-11-19"}

TEXT

saved_at

TIMESTAMP (default CURRENT_TIMESTAMP

Update row 293404 in lives