Table studip30.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
blubber.user_id Implied Constraint R
blubber_mentions.user_id Implied Constraint R
blubber_reshares.user_id Implied Constraint R
blubber_streams.user_id Implied Constraint R
comments.user_id Implied Constraint R
contact.user_id Implied Constraint R
coursesets.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
forum_abo_users.user_id Implied Constraint R
forum_entries.user_id Implied Constraint R
forum_favorites.user_id Implied Constraint R
forum_likes.user_id Implied Constraint R
forum_visits.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
lock_rules.user_id Implied Constraint R
log_events.user_id Implied Constraint R
mail_queue_entries.user_id Implied Constraint R
news.user_id Implied Constraint R
object_user.user_id Implied Constraint R
priorities.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
statusgruppe_user.user_id Implied Constraint R
termin_related_persons.user_id Implied Constraint R
user_config.user_id Implied Constraint R
user_factorlist.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
user_visibility_settings.user_id Implied Constraint R
userlimits.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 varbinary 64
perms enum 6 user
Vorname varchar 64  √  null
Nachname varchar 64  √  null
Email varchar 64  √  null
validation_key varchar 10
auth_plugin varchar 64  √  standard
locked bit 0 0
lock_comment varchar 255  √  null
locked_by varchar 32  √  null
visible enum 7 unknown

Table contained 5 rows at Do Aug 02 15:05 GMT+01:00 2018

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: