Restaurant Trainning - Laravel Schema Designer

employees

id increments
name string (50)
role_id ^FK integer
nid string
phone string
photo string
status boolean
password string
timestamps timestamps

roles

id increments
name string (50)
permissions text

users

id increments
name string (100)
phone string
address string
timestamps timestamps

categories

id increments
name string
status boolean
icon string
timestamps timestamps

attributes

id increments
name string
timestamps timestamps
status boolean

options

id increments
name string
product_id ^FK integer
attribute_id ^FK integer
price string
status boolean
timestamps timestamps

products

id increments
timestamps timestamps
name string (50)
description text
picture string
price string
status boolean
discount string
category_id ^FK integer

zones

id increments
timestamps timestamps
name string
price string

deliveries

id increments
type enum
name string
phone string
nid string
timestamps timestamps

order

id increments
Invoice_number string
type enum
taxes string
discount string
total_price string
payment_type enum
emp_id ^FK integer
paid_status boolean
timestamps timestamps

tables

id increments
name string
status boolean
number_of_chairs string
timestamps timestamps

take_away_orders

id increments
timestamps timestamps
order_id ^FK integer
user_id ^FK integer

delivery_orders

id increments
order_id ^FK integer
user_id ^FK integer
emp_id ^FK integer
timestamps timestamps

inplace_orders

id increments
table_id ^FK integer
order_id ^FK integer
timestamps timestamps

order_products

id increments
order_id ^FK integer
product_id ^FK integer
quantity string
status enum

order_options

id increments
order_id ^FK integer
option_id ^FK integer

reports

id increments
timestamps timestamps

settings

id increments

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