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 |