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 |