login

23830 rows


Description

login

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id MEDIUMINT UNSIGNED 8 √ null
avatars.idUser avatars_ibfk_1 R
ban.author_id ban_revoke_author R
ban.player_id ban_ibfk_1 R
clan.founder_id clan_ibfk_1 R
clan.leader_id clan_ibfk_2 R
clan_membership.player_id clan_membership_ibfk_2 R
featured_mods_owners.uid featured_mods_owners_ibfk_2 C
friends_and_foes.subject_id friends_and_foes_subject_login_id_fk R
friends_and_foes.user_id friends_and_foes_user_login_id_fk R
game_player_stats.playerId fk_game_player_stats_player R
game_review.user_id game_review_ibfk_1 R
game_stats.host fk_game_stats_host R
leaderboard_rating.login_id leaderboard_rating_ibfk_1 R
login_log.login_id login_log_login_id_fk C
map.author author C
map_version_review.user_id map_version_review_ibfk_1 R
mod.uploader mod_ibfk_1 C
mod_version_review.user_id mod_version_review_ibfk_1 R
moderation_report.last_moderator moderation_report_ibfk_1 R
moderation_report.reporter_id reporter_id_of_moderation_report R
name_history.user_id name_history_ibfk_1 C
player_achievements.player_id fk_login C
player_events.player_id player_events_login_id_fk R
reported_user.player_id player_id_of_reported_user R
service_links.user_id user_ibfk_1 R
table_map_comments.user_id table_map_comments_ibfk_2 C
teamkills.teamkiller teamkiller_fk R
teamkills.victim victim_fk R
unique_id_users.user_id FK_unique_id_users_user_id_to_login R
uniqueid_exempt.user_id FK_uniqueid_exempt_user_id_to_login R
user_group_assignment.user_id user_group_assignment_ibfk_1 R
user_notes.author user_notes_author_login_id_fk R
user_notes.user_id user_notes_user_login_id_fk R
vote.player_id player_of_vote R
login VARCHAR 20 null
password CHAR 77 null
email VARCHAR 254 null
ip VARCHAR 45 √ null
steamid BIGINT UNSIGNED 20 √ null
create_time TIMESTAMP 19 current_timestamp()
update_time TIMESTAMP 19 current_timestamp()
user_agent VARCHAR 50 √ null
last_login TIMESTAMP 19 √ null
gog_id VARCHAR 100 √ null

Username on gog.com
accepted_tos SMALLINT 5 √ null
terms_of_service.version login_terms_of_service_version_fk R

Point to the last ToS the user has explicitely accepted

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
login_gog_id_uindex Must be unique Asc gog_id
login_terms_of_service_version_fk Performance Asc accepted_tos
steamid Must be unique Asc steamid
unique_email Must be unique Asc email
unique_login Must be unique Asc login

Relationships

Close relationships within degrees of separation