Table studip23.user_info 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
auth_user_md5.user_id Implied Constraint R
hobby varchar 255
lebenslauf text 65535  √  null
publi text 65535
schwerp text 65535
Home varchar 200
privatnr varchar 32
privatcell varchar 32
privadr varchar 64
score int unsigned 10 0
geschlecht tinyint 3 0
mkdate int 10 0
chdate int 10 0
title_front varchar 64
title_rear varchar 64
preferred_language varchar 20  √  null
smsforward_copy bit 0 1
smsforward_rec varchar 32
guestbook tinyint 3 0
email_forward tinyint 3 0
smiley_favorite varchar 255
motto varchar 255
lock_rule varchar 32

Table contained 5 rows at Do Aug 02 14:36 GMT+01:00 2018

Indexes:
Column(s) Type Sort Constraint Name
user_id Primary key Asc PRIMARY
score + guestbook Performance Asc/Asc score

Close relationships: