Vow-Billing - Laravel Schema Designer

products

id increments
name string (128)
sku string
description text
slug string (128)
base_price integer
sale_price integer
meta_description string (128)
meta_title string (128)
meta_keywords text
is_active boolean
timestamps timestamps

addresses

id increments
user_id ^FK integer
type enum
is_primary boolean
google_place_id string
street_address string (128)
street_address_2 string (128)
city string (128)
state string (128)
postal_code string (10)
country string
timestamps timestamps

discounts

id increments
description string
code string (10)
amount decimal (8,2)
amount_type string (128)
start_date timestamp
end_date timestamp
timestamps timestamps

payment_methods

id increments
customer_id ^FK integer
address_id integer
is_primary boolean
name_on_card string
card_type_id tinyInteger
expiration_month smallInteger
expiration_year smallInteger
last_four_digits smallInteger
type enum
token string (255)
token_type string (128)
expires_in integer
recurring boolean
recurring_date timestamp
frequency string
timestamps timestamps

transactions

id increments
customer_id ^FK integer
receipt_number string (128)
payment_method_id ^FK integer
payment_type enum
discount_id ^FK integer
description text
total integer
transaction_reference string (128)
timestamps timestamps

orders

id increments
order_number bigInteger
hashed_id string (255)
customer_id ^FK integer
status enum
transaction_id ^FK integer
discount_id ^FK integer
softDeletes softDeletes
timestamps timestamps

order_items

id increments
order_id integer
quantity smallInteger
item_total_cost decimal
product_id ^FK integer
discount_id ^FK integer
timestamps timestamps

users

id increments
timestamps timestamps
first_name string (56)
last_name string
username string

customers

id increments
type enum
user_id ^FK integer
billing_company_name string
billing_first_name string
billing_last_name string
billing_address_id ^FK integer
currency string
timestamps timestamps

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