Database
154 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
CAP Theorem
Theorem on Consistency, Availability, Partition tolerance trade-offs
View
Virtual table defined by a SQL query
Relational Database
Database storing data in structured tables with relationships
Normalization
Organizing tables to reduce redundancy and improve integrity
Document Database
NoSQL database storing data as flexible JSON-like documents
Time-Series Database
Database optimized for time-stamped data storage