stores - Laravel Schema Designer

clients

id increments
timestamps timestamps
name string
phone string
email string
password string
type enum
image string

contacts

id increments
timestamps timestamps
body text
client_id ^FK integer

notifications

id increments
timestamps timestamps
title string
body text
type enum
client_id ^FK integer

reviews

id increments
timestamps timestamps
rating enum
comment text
client_id ^FK integer
store_id ^FK integer

messages

id increments
timestamps timestamps
body text
sender_id integer
receiver_id integer

settings

id increments
timestamps timestamps
phone string
email string

questions

id increments
timestamps timestamps
question_ar string
question_en string
type enum

answers

id increments
timestamps timestamps
answer_ar text
answer_en text
type enum
question_id ^FK integer

carts

id increments
timestamps timestamps
product_id ^FK integer
client_id integer

products

id increments
timestamps timestamps
name_ar string
name_en string
image string
price string
discount string
is_active boolean
colour string
size string
description_ar text
description_en text
quantity integer
offer_duration string
state enum
available_quantity string
store_id ^FK integer

stores

id increments
timestamps timestamps
name_ar string
name_en string
type_ar string
type_en string
description_ar string
description_en string
link string
is_approved boolean
lat double
lng double
client_id ^FK integer

countries

id increments
timestamps timestamps
name_ar string
name_en string

cities

id increments
timestamps timestamps
name_ar string
name_en string
country_id ^FK integer

offers

id increments
timestamps timestamps

categories

id increments
timestamps timestamps
name_ar string
name_en string
image string

regions

id increments
timestamps timestamps
name_ar string
name_en string
city_id ^FK integer

user_addresses

id increments
timestamps timestamps
first_name string
family_name string
floor_number string
charge_note text
client_id ^FK integer
region_id ^FK integer

client_product

id increments
timestamps timestamps
client_id ^FK integer
product_id ^FK integer

client_store

id increments
timestamps timestamps
client_id ^FK integer
store_id ^FK integer

payment_methods

id increments
timestamps timestamps
name_ar string
name_en string

orders

id increments
timestamps timestamps
state_ar string
state_en string
sub_cost string
charge_fees string
total_price string
commission double
net_price string
client_id ^FK integer
store_id ^FK integer
coupon_id ^FK integer
payment_method_id ^FK integer

coupons

id increments
timestamps timestamps
code string
expiry_date date

order_product

id increments
timestamps timestamps
order_id ^FK integer
product_id ^FK integer
price string

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