dvlop - Laravel Schema Designer

product_partners

id increments
name string
slug string (32)
website string
meta text
instagram_link string
facebook_link string
timestamps timestamps
softDeletes softDeletes

posts

id increments
slug string (32)
name string
content text
excerpt text
published_at datetime
members_only boolean
author_id ^FK integer
timestamps timestamps
softDeletes softDeletes

payment_methods

id increments
user_id ^FK integer
provider string (32)
type string (32)
external_id string
country_code string (3)
exp_month string (2)
exp_year string (4)
last4 string (4)
meta text
timestamps timestamps
softDeletes softDeletes

orders

id increments
user_id ^FK integer
xero_id string
payment_method_id ^FK integer
meta text
subtotal integer
total integer
timestamps timestamps

users

id increments
first_name string
last_name string
email string
username string
password string
address_street_1 string
address_street_2 string
address_city string
address_state_province string
address_postal_code string (12)
address_country_code string (3)
phone_number string (15)
rememberToken rememberToken
timestamps timestamps
softDeletes softDeletes

presets

id increments
name string
price integer
launch_date date
member_only boolean
timestamps timestamps
softDeletes softDeletes

sale_periods

id increments
begins_at datetime
expires_at datetime
discount_amount integer
discount_percentage smallInteger
category_id ^FK integer
product_id integer
product_type string (32)
product_partner_id ^FK integer
coupon_code string (32)
minimum_spend integer
max_spend integer
excluded_users text
excluded_categories text
excluded_products text
max_uses smallInteger
timestamps timestamps
softDeletes softDeletes

commissions

id increments
order_id ^FK integer
order_item_id ^FK integer
product_partner_id ^FK integer
product_id integer
product_type string (32)
commission_rate_id ^FK integer
commission_percentage smallInteger
commission_amount integer
timestamps timestamps

tags

id increments
name string
slug string (32)
timestamps timestamps

commission_rates

id increments
product_partner_id ^FK integer
product_id integer
product_type string (32)
commission_percentage smallInteger
begins_at datetime
expires_at datetime
timestamps timestamps
softDeletes softDeletes

product_categories

id increments
name string
slug string (32)
timestamps timestamps
softDeletes softDeletes
parent_id ^FK integer

dynamic_pricing

id increments
price_per_product integer
discount_percentage smallInteger
member_only boolean
category_id ^FK integer
product_id integer
product_type string (32)
required_quantity smallInteger
priority tinyInteger
timestamps timestamps

product_cross_sells

id increments
first_product integer
first_product_type string (32)
second_product integer
second_product_type string (32)
meta text
timestamps timestamps

memberships

id increments
order_id ^FK integer
user_id ^FK integer
begins_at datetime
expires_at datetime
timestamps timestamps

galleries

id increments
name string
slug string (32)
product_partner_id ^FK integer
preset_id ^FK integer
timestamps timestamps
softDeletes softDeletes

gallery_images

id increments
gallery_id ^FK integer
file_url string
alt_text string
timestamps timestamps

order_items

id increments
timestamps timestamps
item_type string (32)
item_id integer
purchase_price integer
sale_period_id ^FK integer

pages

slug string (32)
name string
content text
softDeletes softDeletes
timestamps timestamps

available_downloads

id increments
user_id ^FK integer
product_type string (32)
product_id integer
item_order_id ^FK integer
timestamps timestamps
softDeletes softDeletes

downloads

id increments
user_id ^FK integer
product_type string (32)
product_id integer
ip text
user_agent text
location string
timestamps timestamps

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01