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": 260707, "content": "【Asproex（阿波罗）7月18日上线CCM/USDT交易，开盘涨幅达2880%】据官方消息，2021年7月18日15:00（UTC+8），Asproex（阿波罗）上线CCM，并开放CCM/USDT交易，CCM开盘价格为0.01USDT，上线后最高报价为0.298USDT，开盘涨幅达2880%。 \n据悉，Create Chain是一个基于区块链技术的社交数字经济孵化DAPP平台，专注于社交数字经济应用场景，活跃持币地址达24万。CCM是Create Chain的内生通证，总量10亿枚，流通数量2亿枚、无ICO。 \nAsproex（阿波罗）作为一家离岸银行控股持牌交易平台，涵盖CTO(Corporate Token Offering)企业通证上市、合约跟单、ETT指数通证、数字矿业、Digital Bank板块并持有5国合法牌照，致力于为全球中小微企业提数字化上市一站式服务。", "content_prefix": "Asproex（阿波罗）7月18日上线CCM/USDT交易，开盘涨幅达2880%", "link_name": "", "link": "", "grade": 4, "sort": "", "category": 0, "highlight_color": "", "images": [{"width": 400, "height": 400, "thumbnail": "https://img.jinse.com/5433491_live-rb.png", "url": "https://img.jinse.com/5433491_live-rb.png"}], "created_at": 1626604219, "created_at_zh": "2021-07-18", "attribute": "", "up_counts": 683, "down_counts": 24, "zan_status": "", "readings": [], "extra_type": 0, "extra": null, "prev": null, "next": null, "word_blocks": [], "is_show_comment": 0, "is_forbid_comment": 1, "comment_count": 0, "analyst_user": null, "show_source_name": "", "vote_id": 0, "vote": null, "date": "2021-07-18"}

TEXT

saved_at

TIMESTAMP (default CURRENT_TIMESTAMP

Update row 241292 in lives