db primary key relationship super candidate primary alternate foreign partial composite unique surrogate secondary key

 https://www.geeksforgeeks.org/types-of-keys-in-relational-model-candidate-super-primary-alternate-and-foreign/

https://powerbidocs.com/2019/12/25/sql-keys/