SchemaSpy - Table iliasRelease_4_2_x_branch.usr

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
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

Table contained 2 rows at Fri Apr 22 21:41 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