Table Raw
+-------------------+--------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+-------------------+-----------------------------+
| _id | char(32) | NO | PRI | NULL | |
| uuid | char(32) | NO | MUL | NULL | |
| id | varchar(255) | NO | | NULL | |
| account | varchar(255) | NO | MUL | NULL | |
| name | varchar(255) | NO | MUL | NULL | |
| source | varchar(255) | NO | MUL | NULL | |
| replies | int(11) | NO | | NULL | |
| shares | int(11) | NO | | NULL | |
| favorites | int(11) | NO | | NULL | |
| followers | int(11) | NO | | NULL | |
| date | timestamp | NO | MUL | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| text | varchar(255) | NO | | NULL | |
| type | varchar(255) | NO | | NULL | |
| link | varchar(255) | NO | | NULL | |
| replies_details | varchar(255) | NO | | NULL | |
| shares_details | varchar(255) | NO | | NULL | |
| favorites_details | varchar(255) | NO | | NULL | |
+-------------------+--------------+------+-----+-------------------+-----------------------------+
_id - unique record id
uuid - unique source
id - unique record id within specific source id
account - account's name e.g. timberland-us
source - source e.g. twitter,facebook-page etc.
name - source name e.g. timberland
replies - comments count
shares - shares count
favorites - likes count
followers - followers count of specific date of post
date - post's date in
UnixTime format
text - post's message, for some source like blog only title
link - link to that specific post
replies_details/shares_details/favorites_details - source of data for each metric