Table ilias4_3.svy_question 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
question_id int 10 0
questiontype_fi int 10 0
obj_fi int 10 0
owner_fi int 10 0
title varchar 100  √  null
description varchar 200  √  null
author varchar 100  √  null
obligatory varchar 1  √  1
complete varchar 1  √  0
created varchar 14  √  null
original_id int 10  √  null
tstamp int 10 0
questiontext longtext 2147483647  √  null
label varchar 255  √  null

Table contained 0 rows at Sun May 01 00:15 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name
question_id Primary key Asc PRIMARY
obj_fi Performance Asc i1_idx
owner_fi Performance Asc i2_idx
title + description Performance Asc/Asc i3_idx