Tables: user (core)

Here is a list of the tables associated with user data in a standard (core) Drupal database. Please refer to the database documentation for progress on a detailed database schema and data dictionary.

user

The primary user table which stores user info like: username, email, signature, status, picture and selected language

user_roles

List of assignments between users and roles.

role

This is where the roles are defined. Roles are user groups, like ’Admin’ and ‘Editors’.

permission

Assigns each role permissions like “access content”, “post comments”.

profile_fields

Custom fields that have been set up with the profile module.

profile_values

The user data associated with custom fields.

authmap

Stores information about loading user data from external sources.

access

Rules governing the use of email addresses, user names and originating hostnames.