tracetheplace - Laravel Schema Designer

airports

id increments
iata string (3)
name string (128)
area string (128)
city string (128)
partner boolean
map_bounds string (250)

destinations

id increments
campaign_id ^FK integer
airport_departure_id ^FK integer
airport_destination_id ^FK integer
price decimal (10,2)
price_promotion decimal (10,2)
cta string (250)
softDeletes softDeletes

campaigns

id increments
country string (128)
country_code string (3)
language_codes string (128)
currency string (10)
winner_id ^FK integer
start_at datetime
end_at datetime
timestamps timestamps
softDeletes softDeletes
active boolean

entries

id increments
user_id ^FK integer
campaign_id ^FK integer
destination_id ^FK integer
activated boolean
coordinates decimal
timestamps timestamps
softDeletes softDeletes

users

id increments
connect_type enum
social_id string (128)
email binary
email_hash string (250)
password string (250)
first_name string (128)
last_name string (128)
profile_picture string (250)
notify boolean
ip_address string (15)
last_login_at datetime
timestamps timestamps
softDeletes softDeletes

aids

id increments
coordinates decimal
entry_id ^FK integer
user_id ^FK integer
timestamps timestamps
softDeletes softDeletes

locations

id increments
coordinates decimal
destination_id ^FK integer

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