Home
u_p
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
users
id
increments
username
string
email
string
avatar
string
password
string
name
string
slug
string
permissions
text
ip
string
user_role
integer
activated
boolean
remember
boolean
remember_token
string
is_fake
boolean
verified_on
timestamp
active_on
timestamp
confirmed
boolean
activated_at
timestamp
published
boolean
published_on
timestamp
last_login
timestamp
blocked_on
timestamp
address_id
FK
integer
article_id
FK
integer
billing_id
FK
integer
profile_id
FK
integer
software_id
FK
integer
shipping_id
FK
integer
is_employee
boolean
task_id
FK
integer
employee_hr_id
FK
integer
question_id
FK
integer
page_id
FK
integer
group_id
integer
prefered_language
integer
softDeletes
softDeletes
timestamps
timestamps
profiles
id
increments
user_id
FK
integer
display_name
string
first_name
string
last_name
string
pic
string
gender
enum
date_of_birth
date
dob_month
enum
dob_day
enum
dob_year
smallInteger
about_me
text
phone
string
phone_type
enum
activated
boolean
position
string
company
string
website
string
skypeid
string
twitter_username
string
instagram_username
string
facebook_username
string
facebookurl
string
linked_in_url
string
google_plus_url
string
githubid
string
note
text
timestamps
timestamps
api_key_id
FK
integer
addresses
id
increments
user_id
FK
integer
timestamps
timestamps
nickname
string
address
string
street
string
street_additional
string
city
string
state
string
country
string
zipcode
string
(10)
latitude
string
longitude
string
billing_addresses
id
increments
user_id
FK
integer
timestamps
timestamps
billing_address
string
billing_nickname
string
billing_street
string
billing_street_additional
string
billing_city
string
billing_state
string
billing_country
string
billing_zipcode
string
(10)
billing_latitude
string
billing_longitude
string
shipping_addresses
id
increments
user_id
FK
integer
timestamps
timestamps
shipping_nickname
string
shipping_address
string
shipping_street
string
shipping_street_additional
string
shipping_city
string
shipping_state
string
shipping_country
string
shipping_zipcode
string
(10)
shipping_latitude
string
shipping_longitude
string
api_keys
id
increments
key
string
(40)
user_id
FK
integer
level
smallInteger
ignore_limits
boolean
softDeletes
softDeletes
timestamps
timestamps
api_logs
id
increments
api_key_id
FK
integer
route
string
method
string
params
text
ip_address
string
timestamps
timestamps
articles
id
increments
timestamps
timestamps
title
string
slug
string
excerpt
text
content
text
meta_keywords
string
meta_description
text
status
enum
published_on
timestamp
path
string
file_name
string
article_image
string
image_at
string
is_published
boolean
user_id
FK
integer
meta_title
string
(65)
softwares
id
increments
user_id
FK
integer
soft_family
string
(4)
soft_type
string
soft_status
boolean
soft_expire
date
soft_reg_device_id
string
(4)
soft_device_nickname
string
soft_reg_device_status
boolean
soft_activation_code
string
soft_product_key
string
soft_thumb_id
string
soft_authenticated_product
boolean
soft_purchase_order
string
soft_product
string
soft_purchased_on_off
boolean
soft_id
integer
timestamps
timestamps
softDeletes
softDeletes
product_id
FK
integer
soft_products
id
increments
softDeletes
softDeletes
timestamps
timestamps
soft_product_code
string
(3)
soft_product_name
string
soft_product_type
string
soft_prod_id
integer
soft_brands
id
increments
timestamps
timestamps
softDeletes
softDeletes
code
string
(3)
brand_name
string
brand_id
integer
software_features
id
increments
timestamps
timestamps
softDeletes
softDeletes
feature_title
string
feature_desc
string
software_feature_id
integer
softwares_installed
id
increments
timestamps
timestamps
softDeletes
softDeletes
inst_soft_id
integer
device_one
string
device_two
string
device_three
string
software_updates
id
increments
timestamps
timestamps
softDeletes
softDeletes
soft_update_id
integer
issued_date
datetime
update_name
string
update_url
string
update_package
string
software_addons
id
increments
timestamps
timestamps
softDeletes
softDeletes
soft_addon_id
integer
soft_addon_name
string
soft_addon_details
string
soft_addon_available
datetime
soft_addon_status
string
subscriptions
id
increments
timestamps
timestamps
softDeletes
softDeletes
subscr_active
enum
subs_id
integer
renew_every
integer
subscr_types
id
increments
timestamps
timestamps
softDeletes
softDeletes
subsc_name
string
subsc_term_months
integer
subs_type_id
integer
supports
id
increments
timestamps
timestamps
ticket
integer
subject
string
department
string
content
text
assigned_to
FK
integer
status
string
read
boolean
hr
id
increments
employee_number
smallInteger
salary
integer
position
string
jobtitle
string
supervisor
string
hire_date
date
termination_date
string
hourly_rate
smallInteger
department
string
user_id
FK
integer
employment_status
enum
employment_roles
string
timestamps
timestamps
faqs
id
increments
timestamps
timestamps
question
string
answer
text
order
integer
lang
string
(20)
answered_by
FK
integer
asked_by
FK
integer
products
id
increments
timestamps
timestamps
softDeletes
softDeletes
available_on
datetime
product_info
FK
integer
products_translations
id
increments
timestamps
timestamps
product_id
FK
integer
slug
string
name
string
short_description
text
description
text
meta_keywords
string
meta_description
string
(160)
htmlschema
string
bodyschema
string
locale
string
orders
id
increments
timestamps
timestamps
softDeletes
softDeletes
orders_items
id
increments
timestamps
timestamps
products_options
id
increments
timestamps
timestamps
option_name
string
product_id
FK
integer
products_options_values
id
increments
timestamps
timestamps
option_value
string
option_id
FK
integer
products_variants
id
increments
timestamps
timestamps
sku
string
gtin
string
on_backorder
boolean
on_hand
boolean
available_on_demand
boolean
weight
decimal
(8,2)
width
decimal
(8,2)
height
decimal
(8,2)
depth
string
(8,2)
product_id
FK
integer
products_properties
id
increments
timestamps
timestamps
property
string
products_properties_values
id
increments
timestamps
timestamps
property_value
string
prop_id
FK
integer
products_images
id
increments
timestamps
timestamps
image_path
string
image_alt
string
product_variant_id
FK
integer
tasks
id
increments
task
string
priority
string
assigned_to
FK
integer
completed_on
timestamp
created_by
FK
integer
order
mediumInteger
timestamps
timestamps
blog
id
increments
timestamps
timestamps
blog_posts
id
increments
timestamps
timestamps
slider_id
FK
integer
pages
id
increments
title
string
(65)
slug
string
meta_title
string
(65)
meta_description
text
meta_keywords
string
content
text
section_id
FK
integer
author_id
FK
integer
is_published
boolean
lang
string
(20)
timestamps
timestamps
page_path
string
menu_route
string
slider_id
FK
integer
excerpt
text
page_sections
id
increments
timestamps
timestamps
section_title
string
(55)
section_content
text
section_image
string
section_image_type
enum
videos
id
increments
timestamps
timestamps
title
string
(65)
slug
string
video
string
video_url
string
youtube_video_url
string
type
string
published
boolean
lang
string
(20)
category_id
integer
categories
id
increments
timestamps
timestamps
category
string
(65)
category_description
text
category_image
string
slug
string
photo_gallery_id
FK
integer
tags
id
increments
timestamps
timestamps
tag
string
(40)
slug
string
lang
string
(20)
activations
id
increments
user_id
FK
integer
code
string
timestamps
timestamps
completed
boolean
completed_at
timestamp
persistences
id
increments
timestamps
timestamps
user_id
FK
integer
code
string
reminders
id
increments
timestamps
timestamps
user_id
FK
integer
code
string
completed
boolean
completed_at
timestamp
roles
id
increments
timestamps
timestamps
slug
string
name
string
permissions
text
role_users
id
increments
timestamps
timestamps
user_id
FK
integer
role_id
FK
integer
photo_galleries
id
increments
timestamps
timestamps
title
string
(65)
slug
string
content
text
meta_keywords
string
meta_description
text
category_id
FK
integer
photos
id
increments
timestamps
timestamps
file_name
string
title
string
photo_path
string
file_size
integer
photo_type
string
relationship_id
integer
form_posts
id
increments
timestamps
timestamps
sender_name_surname
string
sender_email
string
sender_phone_number
string
subject
string
message
text
created_ip
string
is_answered
boolean
lang
string
(20)
public_settings
id
increments
timestamps
timestamps
setting
text
lang
string
(20)
private_settings
id
increments
timestamps
timestamps
setting
text
lang
string
(20)
news
id
increments
timestamps
timestamps
title
string
(65)
news_content
text
slug
string
datetime
datetime
is_published
boolean
path
string
file_name
string
file_size
string
lang
string
(20)
sliders
id
increments
timestamps
timestamps
title
string
description
text
path
string
file_name
string
file_size
integer
order
integer
lang
string
(20)
page_id
FK
integer
article_id
FK
integer
blog_post_id
FK
integer
mail_list
id
increments
timestamps
timestamps
email
string
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01