users


Description

Users. A large part is obtained from the auth platform and may not be manually edited

Columns

Column Type Size Nulls Auto Default Children Parents Comments
group_id BIGINT 19 null
answers.author_id fk_answers_author_id_users_group_id C
attempts.creator_id fk_attempts_creator_id_users_group_id N
badges.user_id fk_badges_user_id_users_group_id C
filters.user_id fk_filters_user_id_users_group_id C
group_membership_changes.initiator_id fk_group_membership_changes_initiator_id_users_group_id N
sessions.user_id fk_sessions_users_user_id_group_id C
user_batches_v2.creator_id fk_user_batches_v2_creator_id_users_group_id N
users.creator_id fk_users_creator_id_users_group_id N
groups.id fk_users_group_id_groups_id C

Group that represents this user
login_id BIGINT 19 √ null

"userId" returned by the auth platform
temp_user BIT 1 0

Whether it is a temporary user. If so, the user will be deleted soon.
login VARCHAR 100

login provided by the auth platform
profile JSON 1073741824 √ null

A JSON object containing user profile information returned by the login module as the "profile" field
open_id_identity VARCHAR 255 √ null

User's Open Id Identity
password_md5 VARCHAR 100 √ null
salt VARCHAR 32 √ null
recover VARCHAR 50 √ null
registered_at DATETIME 19 √ null

When the user first connected to this platform
email VARCHAR 100 √ null

E-mail, provided by auth platform
email_verified BIT 1 0

Whether email has been verified, provided by auth platform
first_name VARCHAR 100 √ null

First name, provided by auth platform
last_name VARCHAR 100 √ null

Last name, provided by auth platform
student_id TEXT 65535 √ null

A student id provided by the school, provided by auth platform
country_code CHAR 3

3-letter country code
time_zone VARCHAR 100 √ null

Time zone, provided by auth platform
birth_date DATE 10 √ null

Date of birth, provided by auth platform
graduation_year INT 10 0

High school graduation year
grade INT 10 √ null

School grade, provided by auth platform
sex enum('Male', 'Female') 6 √ null

Gender, provided by auth platform
address MEDIUMTEXT 16777215 √ null

Address, provided by auth platform
zipcode LONGTEXT 2147483647 √ null

Zip code, provided by auth platform
city LONGTEXT 2147483647 √ null

City, provided by auth platform
land_line_number LONGTEXT 2147483647 √ null

Phone number, provided by auth platform
cell_phone_number LONGTEXT 2147483647 √ null

Mobile phone number, provided by auth platform
default_language CHAR 3 fr

Current language used to display content. Initial version provided by auth platform, then can be changed manually.
notify_news TINYINT 3 0

Whether the user accepts that we send emails about events related to the platform
notify enum('Never', 'Answers', 'Concerned') 9 Answers

When we should send an email to the user. Answers: when someone posts a message on a thread created by the user. Concerned: when someone post a message on a thread that the user participated in
public_first_name TINYINT 3 0

Whether show user's first name in his public profile
public_last_name TINYINT 3 0

Whether show user's last name in his public profile
free_text MEDIUMTEXT 16777215 √ null

Text provided by the user, to be displayed on his public profile
web_site VARCHAR 100 √ null

Link to the user's website, to be displayed on his public profile
photo_autoload BIT 1 0

Indicates that the user has a picture associated with his profile. Not used yet.
lang_prog VARCHAR 30 √ Python

Current programming language selected by the user (to display the corresponding version of tasks)
latest_login_at DATETIME 19 √ null

When is the last time this user logged in on the platform
latest_activity_at DATETIME 19 √ null

Last activity time on the platform (any action)
latest_profile_sync_at DATETIME 19 √ null

Last time when the profile was synced with the login module
last_ip VARCHAR 16 √ null

Last IP (to detect cheaters).
basic_editor_mode TINYINT 3 1

Which editor should be used in programming tasks.
spaces_for_tab INT 10 3

How many spaces for a tabulation, in programming tasks.
member_state TINYINT 3 0

On old website, indicates if the user is a member of France-ioi
step_level_in_site INT 10 0

User's level
is_admin TINYINT 3 0

Is the user an admin? Not used?
no_ranking TINYINT 3 0

Whether this user should not be listed when displaying the results of contests, or points obtained on the platform
help_given INT 10 0

How many times did the user help others (# of discussions)
access_group_id BIGINT 19 √ null
notifications_read_at DATETIME 19 √ null

When the user last read notifications
creator_id BIGINT 19 √ null
users.group_id fk_users_creator_id_users_group_id N

User who created a given login with the login generation tool
profile_first_name TEXT 65535 √ null
profile_last_name TEXT 65535 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc group_id
country_code Performance Asc country_code
fk_users_creator_id_users_group_id Performance Asc creator_id
lang_prog Performance Asc lang_prog
login Must be unique Asc login
login_id Performance Asc login_id
temp_user Performance Asc temp_user

Relationships

Close relationships within degrees of separation