Home
resturant
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
customers
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
email
string
password
string
phone_number
string
address
string
provider_id
string
provider
string
is_active_phone
integer
latitude
text
longitude
text
menu_sections
id
increments
timestamps
timestamps
name
string
resturant_id
FK
integer
menu_items
id
increments
timestamps
timestamps
menu_section_id
FK
integer
name
string
description
text
price
decimal
resturant_id
FK
integer
orders
id
increments
timestamps
timestamps
customer_id
FK
integer
order_status
integer
notes
text
total_cost
decimal
resturant_id
FK
integer
payment_way_id
FK
integer
pick_time
time
coupon_code
string
resturant_tables
id
increments
timestamps
timestamps
table_number
integer
size
integer
table_status
integer
region_id
FK
integer
resturant_id
FK
integer
resturant_regions
id
increments
timestamps
timestamps
name
string
order_item
id
increments
timestamps
timestamps
menu_item_id
FK
integer
order_id
FK
integer
quantity
integer
price
decimal
size
json
type
json
saus
json
resturants
id
increments
timestamps
timestamps
name
string
address
text
work_hours
string
vat
integer
type
integer
delivery_fee
decimal
minimum_order
decimal
delivery_time
string
latitude
text
longitude
text
country_id
FK
integer
city_id
FK
integer
reservations
id
increments
timestamps
timestamps
customer_id
FK
integer
resturant_table_id
FK
integer
reservation_status
integer
employees
id
increments
timestamps
timestamps
name
string
email
string
phone_number
string
password
string
national_number
string
region_id
FK
integer
resturant_section_id
FK
integer
resturant_id
FK
integer
resturant_sections
id
increments
timestamps
timestamps
name
string
resturant_id
FK
integer
shifts
id
increments
timestamps
timestamps
from_time
time
to_time
time
resturant_id
FK
integer
employee_shift
id
increments
timestamps
timestamps
employee_id
FK
integer
shift_id
FK
integer
admins
id
increments
timestamps
timestamps
name
string
password
string
resturant_id
FK
integer
attendances
id
increments
timestamps
timestamps
employee_id
FK
integer
attendance_time
time
checkout_time
time
resturant_id
FK
integer
reviews
id
increments
timestamps
timestamps
resturant_customer_id
FK
integer
comment
text
rate
integer
type
integer
resturant_id
FK
integer
employee_performances
id
increments
timestamps
timestamps
employee_id
FK
integer
notes
string
evaluation_date
date
rate
decimal
evaluation_type
integer
resturant_id
FK
integer
payment_ways
id
increments
timestamps
timestamps
name
string
resturant_id
FK
integer
payment_transactions
id
increments
payment_way_id
FK
integer
customer_id
FK
integer
timestamps
timestamps
order_id
FK
integer
amount
decimal
resturant_id
FK
integer
coupons
id
increments
timestamps
timestamps
code
string
discount
decimal
expire_in
date
active_in
date
promotions
id
increments
timestamps
timestamps
title
string
description
text
menu_item_id
FK
integer
active_in
date
expire_in
date
discount
integer
resturant_id
FK
integer
delivery_reviews
id
increments
timestamps
timestamps
customer_id
FK
integer
order_id
FK
integer
comment
text
rate
integer
deliveries
id
increments
timestamps
timestamps
start_at
timestamp
end_at
timestamp
delivery_status
integer
employee_id
FK
integer
employee_latitude
text
employee_longitude
text
order_id
FK
integer
resturant_id
FK
integer
delivery_routes
id
increments
timestamps
timestamps
delivery_id
FK
integer
delivery_fee
decimal
start_latitude
text
start_longitude
text
end_latitude
text
end_longitude
text
duration
string
order_invoices
id
increments
timestamps
timestamps
softDeletes
softDeletes
order_id
FK
integer
total_cost
decimal
delivery_fee
decimal
resturant_vat
integer
resturant_id
FK
integer
activation_processes
id
increments
timestamps
timestamps
phone_number
string
code
string
status
integer
carts
id
increments
timestamps
timestamps
total_price
decimal
customer_id
FK
integer
notes
longText
resturant_id
FK
integer
service
integer
cart_menu_item
id
increments
timestamps
timestamps
cart_id
FK
integer
menu_item_id
FK
integer
quantity
integer
price
decimal
special_instructions
text
saus
json
size
json
type
json
meal_attributes
id
increments
timestamps
timestamps
resturant_id
FK
integer
menu_item_id
FK
integer
type
integer
price
decimal
offer_price
decimal
name
string
countries
id
increments
timestamps
timestamps
name
string
cities
id
increments
timestamps
timestamps
name
string
customer_resturant
id
increments
timestamps
timestamps
customer_id
FK
integer
resturant_id
FK
integer
delivery_addresses
id
increments
timestamps
timestamps
house_number
string
postcode
string
city
string
company_name
string
notes
text
order_id
FK
integer
×
Comments for resturant
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01