Navigation

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
=====Description=====
Table weibo_data_company stores companies' weibo data.
The data is growing.

=====Table format=====
^ Field               ^ Type                ^ Null ^ Key ^ Default ^ Extra                         ^ Description^
| id                  | int(11) unsigned   | NO   | PR   I | NOT NULL | auto_increment | Primary key|
| Stkcd            | int(11)                  | NO   |        | NULL         |                           | company id|
| wbid              | varchar(30)           | NO   |        | NULL     |                               | weibo id|
| username      | text                      | NO   |        |              |                                | the user who post this weibo|
| content          | text                      | NO   |       |              |                                | weibo content|
| date               | datetime               | NO   |       | NULL     |                                | weibo post date|
| type               | int(11)                  | NO   |       | 0             |                              | for checking if it's useful|
| checked         | int(11)                  | NO   |        | 0            |                               | for checking if it's useful|

=====record example=====

^ id      ^ Stkcd      ^ wbid ^ username   ^ content ^ date                                                                             ^ type                          ^ checked ^
|1	|2095	|M_ArVX9qjJD	|丫头伊莉	|【网盛科技：海外营销十年_市场营销_新浪财经_新浪网】网盛科技：海外营销十年 http://t.cn/zTw9Y6o	|2014-01-14 09:36:00	|0	|0|
|2	|2095	|M_ArVX98IxP	|丫头露丝安娜	|【网盛科技走下网络神坛_上市公司_新浪财经_新浪网】网盛科技走下网络神坛 http://t.cn/apPDap	|2014-01-14 09:36:00	|0	|0|
|3	|2095	|M_ArVX8vhCo	|丫头河野亨	|网盛科技：高价股隐藏危机 http://t.cn/zTw9Yfy	|2014-01-14 09:36:00	|0	|0|
|4	|2095	|M_ArVX0gH5F	|丫头虎彻勇音	|【网盛科技：海外营销十年_市场营销_新浪财经_新浪网】网盛科技：海外营销十年 http://t.cn/zTw9Y6o	|2014-01-14 09:35:00	|0	|0|
|5	|2095	|M_ArVX0gH0O	|丫头小神晶	|【网盛科技走下网络神坛_上市公司_新浪财经_新浪网】网盛科技走下网络神坛 http://t.cn/apPDap	|2014-01-14 09:35:00	|0	|0|
|6	|2095	|M_ArVWZlFes	|丫头蔷薇真红	|网盛科技：高价股隐藏危机 http://t.cn/zTw9Yfy	|2014-01-14 09:35:00	|0	|0|
|7	|2095	|M_ArVWWq6OF	|小女人华园光	|【网盛科技：海外营销十年_市场营销_新浪财经_新浪网】网盛科技：海外营销十年 http://t.cn/zTw9Y6o	|2014-01-14 09:35:00	|0	|0|
|8	|2095	|M_ArVWWq6If	|丫头塔奇克马	|【网盛科技走下网络神坛_上市公司_新浪财经_新浪网】网盛科技走下网络神坛 http://t.cn/apPDap	|2014-01-14 09:35:00	|0	|0|
|9	|2095	|M_ArVWW8vk7	|丫头十文字一辉	|网盛科技：高价股隐藏危机 http://t.cn/zTw9Yfy	|2014-01-14 09:35:00	|0	|0|
|10	|2095	|M_ArVWVfgc5	|丫头阿部隆也	|【网盛科技走下网络神坛_上市公司_新浪财经_新浪网】网盛科技走下网络神坛 http://t.cn/apPDap	|2014-01-14 09:35:00	|0	|0|




=====change log=====
newly built
<code>
weibo_data_company | CREATE TABLE `weibo_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Stkcd ` int(11) DEFAULT NULL,
  `wbid` varchar(30) DEFAULT NULL,
  `username` text,
  `content` text,
  `date` datetime DEFAULT NULL,
  `type` int(11) NOT NULL DEFAULT '0',
  `checked` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `weibo_date_wbid` (`wbid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
</code>
Navigation

About Us

Publications

Professional Activities

Lab and Projects

Affiliated Labs

Organizations

Current Activities

See Irwin King In

Book Titles

MISC
