Table iliasRelease_3_9_x_branch.survey_survey 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
survey_id int 10  √ 
obj_fi int 10 0
author varchar 50
introduction text 65535  √  null
outro text 65535  √  null
status enum 2 1
startdate date 10  √  null
enddate date 10  √  null
evaluation_access enum 2 0
invitation enum 2 0
invitation_mode enum 2 1
complete enum 2 0
created varchar 14
anonymize enum 2 0
show_question_titles enum 2 1
TIMESTAMP timestamp 19 CURRENT_TIMESTAMP

Table contained 0 rows at Fri Dec 13 20:19 CET 2013

Indexes:
Column(s) Type Sort Constraint Name
survey_id Primary key Asc PRIMARY
introduction Performance Asc introduction
obj_fi Performance Asc obj_fi