users and usermeta table

install a fresh wordpress setup on your local machine and then have a look at wp_usersmeta table . It contains meta(additional) information for each user.You (admin) can also make data entry specific to any user by this function update_user_meta() in usermeta table. and retrive the same using get_user_meta() funciton.

All fields for all users are not necessary. meta keys can be user specific also.

defaults meta key entries for admin in wordpress 3.6 — 

first_name
last_name 
nickname 
description 
rich_editing 
comment_shortcuts
admin_color
use_ssl 
show_admin_bar_front
wp_capabilities
wp_user_level 
dismissed_wp_pointers
show_welcome_panel
wp_dashboard_quick_press_last_post_id
managenav-menuscolumnshidden 
metaboxhidden_nav-menus 
nav_menu_recently_edited
closedpostboxes_page 
metaboxhidden_page 
metaboxhidden_page  
wp_user-settings wp_user-settings-time

Related Posts:

  1. user_login vs. user_nicename
  2. Difference between update_user_meta and update_user_option
  3. get_user_meta() doesn’t include user email?
  4. Automatically delete inactive users after 2 months
  5. How to display custom user meta from registration in backend?
  6. Grouping users under parent user
  7. How to create a template for a custom URI associated with the user
  8. How to order users alphabetically by their last name?
  9. Wp_User_Query not sorting by meta key
  10. How we can get the user id by its display_name
  11. WP_User_Query with combined meta query – not working?
  12. How to use hyperdb to separate and share a user dataset between wordpress installs?
  13. LEFT JOIN, INNER OUTER JOIN, LEFT OUTER JOIN is driving me crazy. Please help?
  14. \WP_User Object | What’s the Difference Between {caps} and {allcaps}?
  15. Show Biographical Info while creating new user
  16. include user profiles in search results?
  17. Where to Store Custom User Fields
  18. Plugin that would allow WordPress Authors to “follow” other Authors and query “Activity Info” from that
  19. Querying Email Addresses for a List of Users with Same Last Name?
  20. User profile custom field
  21. Front end user meta options for users
  22. Drop down list in user profile page
  23. Check for user meta data at Login
  24. Searchable meta value in user.php
  25. How to add country drop down menu to the user profile?
  26. Delete user from frontend
  27. Add custom fields to the user profile
  28. stop login if user_status equal zero
  29. Does wp_delete_user() remove all user content?
  30. WP User Query fails when searching meta queries and search columns
  31. Log all users out of all locations after 24 hours
  32. How to set show admin bar front to true for all users?
  33. Add user data to table when user is created?
  34. User Last Login Sort Column
  35. Updating user meta
  36. Use wp_update_user to update custom column in wp_users table
  37. Are User Levels Still Currently Used?
  38. WPML Default Language User Meta [closed]
  39. Display users in order by an “order” custom meta field
  40. Search Users base on meta_value & meta_key
  41. mysql query two database tables, users and usermeta and sort by custom meta int value
  42. Rest API code to get ID of current user not working: get_current_user_id() gives 0
  43. Updating wp_user_level on user update
  44. Should I encrypt the response that triggers an Ajax action? Is nonce sufficient?
  45. User Meta Data in a Sortable Table
  46. get_user_meta an ID for multiple functions
  47. How can I attach a user to another user with user meta
  48. Column Sorting Code on users.php
  49. Creating user without username and password
  50. List users by meta_key and meta_value
  51. Is this code true or not
  52. WordPress SQL Issue not returning correct reselts
  53. User description only displayed for logged user
  54. The Simple and Correct Way to Add User Meta
  55. How to pull all the contributer users records and order by Designation (which is users meta data)?
  56. cannot get user_registered date from get_user_meta
  57. “the_author_meta(‘url’)” not working inside “href”
  58. how to set default update_user_meta values wordpress
  59. Add custom user meta data
  60. Cannot Update user meta in custom field
  61. Can I Create a Second Admin Level User Role?
  62. How to add an attribute to a user?
  63. Adding fields to the “Add New User” but the form data not saved into DB
  64. SELECT from wp_users, get Displayname too
  65. how do I add role and capability after I create a new user
  66. User Meta stuff
  67. What does “link” refer to when you delete a user?
  68. How do I update user email from frontend input field?
  69. My custom user metadata is only active for only admin but i want it to be active on all users especially customers
  70. How to get image path from id using SQL
  71. Update user role for expired membership
  72. Getting user data via ajax
  73. Get UserInfo from WordPress
  74. How can i add user display name drop down menu in frontend?
  75. Hook into add_user_role and update based on new and removed roles
  76. How to prevent multiple user accounts with the same meta field?
  77. How to Moderate Edits to User Profiles?
  78. meta_query orderby sort multiple keys
  79. How to update user meta from php file?
  80. REST_query_vars for users
  81. In admin manage users page, how can I stop users with certain privileges from editing users with other privileges?
  82. Get meta key with value for user
  83. user and usermeta table not found
  84. Require confirmation of current user’s email before updating database and before send_email_change_email
  85. UserMeta Changes Meta Value for Post ID
  86. Store extra user values permanently
  87. How do I change the user via SQL?
  88. User list order by user meta
  89. User management missing after migration to new host
  90. Creating Custom user type just like custom post
  91. Validate user meta and redirect
  92. Let admin users edit member profiles from front end
  93. Sort users by custom user meta value
  94. Using and saving custom dropdown boxes on user profiles
  95. Problem with update_user_meta() meta_value
  96. Add custom input field in new user page
  97. WordPress – Security Question at Login from User’s Meta Data
  98. How can I list users by date in an array in meta_value?
  99. MySQL query to list users who never signed in
  100. Export user data from Squirrly’s Starbox plugin?