Home
lena
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
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
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01