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 |