Table studip20.auth_user_md5 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
user_id varchar 32
admission_seminar_user.user_id Implied Constraint R
archiv_user.user_id Implied Constraint R
comments.user_id Implied Constraint R
contact.user_id Implied Constraint R
deputies.user_id Implied Constraint R
dokumente.user_id Implied Constraint R
eval_group_template.user_id Implied Constraint R
eval_templates.user_id Implied Constraint R
eval_templates_user.user_id Implied Constraint R
eval_user.user_id Implied Constraint R
evalanswer_user.user_id Implied Constraint R
folder.user_id Implied Constraint R
guestbook.user_id Implied Constraint R
lit_catalog.user_id Implied Constraint R
lit_list.user_id Implied Constraint R
lit_list_content.user_id Implied Constraint R
log_events.user_id Implied Constraint R
news.user_id Implied Constraint R
object_user.user_id Implied Constraint R
px_topics.user_id Implied Constraint R
resources_requests.user_id Implied Constraint R
resources_user_resources.user_id Implied Constraint R
rss_feeds.user_id Implied Constraint R
schedule.user_id Implied Constraint R
schedule_seminare.user_id Implied Constraint R
scm.user_id Implied Constraint R
seminar_user.user_id Implied Constraint R
seminar_user_schedule.user_id Implied Constraint R
statusgruppe_user.user_id Implied Constraint R
user_config.user_id Implied Constraint R
user_info.user_id Implied Constraint R
user_inst.user_id Implied Constraint R
user_studiengang.user_id Implied Constraint R
user_token.user_id Implied Constraint R
user_userdomains.user_id Implied Constraint R
user_visibility.user_id Implied Constraint R
vote_user.user_id Implied Constraint R
voteanswers_user.user_id Implied Constraint R
wiki.user_id Implied Constraint R
wiki_locks.user_id Implied Constraint R
username varchar 64
password varchar 32
perms enum 6 user
Vorname varchar 64  √  null
Nachname varchar 64  √  null
Email varchar 64  √  null
validation_key varchar 10
auth_plugin varchar 64  √  null
locked bit 0 0
lock_comment varchar 255  √  null
locked_by varchar 32  √  null
visible enum 7 unknown

Table contained 5 rows at Mon Aug 25 21:10 CEST 2014

Indexes:
Column(s) Type Sort Constraint Name
user_id Primary key Asc PRIMARY
username Must be unique Asc k_username
perms Performance Asc perms

Close relationships: