Differences
This shows you the differences between two versions of the page.
projs:clans:docs:dataset_db_retweet_people [2014/01/26 21:24] yangjunfeng0317 created |
projs:clans:docs:dataset_db_retweet_people [2014/01/27 11:46] (current) yangjunfeng0317 |
||
---|---|---|---|
Line 4: | Line 4: | ||
=====Table format===== | =====Table format===== | ||
- | ^ Field ^ Type ^ Null ^ Key ^ Default ^ Extra ^ | + | ^ Field ^ Type ^ Null ^ Key ^ Default ^ Extra ^ Description ^ |
- | | id | int(11) unsigned | NO | PR I | NOT NULL | auto_increment | | + | | id | int(11) unsigned | NO | PR I | NOT NULL | auto_increment | primary key| |
- | | wbid | varchar(30) | NO | | NULL | | | + | | wbid | varchar(30) | NO | | NULL | | original weibo id| |
- | | username | text | NO | | NULL | | | + | | username | text | NO | | NULL | | the user who retweet| |
- | | content | text | NO | | | | | + | | content | text | NO | | | | retweet content| |
- | | date | datetime | NO | | NULL | | | + | | date | datetime | NO | | NULL | | retweet posted date| |