orderfo - Laravel Schema Designer

users

id increments
timestamps timestamps
fname string
lname string
email string
phone string
is_active_email boolean
is_active_phone boolean
password string

areas

id increments
timestamps timestamps
governorate_id ^FK integer

governorates

id increments
timestamps timestamps

sliders

id increments
timestamps timestamps
resturant_id ^FK integer

resturants

id increments
timestamps timestamps
latitude text
longitude text
open_to time
open_from time
minimum_order decimal
delivery_fee decimal
delivery_time string
description text
vat integer
category_id ^FK integer
address string

categories

id increments
timestamps timestamps

activation_processes

id increments
timestamps timestamps
user_id ^FK integer
code string
status integer
type integer

meals

id increments
timestamps timestamps
resturant_id ^FK integer

meal_attributes

id increments
timestamps timestamps
meal_id ^FK integer
type integer
price decimal
offer_price decimal

resturant_user

id increments
timestamps timestamps
user_id ^FK integer
resturant_id ^FK integer

reviews

id increments
timestamps timestamps
user_id ^FK integer
comment text
resturant_id ^FK integer
order_packaging decimal
delivery_time decimal
value_of_money decimal

addresses

id increments
timestamps timestamps
street string
latitude text
longitude text
area_id ^FK integer
name string
building string
additional_directions string

carts

id increments
timestamps timestamps
user_id ^FK integer
total_price decimal

cart_items

id increments
timestamps timestamps
meal_id ^FK integer
size json
option json
extras json
meal_price decimal
quantity string
special_instructions text
cart_id ^FK integer

orders

id increments
timestamps timestamps
user_id ^FK integer
resturant_id ^FK integer
subtotal decimal
total_cost decimal
payment_status integer
payment_way string
address_id ^FK integer
delivery_fee decimal
delivery_time string
order_status integer
vat string

meal_order

id increments
timestamps timestamps
meal_id ^FK integer
order_id ^FK integer
size json
option json
extras json
special_instructions text
quantity string
meal_price decimal

governorate_translations

id increments
timestamps timestamps
governorate_id ^FK integer
name string
locale string

area_translations

id increments
timestamps timestamps
area_id ^FK integer
name string
locale string

slider_translations

id increments
timestamps timestamps
slider_id ^FK integer
text text
locale string

category_translations

id increments
timestamps timestamps
category_id ^FK integer
name string
locale string

meal_translations

id increments
timestamps timestamps
meal_id ^FK integer
name string
description text
locale string

meal_attribute_translations

id increments
timestamps timestamps
meal_attribute_id ^FK integer
name string
locale string

resturant_translations

id increments
timestamps timestamps
resturant_id ^FK integer
name string
locale string

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