u_p - Laravel Schema Designer

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

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