(#3) Revised tables and views, adding vendor_id