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