sofra - Laravel Schema Designer

restaurants

id increments
timestamps timestamps
name string (255)
email string (255)
password string (100)
mobile integer
whatsApp integer
status tinyInteger
minimum_charge decimal (255)
delivery_cost decimal
region_id ^FK integer
image string (255)

cities

id increments
timestamps timestamps
name string (255)

regions

id increments
timestamps timestamps
name string (255)
city_id ^FK integer

items

timestamps timestamps
id increments
name string (255)
details string (255)
price decimal
price_after_offer decimal
image string (255)
duration_prepare integer
restaurant_id ^FK integer

reviews

id increments
user_id ^FK integer
resraurant_id ^FK integer
rating enum
comment string (255)
timestamps timestamps

offers

id increments
timestamps timestamps
restaurant_id ^FK integer
description text
image string (255)
start_at date
end_at date

orders

id increments
user_id ^FK integer
restaurant_id ^FK integer
address string (255)
state enum
order_number string (100)
payment_method enum
notes text
commission decimal
order_cost decimal
delivery_cost decimal
total decimal
timestamps timestamps

clients

timestamps timestamps
name string (100)
id increments
phone integer
email string (100)
password string

item_order

id increments
timestamps timestamps
item_id ^FK integer
order_id ^FK integer
quantity integer
special_order string (255)
price decimal

contacts

id increments
timestamps timestamps
name string (100)
email string
message text
type enum

categories

id increments
timestamps timestamps
name string (100)

category_restaurant

id increments
timestamps timestamps
restaurant_id ^FK integer
category_id ^FK integer

payments

id increments
timestamps timestamps
restaurant_id ^FK integer
note text
payment_method string (100)
payed decimal

notifications

id increments
timestamps timestamps
notificationtable_type string (255)
notificationtable_id integer
body text

settings

timestamps timestamps
id increments
about text

tokens

id increments
timestamps timestamps
tokentable_id integer
tokentable_type string (255)
body string (100)

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