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": 359048, "content": "【多链统一交易基础设施zkLink推出新忠诚度积分系统】8月20日消息，多链统一交易基础设施zkLink宣布推出新的忠诚度积分系统。忠诚度积分作为参与生态系统的证明，可用于获得未来的奖励和独家福利；用户在与zkLink生态系统DApp互动、执行链上任务、在社交媒体上互动以及积极参与社区活动都可以获得忠诚度积分。 \nzkLink强调，其正在从过去的活动中收集数据，包括旧忠诚度积分（Loyalty Points）、Loyalty NFT、Zealy Points、Weekly quizes OATs、Sograph OAT、Dunkirk OAT on Galxe、Dunkirk OAT on Aki Network、Community Calls and AMA OATs以及其他小规模活动的积分。 \nzkLink将于2023年第四季度向Galxe上的这些用户收集、上传和空投积分。", "content_prefix": "多链统一交易基础设施zkLink推出新忠诚度积分系统", "link_name": "原文链接", "link": "https://zklinkblog.medium.com/announcing-the-new-zklink-loyalty-points-system-6c6067a659", "grade": 4, "sort": "", "category": 0, "highlight_color": "", "images": [], "created_at": 1692541736, "created_at_zh": "2023-08-20", "attribute": "", "up_counts": 475, "down_counts": 247, "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-20"}

TEXT

saved_at

TIMESTAMP (default CURRENT_TIMESTAMP

Update row 145336 in lives