Home
sofra
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
restaurants
id
increments
timestamps
timestamps
name
string
(255)
email
string
(255)
password
string
(100)
mobile
integer
whatsApp
integer
status
tinyInteger
minimum_charge
decimal
(255)
delivery_cost
decimal
region_id
FK
integer
image
string
(255)
cities
id
increments
timestamps
timestamps
name
string
(255)
regions
id
increments
timestamps
timestamps
name
string
(255)
city_id
FK
integer
items
timestamps
timestamps
id
increments
name
string
(255)
details
string
(255)
price
decimal
price_after_offer
decimal
image
string
(255)
duration_prepare
integer
restaurant_id
FK
integer
reviews
id
increments
user_id
FK
integer
resraurant_id
FK
integer
rating
enum
comment
string
(255)
timestamps
timestamps
offers
id
increments
timestamps
timestamps
restaurant_id
FK
integer
description
text
image
string
(255)
start_at
date
end_at
date
orders
id
increments
user_id
FK
integer
restaurant_id
FK
integer
address
string
(255)
state
enum
order_number
string
(100)
payment_method
enum
notes
text
commission
decimal
order_cost
decimal
delivery_cost
decimal
total
decimal
timestamps
timestamps
clients
timestamps
timestamps
name
string
(100)
id
increments
phone
integer
email
string
(100)
password
string
item_order
id
increments
timestamps
timestamps
item_id
FK
integer
order_id
FK
integer
quantity
integer
special_order
string
(255)
price
decimal
contacts
id
increments
timestamps
timestamps
name
string
(100)
email
string
message
text
type
enum
categories
id
increments
timestamps
timestamps
name
string
(100)
category_restaurant
id
increments
timestamps
timestamps
restaurant_id
FK
integer
category_id
FK
integer
payments
id
increments
timestamps
timestamps
restaurant_id
FK
integer
note
text
payment_method
string
(100)
payed
decimal
notifications
id
increments
timestamps
timestamps
notificationtable_type
string
(255)
notificationtable_id
integer
body
text
settings
timestamps
timestamps
id
increments
about
text
tokens
id
increments
timestamps
timestamps
tokentable_id
integer
tokentable_type
string
(255)
body
string
(100)
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01