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": 398357, "content": "【黄立成自5月3日累计买入价值1535万美元FRIEND，浮亏754万美元】金色财经报道，据链上分析师余烬监测，Friend tech联合创始人Racer准备将Friend tech从Base链迁移至别的链，致使FRIEND价格下跌了30%。 \n而自FRIEND上线以来一路买成榜一的麻吉（黄立成），目前在FRIEND上已经浮亏795万美元（52%）：麻吉自5月3日以来一直在持续买进FRIEND，累计花费4,873枚ETH（1535万美元）买入804.8万FRIEND，综合成本1.9美元。而目前FRIEND价格仅为0.92美元。", "content_prefix": "黄立成自5月3日累计买入价值1535万美元FRIEND，浮亏754万美元", "link_name": "原文链接", "link": "https://x.com/EmberCN/status/1794893337306292278", "grade": 4, "sort": "", "category": 0, "highlight_color": "", "images": [{"width": 900, "height": 417, "thumbnail": "https://img.jinse2.com/jinse_1716771165896337691_live-rb.png", "url": "https://img.jinse2.com/jinse_1716771165896337691_live-rb.png"}], "created_at": 1716771172, "created_at_zh": "2024-05-27", "attribute": "精选", "up_counts": 905, "down_counts": 538, "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": "2024-05-27"}

TEXT

saved_at

TIMESTAMP (default CURRENT_TIMESTAMP

Update row 106882 in lives