dataportal - Laravel Schema Designer

lef_source_mapping

id increments
client_id ^FK integer
source_id ^FK integer
system_rule string
source_rule string
qualification_rule string
ga_source_rule string
ga_medium_rule string
timestamps timestamps

clients

id increments
name string
timestamps timestamps
softDeletes softDeletes

sources

id increments
client_id ^FK integer
name string
autofill boolean
timestamps timestamps

source_channel_mapping

id increments
client_id ^FK integer
channel_id ^FK integer
source_id ^FK integer
timestamps timestamps

channels

id increments
name string
timestamps timestamps

Expenses

id increments
client_id ^FK integer
source_id ^FK integer
date datetime
cost decimal
timestamps timestamps

lef_sources

id increments
client_id ^FK integer
system string
source string
qualification string
ga_source string
ga_medium string
timestamps timestamps

analytics_views

id increments
timestamps timestamps
client_id ^FK integer
view_id integer

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