gg-pos - Laravel Schema Designer

suppliers

id increments
name string (50)
contact_person string (50)
address string (50)
phone string (15)
timestamps timestamps
softDeletes softDeletes

stores

id increments
name string (50)
description text
main boolean
timestamps timestamps
softDeletes softDeletes

warehouses

id increments
name string (50)
description text
main boolean
store_id ^FK integer
timestamps timestamps
softDeletes softDeletes

uoms

id increments
unit string (50)
name string (50)
active boolean
timestamps timestamps
softDeletes softDeletes

attributes

id increments
name string (50)
type string (50)

attribute_values

id increments
attribute_id ^FK integer
value string (50)

attribute_sets

id increments
name string (50)
slug string (50)

attribute_attribute_sets

attribute_id ^FK integer
attribute_set_id ^FK integer

attribute_product_values

product_id ^FK integer
attribute_id ^FK integer
value string (50)

racks

id increments
warehouse_id ^FK integer
code string (50)
rows smallInteger
active boolean
timestamps timestamps
softDeletes softDeletes

products

id increments
attribute_set_id ^FK integer
name string (50)
description text
active boolean
timestamps timestamps
softDeletes softDeletes

product_images

id increments
product_id ^FK integer
name string (50)
caption string (50)
order smallInteger

categories

id increments
parent_id ^FK integer
name string (50)
slug string (50)
lft smallInteger
rgt smallInteger
depth smallInteger
timestamps timestamps
softDeletes softDeletes

product_categories

category_id ^FK integer
product_id ^FK integer

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