Home
Vow-Billing
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
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
×
Comments for Vow-Billing
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01