Home
Sofra
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
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
×
Comments for Sofra
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01