atlas - Laravel Schema Designer

ads

id increments
timestamps timestamps
softDeletes softDeletes
type_configs json
skippable string
on_click string
name string
ad_group_id ^FK integer
status enum
type enum
show_chance_percentage integer

ad_groups

id increments
timestamps timestamps
softDeletes softDeletes
status enum
weight integer
priority enum
type_id ^FK integer
constraint_id integer
notes text
show_chance_percentage integer
owner_id integer
ad_constraint_id ^FK integer
expire_after_impression_click_count integer
expire_after_impression integer
expire_after_cost integer
start_date datetime
end_date datetime

positions

id increments
timestamps timestamps
name string
type_id ^FK integer
status enum
subsystem_id integer
application_id integer
type enum
softDeletes softDeletes

ad_constraints

id increments
timestamps timestamps
name string
continents json
countries json
regions json
cities json
browsers json
os json
device_types json
domains json
blacklist_domains json
ipaddresses json
blacklist_ipaddresses json
urls json
blacklist_urls json
gps_latitude_longtitude_radius json
genres json
categories json
keywords json
contain_words json
maturities json
markets json
contents json
applications json
time_of_the_day json
day_of_the_week json
day_of_the_month json

types

id increments
timestamps timestamps
name string

impressions

id increments
uuid string
position_id ^FK integer
ad_group_id ^FK integer
ad_id ^FK integer
country integer
browser string
language string
operation_system string
domain string
protocol string
is_human string
impress_time string
ad_type string
ip_v4 string
cost float

position_costs

id increments
position_id ^FK integer
per_cost float
currency enum
type enum
timestamps timestamps
softDeletes softDeletes

clicks

id increments
position_id integer
uuid string
created_at timestamp
ad_group_id integer
ad_id integer
country string
browser string
language string
operating_system string
domain string
protocol string
is_human integer
ad_type string
ip_v4 string
cost float

ad_media

id increments
timestamps timestamps
file_path string
ad_id integer

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