user

0 rows


Description

This table stores the data of all registered users,
Created by Martin 17/03/03

The email is the unique identifier for each user (i.d., the username).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id INT UNSIGNED 10 √ null
edition_editor.user_id fk_edition_editor_to_userR
edition_editor_request.admin_user_id edition_editor_request_to_admin_user_idR
edition_editor_request.editor_user_id edition_editor_request_to_editor_user_idR
iaa_edition_catalog_author.user_id fk_iaa_edition_catalog_author_to_userR
iaa_edition_catalog_to_text_fragment_confirmation.user_id fk_iaa_edition_catalog_to_text_fragment_confirmation_to_userR
image_catalog_author.user_id fk_image_catalog_author_to_userR
image_to_image_map_author.user_id fk_image_to_image_map_author_to_userR
recent_edition_catalog_to_col_confirmation.user_id Implied ConstraintR
SQE_image_author.user_id fk_SQE_image_author_to_userR
user_contributions.user_id fk_user_contributions_to_userR
user_email_token.user_id fk_user_email_token_to_userR
email VARCHAR 255 null

The user account email is used as the unique identifier for the account. Users authenticate with a correct email + password.
pw CHAR 56 null

A hashed password
forename VARCHAR 255 √ NULL

The user’s forename, may be null. Neither forename or surname are unique (separately or combined)
surname VARCHAR 255 √ NULL

The user’s surname, may be null. Neither forename or surname are unique (separately or combined)
organization VARCHAR 255 √ NULL

The user’s current organization, may be null.
registration_date TIMESTAMP 19 current_timestamp()
settings LONGTEXT 2147483647 √ NULL
last_scroll_version_id INT UNSIGNED 10 1
activated TINYINT UNSIGNED 3 0

Boolean for whether a user has authenticaed registration via the emailed token.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc user_id
unique_user Must be unique Asc email

Relationships

Close relationships within degrees of separation