kushalgarment - Laravel Schema Designer

stocks

id increments
timestamps timestamps
material_id ^FK integer
quantity double

purchases

id increments
timestamps timestamps
bill_no integer
seller_id ^FK integer
rate double
unit_id ^FK integer
material_id ^FK integer

sellers

id increments
timestamps timestamps
name string
contact string
email text
address text

units

id increments
timestamps timestamps
name string (150)

production_stocks

id increments
timestamps timestamps
stock_id ^FK integer
quantity double

products

id increments
timestamps timestamps
producttype_id ^FK integer
quantity double
production_stock_id ^FK integer

types

id increments
timestamps timestamps
name string

product_types

id increments
timestamps timestamps
name string

materials

id increments
timestamps timestamps
name string
type_id ^FK integer
unit_id ^FK integer

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