Table studip20.vote 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
vote_id varchar 32
vote_user.vote_id Implied Constraint R
voteanswers.vote_id Implied Constraint R
author_id varchar 32
range_id varchar 32
type enum 5 vote
title varchar 100
question text 65535
state enum 9 new
startdate int 10  √  null
stopdate int 10  √  null
timespan int 10  √  null
mkdate int 10 0
chdate int 10 0
resultvisibility enum 8 ever
multiplechoice bit 0 0
anonymous bit 0 1
changeable bit 0 0
co_visibility bit 0  √  null
namesvisibility bit 0 0

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

Indexes:
Column(s) Type Sort Constraint Name
vote_id Primary key Asc PRIMARY
author_id Performance Asc author_id
chdate Performance Asc chdate
range_id Performance Asc range_id
resultvisibility Performance Asc resultvisibility
startdate Performance Asc startdate
state Performance Asc state
stopdate Performance Asc stopdate

Close relationships: