SocialProof - Laravel Schema Designer

sites

id increments
timestamps timestamps
softDeletes softDeletes
name string
team_id ^FK bigInteger

teams

id increments
timestamps timestamps
user_id ^FK bigInteger
name string
personal_team tinyInteger

users

id increments
timestamps timestamps
first_name string
last_name string
current_team_id bigInteger

event_types

id increments
timestamps timestamps
softDeletes softDeletes
name string
site_id ^FK bigInteger

campaigns

id increments
timestamps timestamps
softDeletes softDeletes
name string
site_id ^FK bigInteger

event_type_urls

id increments
timestamps timestamps
softDeletes softDeletes
event_type_id ^FK bigInteger
url string

events

id increments
timestamps timestamps
softDeletes softDeletes
event_type_id ^FK bigInteger
user_name string
data json

campaign_event_types

id increments
timestamps timestamps
softDeletes softDeletes
campaign_id ^FK bigInteger
event_type_id ^FK bigInteger

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