Search CTRL + K

Primary Key

关系模型 数据库 中,主键 唯一标识表中某一

主键 是符合业务场景下的某一个 候选键


CMU 15-445

A relation's primary key uniquely identifies a single tuple.[1]

Database System Concepts

We shall use the term primary key to denote a candidate key that is chosen by the database designer as the principal means of identifying tuples within a relation.[2]


  1. https://youtu.be/uikbtpVZS2s?t=2085 ↩︎

  2. Abraham Silberschatz, Henry F. Korth, and S. Sudarshan, Database System Concepts, Seventh edition (New York, NY: McGraw-Hill, 2020). P44 ↩︎