Database
155 views
Foreign Key
Quick Definition
Field referencing primary key to establish table relationships
Full Definition
A field in one table that references the primary key of another table establishing a relationship between them.
Examples
referential integrity, JOIN operations, relational design
Related Terms
relational-database
primary-key
normalization
More Database Terms
Schema Design
Defining database table structure and constraints
Referential Integrity
Constraint ensuring table relationships remain consistent
Data Modeling
Creating a model describing data structure and relationships
Database Migration
Version-controlled changes to database schema
Time-Series Database
Database optimized for time-stamped data storage
Denormalization
Intentionally adding redundancy to improve reads