Table iliasRelease_3_9_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 unsigned 10 0
ilinc_registration.usr_id Implied Constraint R
usr_pref.usr_id Implied Constraint R
login varchar 80
passwd varchar 32
firstname varchar 32
lastname varchar 32
title varchar 32
gender enum 2 m
email varchar 80
institution varchar 80  √  null
street varchar 40  √  null
city varchar 40  √  null
zipcode varchar 10  √  null
country varchar 40  √  null
phone_office varchar 40
last_login datetime 19 0000-00-00 00:00:00
last_update datetime 19 0000-00-00 00:00:00
create_date datetime 19 0000-00-00 00:00:00
hobby text 65535
department varchar 80
phone_home varchar 40
phone_mobile varchar 40
fax varchar 40
i2passwd varchar 32
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  √ 
matriculation varchar 40  √  null
active int unsigned 10 0
approve_date datetime 19 0000-00-00 00:00:00
agree_date datetime 19 0000-00-00 00:00:00
ilinc_id int unsigned 10  √  null
ilinc_login varchar 40  √  null
ilinc_passwd varchar 40  √  null
client_ip varchar 15  √  null
auth_mode enum 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
longitude varchar 30
loc_zoom int 10 0

Table contained 2 rows at Fri Dec 13 20:19 CET 2013

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

Close relationships: