In This Article:

    The "supporter_action_comment" object

    In This Article:

      The supporter_action_comment table contains comments made on Advocacy petitions.  Petitions differ from targeted actions by the fact that they are not sent to the legislator.  Delivery is left up to the organization that publshed the petition.

      Layout

      Field Type Notes
      supporter_action_comment_KEY int supporter action comment KEY
      Last_Modified timestamp The date of the last modification to the Comment.
      Date_Created timestamp The date the supporter commented on the petition
      action_KEY int The primary key for the advocacy action containing the petition.  Required
      Comment mediumtext Comment
      MD5 varchar MD5 checksum for Comment.

       

      Format notes

      • Salsa timestamps are encoded as "YYYY-MM-DD HH:MM:SS", where all elements are numeric and "HH" is on a 24 hour clock.
      • Salsa timestamps are in the "America/NewYork" timezone (GMT-5), aka Eastern Standard Time (EST).

      Schema

      This image shows how supporters are linked to supporter_action_comment.

      Screenshot_at_Dec_28_12-10-59.png

      Please view the attachment to see how supporter_action_comment fits into the overall table structure for advocacy actions.

       

      Was this article helpful?
      0 out of 0 found this helpful
      Have more questions? Submit a request

      Comments

      0 comments

      Please sign in to leave a comment.