meta_campaign - Laravel Schema Designer

customers

id integer
name string
email string
timestamps timestamps
softDeletes softDeletes

network_api_credentials

id increments
customer_id ^FK integer
network_id smallInteger
account_id string
app_id string
api_key string
access_token string
Status tinyInteger
timestamps timestamps
softDeletes softDeletes

performance_matrices

id increments
customer_id ^FK integer
network_id smallInteger
campaign_id ^FK integer
ad_set_id ^FK integer
ad_id ^FK integer
spend string
impressions integer
clicks integer
reported_installs integer
date date
cost_per_click decimal (10,2)
click_through_rate decimal (10,2)
cost_per_install decimal (10,2)
timestamps timestamps

networks

id smallIncrements
network_name string
timestamps timestamps
softDeletes softDeletes

campaigns

id increments
network_id smallInteger
campaign_name string
recevied_campaign_id string
timestamps timestamps

ad_sets

id increments
network_id smallInteger
campaign_id ^FK bigInteger
recevied_ad_set_id string
ad_set_name string
timestamps timestamps

ads

id increments
network_id smallInteger
recevied_ad_id string
ad_name string
ad_set_id ^FK bigInteger
timestamps timestamps

performance_matrices_attributes

id increments
performance_matrices_id ^FK integer
type enum
retention_number integer
retention_value integer
timestamps timestamps

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