elemandental - Laravel Schema Designer

users

id increments
timestamps timestamps
first_name string (255)
last_name string (255)
password string
phone string
email string
city_id ^FK integer
status tinyInteger
softDeletes softDeletes
code string
image string
api_token string

cities

id increments
timestamps timestamps
status tinyInteger
shipping_fess integer

brand

id increments
timestamps timestamps
status tinyInteger
image string

cities_translations

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

brand_translations

id increments
brand_id ^FK integer
timestamps timestamps
locale string
name string
title string
alt string
description string
description_meta string
keywords string
keywords_meta string

products

id increments
timestamps timestamps
category_id ^FK integer
brand_id ^FK integer
price float
image string
quantity integer
seq tinyInteger
status tinyInteger

categories

id increments
timestamps timestamps
image string
status tinyInteger

category_translations

id increments
category_id ^FK integer
timestamps timestamps
locale string
name string
title string
alt string
description string
description_meta string (2500)
keywords string
keywords_meta string

product_translations

id increments
product_id ^FK integer
timestamps timestamps
locale string
name string
title string
alt string
description string (2500)
description_meta string
keywords string
keywords_meta string

admins

id increments
timestamps timestamps
name string
email string
password string

banners

id increments
timestamps timestamps
image string
url string
status tinyInteger

banner_translations

id increments
timestamps timestamps
banner_id ^FK integer
locale string
alt string

cart_items

id increments
timestamps timestamps
product_id ^FK integer
price float
quantity integer
user_id ^FK integer
order_id integer

orders

id increments
timestamps timestamps
shipping integer
total float
payment_id ^FK integer
address_id integer
status tinyInteger

user_addresses

id increments
timestamps timestamps
city_id ^FK integer
street string
building string
floor string
apartment string
user_id ^FK integer

payments

id increments
timestamps timestamps
status tinyInteger

payment_translations

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

product_images

id increments
timestamps timestamps
product_id ^FK integer
image string
alt string

settings

id increments
timestamps timestamps
location_one string
location_two string
src_one string
src_two string
email string
phone_one string
phone_two string
whatsapp string
facebook string
instagram string
youtube string
twitter string
free_shipping integer

setting_transaltions

id increments
setting_id ^FK integer
timestamps timestamps
address_one string
address_two string
locale string
logo_alt string
about_us string
keywords string
privacy string
terms string

contacts

id increments
timestamps timestamps
name string
email string
message string
status tinyInteger

achievements

id increments
timestamps timestamps
image string
value bigInteger

achievement_translations

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

events

id increments
timestamps timestamps
image string
date date
status tinyInteger

event_translations

id increments
timestamps timestamps
event_id ^FK integer
locale string
name string
location string
description string

customer_reviews

id increments
timestamps timestamps
name string
review string
image string

event_images

id increments
timestamps timestamps
event_id ^FK integer
image string
alt string

certificates

id increments
timestamps timestamps
image string
status tinyInteger

certificates_translations

id increments
timestamps timestamps
certificate_id ^FK integer
locale string
alt string