meta_campaign - Laravel Schema Designer

customers

id increments
name string
email string
timestamps timestamps
softDeletes softDeletes

network_api_credentials

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

performance_matrices

id increments
customer_id ^FK bigInteger
network_id ^FK bigInteger
campaign_id ^FK integer
ad_set_id ^FK integer
ad_id ^FK integer
spend string
impressions integer
clicks integer
reported_installs integer
date date
ctr decimal (5,2)
cpc decimal (10,2)
cpi decimal (10,2)
timestamps timestamps

networks

id increments
network_name string
timestamps timestamps
softDeletes softDeletes

campaigns

id increments
network_id ^FK integer
campaign_name string
recevied_campaign_id string
timestamps timestamps

ad_sets

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

ads

id increments
network_id ^FK integer
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