CRM - Laravel Schema Designer

Products

id increments
product_code string (20)
category_id ^FK integer
product_name string (255)
product_type string (30)
product_unit integer
product_group integer
product_catalogue string (30)
product_mrp float (10,4)
product_rate float (10,4)
product_vat_percentage float (10,2)
product_amount float (10,4)
timestamps timestamps
softDeletes softDeletes

Categories

id increments
category_name string (30)
timestamps timestamps
softDeletes softDeletes

static_data

id increments
type string (30)
value text

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