Footprints Data Model

Table
Table Name Voting Result
Table Definition The root voting result entry for a ticket item that requires voting approval.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Voting Result Id The automatically generated primary key of the voting_result table. LONG Yes
Item Id A Foreign Key to the Item table. LONG No
Voting State Overall Vote State. VARCHAR(64) Yes
Item Definition Id A Foreign Key to the Definition table. LONG Yes
Voting Metadata Id A Foreign Key to the Definition table. Indicates type of voting. LONG Yes
Voting Timestamp Time of the overall vote DATE Yes