SchemaSpy - Table iliasRelease_3_8_x_branch.survey_answer

Generated by
SchemaSpy

Legend:

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

answer_id

int

10

√

active_fi

int

10

0

survey_fi

int

10

0

question_fi

int

10

0

qpl_question_matching.question_fi

Implied Constraint R

user_fi

int

10

0

anonymous_id

varchar

32

value

double

22

√

null

textanswer

text

65535

√

null

row

int

10

0

TIMESTAMP

timestamp

19

CURRENT_TIMESTAMP

Table contained 0 rows at Fri Dec 13 17:53 CET 2013

Indexes:

Column(s)	Type	Sort	Constraint Name
answer_id	Primary key	Asc	PRIMARY
active_fi	Performance	Asc	active_fi
anonymous_id	Performance	Asc	anonymous_id
question_fi	Performance	Asc	question_fi
survey_fi	Performance	Asc	survey_fi
user_fi	Performance	Asc	user_fi