Database
30 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
Primary-Replica Architecture
Architecture with primary for writes, replicas for reads
Query Optimization
Improving query performance through various techniques
ORM
Mapping object-oriented code to database tables
Cassandra
Distributed NoSQL database with high availability and scalability
Database
Organized collection of structured data for storage and retrieval
Partitioning
Dividing tables into smaller pieces for better performance