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