Home
alamhona
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
product
id
increments
timestamps
timestamps
model
string
location
string
quantity
integer
stock_status_id
integer
image
string
shipping
tinyInteger
price
decimal
(15,4)
points
integer
tax_class_id
integer
date_available
date
weight
decimal
(8,4)
weight_class_id
integer
length
decimal
length_class_id
integer
width
float
height
decimal
minimum
integer
status
tinyInteger
viewed
integer
store_id
integer
supplier_id
integer
product_image
id
increments
timestamps
timestamps
image
string
sort_order
string
product_id
FK
integer
product_discount
id
increments
timestamps
timestamps
product_id
FK
integer
quantity
integer
priority
integer
price
decimal
(8,4)
partners
id
increments
timestamps
timestamps
name
string
(255)
owner_name
string
(250)
logo
string
(250)
country_id
integer
city_id
integer
address
string
(250)
id_photo
string
(250)
id_number
string
cer_photo
string
(250)
bank_photo
string
(250)
bank_account
string
(250)
cer_number
string
(250)
merketer_id
integer
partner_type_id
integer
shop_photo
string
(250)
owner_photo
string
(250)
partner_type
id
increments
timestamps
timestamps
title
string
(250)
tax_class
id
increments
timestamps
timestamps
tax_rate
id
increments
timestamps
timestamps
city_id
integer
name
string
(250)
rate
decimal
(8,4)
type
tinyInteger
tax_rule
id
increments
timestamps
timestamps
tax_class_id
integer
tax_rate_id
integer
priority
integer
weight_class
id
increments
timestamps
timestamps
value
decimal
(8,4)
length_class
id
increments
timestamps
timestamps
value
decimal
(8,4)
category
id
increments
timestamps
timestamps
image
string
(250)
parent_id
integer
sort_order
integer
product_category
id
increments
timestamps
timestamps
product_id
integer
category_id
integer
marketer
id
increments
timestamps
timestamps
name
string
(250)
photo
string
(250)
id_number
string
(250)
id_photo
string
(250)
qualification
string
(250)
bank_photo
string
(250)
bank_account
string
(250)
cv_url
string
(250)
nationality_id
integer
gender
tinyInteger
mobile
string
(250)
email
string
(250)
country_id
integer
city_id
integer
license_photo
string
(250)
license_no
string
(250)
car_type
string
(250)
from_company_id
integer
job_type_id
integer
from_companies
id
increments
timestamps
timestamps
title
string
(250)
job_type
id
increments
timestamps
timestamps
title
string
(250)
countries
id
increments
timestamps
timestamps
cities
id
increments
timestamps
timestamps
name
string
(250)
country_id
integer
nationality
id
increments
timestamps
timestamps
title
string
(250)
suppliers
id
increments
timestamps
timestamps
name
string
(250)
mobile
string
(250)
email
string
order
id
increments
timestamps
timestamps
invoice_no
string
(250)
parent_id
integer
customer_id
integer
comment
text
total
decimal
(15,4)
order_status_id
integer
commission
decimal
(15,4)
marketing_id
integer
currency_id
integer
captain_id
integer
shipping_address_id
FK
integer
marketing
id
increments
timestamps
timestamps
name
string
(250)
descreption
text
code
string
(250)
clicks
integer
currency
id
increments
timestamps
timestamps
code
string
(250)
symbol_left
string
(250)
symbol_right
string
(250)
value
decimal
(15,4)
status
integer
order_product
id
increments
timestamps
timestamps
order_id
integer
product_id
integer
name
string
(250)
model
string
(250)
quantity
decimal
(15,4)
price
decimal
(15,4)
total
decimal
(15,4)
tax
decimal
(15,4)
reward
integer
shipping_courier
id
increments
timestamps
timestamps
code
string
(250)
name
string
(250)
order_shipment
id
increments
timestamps
timestamps
order_id
integer
shipping_courier_id
integer
tracking_number
string
(250)
cart
id
increments
timestamps
timestamps
customer_id
integer
product_id
integer
option
text
quantity
decimal
(15,4)
convention
id
increments
timestamps
timestamps
name
string
(250)
url
string
(250)
faculty_id
FK
integer
type
string
copy_no
integer
university_id
integer
university_boss
string
(250)
faculty_dean
string
(250)
date
date
send_email
tinyInteger
target
string
(250)
details
text
convention_marketer
id
increments
timestamps
timestamps
convention_id
integer
marketer_id
integer
company
string
(250)
status
integer
users
id
increments
timestamps
timestamps
name
string
(250)
email
string
(250)
mobile
string
(250)
password
string
(250)
photo
string
(250)
userable_id
integer
userable_type
string
(250)
remember_token
string
(250)
evaluations
id
increments
timestamps
timestamps
parent_id
integer
user_id
integer
rate
string
(250)
comment
string
(250)
wallet
id
increments
timestamps
timestamps
closeing
decimal
(15,4)
closeing_time
datetime
opening
decimal
(15,4)
owner
integer
user_id
integer
stores
id
increments
timestamps
timestamps
name
string
(250)
country_id
integer
city_id
integer
logo
string
(250)
partner_id
integer
press
id
increments
timestamps
timestamps
name
string
(250)
country_id
integer
city_id
integer
logo
string
(250)
address
string
(250)
partner_id
integer
license_photo
string
(250)
license_no
string
(250)
bank_account
string
(250)
marketer_id
integer
user_id
integer
r_name
string
r_job
string
(250)
r_email
string
(250)
r_mobile
string
(250)
r_country_id
integer
r_city_id
integer
r_address
string
(250)
press_orders
id
increments
timestamps
timestamps
user_id
integer
total
decimal
(15,4)
commission
decimal
(15,4)
order_status_id
integer
currency_id
integer
comment
string
(500)
press_id
integer
captain_id
integer
press_orders_files
id
increments
timestamps
timestamps
name
string
(250)
url
string
(250)
file_type_id
string
press_order_id
integer
file_type
id
increments
timestamps
timestamps
name
string
(250)
ads
id
increments
timestamps
timestamps
length
integer
date
date
width
integer
partner_id
integer
type
tinyInteger
image
string
(250)
video_url
string
(255)
period
integer
video_title
string
image_title
string
(255)
show_count
integer
by_admin
tinyInteger
announce_marketer
id
increments
timestamps
timestamps
announce_id
integer
marketer_id
integer
clicked
integer
user_id
integer
date
date
macaddress
string
booking_type
id
increments
timestamps
timestamps
title
string
(250)
bookings
id
increments
timestamps
timestamps
title
string
(250)
country_id
integer
city_id
integer
address
string
(500)
logo
string
(250)
booking_type_id
integer
partner_id
integer
bookings_images
id
increments
timestamps
timestamps
booking_id
integer
image
string
(250)
bookings_attributes
id
increments
timestamps
timestamps
name
string
(250)
bookings_attribute_type_id
integer
is_reserved
tinyInteger
booking_attribute_type
id
increments
timestamps
timestamps
title
string
(250)
booking_attribute_images
id
increments
timestamps
timestamps
booking_attribute_id
integer
image
string
(250)
bookings_rent
id
increments
timestamps
timestamps
booking_attribute_type_id
integer
amount
decimal
(15,4)
from
date
to
date
reservation
id
increments
timestamps
timestamps
rent_id
integer
total
decimal
(15,4)
user_id
integer
trips
id
increments
timestamps
timestamps
from
string
(250)
to
string
(250)
date
date
amount
decimal
(15,4)
marketer_id
integer
user_id
integer
trip_type_id
integer
trip_types
id
increments
timestamps
timestamps
title
string
(250)
wallet_transactions
id
increments
timestamps
timestamps
wallet_iid
integer
from_user_id
integer
amout
decimal
(15,4)
charity
id
increments
timestamps
timestamps
name
string
(250)
country_id
integer
city_id
integer
address
string
(250)
bank_account
string
(250)
bank_photo
string
(250)
partner_id
integer
donation
id
increments
timestamps
timestamps
user_id
integer
charity_id
integer
amount
decimal
(15,4)
language
id
increments
timestamps
timestamps
name
string
(250)
code
string
(250)
product_translation
id
increments
timestamps
timestamps
product_id
FK
integer
name
string
(250)
descreption
text
tag
text
language_id
FK
integer
category_translation
id
increments
timestamps
timestamps
category_id
FK
integer
language_id
FK
integer
name
string
(250)
descreption
text
tax_class_trans
id
increments
timestamps
timestamps
title
string
(250)
descreption
text
tax_class_id
FK
integer
language_id
FK
integer
weight_class_trans
id
increments
timestamps
timestamps
weight_class_id
FK
integer
language_id
FK
integer
title
string
(250)
length_class_trans
id
increments
timestamps
timestamps
language_id
FK
integer
length_class_id
FK
integer
title
string
(250)
announce_translation
id
increments
timestamps
timestamps
announce_id
FK
integer
language_id
FK
integer
subject
string
(250)
subtitle
string
(250)
content
text
attribute
id
increments
timestamps
timestamps
sort_order
integer
attribute_translation
id
increments
timestamps
timestamps
attribute_id
FK
integer
name
string
(250)
language_id
FK
integer
product_attribute
id
increments
timestamps
timestamps
product_id
FK
integer
attribute_id
FK
integer
language_id
integer
text
text
brands
id
increments
timestamps
timestamps
image
string
(250)
brands_translation
id
increments
timestamps
timestamps
name
string
(250)
brand_id
FK
integer
language_id
FK
integer
product_rate
id
increments
timestamps
timestamps
rate
integer
title
string
(250)
descreption
text
user_id
FK
integer
product_id
FK
integer
address
id
increments
timestamps
timestamps
firstname
string
(250)
lastname
string
(250)
country_id
FK
integer
city_id
FK
integer
descreption
text
postno
string
(250)
mobile
string
(250)
user_id
FK
integer
order_status
id
increments
timestamps
timestamps
order_status_translation
id
increments
timestamps
timestamps
name
string
(250)
order_status_id
FK
integer
language_id
FK
integer
favourite
id
increments
timestamps
timestamps
product_id
FK
integer
user_id
FK
integer
copyrights
id
increments
timestamps
timestamps
termsconditions
text
propertyrights
text
license
text
liability
text
governinglaw
text
watched_product
id
increments
timestamps
timestamps
product_id
FK
integer
user_id
FK
integer
option
id
increments
timestamps
timestamps
type
string
(250)
sort_order
integer
option_translation
id
increments
timestamps
timestamps
option_id
FK
integer
language_id
FK
integer
name
string
(250)
product_option
id
increments
timestamps
timestamps
product_id
FK
integer
option_id
FK
integer
option_value
string
required
tinyInteger
option_value
id
increments
timestamps
timestamps
option_id
FK
integer
image
string
(250)
sort_order
integer
option_value_translation
id
increments
timestamps
timestamps
option_id
integer
option_value_id
integer
language_id
FK
integer
name
string
(250)
product_option_value
id
increments
timestamps
timestamps
product_option_id
integer
product_id
FK
integer
option_id
FK
integer
option_value_id
integer
quantity
integer
subtract
tinyInteger
price
decimal
(15,4)
price_prefix
string
(1)
points
integer
points_prefix
string
(1)
weight
decimal
(15,4)
weight_prefix
string
(1)
press_messages
id
increments
timestamps
timestamps
type
string
(250)
star
integer
sender_id
FK
integer
sender_name
string
(250)
subject
string
(250)
status
integer
press_id
FK
integer
description
text
marketer_id
FK
integer
press_partners
id
increments
timestamps
timestamps
store_id
FK
integer
from_date
date
to_date
date
press_id
FK
integer
press_visits
id
increments
timestamps
timestamps
marketer_id
integer
visit_date
datetime
reason
string
(250)
descreption
text
press_id
FK
integer
payment_method
id
increments
timestamps
timestamps
name
string
(250)
press_rating
id
increments
timestamps
timestamps
press_id
FK
integer
marketer_id
FK
integer
rate
integer
type
string
rating_items
id
increments
timestamps
timestamps
name
string
(250)
descreption
text
press_rating_items
id
increments
timestamps
timestamps
press_rate_id
FK
integer
rating_item_id
FK
integer
rate
integer
pages
id
increments
timestamps
timestamps
parent_id
integer
infooter
tinyInteger
inheader
tinyInteger
status
tinyInteger
pages_translation
id
increments
timestamps
timestamps
page_id
FK
integer
language_id
FK
integer
title
string
(250)
description
text
success_partners
id
increments
timestamps
timestamps
title
string
(250)
logo
string
(250)
car_type
id
increments
timestamps
timestamps
title
string
(250)
car_categories
id
increments
timestamps
timestamps
title
string
(250)
quals
id
increments
timestamps
timestamps
job
string
(250)
job_type_id
integer
qual_type_id
integer
university
string
(250)
faculty
string
(250)
graduate_year
string
(250)
photo
string
(250)
experience_years
string
(250)
cv
string
(250)
marketer_id
integer
statements
id
increments
timestamps
timestamps
side
string
(250)
target
text
marketer_id
FK
integer
selfie
id
increments
timestamps
timestamps
photo
string
(250)
marketer_id
FK
integer
qual_type
id
increments
timestamps
timestamps
title
string
(250)
warning
id
increments
timestamps
timestamps
text
text
marketer_id
FK
integer
gifts
id
increments
timestamps
timestamps
marketer_id
FK
integer
amount
decimal
(15,4)
date
date
pocket
id
increments
timestamps
timestamps
store
decimal
press
decimal
(15,4)
booking
decimal
(15,4)
ads
decimal
(15,4)
gifts
decimal
(15,4)
transfers
decimal
(15,4)
total
decimal
(15,4)
marketer_id
FK
integer
press_id
FK
integer
store_id
FK
integer
transferes
timestamps
timestamps
from_account
string
(250)
to_account
string
(250)
amount
decimal
(15,4)
posts
id
increments
timestamps
timestamps
marketer_id
FK
integer
facebook
integer
insta
integer
twitter
integer
snapchat
integer
others
integer
faculties
id
increments
timestamps
timestamps
faculty_no
string
faculties_trans
id
increments
timestamps
timestamps
name
string
(250)
visits
id
increments
timestamps
timestamps
visit_date
date
reason
string
(250)
descreption
text
university_id
integer
universities
id
increments
timestamps
timestamps
university_no
string
universities_trans
id
increments
timestamps
timestamps
name
string
(250)
services
id
increments
timestamps
timestamps
title
string
(250)
description
text
language_id
FK
integer
services_trans
id
increments
timestamps
timestamps
department
id
increments
timestamps
timestamps
department_trans
id
increments
timestamps
timestamps
department_id
FK
integer
language_id
FK
integer
title
string
(250)
complaint_proposal
id
increments
timestamps
timestamps
department_id
FK
integer
type
integer
subject
string
(250)
descreption
text
file
string
(250)
user_id
integer
marketer_partners
id
increments
timestamps
timestamps
store_id
FK
integer
from_date
date
to_date
date
marketer_id
FK
integer
messages
id
increments
timestamps
timestamps
type
string
(250)
star
integer
sender_id
integer
sender_name
string
(250)
subject
string
(250)
status
integer
marketer_id
integer
descreption
text
alerts
id
increments
timestamps
timestamps
marketer_id
FK
integer
description
text
accounts
id
increments
timestamps
timestamps
user_id
integer
account_number
string
(250)
convention_update
id
increments
timestamps
timestamps
convention_id
FK
integer
update_no
integer
from
string
(250)
termno
integer
reason
string
(250)
details
text
status
tinyInteger
offers_orders
id
increments
timestamps
timestamps
category_id
FK
integer
title
string
(255)
permit_photo
string
(255)
description
text
offers
id
increments
timestamps
timestamps
title
string
(255)
from
date
to
date
offers_products
id
increments
timestamps
timestamps
offer_id
FK
integer
product_id
FK
integer
percent
decimal
(14.8)
price
decimal
(14.8)
shipping_companies
id
increments
timestamps
timestamps
title
string
(255)
mobile
string
(255)
address
string
(255)
shipping_prices
id
increments
timestamps
timestamps
shipping_company_id
FK
integer
from_c_id
FK
integer
to_c_id
FK
integer
c1
decimal
(14.8)
c2
decimal
(14.8)
c3
decimal
(14.8)
c4
decimal
(14.8)
c5
decimal
shipping_orders
id
increments
timestamps
timestamps
shipping_company_id
FK
integer
paymnent_method_id
FK
integer
weight
decimal
product_id
FK
integer
from_c_id
FK
integer
to_c_id
FK
integer
date
date
receive_date
date
customer_id
integer
total
decimal
(14.8)
description
text
order_history
id
increments
timestamps
timestamps
order_status_id
integer
contact_us
id
increments
timestamps
timestamps
store_id
integer
email1
string
(255)
email2
string
(255)
mobile1
string
(255)
mobile2
string
(255)
address
string
(255)
facebook
string
(255)
twitter
string
(255)
google
string
(255)
help
id
increments
timestamps
timestamps
user_id
FK
integer
title
string
(255)
description
text
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01