Fremdschlüssel (EN)

Concept

An attribute or combination of attributes that references the primary key of another table

Relationship between tables

flowchart LR   A[Customers] -->|customer_id| B[Orders]   B -->|product_id| C[Products]   D[Categories] -->|category_id| C

In context

  • Typically used together with primary keys, indexes, and database normalization
  • Related to: Primary key, referential integrity, database relationships
  • Example use case: Linking customers with their orders in an e-commerce system
Quelle: AI Generated