Table of Contents
Description
Table retweet_people stores people's retweet data of original weibo. 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 |
| wbid | varchar(30) | NO | NULL | original weibo id | ||
| username | text | NO | NULL | the user who retweet | ||
| content | text | NO | retweet content | |||
| date | datetime | NO | NULL | retweet posted date |
record example
| id | wbid | username | content | date |
|---|---|---|---|---|
| 1 | M_yArE653NV | 流体机械B2B-石头钟 | 转发微博。 | 2012-09-06 06:49:27 |
| 2 | M_yBcxS8Raf | SUPER-LOCKER-MR-KOI小罗 | 转发微博 | 2012-09-10 10:55:11 |
| 3 | M_z9GxdpqQ9 | 朵朵棉花糖—呼吁动保立法 | 转发微博。 | 2012-12-14 19:59:39 |
| 4 | M_yrN1x0fh8 | 姚奢华 | 转发微博 | 2012-07-12 09:31:48 |
| 5 | M_yrN1x0fh8 | writerKitty [兔子] | 2012-07-11 16:07:03 | |
| 6 | M_yrN1x0fh8 | 幸福阶梯哥哥 | 新郎笑的好开心。。。羡慕嫉妒中哈哈[哈哈] | 2012-07-11 15:38:39 |
| 7 | M_yrN1x0fh8 | 姚奢华 | 转发微博 | 2012-07-10 18:36:18 |
| 8 | M_yrk8ftHqV | 姚奢华 | 转发微博 | 2012-07-12 09:32:32 |
| 9 | M_zhuw841ok | 高树莲 | huhu… | 2013-02-05 15:22:00 |
| 10 | M_zhuw841ok | 大侠蜜柑 | 2013-02-04 04:35:00 |
change log
newly built
retweet_people | CREATE TABLE `retweet_people` ( `id` int(11) NOT NULL AUTO_INCREMENT, `wbid` varchar(30) DEFAULT NULL, `username` varchar(50) DEFAULT NULL, `content` text, `date` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
