sofra - Laravel Schema Designer

restaurants

id increments
timestamps timestamps
logo string
images string
name string
email string
password string
phone_number string
whatsapp_number string
description text
min_order_amount decimal
delivery_fee decimal
rating decimal (3,2)
open_time time
close_time time
location string
is_active boolean
city_id ^FK integer
category_id ^FK integer

menu_items

id increments
timestamps timestamps
title string
image string
description text
preparation_time integer
price decimal
restaurant_id ^FK integer

reviews

id increments
timestamps timestamps
rating decimal (3,2)
comment text
user_id ^FK integer
restaurant_id ^FK integer

governorates

id increments
timestamps timestamps
name string

cities

id increments
timestamps timestamps
name string
governorate_id ^FK integer

orders

id increments
timestamps timestamps
order_number string
total_price decimal
status enum
address string
note text
delivery_fee decimal
grand_total decimal
payment_method enum
user_id ^FK integer
restaurant_id ^FK integer

order_items

id increments
timestamps timestamps
quantity integer
price decimal
special_request text
order_id ^FK integer
menu_item_id ^FK integer

contacts

id increments
timestamps timestamps
name string
email string
phone string
content text
type enum

app_info

id increments
timestamps timestamps
app_name string
description text

offers

id increments
timestamps timestamps
title string
image string
description text
discount decimal
start_date date
end_date date
is_active boolean
restaurant_id ^FK integer

carts

id increments
timestamps timestamps
quantity integer
menu_item_id ^FK integer
user_id ^FK integer

users

id increments
timestamps timestamps
avatar string
name string
email string
password string
phone_number string
city_id ^FK integer

payments

id increments
timestamps timestamps
payment_method enum
transaction_id string
status enum
order_id ^FK integer

categories

id increments
timestamps timestamps
name string

commissions

id increments
timestamps timestamps
total_sales decimal
commission_fee decimal
amount_paid decimal
remaining_due decimal
transfer_reference string
note text
restaurant_id ^FK integer

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