Foreign keys

5 videos across 3 channels

Relational databases rely on foreign keys to enforce data integrity across tables. These links are typically defined during migrations, with up and down methods to apply or revert changes, and they underpin common patterns like users, profiles, roles, and related records. Understanding how to declare, name, and safeguard these keys—along with how joins leverage them—helps you build scalable schemas and reliable query logic across frameworks like Laravel, AdonisJS, and standard SQL.