new_barber_app - Laravel Schema Designer

users

id increments
role_id ^FK bigInteger
name string (191)
email string (191)
password string (191)
profile_image string (191)
status boolean
timestamps timestamps
softDeletes softDeletes

roles

id increments
name string (191)
timestamps timestamps
softDeletes softDeletes

shops

id increments
owner_id ^FK bigInteger
name string (191)
location string (191)
timestamps timestamps
softDeletes softDeletes

services

id increments
professional_id ^FK bigInteger
shop_id ^FK bigInteger
name string (191)
approximate_time time
charges bigInteger
timestamps timestamps
softDeletes softDeletes

availabilities

id increments
professional_id ^FK bigInteger
shop_id ^FK bigInteger
monday string (191)
is_monday boolean
tuesday string
is_tuesday boolean
wednesday string (191)
is_wednesday boolean
thursday string (191)
is_thursday boolean
friday string (191)
is_friday boolean
saturday string (191)
is_saturday boolean
sunday string (191)
is_sunday boolean
is_for_shop boolean
is_for_indep_pro boolean
is_for_normal_user boolean
timestamps timestamps
softDeletes softDeletes

open_chairs

id increments
owner_id ^FK bigInteger
shop_id ^FK bigInteger
available_chairs bigInteger
status boolean
timestamps timestamps
softDeletes softDeletes

appointments

id increments
professional_id ^FK bigInteger
shop_id bigInteger
owner_id ^FK bigInteger
customer_id ^FK bigInteger
service_id ^FK bigInteger
status string (191)
timestamps timestamps
softDeletes softDeletes

reviews

id increments
professional_id ^FK bigInteger
shop_id bigInteger
owner_id ^FK bigInteger
customer_id ^FK bigInteger
ratings double
feedback string (191)
timestamps timestamps
softDeletes softDeletes

products

id increments
user_id ^FK bigInteger
shop_id ^FK bigInteger
product_name string (191)
product_image string (191)
product_price double
product_description longText
product_quantity bigInteger
timestamps timestamps
softDeletes softDeletes

orders

id increments
professional_id ^FK bigInteger
shop_id ^FK bigInteger
owner_id ^FK bigInteger
customer_id ^FK bigInteger
email string (191)
phone_number bigInteger
shipping_address string (191)
order_status string (191)
timestamps timestamps
softDeletes softDeletes

order_items

id increments
order_id ^FK bigInteger
product_id ^FK bigInteger
product_name string (191)
product_image string (191)
product_description longText
timestamps timestamps
softDeletes softDeletes

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