Footprints Data Model

Table
Name voting_result
Comment The root voting result entry for a ticket item that requires voting approval.

Column
Name Datatype Comment Is PK Is FK
voting_result_id bigint The automatically generated primary key of the voting_result table. Yes No
item_id bigint The value of a Voting Result stored as Long. No No
voting_state varchar(64) Overall Vote State. No No
item_defn_id bigint A Foreign Key to the Definition table. No Yes
voting_metadata_id bigint A Foreign Key to the Definition table. Indicates type of voting. No Yes
voting_timestamp datetime Time of the overall vote No No