mtl_zmot_connector - Laravel Schema Designer

exports

id increments
timestamps timestamps
name string (250)

influencers

id integer
name string (1000)
first_name string (1000)
email string
description text
country string
address string (1000)
created_at integer
updated_at integer
type string (1000)
blog_id integer
facebook_id integer
twitter_id integer
instagram_id integer
youtube_id integer
pinterest_id integer

upfluence_tokens

id increments
access_token string (500)
refresh_token string (500)
timestamps timestamps
softDeletes softDeletes

search_terms

id increments
timestamps timestamps
softDeletes softDeletes
term string
weight string
field string
type string
export_id ^FK integer

term_field

id increments
field string
name string

country

id increments
code string (2)
name string

language

id increments
code string (2)
name string

influencer_matches

id increments
timestamps timestamps
influence_score integer
relevancy_score float (40,20)
search_terms_id ^FK integer
influencer_id ^FK integer
active boolean

articles

id integer
title text
description text
timestamp integer
url string (1000)
facebook_shares integer
blog_id ^FK integer

blogs

id integer
url string (1000)
title text
description text
visits integer
page_rank integer
alexa_rank integer
category integer
average_facebook_shares float (40,20)
influencer_id ^FK integer

facebooks

id integer
url string (1000)
fans integer
name string (1000)
bio text
engagement_rate float (40,20)
category string (1000)
subcategories string (1000)
average_shares float (40,20)
average_likes float (40,20)
average_comments float (40,20)
influencer_id ^FK integer

facebook_statuses

id integer
text text
timestamp integer
likes integer
comments integer
shares integer
post_id string (500)
facebook_id ^FK integer

tweets

id integer
content text
timestamp integer
retweets integer
favorites integer
post_id string (500)
twitter_id ^FK integer

twitters

id integer
url string (1000)
name string (1000)
screen_name string (1000)
bio text
followers integer
engagement_rate float (40,20)
average_retweets float (40,20)
average_favorites float (40,20)
influencer_id ^FK integer

instagrams

id integer
username string (1000)
bio text
full_name string (1000)
website string (1000)
followers integer
engagement_rate float (40,20)
average_likes float (40,20)
average_comments float (40,20)
influencer_id ^FK integer

instagram_medias

id integer
text text
link string (1000)
type string (500)
location_name string (500)
timestamp integer
likes integer
comments integer
post_id string (500)
instagram_id ^FK integer

youtubes

id integer
name string (1000)
description text
username string (1000)
followers integer
views integer
engagement_rate float (40,20)
average_likes float (40,20)
average_views float (40,20)
average_comments float (40,20)
influencer_id ^FK integer

youtube_videos

id integer
name string (1000)
description text
link string (1000)
timestamp integer
views integer
comments integer
likes integer
dislikes integer
post_id string (500)
youtube_id ^FK integer

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01