Footprints Data Model

Table
Name vote
Comment The vote of a single approver on a single item.

Column
Name Datatype Comment Is PK Is FK
vote_id bigint The automatically generated primary key of the vote table. Yes No
voting_timestamp datetime Voting Timestamp No No
approver_id bigint A Foreign Key to the Application User table. No Yes
comments varchar() Vote comments No No
voting_state varchar(64) State of the vote No No
voting_result_id bigint A Foreign Key to the Voting Result table. No Yes