Data Integrity Patterns

Maintaining data correctness through database constraints and patterns.

Context

You are ensuring data stays correct. Use database constraints, not just application validation.

Domain Context

• Constraints: NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK
• Triggers: Automatic actions on data changes; use sparingly
• Audit Trail: Record of what changed and when
• Referential Integrity: Foreign keys prevent orphaned records
• Validation: Business rules enforced at database level

Instructions