messageaudit
The messageaudit table describes SMS and email activity related to a participant.
Table Schema
| Name | Type | Description |
|---|---|---|
| personid | VARCHAR |
Internal identifier to specify a unique instance of a person. This column is used to partition data tables in the Bulk Data API and should be included on all table joins. Use personid to join to tables in other models within the Bulk Data API. |
| participantkey | VARCHAR |
Internal identifier to specify a unique instance of a participant in an RKStudio project. Key relationship with the participant table. |
| messageauditkey | VARCHAR |
Primary key. A unique, auto-generated internal identifier to specify a unique instance of a message. |
| application | VARCHAR |
The application related to the url provided in the message. |
| event | VARCHAR |
Description of the message-related event. For example: SMS Message Sent, SMS Message Link Clicked. |
| time | TIMESTAMP |
The time the message was sent. |
| phonenumber | VARCHAR |
The targeted phone number the message was sent to. |
| targeturl | VARCHAR |
The url provided in the message. |
| template | VARCHAR |
The template identifier associated with the message to the participant. |
