Footprints Data Model

Table
Name survey_sent
Comment A record of a survey sent to an application user.

Column
Name Datatype Comment Is PK Is FK
survey_sent_id bigint The automatically generated primary key of the survey_sent table. Yes No
survey_sent_email varchar(50) Email address of recipient. No No
date_sent datetime Date sent. No No
item_defn_id bigint A Foreign Key to the Definition Version table. No Yes