sofra - Laravel Schema Designer

restaurants

id increments
timestamps timestamps
name string
email string
phone integer
password string
minimum decimal
delivery decimal
image string
neighborhood_id ^FK integer
state enum
api_token string
whats_app integer
restaurant_phone integer
pin_code integer

clients

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

products

id increments
timestamps timestamps
name string
description longText
price decimal
offer decimal
image string
time string
restaurant_id ^FK integer

settings

id increments
timestamps timestamps
phone integer
email string
text longText
content longText
image string
whats_app string
instagram string
you_tube string
twitter string
facebook string
max_credit decimal
commission decimal

contacts

id increments
timestamps timestamps
name string
email string
phone integer
message longText
type enum

comments

id increments
timestamps timestamps
comment longText
evaluate enum
client_id ^FK integer
restaurant_id ^FK integer

cities

id increments
timestamps timestamps
name string

neighborhoods

id increments
timestamps timestamps
name string
city_id ^FK integer

offers

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

categories

id increments
timestamps timestamps
name string

category_restaurant

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

notifications

id increments
timestamps timestamps
title string
body longText
order_id ^FK integer
action enum
notifiiable_id integer
notifiiable_type string

orders

id increments
timestamps timestamps
note longText
state enum
restaurant_id ^FK integer
client_id ^FK integer
price decimal
delivery decimal
commission decimal
total decimal
address string
payment_method_id ^FK integer

payments

id increments
timestamps timestamps
restaurant_id ^FK integer
note string
amount string

payment_methods

id increments
timestamps timestamps
name string

order_product

id increments
timestamps timestamps
product_id ^FK integer
order_id ^FK integer
qty string
note string
price decimal

tokens

id increments
timestamps timestamps
token string
type enum
tokenable_id integer
tokenable_type string

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