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": 178360, "content": "【Web3基金会公布第六批Grant名单，Phala Network 数据产品W3A在列】金色财经报道，7月13日，Web3基金会公布了第六批Grant资助名单，基于Phala Network隐私计算协议的数据产品Web3 Analytics (简称W3A) 获得资助，W3A是一款去中心化数据分析工具，通过保密智能合约实现了数据采集和数据分析的隔离，解决了因为数据迁移和保管不力导致的泄露和滥用问题。 \n \n据悉，在W3A中，用户数据在用户浏览器和后端之间进行端到端加密，加密后的数据将存储在一个分散的存储网络中。加密密钥只有其所有者和智能合同才能访问，智能合同允许用户随时随地提取或删除用户数据。", "content_prefix": "Web3基金会公布第六批Grant名单，Phala Network 数据产品W3A在列", "link_name": "", "link": "", "grade": 4, "sort": "", "category": 0, "highlight_color": "", "images": [{"width": 997, "height": 910, "thumbnail": "https://img.jinse.com/jinse_1594629881375977922_live-rb.png", "url": "https://img.jinse.com/jinse_1594629881375977922_live-rb.png"}], "created_at": 1594629894, "created_at_zh": "2020-07-13", "attribute": "", "up_counts": 213, "down_counts": 113, "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": "2020-07-13"}

TEXT

saved_at

TIMESTAMP (default CURRENT_TIMESTAMP

Update row 320451 in lives