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": 100257, "content": "【动态 | 合约帝COO杜万接受券商中国采访 分析比特币本轮牛市原因】据合约帝官方消息，合约帝COO杜万近日接受《证券时报》旗下券商中国的采访，在采访中他表示：从历史走势看，比特币本轮上涨前与2015年上涨前趋势相同，分别在300美金和6000美金完成6次支撑，第七次分别跌落到150美金和3200美金触底。对于近期的市场趋势，杜万认为，比特币在月线级别已连续上涨4个月，技术层面存在回调需求。本轮回调的支撑位在7000附近，若放量有效跌破7000美金，投机资金或将斩仓，可能下探至6000美金。", "content_prefix": "动态 | 合约帝COO杜万接受券商中国采访 分析比特币本轮牛市原因", "link_name": "原文链接", "link": "https://mp.weixin.qq.com/s/k2ug0cfvnvl2Fk_xv0l98Q", "grade": 4, "sort": "动态", "category": 0, "highlight_color": "", "images": [{"width": 1080, "height": 1414, "thumbnail": "https://img.jinse.com/jinse_1559808872027647429_live-rb.png", "url": "https://img.jinse.com/jinse_1559808872027647429_live-rb.png"}], "created_at": 1559808910, "created_at_zh": "2019-06-06", "attribute": "", "up_counts": 101, "down_counts": 166, "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-06"}

TEXT

saved_at

TIMESTAMP (default CURRENT_TIMESTAMP

Update row 384819 in lives