This guide last modified:
2021-04-23 06:46.
.
| Database Schema Tables / VMP Tables | |
Fact table delivering detailed insight on text conversation participants.
| Column | Description | Example |
|---|---|---|
| TenantID | int This field is for future use only, and is currently set to 0. |
|
| BatchId | int This field is for future use only, and is currently set to 0. |
|
| ConversationID | int Displays the unique id for this conversation. When joined with the Id field in the fcttextconversation table, you can retrieve all of the participants in the conversation. |
11944 |
| InTime | timestamp Displays the time that the participant joined the conversation. |
2017-11-05 12:18:04 |
| UserID | int Displays the numeric user id associated with the conversation. The vmpusers table has the internal id of the user generated by the VMP application. |
11579 |
| FirstName | varchar Displays the first name of the user in the conversation. |
John |
| MiddleName | varchar Displays the middle name of the user in the conversation. |
|
| LastName | varchar Displays the last name of the user in the conversation. |
Smith |
| ExternalID | varchar Displays the external id. |
2220 |
| ForwardedByUserID | varchar Displays the user id of the forwarding user. This field is blank if there is no forwarding user. |
460 |
| RowCreatedTS | timestamp Displays the date and time that the table row was created. |
2017-12-05 23:50:25 |
This guide last modified:
2021-04-23 06:46.
.