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": 99860, "content": "【分析 | 7900将成为短期行情重要分水岭】瑞海咨询首席分析师Steven观点：比特币并未成功突破8560阻力位，借助“海外大户砸盘“消息，比特币大幅跳水，目前在7900美金附近横盘，目前空头防守区域在8250-8360附近，如果价格在未来12小时内无法有效站稳8040阻力位，可能价格将跌破7900继续下行；如果价格成功站稳8040，价格有望测试8250阻力位。所谓海外大户去Coinbase砸盘，实际上是xapo.com公司钱包的内部转账，第一次24000枚比特币是内部互转，第二次11000枚也是内部转账，目前24000枚比特币已经全部转入新的匿名钱包。", "content_prefix": "分析 | 7900将成为短期行情重要分水岭", "link_name": "", "link": "", "grade": 4, "sort": "分析", "category": 0, "highlight_color": "", "images": [{"width": 4724, "height": 1876, "thumbnail": "https://img.jinse.com/jinse_1559666689538172882_live-rb.png", "url": "https://img.jinse.com/jinse_1559666689538172882_live-rb.png"}], "created_at": 1559666656, "created_at_zh": "2019-06-05", "attribute": "", "up_counts": 370, "down_counts": 280, "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": "2019-06-05"}

TEXT

saved_at

TIMESTAMP (default CURRENT_TIMESTAMP

Update row 385057 in lives