Data Structures

Campaigns table

Describes the campaigns and the amount of letters sent for each campaign.

---

letter_versions table

This data is sent to Lob, primarily template_id which is specific to each campaign by office division. This data structure triages the letter object that's being displayed and sent, specific to the template_id of the region that's being picked by the office.

​​

• keyID: use to create join or belong relationships for Users, Campaigns, and Letters sent
• template_id: lob html template
• office_division: each campaign has a different letter dependent on filter. Federal is the default.
• state: Custom versions per state
• county: Custom versions per county
• CampaignID: maps to campaigns table

---

letter_sent table

Way to understand volumes of letters being sent. This table will be used to measure conversion for letter_upload, user_volunteer and user_campaign.