made vendor and software information nullable and changed vendor_id to vendor