preetio - Laravel Schema Designer

users

id increments
first_name string
last_name string
email string
password string
is_active tinyInteger
remember_token string (100)
timezone string
timestamps timestamps
softDeletes softDeletes

roles

id increments
name string
display_name string
description string
timestamps timestamps

role_user

id increments
user_id ^FK integer
role_id ^FK integer

permissions

id increments
name string
display_name string
description string
timestamps timestamps

permission_role

id increments
permission_id ^FK integer
role_id ^FK integer

pitches

id increments
user_id integer
pitch_type_id integer
contact_id string
status_id integer
name string
headline text
body text
send_time datetime
send_email_time datetime
timestamps timestamps
softDeletes softDeletes

user_meta

id increments
user_id ^FK integer
role_id ^FK integer
timestamps timestamps
company_name string
company_role string
biography text
phone string
country string
state string
city string

pitch_types

id increments
name string
timestamps timestamps

pitch_statuses

id increments
status string
timestamps timestamps

media_lists

id increments
name string
user_id integer
timestamps timestamps

media_list_categories

id increments
parent_id integer
name string
timestamps timestamps

media_list_regions

id increments
country_id ^FK integer
name string
timestamps timestamps

media_list_types

id increments
name string
timestamps timestamps

media_list_outlets

id increments
name string
timestamps timestamps

media_list_items

media_list_type_id ^FK integer
id increments
media_list_id ^FK integer
media_list_outlet_id ^FK integer
media_list_category_id ^FK integer
media_list_region_id ^FK integer
timestamps timestamps

media_list_region_outlet

id increments
media_list_region_id ^FK integer
media_list_outlet_id ^FK integer
timestamps timestamps

media_list_category_outlet

id increments
media_list_category_id ^FK integer
media_list_outlet_id ^FK integer
timestamps timestamps

media_list_type_outlet

id increments
media_list_type_id ^FK integer
media_list_outlet_id ^FK integer
timestamps timestamps

countries

id increments
name string
timestamps timestamps

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