All posts

How does Rails handle referential integrity

Primary Key / Foreign Key

To properly illustrate this concept lets first outline the primary key / foreign key relationship:

  • Primary key: this is a column (sometimes multiple columns) in a table that uniquely identify a row in a database table. Relational databases enforce the uniqueness of primary keys, each row in a table must have a unique primary key and they are almost always auto generated.
  • Foreign key: this is a column in a table whose value matches the primary key of a record in another table. If you are to add a database row with a foreign key column, the primary key record must already exist.

The primary key / foreign key relationship sets up the one to many relationship in rails where the primary key record can have many related foreign key records.

What is referential integrity

Referential integrity is a constraint that enforces a relationship between two records. It ensures that values in a foreign key column must either be exist in primary key that is referenced by the foreign key or they must be null. This is usually configured and handled at the database layer of an applications system.

How does Rails handle referntial integrity

The Rails way and specifically here, the Active Record way says that we should handle as much behavior and contraints as possible at the application level so rails suggests first adding application level validations in your Active Record models like so:

class Product < ApplicationRecord
  validates :user_id, uniqueness: true
end

And we can also add the dependent: :destroy option to our models to destroy child objects when parent objects are destroyed. But Rails also gives you the option of adding the database level contraint to guarantee referential integrity and you can do that by add_foreign_key :products, :users.

Similar posts:

Postscript:

I built two products to help fund continued efforts for this website, it would mean a lot if you would check them out:
1. 2500+ Words for the Undermotivated Software Engineer - A short essay I wrote on the titled topic ($3).
2. Build 3 Chrome Extensions in Under 2 Hours - A course I built to teach chrome extension development ($9-20).