Salon_system - Laravel Schema Designer

salons

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
location string (255)

users

id increments
timestamps timestamps
softDeletes softDeletes
salon_id ^FK integer
role_id integer
status string (255)

services

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
desc string (255)
price float
avg_time integer
salon_id ^FK integer

packages

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
salon_id ^FK integer

package_services

package_id ^FK integer
service_id ^FK integer

schedules

id increments
timestamps timestamps
softDeletes softDeletes
start_time time
end_time time
refrence_id integer
status string (255)
refrence_type string (255)

vacations

id increments
timestamps timestamps
refrence_id integer
refrence_type string
date date
status string

customers

id increments
timestamps timestamps
salon_id ^FK integer
created_by ^FK integer
first_name string
last_name string (255)

orders

id increments
timestamps timestamps
softDeletes softDeletes
salon_id ^FK integer
user_id integer
start_time datetime
end_time datetime
customer_id ^FK integer
total float
status string
amount float
discount_amount float
payment_method string

order_items

id increments
timestamps timestamps
order_id ^FK integer
refrence_id integer
refrence_type string (255)
total float
discount_amount float
amount float

salon_contract

id increments
timestamps timestamps
salon_id ^FK integer
user_id ^FK integer
type string
amount float
duration string
status string

purchases

id increments
timestamps timestamps
name string (255)
amount float
user_id ^FK integer
salon_id ^FK integer
date date
quantity integer

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