Table that stores survey data by device and agent profile
Data model
Fields
| Field | Type | Description |
|---|---|---|
| agent_profile_id* | INT | Agent profile identifier. Reference to the ADM_AGENT_PROFILE.id table |
| creation_date* | DATETIME | Date of creation |
| device_id* | INT | Device identifier. Reference to the AAM_DEVICE.id table |
| id* | INT | Unique Table Identifier |
| is_completed_survey* | BIT | Flag to indicate if the survey is completed |
Primary Key
| PK_ADM_AGENT_PROFILE_SURVEY |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| agent_profile_id* | Bod. ADM_AGENT_PROFILE | id | FK01_ADM_AGENT_PROFILE_SURVEY |
| device_id* | dbo.AAM_DEVICE | id | FK02_ADM_AGENT_PROFILE_SURVEY |