lena - Laravel Schema Designer

users

id increments
first_name string (255)
last_name string
phone string
company_name string
address_company string
birth_date date
type integer
email string (255)
password string (255)
image string (255)
is_notification integer
is_notify_chat integer
timestamps timestamps

suppliers

id increments
name_ar_company string
name_en_company string
type_work string
created_year integer
num_employees string
place_company string
descr_ar longText
descr_en longText
commerical_guarantee integer
quality_sup integer
shipping_specific_date integer
promotion_sup_id ^FK integer
job_title string
phone string
tel string
fax string
address string
postal_code string
approve integer
category_id ^FK integer
country_id ^FK integer
city_id ^FK integer
town_id ^FK integer
user_id ^FK integer
timestamps timestamps

categories

id increments
name_ar string (255)
name_en string (255)
parent_id ^FK integer
type integer
image string (255)
timestamps timestamps

images

id increments
image string (255)
ref_id integer
is_primary integer
ref_type string (255)
timestamps timestamps

products

id increments
name_ar string (255)
name_en string (255)
descr_ar string (255)
descr_en string (255)
min_orders string
price double
discount_price string
qty integer
category_id ^FK integer
supplier_id ^FK integer
commerical_guarantee integer
quality_pro integer
shipping_specific_date integer
unit_pro string
ready_ship integer
sale_end date
like_pro integer
timestamps timestamps

coupons

id increments
ratio string (255)
code string (255)
expired_at date
supplier_id ^FK integer
timestamps timestamps

messages

id increments
sender_id integer
receiver_id integer
read_at integer
content string (255)
timestamps timestamps

users_addresses

id increments
fullname string
note string
is_address integer
phone string (255)
postal_code integer
country_id ^FK integer
city_id ^FK integer
town_id ^FK integer
user_id ^FK integer
timestamps timestamps

cart

id increments
qty integer
price integer
product_id ^FK integer
user_id ^FK integer
marterial_pro_attr_id ^FK integer
timestamps timestamps

countries

id increments
name_ar string
name_en string
timestamps timestamps

cities

id increments
country_id ^FK integer
name_ar string (255)
name_en string (255)
timestamps timestamps
charge_value integer
delivery_value integer

settings

id increments
key string (255)
neckname string (255)
value mediumText
orderby smallInteger
timestamps timestamps

contact_us

id increments
name string (255)
email string (255)
content string (255)
timestamps timestamps

favourites

id increments
ref_id integer
ref_type string (255)
user_id ^FK integer
timestamps timestamps

bank_accounts

id increments
name_ar string (255)
name_en string (255)
image string (255)
account_number bigInteger
ibn_number integer
timestamps timestamps

payment_details

id increments
image string (255)
user_id ^FK integer
bank_account_id ^FK integer
coupon_id ^FK integer
payment_type_id ^FK integer
timestamps timestamps
address_id ^FK integer

notifications

id char
type string (255)
notifiable_type string (255)
notifiable_id bigInteger
data text
msg_id integer
read integer
read_at timestamp
timestamps timestamps

ratings

id increments
degree string
comment string (255)
ref_id integer
ref_type string (255)
user_id ^FK integer
timestamps timestamps

asks

id increments
ask_ar string (255)
ask_en string (255)
answer_ar string
timestamps timestamps
answer_en string

product_attribute

id increments
material_ar string
material_en string (255)
product_id ^FK integer
timestamps timestamps

order_product

id increments
qty string (255)
price string
order_id ^FK integer
product_id ^FK integer
material_pro_attr_id ^FK integer
timestamps timestamps

orders

id increments
user_id ^FK integer
address_id ^FK integer
supplier_id ^FK integer
status_id ^FK integer
coupon_id ^FK integer
payment_id ^FK integer
timestamps timestamps
number_charge integer

order_status

id increments
status_ar string (255)
status_en string (255)
timestamps timestamps

payment_types

id increments
name_ar string (255)
name_en string (255)
timestamps timestamps

sliders

id increments
descr_ar longText
descr_en longText
image string (255)
ref_id integer
ref_type string (255)
type integer
place_slider string
timestamps timestamps

towns

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

device_tokens_users

id increments
device_token longText
platform_type string
device_id string
user_id ^FK integer
timestamps timestamps

password_resets

email string
token string
timestamps timestamps

product_properties

id increments
product_id ^FK integer
property_name_ar string
property_value_ar string
property_name_en string
property_value_en string
timestamps timestamps

promotion_supplier

id increments
name_ar string
name_en string
descr_ar string
descr_en string
price string
icon string
time_supscripe string
timestamps timestamps

certificates

id increments
timestamps timestamps
name_ar string
name_en string
image string

supp_certificates

id increments
supplier_id ^FK integer
certificate_id ^FK integer
timestamps timestamps

news

id increments
title_ar string
title_en string
descr_ar longText
descr_en string
image string
timestamps timestamps

delivery_methods

id increments
name_ar string
name_en string
price string
image string
timestamps timestamps

payment_card

id increments
timestamps timestamps
user_id ^FK integer
name string
num string
date string
cvv string
default_payment integer
payment_type_id ^FK integer

users_coupon

id increments
status integer
coupon_id ^FK integer
user_id ^FK integer
timestamps timestamps

result_search

id increments
keyword_searh string
user_id ^FK integer
timestamps timestamps

suppliers_properties

id increments
property_name_ar string
property_name_en string
property_value_ar string
property_value_en string
supplier_id ^FK integer
timestamps timestamps