sofraa - Laravel Schema Designer

clients

id increments
name string
phone string
email string
password string
timestamps timestamps

resturants

id increments
name string
email string
phone string
password string
minmum_order integer
delivery_fee integer
communication_phone string
whats_up string
resturant_image string
status enum
city_id ^FK integer
neighborhood_id ^FK integer
timestamps timestamps

categories

id increments
name string
timestamps timestamps

comments

id increments
emoji enum
content text
client_id ^FK integer
resturant_id ^FK integer
timestamps timestamps

foods

id increments
food_image string
name string
description text
price integer
timeReady time
timestamps timestamps

carts

id increments
total_price integer
client_id ^FK integer
resturant_id ^FK integer
timestamps timestamps

orders

id increments
payment enum
total_price integer
delivery_address string
note text
no_order integer
status enum
resturant_id ^FK integer
food_id ^FK integer
timestamps timestamps

contact

id increments
full_name string
email string
phone string
content text
type enum
timestamps timestamps

config

id increments
account_bank string
account_bank2 string
text text
timestamps timestamps

commissions

id increments
total_food_price integer
commission_application integer
commission_received integer
commission_left integer
resturant_id ^FK integer
timestamps timestamps

cities

id increments
name string
timestamps timestamps

neighborhoods

id increments
name string
city_id ^FK integer
timestamps timestamps

offers

id increments
name string
cotent text
price_with_offer integer
from date
to date
resturant_id ^FK integer
food_id ^FK integer
timestamps timestamps

client_neighborhood

id increments
timestamps timestamps
client_id ^FK integer
neighborhood_id ^FK integer

food_resturant

id increments
food_id ^FK integer
resturant_id ^FK integer
timestamps timestamps

city_client

id increments
client_id ^FK integer
city_id ^FK integer
timestamps timestamps

category_resturant

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

cart_food

id increments
timestamps timestamps
cart_id ^FK integer
food_id ^FK integer

client_order

id increments
client_id ^FK integer
order_id ^FK integer
timestamps timestamps

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