whoserinv - Laravel Schema Designer

uoms

id increments
timestamps timestamps
softDeletes softDeletes
slug string (64)
name string (32)

categories

id increments
timestamps timestamps
softDeletes softDeletes
slug string (64)
name string (32)

products

id increments
timestamps timestamps
softDeletes softDeletes
slug string (64)
name string (32)
descriptions text
sell_price double
purchase_price double

product_versions

id increments
timestamps timestamps
softDeletes softDeletes
active tinyInteger
products_id ^FK integer
uoms_id ^FK integer

product_categories

id increments
timestamps timestamps
softDeletes softDeletes
products_id ^FK integer
categories_id ^FK integer

uom_rules

id increments
timestamps timestamps
softDeletes softDeletes
product_versions_id ^FK integer
uoms_id ^FK integer
conversion double

stockinhands

id increments
timestamps timestamps
softDeletes softDeletes
product_versions_id ^FK integer
amount double

users

id increments
timestamps timestamps
softDeletes softDeletes
email string
username string (32)
password string
token text
name string

financial_storages

id increments
timestamps timestamps
softDeletes softDeletes
slug string (64)
name string (32)
notes text

in_out_tags

id increments
timestamps timestamps
softDeletes softDeletes
slug string (64)
name string (32)
type tinyInteger

income_items

id increments
timestamps timestamps
softDeletes softDeletes
received_at timestamp
ref enum
ref_id integer
financial_storages_id ^FK integer
amount double
notes text

outcome_items

id increments
timestamps timestamps
softDeletes softDeletes
received_at timestamp
ref enum
ref_id integer
financial_storages_id ^FK integer
amount double
notes text

payment_terms

id increments
timestamps timestamps
softDeletes softDeletes
slug string (64)
name string (32)
period smallInteger

buyers

id increments
timestamps timestamps
softDeletes softDeletes
slug string (64)
name string (32)
email string
phone string (32)
address text
payment_terms_id ^FK integer

sales_orders

id increments
timestamps timestamps
softDeletes softDeletes
code string
buyers_id ^FK integer
payment_terms_id ^FK integer
issued timestamp
duedate timestamp
notes text

sales_order_items

id increments
timestamps timestamps
product_versions_id ^FK integer
softDeletes softDeletes
warehouses_id ^FK integer
sales_orders_id ^FK integer
uom_id ^FK integer
quantity double
price double

sales_order_payments

id increments
timestamps timestamps
softDeletes softDeletes
sales_orders_id ^FK integer
income_items_id ^FK integer
received_at timestamp
amount double

sales_return_orders

id increments
timestamps timestamps
softDeletes softDeletes
code string
sales_orders_id ^FK integer
note text

sales_return_order_items

id increments
timestamps timestamps
softDeletes softDeletes
sales_return_orders_id ^FK integer
returned_at timestamp
warehouses_id ^FK integer
product_versions_id ^FK integer
uoms_id ^FK integer
quantity double
price double

sales_return_payments

id increments
timestamps timestamps
softDeletes softDeletes
sales_return_orders_id ^FK integer
outcome_items_id ^FK integer
paid_at timestamp
amount double

warehouses

id increments
timestamps timestamps
softDeletes softDeletes
default tinyInteger
slug string (64)
name string (32)
address text

warehouse_products

id increments
timestamps timestamps
softDeletes softDeletes
product_versions_id ^FK integer
stock double

product_movement_orders

id increments
timestamps timestamps
softDeletes softDeletes
code string
warehouses_id ^FK integer
issued timestamp
clause enum
notes text

product_movement_order_items

id increments
timestamps timestamps
softDeletes softDeletes
product_versions_id ^FK integer
uoms_id ^FK integer
quantity double
price double

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