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": 224448, "content": "【XRP交易量在去年第四季度激增300％】金色财经报道，根据Ripple的最新报告，XRP的全球交易量在2020年第四季度猛增299％，达到1481.5亿美元。日均成交量（ADV）从第三季度的4.0358亿美元跃升至第四季度的16.1025亿美元。此外，第四季度Ripple的XRP销售总额（净购买量）为7627万美元，而上一季度为3584万美元。尽管有33个市场参与者由于美国证券交易委员会（SEC）于12月下旬针对Ripple的提起的诉讼而暂停交易或完全下线XRP，但XRP仅损失了12.49%的交易量。", "content_prefix": "XRP交易量在去年第四季度激增300％", "link_name": "原文链接", "link": "https://u.today/global-xrp-volume-soared-300-percent-in-q4-despite-trading-restrictions", "grade": 5, "sort": "", "category": 2, "highlight_color": "", "images": [{"width": 1524, "height": 998, "thumbnail": "https://img.jinse.com/jinse_1612554932719246373_live-rb.png", "url": "https://img.jinse.com/jinse_1612554932719246373_live-rb.png"}], "created_at": 1612554707, "created_at_zh": "2021-02-06", "attribute": "", "up_counts": 426, "down_counts": 168, "zan_status": "", "readings": [], "extra_type": 0, "extra": null, "prev": null, "next": null, "word_blocks": [], "is_show_comment": 1, "is_forbid_comment": 0, "comment_count": 59, "analyst_user": null, "show_source_name": "", "vote_id": 0, "vote": null, "date": "2021-02-06"}

TEXT

saved_at

TIMESTAMP (default CURRENT_TIMESTAMP

Update row 275895 in lives