This is a custom table created within Tugger. This table is used to track changes in stages for tickets. Tugger monitors changes to the hs_date_entered_* and hs_date_exited_* properties and uses these to track changes within this table.
Due to the fact that these changes have to be tracked by monitoring in this way only the changes to stages are tracked from the point at which you start to use Tugger. i.e. historic changes will be unknown to Tugger.
| Column | Type | Notes |
|---|---|---|
| archived | BINARY | |
| createdAt | DATETIME | |
| entered_stage | DATETIME | |
| exited_stage | DATETIME | |
| stage | TEXT | Foreign Key from HubSpotTicketPipelineStages table |
| ticket_id | WHOLE NUMBER | Foreign Key from HubSpotTickets table |
| updatedAt | DATETIME | |
| LastTugDate | WHOLE NUMBER | The date the information was last pulled from HubSpot to Tugger in the format YYYYMMDD |
| Deleted | BINARY | Flag to indicate if the row has been deleted from HubSpot |