Sofra - Laravel Schema Designer

restaurants

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string
phone string
district_id ^FK integer
pin_code string
api_token string
password string
image string
minimum_charge float
delivery_charge float
whats_app_number string
delivery_time integer
available enum
active boolean

cities

id increments
timestamps timestamps
softDeletes softDeletes
name string

districts

id increments
timestamps timestamps
softDeletes softDeletes
name string
city_id ^FK integer

categories

id increments
timestamps timestamps
softDeletes softDeletes
name string

products

id increments
timestamps timestamps
softDeletes softDeletes
name string
notes text
price float (8,2)
discount float
restaurant_id ^FK integer

categories_restaurants

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

orders

id increments
timestamps timestamps
softDeletes softDeletes
payment_method_id ^FK integer
notes text
address string
coast float
net float
commission float
status enum
restaurant_id ^FK integer
client_id ^FK integer
total double

products_orders

id increments
timestamps timestamps
softDeletes softDeletes
order_id ^FK integer
product_id ^FK integer
price float
quantity integer
note string

payment_methods

id increments
timestamps timestamps
softDeletes softDeletes
name string

transactions

id increments
timestamps timestamps
softDeletes softDeletes
restaurant_id ^FK integer
paid double
residual double

offers

id increments
timestamps timestamps
softDeletes softDeletes
image string
name string
description string
from date
restaurant_id ^FK integer
to date

clients

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string
phone string
password string
api_token string
pin_code string
image string
district_id ^FK integer
active boolean

reviews

id increments
timestamps timestamps
softDeletes softDeletes
status enum
restaurant_id ^FK integer
comment text
client_id ^FK integer

settings

id increments
timestamps timestamps
softDeletes softDeletes
about_app text
about_us text
phone string
commission integer
bank_name string
bank_account string

contacts

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string
phone string
message string
type enum

notifications

id increments
timestamps timestamps
softDeletes softDeletes
title string
content text
order_id ^FK integer
notifable_id integer
notifable_type string

tokens

id increments
timestamps timestamps
softDeletes softDeletes
token string
type enum
client_id ^FK integer

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