voting_subject

15 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
vote.voting_subject_id voting_subject_of_vote R
voting_question.voting_subject_id voting_subject_of_voting_question R
subject_key VARCHAR 255 null

With this key the ‘subject’ can be loaded from the messages table
begin_of_vote_time DATETIME 19 current_timestamp()
end_of_vote_time DATETIME 19 null
min_games_to_vote INT UNSIGNED 10 0

The number of games a player must have to in order to vote
description_key VARCHAR 255 √ null

The ‘description-key’ of the voting subject with it additional information (HTML) can be loaded from the messages table
topic_url MEDIUMTEXT 16777215 √ null

An URL to a page with additional information, e.g. a forum post.
reveal_winner TINYINT UNSIGNED 3 0

When set to true after voting ended the winner is calculated and shown publicly
create_time TIMESTAMP 19 current_timestamp()
update_time TIMESTAMP 19 current_timestamp()

Indexes

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

Relationships

Close relationships within degrees of separation