voting_question

303 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
voting_choice.voting_question_id voting_question_of_voting_choice R
winner_for_voting_question.voting_question_id voting_question_of_winner R
max_answers INT UNSIGNED 10 1
question_key VARCHAR 255 null

With this key the ‘question’ can be loaded from the messages table
voting_subject_id INT UNSIGNED 10 null
voting_subject.id voting_subject_of_voting_question R
description_key VARCHAR 255 √ null

The ‘description-key’ of the voting question, with it additional information (HTML) can be loaded from the messages table
ordinal INT UNSIGNED 10 0

The ‘ordinal’ of the voting question, in the client questions are shown according to their ordinal value
alternative_voting TINYINT UNSIGNED 3 0

Defines whether alternative voting applies to this question
create_time TIMESTAMP 19 current_timestamp()
update_time TIMESTAMP 19 current_timestamp()

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
voting_subject_of_voting_question Performance Asc voting_subject_id

Relationships

Close relationships within degrees of separation