wp_usermeta

Used as the secondary location for user data. By default, it keeps track of names, descriptions, capabilities, and so on. This table consists of four columns. Let's identify some of the most important columns in this table:

user_id This is where you find the ID of the user that this data belongs to. This column is used to form the relationship with the wp_users table.
meta_key All the additional user data is saved as key-value pairs. This column defines the identification for user data. A unique key should be used for this column with alpha numeric characters, underscores, and dashes. This is different to what we have used as developers, where we store such data in a different table with these keys as columns.
meta_value ...

Get WordPress Development Quick Start Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.