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 | This column contains the user-related data for the specified metakeys. Usually, these values are stored as plain text or serialized values. |
Apart from default options, we can use this table to store simple custom user data such as date of birth, country, city, and advanced user data such as interests, and profile pictures.