================================ Next Steps Tracking ================================ +------------------------------+----------------------------------+--------------------+ | Property | Description | Type | +==============================+==================================+====================+ | ID | Unique ID for the message | Auto number | +------------------------------+----------------------------------+--------------------+ | nextStepUserID | ID from the nextStep user entity | Integer/ entity | | | | reference | +------------------------------+----------------------------------+--------------------+ | created | created date/time | timestamp | +------------------------------+----------------------------------+--------------------+ | changed | changed date/time | timestamp | +------------------------------+----------------------------------+--------------------+ | step_sent | ID of the component sent | integer | +------------------------------+----------------------------------+--------------------+ | reply_received | Reply received | string | +------------------------------+----------------------------------+--------------------+ | next_step | ID of the next step to send | integer | +------------------------------+----------------------------------+--------------------+ | next_step_due_date | date to send next step | timestamp | +------------------------------+----------------------------------+--------------------+ | resent_count | integer | integer | +------------------------------+----------------------------------+--------------------+ This table is used to store a history of messages sent.