Candidate Key

A Candidate Key is an optional Key that uniquely identifies an occurrence of a Database Entity. An entity can have multiple candidate keys each defining a unique combination of fields that uniquely identify an occurrence.

Characteristics

Characteristics

  

Icon:

Candidate key

Object type code:

key

Main Development Object?

No

Part of:

Modeled Entity

Contains:

Property

Generalization:

Key

Specializations:

—

Compilation Output:

—

Specialization

Candidate Key specializes Key in the following ways:

  • It has the Type property set to Candidate.