Whats the name for columns which purpose is not to identify

terminology

I have a contacts table.

Columns are:

id
user_id
provider_id
title
phone_number
phone_ext

I want to know if there's a word that refers to the columns that make up the meat of the table. ie. (title, phone_number, phone_ext)

Thanks in advance

Best Answer

Those columns are generally referred to as non-key attributes, in my experience.

Googling for that phrase backs up the fact that it is commonly used, if you need a reference.

Related Question