Sofra - Laravel Schema Designer

clients

id increments
timestamps timestamps
name string (255)
email string (255)
phone string (255)
district_id ^FK integer
password string (255)
pin_code string (255)
remember_token string (255)
api_token string (255)

cities

id increments
timestamps timestamps
name string (255)

districts

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

restaurants

id increments
timestamps timestamps
name string (255)
email string (255)
phone string (255)
district_id ^FK integer
password string (255)
type_id ^FK integer
min_price decimal (8,2)
max_price double (8,2)
delivery_cost decimal (8,2)
whatsapp string (255)
restaurant_phone string
status enum
pin_code string
api_token string (255)
remember_token string

categories

id increments
timestamps timestamps
name string (255)

products

id increments
timestamps timestamps
name string (255)
price decimal (8,2)
offer_price decimal (8,2)
time integer
description text
pic string (255)
category_id ^FK integer
restaurant_id ^FK integer

restaurants_types

id increments
timestamps timestamps
name string (255)

orders

id increments
timestamps timestamps
address string (255)
total decimal (8,2)
commission decimal (8,2)
payment_method enum
delivery_cost double (8,2)
cost double (8,2)
status enum
net double (8,2)
restaurant_id ^FK integer
client_id ^FK integer

order_product

id increments
timestamps timestamps
order_id ^FK integer
product_id ^FK integer
price decimal (8,2)
quantity smallInteger
note text

payment

id increments
timestamps timestamps
restaurant_sales integer
app_commission integer
paid_money decimal (8,2)
rest_of_money decimal (8,2)
notes text
date date
restaurant_id ^FK integer

reviews

id increments
timestamps timestamps
comment string (255)
rating tinyInteger
client_id ^FK integer
restaurant_id ^FK integer

offers

id increments
timestamps timestamps
name string (255)
discount integer
from datetime
to datetime
restaurant_id ^FK integer
pic string (255)

notifications

id increments
timestamps timestamps
title string (255)
content string (255)
notifiable_id integer
notifiable_type enum

contacts

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

settings

id increments
timestamps timestamps
about_us text
app_commission integer
alahly_account_num smallInteger
raghy_account_num smallInteger
account_name string (255)

tokens

id increments
timestamps timestamps
token string (255)
type enum
tokenable_id integer
tokenable_type enum

clientables

id increments
timestamps timestamps
client_id integer
clientable_id integer
clientable_type string

restaurantables

id increments
timestamps timestamps
restaurant_id integer
restaurantable_id integer
restaurantable_type string

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