fix - create a foreign key for `produce_item_id` in `item_seasons` table - Githubissues

vasconsaurus / produce_in_season

0 stars 0 forks source link

fix - create a foreign key for `produce_item_id` in `item_seasons` table #51

Closed tcione closed 1 year ago

tcione commented 1 year ago

Having a foreign key guarantees a few things:

Better performance in fetching data
A safe way to handle relationships, since the id must exist to be there
A safe way to handle entity deletion via SQL cascading

tcione commented 1 year ago

The key already existed: https://github.com/vasconsaurus/produce_in_season/blob/e93202d63b49813e24bc7d8d5971cb15c3126622/db/schema.rb#L34