ttc - Laravel Schema Designer

products

id increments
name string
quantity integer
quantity_unit_id ^FK integer
cost decimal (16,8)
warehouse_location_id ^FK integer
custcat enum
taxable boolean
srp decimal (10,2)
pre_priced string
active boolean
model string
timestamps timestamps
softDeletes softDeletes

product_units

id increments
product_id ^FK integer
unit_type_id ^FK integer
price decimal (10,2)
contains_unit_id ^FK integer
contains_quantity integer
weight decimal (8,2)
timestamps timestamps

product_unit_types

id increments
name string
short_name string
timestamps timestamps

product_categories

id increments
parent_id ^FK integer
name string
timestamps timestamps

product_warehouse_locations

id increments
name string
timestamps timestamps

products_products_categories

product_id ^FK integer
category_id ^FK integer

customers

id increments
company string
firstname string
lastname string
address string
city string
state string
zipcode string
phone string
fax string
email string
def_pay_method enum
tax_id string
active boolean
timestamps timestamps
softDeletes softDeletes

order_payments

id increments
order_id ^FK integer
amount decimal (10,2)
date_paid date
pay_method enum
reference string
date_deposited date
timestamps timestamps
softDeletes softDeletes

orders

id increments
credit_memo boolean
date_purchased date
customer_id ^FK integer
company string
contact string
address string
city string
state string
zipcode string
phone string
email string
pay_method string
status enum
sub_total decimal (10,2)
discount decimal (10,2)
returns decimal (10,2)
delivery decimal (10,2)
total decimal (10,2)
timestamps timestamps
softDeletes softDeletes

order_lines

id increments
order_id ^FK integer
product_id ^FK integer
name string
quantity integer
quantity_unit_id ^FK integer
price decimal (10,2)
discount decimal (10,2)
cost decimal (16,8)
custcat enum
timestamps timestamps
softDeletes softDeletes

adjustments

id increments
date_adjusted date
product_id ^FK integer
name string
quantity_adj integer
quantity_unit_id ^FK integer
reason enum
cost decimal (16,8)
timestamps timestamps

calendar

id increments
date_from date
date_to date
week string
timestamps timestamps

vendors

id increments
company string
contact string
address string
city string
state string
zipcode string
phone string
email string
timestamps timestamps
softDeletes softDeletes

purchases

id increments
date_purchased date
vendor_id ^FK integer
total decimal (10,2)
freight_handling decimal (10,2)
tobacco_tax decimal (10,2)
non_inventory decimal (10,2)
shipped_via string
terms string
timestamps timestamps
softDeletes softDeletes

purchase_lines

id increments
purchase_id ^FK integer
product_id ^FK integer
description string
vendor_quantity integer
vendor_cost decimal (16,8)
quantity integer
quantity_unit_id ^FK integer
purchase_cost decimal (16,8)
inventory_cost decimal (16,8)
timestamps timestamps
softDeletes softDeletes

vendor_product

id increments
product_unit_id ^FK integer
vendor_id ^FK integer
tobacco_tax boolean
name string
location string
model string
cost decimal (16,8)
timestamps timestamps

product_unit_barcodes

id increments
product_unit_id ^FK integer
barcode string
description string
timestamps timestamps

product_images

id increments
product_id ^FK integer
basename string
extension string
order integer
timestamps timestamps

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