Added foreign key constraints to the tables in the schema.