Restaurant app - Laravel Schema Designer

plates

id increments
timestamps timestamps
name string (255)
description text
category_id bigInteger
image string (255)
active boolean
quantity integer
weight string (255)
restaurant_id ^FK bigInteger

categories

id increments
timestamps timestamps
name string (255)
image string (255)
active boolean
parent_id ^FK bigInteger
restaurant_id ^FK bigInteger

orders

id increments
timestamps timestamps
status enum
payment_status enum
name string (255)
person_quantity integer
people_for_quantity integer
is_takeaway boolean
is_online_payment boolean
restaurant_id ^FK bigInteger
client_id ^FK bigInteger

tables

id increments
timestamps timestamps
name string (255)
restaurant_id ^FK bigInteger

order_plates

timestamps timestamps
order_id ^FK bigInteger
plate_id ^FK bigInteger
amount integer
comment text

ingredients

id increments
timestamps timestamps
name string (255)
price float (8,2)
category_id ^FK bigInteger
active boolean

removable_ingredients

id increments
timestamps timestamps
name string (255)
plate_id ^FK bigInteger

plate_ingredients

timestamps timestamps
order_id ^FK bigInteger
plate_id ^FK bigInteger
ingredient_id ^FK bigInteger

plate_removable_ingredients

timestamps timestamps
order_id ^FK bigInteger
removable_ingredient_id ^FK bigInteger

users

id increments
timestamps timestamps
restaurant_id ^FK bigInteger
name string (255)
lastname string (255)
email string (255)
password string (255)
role enum
image string (255)
verified_at timestamp

restaurants

id increments
timestamps timestamps
name string (255)
address string (255)
phone string (255)
logo string (255)
slug string (255)

clients

id increments
timestamps timestamps
name string (255)
email string (255)
phone string (255)
password string (255)
verified_at timestamp
payment_method enum

cards

id increments
timestamps timestamps
client_id ^FK bigInteger
name string (255)
number string (255)
cvv string (255)
expiration_date date
default boolean

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