Footprints Data Model |
Table |
Table Name | Vote |
Table Definition | The vote of a single approver on a single item. |
Attribute |
Attribute Name | Attribute Definition | Logical Datatype | Is Required |
Vote Id | The automatically generated primary key of the vote table. | LONG | Yes |
Voting Timestamp | Voting Timestamp | DATE | Yes |
Approver Id | A Foreign Key to the Application User table. | LONG | Yes |
Comments | Vote comments | VARCHAR(max) | No |
Voting State | State of the vote | VARCHAR(64) | Yes |
Voting Result Id | A Foreign Key to the Voting Result table. | LONG | Yes |