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": 299128, "content": "【Web3社交开放协议Linkkey&SNS将针对ENS用户空投】4月27日消息，据Linkkey&SNS官方消息，SNS分叉于ENS，即将针对ENS用户进行空投。SNS与ENS其区别在于支持多链注册（目前支持Polygon，是Polygon官方孵化的DID项目），已部署KAVA、TRON。SNS注册后不用续费，并持续三年享有KEY的分红，另外支持发行个人NFT和社群NFT，属于社交场景。每100人注册费上涨约0.45 USDT，注册费的40%作为流动性支持。 \n据悉，SNS是Web3社交协议LINKKEY的去中心化用户名称系统，于2021年12月上线，目前已有近2万地址注册。", "content_prefix": "Web3社交开放协议Linkkey&SNS将针对ENS用户空投", "link_name": "", "link": "", "grade": 4, "sort": "", "category": 5, "highlight_color": "", "images": [{"width": 610, "height": 655, "thumbnail": "https://img.jinse2.com/jinse_1651052209238620672_live-rb.png", "url": "https://img.jinse2.com/jinse_1651052209238620672_live-rb.png"}], "created_at": 1651052225, "created_at_zh": "2022-04-27", "attribute": "", "up_counts": 5, "down_counts": 0, "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": "2022-04-27"}

TEXT

saved_at

TIMESTAMP (default CURRENT_TIMESTAMP

Update row 203877 in lives