Home
gutscheinverwaltung
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
users
id
increments
name
string
(128)
role
string
(55)
email
string
(55)
password
string
(255)
timestamps
timestamps
customers
id
increments
number
string
(128)
type
tinyInteger
gender
tinyInteger
company
string
(128)
firstname
string
(128)
lastname
string
(128)
street
string
(128)
zip
string
(10)
city
string
(128)
country
string
(128)
delivery_address
tinyInteger
delivery_company
string
(128)
delivery_firstname
string
(128)
delivery_lastname
string
(128)
delivery_street
string
(128)
delivery_zip
string
(10)
delivery_city
string
(128)
delivery_country
string
(128)
email
string
(128)
invoice_email
string
(128)
order_email
string
(128)
phone
string
(128)
mobile
string
(128)
tax_number
string
(128)
commercial_register
string
(128)
note
longText
state
tinyInteger
state_at
datetime
timestamps
timestamps
softDeletes
softDeletes
orders
id
increments
customer_id
integer
number
string
(128)
type
tinyInteger
gender
tinyInteger
company
string
(128)
firstname
string
(128)
lastname
string
(128)
street
string
(128)
zip
string
(10)
city
string
(128)
country
string
(128)
delivery_address
tinyInteger
delivery_company
string
(128)
delivery_firstname
string
(128)
delivery_lastname
string
(128)
delivery_street
string
(128)
delivery_zip
string
(10)
delivery_city
string
(128)
delivery_country
string
(128)
email
string
(128)
invoice_email
string
(128)
order_email
string
(128)
delivery_email
string
(128)
tax_number
string
(128)
customer_note
longText
commercial_register
string
(128)
note
string
delivery_type
tinyInteger
payment_method_id
integer
recurring
tinyInteger
recurring_interval
string
(128)
recurring_last
datetime
recurring_next
datetime
state
tinyInteger
state_at
datetime
price_with_tax
decimal
price_without_tax
decimal
tax
decimal
timestamps
timestamps
softDeletes
softDeletes
coupons
id
increments
customer_id
integer
order_id
integer
order_position_id
integer
product_id
integer
huth_type
integer
number
string
(128)
balance
decimal
balance_at
datetime
state
tinyInteger
state_at
datetime
timestamps
timestamps
softDeletes
softDeletes
invoices
id
increments
customer_id
integer
order_id
integer
number
string
(128)
type
tinyInteger
gender
tinyInteger
company
string
(128)
firstname
string
(128)
lastname
string
(128)
street
string
(128)
zip
string
(10)
city
string
(128)
country
string
(128)
delivery_address
tinyInteger
delivery_company
string
(128)
delivery_firstname
string
(128)
delivery_lastname
string
(128)
delivery_street
string
(128)
delivery_zip
string
(10)
delivery_city
string
(128)
delivery_country
string
(128)
tax_number
string
(128)
commercial_register
string
(128)
invoice_email
string
(128)
term
longText
note
longText
payment_method_id
integer
state
tinyInteger
state_at
datetime
price_with_tax
decimal
price_without_tax
decimal
tax
decimal
timestamps
timestamps
softDeletes
softDeletes
payments
id
increments
customer_id
integer
order_id
integer
invoice_id
integer
type
tinyInteger
transaction_id
string
(255)
state
tinyInteger
state_at
datetime
paid_price
decimal
timestamps
timestamps
softDeletes
softDeletes
settings
id
increments
key
string
(255)
value
longText
timestamps
timestamps
softDeletes
softDeletes
templates
id
increments
name
string
(255)
key
string
(255)
content
longText
timestamps
timestamps
softDeletes
softDeletes
payment_methods
id
increments
name
string
(128)
description
longText
image
longText
term
longText
default_enabled
tinyInteger
timestamps
timestamps
softDeletes
softDeletes
products
id
increments
order
integer
huth_type
integer
name
string
(255)
description
longText
tax_percent
integer
state
tinyInteger
timestamps
timestamps
softDeletes
softDeletes
customer_payment_methods
id
increments
customer_id
integer
payment_method_id
integer
timestamps
timestamps
softDeletes
softDeletes
customer_accounts
id
increments
customer_id
integer
name
string
(128)
email
string
(128)
password
string
(255)
timestamps
timestamps
softDeletes
softDeletes
product_images
id
increments
product_id
integer
order
integer
name
string
(255)
image
longText
timestamps
timestamps
softDeletes
softDeletes
order_positions
id
increments
order_id
integer
product_id
integer
coupon_id
integer
name
string
(255)
amount
integer
price_with_tax
decimal
price_without_tax
decimal
tax
decimal
tax_percent
integer
total_price_with_tax
decimal
total_price_without_tax
decimal
total_tax
decimal
delivery_name
string
(255)
delivery_email
string
(128)
timestamps
timestamps
softDeletes
softDeletes
invoice_positions
id
increments
invoice_id
integer
product_id
integer
name
string
(255)
amount
integer
price_with_tax
decimal
price_without_tax
decimal
tax
decimal
tax_percent
integer
total_price_with_tax
decimal
total_price_without_tax
decimal
total_tax
decimal
timestamps
timestamps
softDeletes
softDeletes
payment_logs
id
increments
payment_id
integer
log
longText
timestamps
timestamps
softDeletes
softDeletes
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01