Table iliasRelease_4_3_x_branch.usr_data Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
usr_id int 10 0
login varchar 80  √  null
passwd varchar 32  √  null
firstname varchar 32  √  null
lastname varchar 32  √  null
title varchar 32  √  null
gender char 1  √  m
email varchar 80  √  null
institution varchar 80  √  null
street varchar 40  √  null
city varchar 40  √  null
zipcode varchar 10  √  null
country varchar 40  √  null
phone_office varchar 40  √  null
last_login datetime 19  √  null
last_update datetime 19  √  null
create_date datetime 19  √  null
hobby varchar 4000  √  null
department varchar 80  √  null
phone_home varchar 40  √  null
phone_mobile varchar 40  √  null
fax varchar 40  √  null
i2passwd varchar 32  √  null
time_limit_owner int 10  √  0
time_limit_unlimited int 10  √  0
time_limit_from int 10  √  0
time_limit_until int 10  √  0
time_limit_message int 10  √  0
referral_comment varchar 250  √  null
matriculation varchar 40  √  null
active int 10 0
approve_date datetime 19  √  null
agree_date datetime 19  √  null
ilinc_id int 10  √  null
ilinc_login varchar 40  √  null
ilinc_passwd varchar 40  √  null
client_ip varchar 255  √  null
auth_mode char 10  √  default
profile_incomplete int 10  √  0
ext_account varchar 50  √  null
im_icq varchar 40  √  null
im_yahoo varchar 40  √  null
im_msn varchar 40  √  null
im_aim varchar 40  √  null
im_skype varchar 40  √  null
feed_hash varchar 32  √  null
delicious varchar 40  √  null
latitude varchar 30  √  null
longitude varchar 30  √  null
loc_zoom int 10 0
login_attempts tinyint 3 0
last_password_change int 10 0
im_jabber varchar 40  √  null
im_voip varchar 40  √  null
reg_hash char 32  √  null
birthday date 10  √  null
sel_country varchar 2  √  null
last_visited longtext 2147483647  √  null
inactivation_date datetime 19  √  null
is_self_registered tinyint 3 0

Table contained 2 rows at Sun Apr 24 00:38 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name
usr_id Primary key Asc PRIMARY
login + passwd Performance Asc/Asc i1_idx
ext_account + auth_mode Performance Asc/Asc i2_idx