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 |