Inventory Schema

[iGoliath]

Category, Subcategory, and Vendor should all be their own table, and these fields in inventory should be foreign keys to these tables.