nearbuy - Laravel Schema Designer

products

id increments
timestamps timestamps
user_id ^FK bigInteger
product_category_id ^FK bigInteger
vat_category_id ^FK bigInteger

users

id increments
timestamps timestamps
type enum
profile_id bigInteger
profile_type string

product_categories

id increments
timestamps timestamps
name string

orders

id increments
timestamps timestamps
status string
gross_price integer
user_id bigInteger
partner_id bigInteger

order_items

id increments
timestamps timestamps
order_id ^FK bigInteger
amount integer
unit_price integer
gross_price integer
vat_value smallInteger
product_id bigInteger

vat_categories

id increments
timestamps timestamps
name string
value smallInteger

user_profiles

id increments
timestamps timestamps
user_id bigInteger

partner_profiles

id increments
timestamps timestamps
user_id bigInteger

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