Sent_Emails

List view
Voter Registration and Quality Control
Organizing
Petitions and Quality Control
Admin
Phone Banking
 

Sent_Emails


 
This table displays information on emails sent from Blocks
 

Field
Type
Description
Joins
id
primary key (int)
id of email sent
unique to table
subject
text
subject of email sent
unique to table
from
text
from of email sent
unique to table
body
text
body of email sent
unique to table
sender_id
foreign key (int)
id of user that sent the email
id in users table
list_id
foreign key (int)
id of list of people records that received the email
id in lists table
team_id
foreign key (int)
id of team associated with people records that received the email
id in teams table
event_id
foreign key (int)
id of event associated with people records that received the email
id in events table
email_template_id
foreign key (int)
id of email template
id in email_templates table
recipients_count
integer
count of recipients to the email sent
unique to table
created_at
timestamp
date&time email was sent
unique to table