contacts - Laravel Schema Designer

contact_folders

id increments
company_id integer
parent_id ^FK integer
created_by ^FK integer
contact_folder_access_id ^FK integer
name string
order integer
timestamps timestamps
softDeletes softDeletes

contact_lists

id increments
company_id integer
contact_folder_id ^FK integer
owner_id ^FK integer
is_bookmarked boolean
name string
type tinyInteger
headers json
filters json
order integer
is_default boolean
timestamps timestamps
softDeletes softDeletes

contacts

id increments
timestamps timestamps
softDeletes softDeletes

contact_folder_access_users

id increments
company_id integer
user_id mediumInteger
contact_folder_access_id ^FK integer
has_edit boolean
has_delete boolean
timestamps timestamps

contact_list_items

id increments
company_id integer
contact_list_id ^FK integer
contact_id ^FK integer
order integer
contact_phone_number_id integer
incoming_number_id integer
timestamps timestamps
softDeletes softDeletes

companies

id increments
timestamps timestamps
softDeletes softDeletes

contact_phone_numbers

id increments
timestamps timestamps
softDeletes softDeletes

incoming_numbers

id increments
timestamps timestamps
softDeletes softDeletes

users

id increments
timestamps timestamps
softDeletes softDeletes

contact_folder_access

id increments
company_id ^FK integer
timestamps timestamps
softDeletes softDeletes

contact_list_bookmarks

id increments
company_id ^FK integer
contact_list_id ^FK integer
user_id ^FK integer
order integer
timestamps timestamps

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