Footprints Data Model

Table
Table Name Vote History
Table Definition The history of votes in the case that voting changes.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Vote History Id The automatically generated primary key of the vote_history table. LONG Yes
Voting Timestamp History timestamp DATE Yes
Comments History comments VARCHAR(max) No
Voting State History state VARCHAR(64) Yes
Vote Id A Foreign Key to the Vote table. The source of the history entry. LONG Yes