cardo - Laravel Schema Designer

users

id increments
name text
email text
password text
role_id ^FK integer
timestamps timestamps

roles

id increments
name string (20)
timestamps timestamps

companies

id increments
logo text
name text
public_email text
phone text
site_url text
is_confirmed boolean
timestamps timestamps
user_id ^FK integer

departments

id increments
name text
photo text
phone text
email text
description text
latitude double
longitude double
site_url text
company_id ^FK integer
timestamps timestamps

department_services

id increments
department_id ^FK integer
service_id ^FK integer
description text
price double
timestamps timestamps

services

id increments
name text
timestamps timestamps

reviews

id increments
timestamps timestamps
comment text
rating integer
full_name text
email text
service_id ^FK integer
department_id ^FK integer

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