Constraints & Referential Integrity Review

Review database constraints, foreign keys, and data integrity rules.

Database-Level Enforcement

# PROBLEM: Model-only validation (race condition vulnerable)
validates :email, uniqueness: true

# SOLUTION: Database constraint + model validation
add_index :users, :email, unique: true
validates :email, uniqueness: true

Race Condition Prevention