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": 357994, "content": "【0x316地址在过去3天内总共使用25万美元买入17.72万枚LBR】金色财经报道，据Spot On Chain监测显示，0x316地址在2小时前以平均1.514美元的价格买入9.907万LBR（15万美元），随后价格上涨 4%。该地址在过去3天内总共使用25万美元买入17.72万枚LBR。每次买入后，LBR的价格都会飙升，该地址目前仍持有全部，现值26.7万美元。 \n此外，地址0x316也从两个流行的meme coin赚取了总计约28.9万美元：从7月24日到7月28日，将9500万枚RSR (18.8万美元) 兑换为 2.53亿枚RLB (现价值46.1万美元)，从8月10日起，将7.5万枚USDT兑换为74万枚BITCOIN（现价值9.1万美元）。", "content_prefix": "0x316地址在过去3天内总共使用25万美元买入17.72万枚LBR", "link_name": "原文链接", "link": "https://twitter.com/spotonchain/status/1690217591007297536", "grade": 4, "sort": "", "category": 0, "highlight_color": "", "images": [{"width": 1794, "height": 1076, "thumbnail": "https://img.jinse2.com/jinse_1691815209145528487_live-rb.png", "url": "https://img.jinse2.com/jinse_1691815209145528487_live-rb.png"}], "created_at": 1691816364, "created_at_zh": "2023-08-12", "attribute": "", "up_counts": 381, "down_counts": 327, "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": "2023-08-12"}

TEXT

saved_at

TIMESTAMP (default CURRENT_TIMESTAMP

Update row 146371 in lives