Footprints Data Model

Table
Table Name Survey Sent
Table Definition A record of a survey sent to an application user.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Survey Sent Id The automatically generated primary key of the survey_sent table. LONG Yes
Survey Sent Email Email address of recipient. VARCHAR(50) Yes
Date Sent Date sent. DATE No
Item Definition Id A Foreign Key to the Definition Version table. LONG Yes