sofra - Laravel Schema Designer

clients

id increments
timestamps timestamps
name string
email string
neighborhood_id ^FK integer
password string
pin_code string

resturants

id increments
timestamps timestamps
name string
email string
phone string
neighborhood_id ^FK integer
password string
minimum double
delivery_fees double
whatsapp string

orders

id increments
timestamps timestamps
client_id ^FK integer
note text
price double
total_price double
payment_method string
delivery_fees double
address string
status enum
resturant_id ^FK integer

meals

id increments
timestamps timestamps
name string
price double
description text
image string
price_in_offer double
is_offer tinyInteger

cities

id increments
timestamps timestamps
name string

neighborhoods

id increments
timestamps timestamps
name string
city_id ^FK integer

classifications

id increments
timestamps timestamps
name string

categories

id increments
timestamps timestamps
name string

contacts

id increments
timestamps timestamps
name string
email string
address string
message string
type enum

payments

id increments
timestamps timestamps
resturant_id ^FK integer
amount double
note text
date datetime

notifications

id increments
timestamps timestamps
is_read tinyInteger
title string
content text
user morphs

classfication_resturant

id increments
timestamps timestamps
classification_id ^FK integer
resturant_id ^FK integer

category_resturant

id increments
timestamps timestamps
category_id ^FK integer
resturant_id ^FK integer

reviews

id increments
timestamps timestamps
resturant_id ^FK integer
comment text
client_id ^FK integer
rate enum

client_notification

id increments
timestamps timestamps

offers

id increments
timestamps timestamps
meal_id ^FK integer
offer string
offer_from string
date_to datetime
title string
description text

tokens

id increments
timestamps timestamps
user morphs
type string
token string

meal_order

id increments
timestamps timestamps
meal_id ^FK integer
order_id ^FK integer

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