updated schema w/ relationships