update schema to include a foreign key