Table studip20.eval_templates 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
template_id varchar 32
eval_templates_eval.template_id Implied Constraint R
eval_templates_user.template_id Implied Constraint R
evalgroup.template_id Implied Constraint R
user_id varchar 32  √  null
auth_user_md5.user_id Implied Constraint R
institution_id varchar 32  √  null
name varchar 255
show_questions bit 0 1
show_total_stats bit 0 1
show_graphics bit 0 1
show_questionblock_headline bit 0 1
show_group_headline bit 0 1
polscale_gfx_type varchar 255 bars
likertscale_gfx_type varchar 255 bars
mchoice_scale_gfx_type varchar 255 bars
kurzbeschreibung varchar 255  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
template_id Primary key Asc PRIMARY
user_id + institution_id + name Performance Asc/Asc/Asc user_id

Close relationships: