Database Reference

Key Table Diagrams

These entity-relationship diagrams (click each one to enlarge) show the relationships between the key tables for tracking users, subscription status, actions, donations, and mailings.

Common User Tables	Common Action Tables	Common Mailing Tables

Action Tables

The action tables relate to user actions. Users take action anytime they submit on a page.

The following action tables are described below:

• core_action

• core_actionfield

• core_actionnotification

• core_actionnotification_to_staff

• core_callaction

• core_callaction_checked

• core_callaction_local_office_checked

• core_callaction_targeted

• core_campaignvolunteeraction

• core_donationaction

• core_donationupdateaction

• core_donationcancellationaction

• core_eventcreateaction

• core_eventmoderateaction

• core_eventsignupaction

• core_eventvolunteeraction

• core_importaction

• core_letteraction

• core_letteraction_targeted

• core_lteaction

• core_petitionaction

• core_petitionaction_targeted

• core_recurringdonationcancelaction

• core_recurringdonationupdateaction

• core_redirectaction

• core_signupaction

• core_surveyaction

• core_unsubscribeaction

• core_userupdateaction

• core_whipcountaction

• core_whipcountactioncalled

• spam_spamchecklog

core_action

Every action submitted with associated user_id, page_id, and source.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for each action taken	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
user_id	int(11)	Joins to core_user on (core_action.user_id= core_user.id)	NO	MUL	NULL
mailing_id	int(11)	If user followed an email link to the action, the mailing id shows here. Joins to core_mailing.	YES	MUL	NULL
page_id	int(11)	Joins to core page on (core_page.id= core_action.page_id)	NO	MUL	NULL
link	int(11)	Not in use.	YES		NULL
source	varchar(255)	Whether the user came to this action from a website, mailing, TAF email, etc.	NO		NULL
opq_id	varchar(255)	Not in use.	NO		NULL
created_user	tinyint(1)	1 if this is the first action ever taken by this user	NO		NULL
subscribed_user	tinyint(1)	1 is this user was added to any of your mailings lists as a result of this action	NO		NULL
referring_user_id	int(11)	User_id of referrer, if the source of this action was TAF or a forwarded email.	YES	MUL	NULL
referring_mailing_id	int(11)	ID for the forwarded email if that was the action source.	YES	MUL	NULL
status	varchar(255)	Complete or incomplete. Incomplete only applies to certain page types.	NO		NULL
taf_emails_sent	int(11)	Number of friends’ emails the action taker entered in the TAF widget.	YES		NULL
is_forwarded	int(1)	0: action was not from a forwarded mailing. 1: action was from a forwarded mailing.	NO		0
ip_address	varchar(15)	IP address of the action taker.	YES		NULL
useragent_id	int	Useragent of the action taker, joining to core_useragent.	YES	MUL	NULL

core_actionfield

Custom action fields; answers to survey questions (from any page type).

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
parent_id	int(11)	Joins to the action where you find the user_id and other info. Joins on (core_actionfield.parent_id= core_action.id)	NO	MUL	NULL
name	varchar(255)	Name of the survey question. Defined on the page using “name= action_[desiredname]”	NO	MUL	NULL
value	longtext	User’s answer.	NO		NULL

core_actionnotification

Notification email to be sent to someone aside from the actiontaker after an action.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
hidden	tinyint(1)	1=hidden	NO		NULL
name	varchar(255)	The name of the email notification.	NO		NULL
to	varchar(255)	Email recipient(s)	YES		NULL
from_line_id	int(11)	From line id for standard from line from mailer.	YES	MUL	NULL
custom_from	varchar(255)	Custom from line	NO		NULL
reply_to	varchar(255)	Email recipient (or {{ user.email }}, or leave blank to default to your from line.	YES		NULL
subject	varchar(255)	Email subject.	NO		NULL
wrapper_id	int(11)	Email wrapper.	YES	MUL	NULL
body	longtext	Notification email body.	NO		NULL

core_actionnotification_to_staff

Joins notification email from above with one or more staff user_ids to receive it.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
actionnotification_id	int(11)	Joins to action notification.	NO	MUL	NULL
user_id	int(11)	Joins to auth_user.	NO	MUL	NULL

core_callaction

Records every call action submitted and joins to core_action.

Field	Type	Description	Null	Key	Default	Extra
action_ptr_id	int(11)	id for an action submittal; Joins to core_actions	NO	PRI	NULL

Other Tables Following The Same Formula

Records every action of the given type submitted and joins to core_action.

Table	Description
core_donationaction	Records every donation action submitted and joins to core_action.
core_donationupdateaction	Records every donationupdate action submitted and joins to core_action.
core_donationcancellationaction	Records every donationcancellation action submitted and joins to core_action.
core_importaction	Records every import action submitted and joins to core_action.
core_letteraction	Records every letter action submitted and joins to core_action.
core_petitionaction	Records every petition action submitted and joins to core_action.
core_recurringdonationcancelaction	Records every recurringdonationcancel action submitted and joins to core_action.
core_recurringdonationupdateaction	Records every recurringdonationupdate action submitted and joins to core_action.
core_redirectaction	Records every redirect action submitted and joins to core_action.
core_signupaction	Records every signup action submitted and joins to core_action.
core_surveyaction	Records every survey action submitted and joins to core_action.
core_unsubscribeaction	Records every unsubscribe action submitted and joins to core_action.
core_userupdateaction	Records every userupdate action submitted and joins to core_action.
core_whipcountaction	Records every whipcount action submitted and joins to core_action.

core_callaction_local_office_checked

Identifies which office the user indicated they called (if local offices were shown on the call page).

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
callaction_id	int(11)	Joins to core_action on (core_callaction_targeted.callaction_id= core_action.id)	NO	MUL	NULL
targetoffice_id	int(11)	Shows target offices listed for the action. Joins to targetoffice table on (core_callaction_local_office_checked.targetoffice_id= core_targetoffice.targetoffice_id)	NO	MUL	NULL

core_callaction_checked

Identifies which of the targets displayed on a call page the user indicated they called.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
callaction_id	int(11)	Joins to core_action.	NO	MUL	NULL
target_id	int(11)	Joins to core_target.	NO	MUL	NULL

core_callaction_targeted

Identifies who showed as targets for a specific user on a specific call page.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
callaction_id	int(11)	Joins to core_action on (core_callaction_targeted.callaction_id= core_action.id)	NO	MUL	NULL
target_id	int(11)	Shows targets listed for the action. Joins to target table on (core_callaction_targeted.target_id= core_target.target_id)	NO	MUL	NULL

Other tables following the same formula

Identifies targets for a specific user on the relevant page type.

Table	Description
core_letteraction_targeted	Identifies targets for a specific user taking action on a letter page.
core_petitionaction_targeted	Identifies targets for a specific user taking action on a petition page.

core_campaignvolunteeraction

Records every volunteer moderator signup submitted and joins to core_action as well as the event campaign.

Field	Type	Description	Null	Key	Default	Extra
action_ptr_id	int(11)	id for an action submittal; Joins to core_actions	NO	PRI	NULL
campaign_id	int(11)	Event Campaign ID. Joins to event_campaign.	NO	PRI	NULL
volunteer_id	int(11)	ID for a specific volunteer moderator/event campaign combination. Joins to events_campaign_volunteer.	NO	PRI	NULL

core_eventcreateaction

Joins each event creation action in core_action to the event. Also links to the events table.

Field	Type	Description	Null	Key	Default	Extra
action_ptr_id	int(11)	id for an action submittal; Joins to core_action	NO	PRI	NULL
event_id	int(11)	Joins to events_event.	NO	MUL	NULL

core_eventmoderateaction

Joins each event moderation action in core_action to the event.

Field	Type	Description	Null	Key	Default	Extra
action_ptr_id	int(11)	id for an action submittal; Joins to core_action	NO	PRI	NULL
event_id	int(11)	Joins to events_event.	NO	MUL	NULL
approved_event	tinyint(1)	1=yes.	NO		NULL
deleted_event	tinyint(1)	1=yes.	NO		NULL

core_eventsignupaction

Joins attendee sign up in core_action to sign up record.

Field	Type	Description	Null	Key	Default	Extra
action_ptr_id	int(11)	id for an action submittal; Joins to core_action	NO	PRI	NULL
signup_id	int(11)	Joins to events_eventsignup, which includes event_id.	NO	MUL	NULL

core_eventvolunteeraction

Joins each event moderation volunteer signup in core_action to the event campaign.

Field	Type	Description	Null	Key	Default	Extra
action_ptr_id	int(11)	id for an action submittal; Joins to core_action	NO	PRI	NULL
campaign_id	int(11)	Joins to events_campaign.	NO	MUL	NULL
volunteer_id	int(11)	Joins to events_campaignvolunteer.	NO	MUL	NULL

core_lteaction

Joins each LTE action in core_action to the newspaper and includes the letter text. Also includes the users letter.

Field	Type	Description	Null	Key	Default	Extra
action_ptr_id	int(11)	id for an action submittal; Joins to core_action	NO	PRI	NULL
subject	varchar(80)	LTE subject submitted by user.	NO		NULL
letter_text	longtext	Body of the LTE submitted by user.	NO		NULL
target_id	int(11)	Joins to core_mediatarget.	YES	MUL	NULL

core_whipcountactioncalled

Records who was called for each whipcount action and the response recorded by the user.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
target_id	int(11)	joins core_target	NO	MUL	NULL
whipcountaction_id	int(11)	joins whipcountaction	NO	MUL	NULL
response	varchar(255)	Target position submitted by user.	NO		NULL

spam_spamchecklog

A history of actions that looked like spambots, malicious users, or that matched blacklists or whitelists.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI		auto_increment
created_at	datetime		NO	MUL
updated_at	datetime		NO
check	varchar(255)	Check that matched this action.	NO
why	text	Details of the filter match.	NO
whitelisted	tinyint(1)	1=Any spam check unsubscribing or suppressing was prevented because the IP address is whitelisted.	NO
action_id	int(11)	Unique identifier for user action.	NO	MUL
action_status	varchar(255)	The action status before any filtering was applied.	NO
action_updated_at	datetime		NO
reversed	tinyint(1)	1=Filtering applied to this action has been reversed.	NO
reversed_at	datetime	If the filtering has been reversed, the timestamp of the reversal.	YES

Page Tables

The Page tables define key elements of pages, like goals, advocacy targets, and what the user sees after they submit an action.

The following core page tables are described below:

• core_allowedpagefield

• core_builtintranslation

• core_callpage

• core_callpage_target_groups

• core_campaignvolunteerpage

• core_donationpage

• core_donationcancellationpage

• core_donationupdatepage

• core_eventcreatepage

• core_eventmoderatepage

• core_eventsignuppage

• core_formfield

• core_importpage

• core_language

• core_letterpage

• core_letterpage_target_groups

• core_ltepage

• core_multilingualcampaign

• core_page

• core_page_required_fields

• core_page_tags

• core_page_visible_fields

• core_pagefield

• core_pagefollowup

• core_pagefollowup_notifications

• core_petitiondeliveryjob

• core_petitiondeliveryjob_petitions

• core_petitiondeliveryjob_target_groups

• core_petitionpage

• core_petitionpage_target_groups

• core_printtemplate

• core_recurringdonationcancelpage

• core_recurringdonationupdatepage

• core_signaturetemplate

• core_signuppage

• core_surveypage

• core_tag

• core_tellafriendpage

• core_unsubscribepage

• core_userupdatepage

• core_whipcountpage

• core_whipcountpage_target_groups

• core_whipcountpagefollowup

core_allowedpagefield

Custom field created by your group to display text or activate custom code on a particular page.

Field	Type	Description	Null	Key	Default	Extra
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
hidden	tinyint(1)	1=hidden	NO	MUL	NULL
order_index	int(1)	Sets the display order for page fields shown on the Basics screen and in the pull down display.	NO		NULL
display_name	varchar(255)	The display name is shown when selecting a custom field and may be changed in the future. Spaces, punctuation, etc are permitted.	NO	UNI	NULL
name	varchar(255)	Name of the custom page field.	NO	PRI	NULL
always_show	tinyint(1)	1=show when creating pages.	NO		0
required	tinyint(1)	Value must be entered for this field before the page can be saved.	NO		NULL
description	longtext	Description of custom page field.	YES		NULL
field_type	varchar(32)	Choose how data should be entered in this field.	NO		NULL
field_default	longtext	Provide a default value that will be pre-filled wherever this field is displayed in the admin.	NO		NULL
field_choices	longtext	Values available if the list type is Select From List or Select From List with Other.	NO		NULL
field_regex	longtext	You can provide a regular expression to validate campaigners’ input here.	NO		NULL
field_length	int(11)	Maximum number of characters; leave blank for unlimited.	YES		NULL

core_builtintranslation

ActionKit provided language translations for error messages, form fields, etc.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
hidden	tinyint(1)	1=hidden	NO		NULL
name	varchar(255)	The name for this translation.	NO	UNI	NULL
iso_code	varchar(10)	Alphanumeric iso code for the language.	NO		NULL
translations	long text	All provided translations for this language.	NO		NULL

core_callpage

Page id for all pages of type call and page specific attributes (like whether only constituents can take this action).

Field	Type	Description	Null	Key	Default	Extra
page_ptr_id	int(11)	Joins to core_page on (core_callpage.page_ptr_id= core_page.id)	NO	PRI	NULL
constituents_only_url	varchar(200)	Fallback page URL - page displayed to non-constituents in lieu of message that the action isn’t available where they live.	NO		NULL
allow_local_targetoffices	tinyint(1)	=1 displays local office phone numbers for federal legislators.	NO		NULL

core_callpage_target_groups

Joins call page to targets.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
callpage_id	int(11)	Joins to core_page and core_callpage.	NO	MUL	NULL
targetgroup_id	int(11)	Joins to core_targetgroup.	NO	MUL	NULL

Other tables following the same formula

Linking page to targets.

Table	Description
core_letterpage_target_groups	Joins letter page to targets.
core_petitionpage_target_groups	Joins petition page to targets.
core_whipcountpage_target_groups	Joins whipcount page to targets.

core_campaignvolunteerpage

Page ID for all volunteer event moderator signup pages and campaign the page is associated with.

Field	Type	Description	Null	Key	Default	Extra
page_ptr_id	int(11)	Joins to core_page on core_campaignvolunteerpage.page_ptr_id= core_page.id	NO	PRI	NULL
campaign_id	int(11)	Campaign of event the volunteer moderator signup page is associated with. Joins to events_campaign.	NO		NULL

core_donationpage

Page id for all pages of type donation and page specific attributes.

Field	Type	Description	Null	Key	Default	Extra
page_ptr_id	int(11)	Unique identifier to core_page.	NO	PRI	NULL
minimum_amount	decimal(10,2)	Minimum donation amount.	NO	NULL
payment_account	varchar(255)	Merchant vendor account used for this page.	NO	NULL
hpc_rule_id	int(11)	Joins to core_donation_hpc_rule.	YES	MUL	NULL
allow_international	tinyint(1)	1=Accept international donations.	NO	NULL
filtering_for_web_id	int(11)	Values for fraud filter are “Default for users from mailings”, “Default for users from web”, and “None”.	YES	MUL	NULL
filtering_for_mailings_id	int(11)	Values for fraud filter are “Default for users from mailings”, “Default for users from web”, and “None”.	YES	MUL	NULL
use_account_switcher	tinyint(1)	1=Currency switcher is added to donation page display.	YES
paypal_account	varchar(255)	Paypal account used for this page.	YES
paypal_user_requirements	varchar(255)	‘none’=no user data required. email=email required, all=name, email, and address required.	NO		‘none’
accept_ach	tinyint(1)	1=ACH Direct Debit is added to donation page display	NO		NULL

core_donationcancellationpage

Page id for all pages of type Cancel Recurring Donation and page specific attributes.

Field	Type	Description	Null	Key	Default	Extra
page_ptr_id	int(11)	Joins to core_page on (core_donationcancellationpage.page_ptr_id= core_page.id)	NO	PRI	NULL

core_donationupdatepage

Page id for all pages of type Update Rcurring Donation and page specific attributes.

Field	Type	Description	Null	Key	Default	Extra
page_ptr_id	int(11)	Joins to core_page on (core_donationupdatepage.page_ptr_id= core_page.id)	NO	PRI	NULL

core_eventcreatepage

Joins event campaign to the event creation page.

Field	Type	Description	Null	Key	Default	Extra
page_ptr_id	int(11)	Joins to core_page on (core_eventcreatepage.page_ptr_id = core_page.id).	NO	PRI	NULL
campaign_id	int(11)	Joins to events_campaign.	NO	MUL	NULL
campaign_title	varchar(255)	Title of campaign.	YES

core_eventsignuppage

Joins event signup to the event campaign.

Field	Type	Description	Null	Key	Default	Extra
page_ptr_id	int(11)	Joins on core_eventsignuppage.page_ptr_id= core_page.id).	NO	PRI	NULL
campaign_id	int(11)	Joins to events_campaign.	NO	MUL	NULL

core_eventmoderatepage

Joins event moderation page to the event campaign.

Field	Type	Description	Null	Key	Default	Extra
page_ptr_id	int(11)	Joins on core_eventmoderatepage.page_ptr_id= core_page.id).	NO	PRI	NULL
campaign_id	int(11)	Joins to events_campaign.	NO	MUL	NULL

core_formfield

Default fields available for inclusion in forms (name, state, etc.)

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
name	varchar(255)	Name of field.	NO	UNI	NULL

core_immediatedeliverylog

Logs every immediate delivery sent. Joins to core_action.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI		auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
email	varchar(255)	Email or link to webform if no email	YES	MUL	NULL
action_id	int(11)	Unique identifier for user action.	YES	MUL	NULL

core_immediatedeliverywarning

Used to generate message to switch to bulk delivery to admin if immediate delivery limit is exceeded.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
email	varchar(255)	Email or link to webform if no email	YES	MUL	NULL

core_importpage

Page id for all pages of type import and page specific attributes.

Field	Type	Description	Null	Key	Default	Extra
page_ptr_id	int(11)	Joins to core_page on (core_importpage.page_ptr_id = core_page.id)	NO	PRI	NULL
subscribe	tinyint(1)	1=subscribe users to list selected.	YES		1
subscribe_if_new	tinyint(1)	1=subscribe users to list selected only if they are new to database	YES		0
default_source	varchar(255)	The default value for the user source if a value is not specified for the row in the import file.	YES		NULL
unsubscribe_all	tinyint(1)	1=unsubscribe users from all lists.	YES		0
unsubscribe	tinyint(1)	1=unsubscribe user from list selected.	YES		0
privacy_notes_id	int(11)		YES	MUL	NULL
custom_privacy_notes	longtext		NO		NULL
texting_subscribe	tinyint(1)	1=subscribe users to texting list selected	NO		0
texting_list_id	int(11)	id of the texting list that texting users will be subscribed to	YES		NULL
texting_match	tinyint(1)	1=try to match imported texting_address to existing user phones	NO		0
texting_match_phone_max_age	int(11)	maximum age (in days) after which a user’s phone number is considered too unreliable for a match	NO		365
texting_match_name	varchar(20)	May be “exact”, “fuzzy”, or “none” (str) indicating minimum match quality required	NO		“fuzzy”
texting_match_location	tinyint(1)	1=require location match; either zip, or city AND state	NO		1

core_language

Name of language and error translations you’ve entered for any additional languages (aside from English).

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
name	varchar(255)	Name of language (ex. “Spanish”)	NO	UNI	NULL
translations	longtext	Translations of error and other messages as a single text blob.	NO		NULL
hidden	tinyint(1)	1=hidden	NO	MUL	NULL
iso_code	varchar(10)	iso code for the language.	YES
inherit_from_id	tinyint(4)	Built in phrases are available for English, French, and Portuguese	YES		NULL
ordering	int(11)	Order for the Language picker, 0=English.	YES		0

core_letterpage

Page id for all pages of type letter and page specific attributes.

Field	Type	Description	Null	Key	Default	Extra
page_ptr_id	int(11)	Joins to core_page on (core_letterpage.page_ptr_id= core_page.id)	NO	PRI	NULL
send_immediate_fax	tinyint(4)	Binary for enabled immediate fax.	YES		0
send_immediate_email	tinyint(4)	1=send letter immediately as email (if available).	YES		0
send_immediate_email_override_limit	tinyint(1)	1=you requestsed and received an override of the daily email delivery limit for this page.	NO		NULL
immediate_email_subject	text	Subject text.	YES		NULL
delivery_template	text	Email/fax text	YES		NULL
email_mode	int(11)		YES		NULL
remind_me_set_up_batch_delivery	tinyint(1)		NO		NULL
immediate_email_subject	text		YES		NULL
delivery_template	text		YES		NULL
batch_delivery_from_id	int(11)		YES	MUL	NULL
batch_delivery_subject	varchar(255)		YES		NULL
batch_delivery_template	longtext		YES		NULL
batch_petitiondeliveryjob_id	int(11)		YES		NULL
send_immediate_email_delivery_blocked_at	datetime		YES		NULL
batch_delivery_threshold	int(11)		YES		NULL
batch_delivery_minimum	int(11)		NO
send_via_cwc	tinyint(1)		YES		NULL
cwc_topic	varchar(255)		YES		NULL
cwc_statement	text		YES		NULL
cwc_subject	varchar(255)		YES		NULL

core_ltepage

Page id for all pages of type letter to the editor and page specific attributes such as selections made during set up for types of papers and whether to show phone number.

Field	Type	Description	Null	Key	Default	Extra
page_ptr_id	int(11)	Joins to core_page on (core_callpage.page_ptr_id= core_page.id).	NO	PRI	NULL
national_newspapers	tinyint(1)	1=show national newspapers	NO		NULL
regional_newspapers	tinyint(1)	1=show regional newspapers	NO		NULL
local_newspapers	tinyint(1)	1=show local newspapers	NO		NULL
show_phones	tinyint(1)	1=show newspaper phone number	NO		NULL
signature_template_id	int(11)	Template used for users LTE signature. Join to core_signaturetemplate.	NO	MUL	1

core_multilingualcampaign

Join translations of a page together for reporting and for your end users.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
hidden	tinyint(1)	1=hidden	NO		NULL
name	varchar(255)	Campaign name.	NO	UNI	NULL

core_page

Unique id for each page and basic info including name, goal, page type.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
title	varchar(255)	Shows to the end user as the header for the page	NO	MUL	NULL
name	varchar(255)	Generally part of the URL for the page	NO	UNI	NULL
notes	varchar(255)	Notes field for internal use.	YES
hosted_with_id	int(11)	AK or outside webserver	NO	MUL	NULL
url	varchar(255)	Not currently in use.	NO		NULL
type	varchar(255)	page type (petition, call, etc.)	NO	MUL	NULL
lang_id	int(11)	Specifies language when not English. Joins to core_language.	YES	MUL	NULL
multilingual_campaign_id	int(11)	Points to a row in core_multilingualcampaign if used. Used for grouping pages that hold different translations of the same basic campaign.	YES	MUL	NULL
goal	int(11)	optional numeric goal displays progress meter to end user	YES		NULL
goal_type	varchar(255)	actions taken or dollars raised	NO		NULL
status	varchar(255)	identifies model pages	NO	MUL	NULL
list_id	int(11)	shows list a user will be subscribed to after taking action on this page	NO	MUL	NULL
hidden	tinyint(1)	1=yes, page is hidden	NO	MUL	NULL
allow_multiple_responses	tinyint(1)	1=yes	NO		1
real_actions	tinyint(1)	1=include in reports of member actions.	NO		0
recognize	varchar(255)	Set this page to recognize users based on AKID: always, never or once.	NO		once
never_spam_check	tinyint(1)	1=do not treat actions on this page as potential spam.	NO		0

core_page_required_fields

Fields required for the user to submit the given page, selected from the formfields above.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for page/ required fields combo.	NO	PRI	NULL	auto_increment
page_id	int(11)	Identifies the page. Joins on (core_page_required_fields.page_id = core_page.id)	NO	MUL	NULL
formfield_id	int(11)	Identifies the required field. Joins on (core_page_required_fields. formfield_id= core_formfield.id)	NO	MUL	NULL

core_page_tags

Associates a page with a tag or tags.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
page_id	int(11)	Joins to core_page.	NO	MUL	NULL
tag_id	int(11)	Identifies the tag. Joins to core_tag.	NO	MUL	NULL

core_page_groups

Associates a page with one or more groups.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
page_id	int(11)	Joins to core_page.	NO	MUL	NULL
usergroup_id	int(11)	Identifies the user group. Joins to core_usergroup.	NO	MUL	NULL

core_page_visible_fields

Shows the fields you selected as required on the Action Basics screen when creating the page.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for page/ visible fields combo.	NO	PRI	NULL	auto_increment
page_id	int(11)	Identifies the page. Joins on (core_page_visible_fields.page_id = core_page.id)	NO	MUL	NULL
formfield_id	int(11)	Identifies the visible field. Joins on (core_page_visible_fields.formfield_id = core_formfield.id)	NO	MUL	NULL

core_pagefield

Page and page field value.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for this content on this page.	NO	PRI	NULL	auto_increment
parent_id	int(11)	ID for the page. Joins to core_page.	NO	MUL	NULL
name	varchar(255)	Name of field. Same name as in core_allowedpagefield.	NO	MUL	NULL
value	longtext	Text to be displayed or code to be activated by this field.	NO		NULL

core_pagefollowup

Landing page, confirmation email, TAF and sharing for all pages.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
page_id	int(11)	Joins to core_page.	NO	UNI	NULL
send_email	tinyint(1)	Determines whether a confirmation email is sent. Yes=1.	NO		NULL
url	varchar(255)	After-action landing page.	NO		NULL
email_wrapper_id	int(11)	Used in confirmation email. Joins to core_emailwrapper.	YES	MUL	NULL
email_from_line_id	int(11)	Used in confirmation email. Joins to core_fromline.	YES	MUL	NULL
email_custom_from	varchar(255)	“From” line for this confirmation email only.	NO		NULL
email_subject	varchar(255)	After-action confirmation email subject.	NO		NULL
email_body	longtext	After-action confirmation email content.	NO		NULL
send_taf	tinyint(1)	Determines whether the email TAF widget displays on the thank you page. Yes=1.	NO		NULL
taf_subject	varchar(255)	Default TAF email subject line (user can edit)	NO		NULL
taf_body	longtext	Default TAF email content (user cannot edit)	NO		NULL
share_title	varchar(255)	Customized title for sharing	YES		NULL
share_description	varchar(1024)	Customized description for sharing	YES		NULL
share_image	varchar(1024)	Customized image URL for sharing	YES		NULL
twitter_message	longtext	Customized Twitter message for sharing	YES		NULL
send_notifications	tinyint(1)	Yes=1.	NO		NULL
send_pushes	tinyint(1)	Send API Push notifications	NO		NULL
send_texts	tinyint(1)	Send confirmation text messages	NO		NULL
confirmation_text_id	int(11)	Join to texting_afteractionmessage	YES	MUL	NULL

core_pagefollowup_notifications

Joins the page followup to the notification.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
pagefollowup_id	int(11)	Joins to page follow up.	NO	MUL	NULL
actionnotification_id	int(11)	Joins to notifications.	NO	MUL	NULL

core_petitiondeliveryjob

Defines the content, delivery options, and appearance for each delivery job.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
single_file	tinyint(1)	Not currently in use.	NO		NULL
cover_html	longtext	Cover page text and html.	NO		NULL
print_template_id	int(11)	Joins to core_printtemplate. Template for cover page and petitions	NO	MUL	NULL
header_content	longtext	Header	NO		NULL
footer_content	longtext	Footer	NO		NULL
allow_pdf_download	tinyint(1)	1=yes	YES		0
allow_csv_download	tinyint(1)	1=yes	YES		0
template_set_id	int(11)	Joins to cms_templateset. Defines the appearance of the pick up website.	YES	MUL	NULL
limit_delivery	tinyint(1)	Limit to only certain targets.	NO		0
all_to_all	tinyint(1)	Deliver all signatures to all targets.	YES		0
include_prefix_in_csv	tinyint(1)	Display name prefix for users who signed in CSV.	NO		NULL
include_first_name_in_csv	tinyint(1)	Display first name for users who signed in CSV.	NO		NULL
include_middle_name_in_csv	tinyint(1)	Display middle name for users who signed in CSV.	NO		NULL
include_last_name_in_csv	tinyint(1)	Display last name for users who signed in CSV.	NO		NULL
include_suffix_in_csv	tinyint(1)	Display name suffix for users who signed in CSV.	NO		NULL
include_email_in_csv	tinyint(1)	Display email addresses for users who signed in CSV.	NO		NULL
include_phone_in_csv	tinyint(1)	Display phone number for users who signed in CSV.	NO		NULL
include_address1_in_csv	tinyint(1)	Display street addresses for users who signed in CSV.	NO		NULL
include_address2_in_csv	tinyint(1)	Display address2 for users who signed in CSV.	NO		NULL
include_city_in_csv	tinyint(1)	Display city for users who signed in CSV.	NO		NULL
include_state_in_csv	tinyint(1)	Display state for users who signed in CSV.	NO		NULL
include_zip_in_csv	tinyint(1)	Display zip codes for users who signed in CSV.	NO		NULL
include_region_in_csv	tinyint(1)	Display region for users who signed in CSV.	NO		NULL
include_postal_in_csv	tinyint(1)	Display postal for users who signed in CSV.	NO		NULL
include_country_in_csv	tinyint(1)	Display country for users who signed in CSV.	NO		NULL
include_comment_in_csv	tinyint(1)	Display signature comment for users who signed in CSV.	NO		NULL
date_from	date	Only include signatures after this date.	YES		NULL
ldate_to	date	Only include signatures before this date.	YES		NULL

core_petitiondeliveryjob_petitions

Joins the job to the page(s) to be delivered.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
petitiondeliveryjob_id	int(11)	Joins to core_petitiondeliveryjob.	NO	MUL	NULL
page_id	int(11)	Joins to core_page.	NO	MUL	NULL

core_petitiondeliveryjob_target_groups

Used to limit delivery to a subset of page targets.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for each job and target group combo.	NO	PRI	NULL	auto_increment
petitiondeliveryjob_id	int(11)	Joins to core_petitiondeliveryjob.	NO	MUL	NULL
targetgroup_id	int(11)	Joins to core_targetgroup.	NO		NULL

core_petitionpage

Page ID for all pages of type Petition and page specific attributes.

Field	Type	Description	Null	Key	Default	Extra
page_ptr_id	int(11)	Joins to core_page on (core_petitionpage.page_ptr_id= core_page.id)	NO	PRI	NULL
send_immediate_fax	tinyint(4)	1=send fax immediately upon user signature (when available)	YES
send_immediate_email	tinyint(4)	1=send email to target immediately upon user signature (when available)	YES
send_immediate_email_override_limit	tinyint(1)	1=you requested and received an override on the daily email delivery limit for this page	NO		NULL
email_mode	int(11)	Description needed.	YES		NULL
remind_me_set_up_batch_delivery	tinyint(1)	1=YES	NO		NULL
immediate_email_subject	text	Subject text for immediate email delivery.	YES		NULL
delivery_template	text	Text for email or fax	YES		NULL
one_click	tinyint(1)	1=Enable one click signing	NO		NULL
batch_delivery_from_id	int(11)		YES	MUL	NULL
batch_delivery_subject	varchar(255)	Subject line for batch delivery.	YES		NULL
batch_delivery_template	longtext		YES		NULL
batch_petitiondeliveryjob_id	int(11)		YES		NULL
send_immediate_email_delivery_blocked_at	datetime		YES		NULL
batch_delivery_threshold	int(11)		YES		NULL
batch_delivery_minimum	int(11)		NO
send_via_cwc	tinyint(1)	1=Delivery via CWC.	YES		NULL
cwc_topic	varchar(255)	Topic selected for CWC delivery for this page.	YES		NULL
cwc_statement	text		YES		NULL
cwc_subject	varchar(255)		YES		NULL

core_printtemplate

Defines the appearance of the cover letter and signature pages for delivery jobs.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
name	varchar(255)	Template name.	NO	UNI	NULL
header_html	longtext	Template header appearance.	NO		NULL
template	longtext	Body html.	NO		NULL
footer_html	longtext	Footer appearance.	NO		NULL
font_family	varchar(255)	Text font.	NO		NULL
font_size	double	Font size.	NO		NULL
logo_URL	varchar(200)	Logo to include in the header.	NO		NULL
page_size	varchar(255)	Letter or A4	NO		NULL
margin_units	varchar(255)	Inches or millimeters	NO		NULL
margin_top	double	Margin for body text.	NO		NULL
margin_bottom	double	Margin for body text.	NO		NULL
margin_left	double	Margin for body text.	NO		NULL
margin_right	double	Margin for body text.	NO		NULL
readonly	tinyint(1)	1 = makes template readonly.	NO		NULL
hidden	tinyint(1)	1 = makes template hidden.	NO		NULL

core_recurringdonationcancelpage

Pointer to page id for all pages of type cancel recurring donation.

Field	Type	Description	Null	Key	Default	Extra
page_ptr_id	int(11)	Joins to core_page on (core_recurringdonationcancelpage.page_ptr_id= core_page.id)	NO	PRI	NULL

core_recurringdonationupdatepage

Pointer to page id for all pages of type update recurring donation.

Field	Type	Description	Null	Key	Default	Extra
page_ptr_id	int(11)	Joins to core_page on (core_recurringdonationupdatepage.page_ptr_id= core_page.id)	NO	PRI	NULL
minimum_amount	decimal(10,2)	Minimum accepted donation amount.	NO		NULL

core_signaturetemplate

Template for user signature for LTEs.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	unique identifier	NO	PRI	NULL	auto_increment
name	varchar(255)	Name of signature template.	NO	UNI	NULL
is_default	tinyint(4)	=1 if this templateset is to be selected by default during page creation	YES		0
template	longtext	format for displaying user info to newspapers.	NO		NULL

core_signuppage

Pointer to page id for all pages of type Signup.

Field	Type	Description	Null	Key	Default	Extra
page_ptr_id	int(11)	Joins to core_page on (core_signuppage.page_ptr_id=core_page.id)	NO	PRI	NULL

core_surveypage

Pointer to page id for all pages of type Survey.

Field	Type	Description	Null	Key	Default	Extra
page_ptr_id	int(11)	Joins to core_page on (core_surveypage.page_ptr_id=core_page.id)	NO	PRI	NULL

core_tag

Word or phrase which can be used to associate pages or emails with a campaign or issue.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
name	varchar(255)	Tag name.	NO	UNI	NULL
hidden	tinyint(1)	1=hidden	NO	MUL	NULL
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
times_used	int(11)	Used to display most used on top.	YES		NULL
order_index	int(11)	Used to retain tag order if you change the default order on the tags screen.	NO		NULL

core_tellafriendpage

Pointer to page id for all tell-a-friend pages.

Field	Type	Description	Null	Key	Default	Extra
page_ptr_id	int(11)	Joins to core_page on (core_tellafriendpage.page_ptr_id= core_page.id).	NO	PRI	NULL

core_unsubscribepage

Pointer to page id for all unsubscribe pages and user in mail wrapper flag.

Field	Type	Description	Null	Key	Default	Extra
page_ptr_id	int(11)	Joins to core_page on (core_unsubscribepage.page_ptr_id = core_page.id)	NO	PRI	NULL
use_in_mail_wrapper	tinyint(1)	1=default unsubscribe page; always used in email wrappers unless you overwrite manually in the wrapper.	NO		NULL

core_userupdatepage

Pointer to page id for all user update pages.

Field	Type	Description	Null	Key	Default	Extra
page_ptr_id	int(11)	Joins to core_page on (core_userupdatepage.page_ptr_id= core_page.id)	NO	PRI	NULL

core_whipcountpage

Field	Type	Description	Null	Key	Default	Extra
page_ptr_id	int(11)		NO	PRI	NULL

core_whipcountpagefollowup

Field	Type	Description	Null	Key	Default	Extra
pagefollowup_ptr_id	int(11)		NO	PRI	NULL

Target tables

The Target tables relate to advocacy targets for call, whipcount, letter and petition page types and to media targets for Letters-to-the-Editor.

The following core target tables are described below:

• core_boundary

• core_boundarygroup

• core_congresstargetgroup

• core_congresstargetgroup_excludes

• core_congresstargetgroup_targets

• core_cwcdeliverylog

• core_mediatarget

• core_pagetargetchange

• core_petitionpage_target_groups

• core_specialtarget

• core_specialtargetgroup

• core_poltarget

• core_poltargetgroup

• core_target

• core_targetgroup

core_boundary

Unique geographic area defined by a spatial file or a handdrawn boundary. Can be associated with a custom target.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
group_id	int(11)	Unique identifier.	NO	MUL	NULL	auto_increment
name	varchar(255)	Name of the specific boundary (e.g. school district 6).	NO		NULL
geometry	multipolygon	Description needed.	NO	MUL	NULL
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL

core_boundarygroup

A group of boundaries of the same type (e.g. School District #23 boundary might belong to the Madison School District group).

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
hidden	tinyint(1)	1=yes	NO		NULL	auto_increment
name	varchar(255)	Name of the boundary group.	NO	UNI	NULL
description	longtext	Optional description for the group.	YES		NULL

core_congresstargetgroup

Indicates whether the congressional group includes Republicans, Democrats, and/or Independents.

Field	Type	Description	Null	Key	Default	Extra
targetgroup_ptr_id	int(11)	Joins to core_targetgroup, which defines the legislative body, on (core_targetgroup.id=core_congresstargetgroup.targetgroup_ptr_id)	NO	PRI	NULL
include_republicans	tinyint(1)	1=yes	NO		NULL
include_democrats	tinyint(1)	1=yes	NO		NULL
include_independents	tinyint(1)	1=yes	NO		NULL
states	longtext	contains list of states included in group. default is all states.	NO		NULL

core_congresstargetgroup_excludes

Individuals excluded from the congress target group above.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
congresstargetgroup_id	int(11)		NO	MUL	NULL
target_id	int(11)		NO	MUL	NULL

core_congresstargetgroup_targets

Individual legislators targeted (used when you pick specific individuals versus targeting by body and party).

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
congresstargetgroup_id	int(11)		NO	MUL	NULL
target_id	int(11)		NO	MUL	NULL

core_cwcdeliverylog

Log of all successful constituent deliveries via the Communicating With Congress integration.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
target_id	int(11)	Joins to core_target.	NO	MUL	NULL
action_id	int(11)	Joins to core_action.	NO	MUL	NULL
cwc_delivery_id	varchar(255)		YES		NULL

core_mediatarget

Contact and circulation data for newspapers for LTEs.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
hidden	tinyint(1)	1=hidden	NO		NULL
address1	varchar(255)	Newspaper address.	NO		NULL
address2	varchar(255)	Newspaper address.	NO		NULL
city	varchar(255)	Newspaper address.	NO		NULL
state	varchar(255)	Newspaper address.	NO		NULL
region	varchar(255)	Newspaper address.	NO		NULL
postal	varchar(255)	Newspaper address.	NO		NULL
zip	varchar(5)	Newspaper address.	NO		NULL
plus4	varchar(4)	Newspaper address.	NO		NULL
country	varchar(255)	Newspaper address.	NO		NULL
longitude	double	Newspaper longitude.	YES		NULL
latitude	double	Newspaper latitude.	YES		NULL
orgid	int(11)	Paper identifier.	YES		NULL
name	varchar(255)	Reporter name.	NO		NULL
phone	varchar(255)	Reporter phone.	YES		NULL
fax	varchar(255)	Reporter fax.	YES		NULL
email_address	varchar(255)	Reporter email.	YES		NULL
website_url	varchar(255)	Newspaper website.	YES		NULL
circulation	int(11)	Circulation size.	YES		NULL
frequency	varchar(36)	Daily, weekly, etc.	YES		NULL
language	varchar(64)	Newspaper language.	YES		NULL
levelcode	varchar(64)	Local, regional, national.	YES		NULL
dmacode	varchar(10)	Designated Market Area code.	YES		NULL
fipscode	int(11)	Standardized geographic area codes (state, county, etc.)	YES		NULL
msacode	int(11)	Metropolitan Statistical Area identifier.	YES		NULL

core_pagetargetchange

Used to redistribute signatures after a targeting change.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
page_id	int(11)	Joins to advocacy page with changed targeting.	NO	UNI	NULL
targets_representation	longtext	Need description.	NO		NULL

core_specialtarget

Custom targets.

Field	Type	Description	Null	Key	Default	Extra
target_ptr_id	int(11)	Joins to core_target on (core_target.id= core_specialtarget.target_ptr_id)	NO	PRI
body_id	int(11)	Defines the group to which the custom target belongs. Joins to core_targetgroup.	NO	MUL
boundary_id	int(11)	Joins to core_boundary.id.	YES		NULL

core_specialtargetgroup

A group of custom targets.

Field	Type	Description	Null	Key	Default	Extra
targetgroup_ptr_id	int(11)	Identifies group. Joins to core_targetgroup.	NO	PRI	NULL	auto_increment
jurisdiction	varchar(50)	All, state or country.	NO		all
custom_boundaries_id	int(11)		YES	MUL	NULL

core_poltarget

International targets.

Field	Type	Description	Null	Key	Default	Extra
target_ptr_id	int(11)	Joins to core_target on (core_target.id=core_poltarget.target_ptr_id)	NO	PRI
body_id	varchar(255)	Identifies the political body to which the target belongs.	NO	MUL
person_id	varchar(255)	Unique external person id.	NO	MUL
division_id	varchar(255)	Id of the division (political geography) this target belongs to.	NO	MUL

core_poltargetgroup

A group of international targets.

Field	Type	Description	Null	Key	Default	Extra
targetgroup_ptr_id	int(11)	Identifies group. Joins to core_targetgroup.	NO	PRI	NULL	auto_increment
body_id	varchar(255)	Identifies the political body to which the target belongs.	NO

core_target

Contact information for the president, House and Senate members, and delegates, plus any custom targets you have added.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
type	varchar(255)	house or senate	NO	MUL	NULL
seat	varchar(255)	Only available for Senate seat.	NO	MUL	NULL
country	varchar(255)	Designated target’s country.	NO	MUL	NULL
state	varchar(255)	Designated target’s state.	NO	MUL	NULL
city	varchar(255)	Designated target’s city.	NO	MUL	NULL
region	varchar(255)	Designated target’s region.	NO	MUL	NULL
county	varchar(255)	Designated target’s county.	NO	MUL	NULL
us_district	varchar(255)	Only pertains to House member target’s districts.	NO	MUL	NULL
title	varchar(255)	Target’s title	NO		NULL
long_title	varchar(255)	Target’s title	NO		NULL
first	varchar(255)	Target’s given first name.	NO		NULL
last	varchar(255)	Target’s last name.	NO		NULL
official_full	varchar(255)	Full name of target using nickname if available otherwise given name. Only available for some target types.	NO		NULL
nickname	varchar(255)	Nickname if different than given name (e.g. Bernie instead of Bernard). Only available for some target types.	NO		NULL
phone	varchar(255)	Target’s phone number.	NO		NULL
fax	varchar(255)	Target’s fax number.	NO		NULL
email	varchar(255)	Email or link to webform if no email	NO		NULL
gender	varchar(1)	Target’s preferred gender pronouns. Value is null for They/Them/Theirs; M for He/Him/His; or F for She/Her/Hers.	NO		NULL
party	varchar(255)	Target’s party affiliation.	NO		NULL
hidden	tinyint(1)	=1 is hidden	NO		0
district_name	varchar(255)		NO	MUL	NULL
twitter	varchar(255)		YES		NULL
twitter_id	varchar(255)		YES		NULL
facebook	varchar(255)		YES		NULL
facebook_id	varchar(255)		YES		NULL
youtube	varchar(255)		YES		NULL
youtube_id	varchar(255)		YES		NULL
instagram	varchar(255)		YES		NULL
instagram_id	varchar(255)		YES		NULL

Note: we cannot expose the email details of representatives, so the email field is sometimes listed as actionkit-contact@example.com. Behind the scenes, there is a lookup for the real email address of the representative when a query that includes it is used in targeting.

core_targetgroup

Groups of targets.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for this group of targets	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
name	varchar(255)	Name of group. For example, U.S. House is all house members.	NO	UNI	NULL
type	varchar(255)	House, senate or other.	NO	MUL	NULL
readonly	tinyint(1)	1=true	NO		0
hidden	tinyint(1)	1=hidden	NO	MUL	NULL

core_targetoffice

District offices for congressional targets.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL
updated_at	datetime		NO		NULL
target_id	int(11)	Joins to core_target on (core_target.id= core_targetoffice.target_id)	NO	MUL	NULL
type	varchar(255)	house or senate	NO	MUL	NULL
address1	varchar(255)	Address of office.	NO		NULL
address2	varchar(255)	Address of office.	NO		NULL
name	varchar(255)	Office name	NO		NULL
city	varchar(255)	Office location city	NO		NULL
state	varchar(255)	Office location state	NO		NULL
zip	varchar(255)	Office location zip	NO		NULL
phone	varchar(255)	Office phone number.	NO		NULL
fax	varchar(255)	Office fax number.	NO		NULL
is_current	tinyint(1)	1=true. 0=old office info.	NO		NULL

core_letterpage_target_groups

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
letterpage_id	int(11)		NO	MUL	NULL
targetgroup_id	int(11)		NO	MUL	NULL

core_petitionpage_target_groups

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
petitionpage_id	int(11)		NO	MUL	NULL
targetgroup_id	int(11)		NO	MUL	NULL

Event tables

The Event tables relate to event pages and actions.

The following core event tables are described below:

• events_campaign

• events_campaignvolunteer

• events_emailbodylog

• events_emaillog

• events_emaillog_to_users

• events_event

• events_eventfield

• events_eventsignup

• events_eventsignupfield

• events_historicalevent

• events_customemailgroup

• events_customemail

events_campaign

Settings for a particular events campaign.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
title	varchar(255)	Campaign title–used on event creation pages.	NO	MUL	NULL
name	varchar(255)	Campaign name – used in the URL.	NO	UNI	NULL
public_create_page	tinyint(1)	0=only staff can create events; 1=public can create events	NO		NULL
use_title	tinyint(1)	0=use the title in this table; 1=allow hosts to set a title for their own event	NO		NULL
starts_at	datetime	Default event date and time.	YES		NULL
use_start_date	tinyint(1)	0=use default date; 1=allow hosts to pick date	NO		NULL
use_start_time	tinyint(1)	0=use default time; 1=allow hosts to pick time	NO		NULL
require_staff_approval	tinyint(1)	0=no; 1=yes	NO		NULL
require_email_confirmation	tinyint(1)	not in use	NO		NULL
allow_private	tinyint(1)	0=no; 1=yes	NO		NULL
max_event_size	int(11)	Max event size a host can enter for their event.	YES		NULL
default_event_size	int(11)	Default size pre-filled on event creation page.	YES		NULL
public_search_page	tinyint(1)	Not in use.	NO		NULL
show_title	tinyint(1)	0=display default title on search page; 1=display host provided title on search page	NO		NULL
show_venue	tinyint(1)	0=no; 1=yes	NO		NULL
show_address1	tinyint(1)	0=no; 1=yes	NO		NULL
show_city	tinyint(1)	0=no; 1=yes	NO		NULL
show_state	tinyint(1)	0=no; 1=yes	NO		NULL
show_zip	tinyint(1)	0=no; 1=yes	NO		NULL
show_public_description	tinyint(1)	0=no; 1=show host provided description if available	NO		NULL
show_directions	tinyint(1)	0=no; 1=show host provided directions if available	NO		NULL
show_attendee_count	tinyint(1)	0=no; 1=yes	NO		NULL
default_title	varchar(255)	Not in use.	No
hidden	tinyint(1)	1=yes, campaign is hidden			0
show_completed_events	tinyint(1)	0=no; 1=yes	No		0
show_full_events	tinyint(1)	0=no; 1=yes	No		0
mode_onsite	tinyint(1)	0=no; 1=yes	No		1
mode_local	tinyint(1)	0=no; 1=yes	No		0
mode_global	tinyint(1)	0=no; 1=yes	No		0

events_campaignvolunteer

Record of each volunteer moderator signup and their status.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
user_id	int(11)	Joins to core_user.	NO	MUL	NULL
campaign_id	int(11)	Joins to events_campaign.	NO	MUL	NULL
is_approved	tinyint(1)	Staff approval status. 1=approved.	NO		NULL
status	varchar(32)	Description needed	NO		NULL

events_emailbodylog

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
body	longtext	Copy of the email body text sent.	NO		NULL

events_emaillog

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
from_type	varchar(32)	ADD	NO		NULL
to_type	varchar(32)	ADD	NO		NULL
event_id	int(11)	Joins to events_event.	NO	MUL	NULL
from_user_id	int(11)	Description needed	YES	MUL	NULL
from_admin_id	int(11)	Description needed	YES	MUL	NULL
user_written_subject	longtext	Description needed	YES		NULL
body_id	int(11)	Joins to events_emailbodylog.	NO	MUL	NULL

events_emaillog_to_users

Joins the email from the log to the recipient.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
emaillog_id	int(11)	Joins to events_emaillog.	NO	MUL	NULL
user_id	int(11)	Joins to core_user.	NO	MUL	NULL

events_event

Selections made by host for their event.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
address1	varchar(255)	Event address.	NO		NULL
address2	varchar(255)	Event address.	NO		NULL
city	varchar(255)	Event address.	NO		NULL
state	varchar(255)	Event address.	NO	MUL	NULL
us_district	varchar(5)	Event address.	NO	MUL	NULL
us_county	varchar(24)	Event address.		MUL	NULL
region	varchar(255)	International events only.	NO		NULL
postal	varchar(255)	International events only.	NO		NULL
zip	varchar(5)	Event address.	NO	MUL	NULL
plus4	varchar(4)	Event address.	NO		NULL
country	varchar(255)	MUL	NO		NULL
longitude	double	Event address.	YES		NULL
latitude	double	Event address.	YES		NULL
campaign_id	int(11)	Joins to events_campaign.	NO	MUL	NULL
title	varchar(255)	Host-provided event title.	NO	MUL	NULL
creator_id	int(11)	User_id of person who created the event.	NO	MUL	NULL
starts_at	datetime	Host-provided start time in the event’s local time.	YES		NULL
ends_at	datetime	Not in use.	YES		NULL
status	varchar(32)	active, cancelled, deleted	NO		NULL
host_is_confirmed	tinyint(1)	0=no; 1=yes	NO		NULL
is_private	tinyint(1)	0=no; 1=yes	NO		NULL
is_approved	tinyint(1)	0=no; 1=yes	NO		NULL
attendee_count	int(11)	Current count.	NO		NULL
max_attendees	int(11)	Host-provided event max.	YES		NULL
venue	varchar(255)	Host-provided venue.	NO		NULL
phone	varchar(255)	Host phone.	NO		NULL
public_description	longtext	Description host provides of the event.	NO		NULL
directions	longtext	Directions if provided by host.	NO		NULL
note_to_attendees	longtext	Note from host to display on attendee tools page if provided.	NO		NULL
notes	longtext	Any notes entered by staff through the event admin.	NO		NULL
mode	varchar(32)	Event type: onsite, local, or global.	NO		onsite
starts_at_utc	datetime	Host-provided start time in UTC.	YES		NULL
ends_at_utc	datetime	Not in use.	YES		NULL
timezone	varchar(255)	Event timezone.	YES		NULL
confirmed_at	datetime	Date/time of event confirmation.	YES		NULL
approved_at	datetime	Date/time of event approval.	YES		NULL
merged_to_id	int(11)	ID of event merged to.	YES		NULL

events_eventfield

Custom event field – host page.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
parent_id	int(11)	Joins to events_event.	NO	MUL	NULL
name	varchar(255)	Name of custom event field.	NO	MUL	NULL
value	longtext	Value entered by host.	NO		NULL

events_eventsignup

Record of each sign up, including role.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
user_id	int(11)	Joins to core_user.	NO	MUL	NULL
event_id	int(11)	Joins to events_event.	NO	MUL	NULL
role	varchar(32)	Attendee or host.	NO		NULL
status	varchar(32)	Active, deleted or cancelled.	NO		NULL
page_id	int(11)	Joins to core_page.	NO		0
attended	tinyint(1)	Binary, 1=YES.	YES		0

events_eventsignupfield

Custom event field – attendee page.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
parent_id	int(11)	Joins to events_eventsignup.	NO	MUL	NULL
name	varchar(255)	Name of custom event field.	NO	MUL	NULL
value	longtext	Value entered by attendee.	NO		NULL

events_historicalevent

This stores previous versions of an event. Joins to events_event.

Field	Type	Description	Null	Key	Default	Extra
history_id	int(11)	Unique identifier of the event’s history record. Not to be confused with id, the unique identifier of the event.	NO	PRI	NULL	auto_increment
history_date	datetime	Date/time this event was updated, and this history record was saved as a result	NO		NULL
history_change_reason	varchar(100)	For internal use only.	NO		NULL

events_customemailgroup

This associates a collection of custom event emails to a page. Joins to core_page.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
page_id	int(11)	Which page is associated with this group of custom emails. Joins to core_page.	NO	UNIQUE	NULL

events_customemail

Allows customizing an event’s emails, like event approval and cancellation emails. Joins to events_customemailgroup.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
group_id	int(11)	Which custom email group is associated with this custom email. Joins to events_customemailgroup.	NO		NULL
email_subject	longtext	Customizes the email subject associated with this email, or leave blank to use what’s in this page’s templateset.	NO		NULL
email_body	longtext	Customizes the email body associated with this email, or leave blank to use what’s in this page’s templateset.	NO		NULL
email_body	varchar(50)	Which type of event email should this customize? Must match the filename of the templateset; use one of: event_email_approved.html, event_email_from_admin.html, event_email_from_attendee.html, event_email_from_host.html, event_email_from_moderator.html, event_email_cancelled.html, event_email_attendee_removed.html, event_email_role_changed.html, event_email_details_changed.html, event_email_volunteer_approved.html.	NO		NULL

Donation tables

The Donation table relate to donations and products to be used in donation page types.

The following core donation tables are described below:

• core_authnettransactionlog

• core_candidate

• core_candidate_tags

• core_donationchangelog

• core_donation_hpc_rule

• core_donation_hpc_rule_condition

• core_donation_hpc_rule_exclude_tags

• core_donationfraudfilter

• core_donationpage_candidates

• core_donationpage_products

• core_order

• core_order_detail

• core_order_shipping_address

• core_order_user_detail

• core_orderrecurring

• core_paymentaccount

• core_product

• core_product_tags

• core_transaction

core_authnettransactionlog

Additional data from auth.net (empty unless they are your vendor).

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
source	varchar(255)	Description needed.	NO		NULL
raw	longtext	Description needed.	NO		NULL
processed	tinyint(1)	Description needed.	NO	MUL	NULL

core_candidate

Candidates for use in bundling on donation pages.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for candidate.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
hidden	tinyint(1)	1=hidden.	NO	MUL	NULL
name	varchar(255)	Candidate name for display, includes titles.	NO	UNI	NULL
fec_id	varchar(16)	Candidate’s FEC ID.	YES	UNI	NULL
portrait_url	varchar(255)	URL of candidate photo for inclusion on page.	NO		NULL
description	longtext	Text about candidate.	NO		NULL
status	varchar(255)	values are active candidate or inactive candidate.	NO		NULL
is_ours	tinyint(1)	Used to indicate that this candidate/entity should be considered “yours”, not an external candidate/entity. This is used to filter contributions in some reports.	NO	MUL	NULL

core_candidate_tags

Tags associated with a candidate.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for candidate, tag combo.	NO	PRI	NULL	auto_increment
candidate_id	int(11)	Joins to core_candidate.	NO	MUL	NULL
tag_id	int(11)	Joins to core_tag.	NO	MUL	NULL

core_donationchangelog

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime(6)		NO	MUL	NULL
updated_at	datetime(6)		NO		NULL
change_type	varchar(255)		NO		NULL
action_id	int(11)		NO	MUL	NULL
order_id	int(11)		NO	MUL	NULL
recurring_id	int(11)		YES	MUL	NULL
transaction_id	int(11)		YES	MUL	NULL
new_amount	decimal(10		NO		NULL
user_id	int(11)		YES	MUL	NULL
staff_id	int(11)		YES	MUL	NULL

core_donation_hpc_rule

Name and timestamps for each set of rules for suggested ask amounts based on HPC (Highest Previous Contribution), 2nd highest contribution, and average.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
name	varchar(255)	Name of this Suggested Ask Formula.	NO	UNI	NULL
hidden	tinyint(1)	1=hidden	NO	MUL	NULL
which_amount	varchar(255)	values are “Highest Donation”, “Second Highest Donation”, “Average Donation”, and “Most Recent”.	NO		highest
timespan	varchar(255)	values are “to the begining (default)”, “6 months”, “12 months”, and “24 months”.	NO		all
currency	varchar(3)	Currency used for this Suggested Ask Formula.	No		USD

core_donation_hpc_rule_condition

Thresholds and ask amounts for each set of Suggestion Ask Rules.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
rule_id	int(11)	Identifies which rule set this threshold and ask belong to. Joins to core_donation_hpc_rule.	NO	MUL	NULL
threshold	varchar(10)	Amount, above the previous threshold, up to which the ask applies.	NO		NULL
ask	varchar(10)	Ask amount to be displayed for up to this threshold.	NO		NULL

core_donation_hpc_rule_exclude_tags

Joins tags you’ve selected for exclusion from suggested ask rules with the rule.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
donationhpcrule_id	int(11)	Unique identifier for hpc rule.	NO	MUL	NULL
tag_id	int(11)	Unique identifier for tag.	NO	MUL	NULL

core_donationfraudfilter

MaxMind anti-fraud settings which apply if you enable this.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
hidden	tinyint(1)	=1 means this filter is hidden.	NO	MUL	NULL
name	varchar(255)	The name of the fraud filter	NO	UNI	NULL
check_maxmind	tinyint(1)	=1 enables maxmind.	NO		NULL
maxmind_threshold	int(11)	Integer representing percentage of allowable chance of donation fraud.	NO		NULL
whitelist_where	longtext	Description needed.	NO		NULL
blacklist_where	longtext	Description needed.	NO		NULL
is_default_for_mailings	tinyint(1)	=1 is default for mailings	NO		NULL
is_default_for_web	tinyint(1)	=1 is default for web	NO		NULL
message	longtext	Message displayed to user if fraud is detected.	NO		NULL

core_donationpage_products

Joins donation page to product.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for this combination of page and product(s).	NO	PRI	NULL	auto_increment
donationpage_id	int(11)	Joins to core_page.	NO	MUL	NULL
product_id	int(11)	Joins to core_product.	NO	MUL	NULL

Tables following the same formula

Table	Description
core_donationpage_candidates	Joins donation page to candidate.

core_order

Information about donations and/or product orders made by a user.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO	MUL	NULL
action_id	int(11)	Shows the action associated with this order. Joins to core_action.	NO	UNI	NULL
user_id	int(11)	Shows the user who made this order. Joins to core_user.	NO	MUL	NULL
user_detail_id	int(11)	Joins to core_order_user_detail.	NO	MUL	NULL
shipping_address_id	int(11)	Where a shipping address was given, joins to core_order_shipping_address.	YES	MUL	NULL	auto_increment
total	decimal(10,2)	Total of donations and products.	NO		NULL
total_converted	decimal(10,2)	Total of donations and products, converted to USD	NO		NULL
currency	varchar(3)	Currency code.	NO		USD
status	varchar(255)	Shows if the order was completed or if it failed.	NO		NULL
card_num_last_four	varchar(4)	Last four digits of credit card	YES		NULL
import_id	varchar(64)	identifier you specify in your CSV for imported donations	YES	MUL	NULL
account	varchar(255)	name of the merchant vendor account for this order	YES		NULL
payment_method	varchar(255)	“cc” for creditcard, or “paypal”	NO		cc

core_order_detail

Quantity and amount of products ordered by a user.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
order_id	int(11)	Joins to core_order.	NO	MUL	NULL
product_id	int(11)	Joins to core_product.	YES	MUL	NULL
quantity	int(11)	Number of the product ordered by the user.	NO		NULL
amount	decimal(10,2)	Total for products only (not including any additional donation).	NO		NULL
amount_converted	decimal(10,2)	Total for products only approximately converted into USD.	NO		0.00
candidate_id	int(11)	Joins to core_candidate.	YES	MUL	NULL
currency	varchar(3)	Currency used for this order.	No		USD

core_order_shipping_address

Shipping address for orders of shippable products.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
address1	varchar(255)	Shipping address line 1.	NO		NULL
address2	varchar(255)	Shipping address line 2.	NO		NULL
city	varchar(255)	Shipping city.	NO		NULL
state	varchar(255)	Shipping state.	NO		NULL
region	varchar(255)	International region.	NO		NULL
postal	varchar(255)	Postal code for international shipping.	NO		NULL
zip	varchar(5)	Shipping zip.	NO	MUL	NULL
plus4	varchar(4)	Zip code plus 4.	NO		NULL
country	varchar(255)	Shipping country.	NO		NULL

core_order_user_detail

Billing information for user and source of action. Billing address is the last saved address for the order. Updates to the billing address for a recurring profile made by the user or an admin will overwrite the previously saved billing address in this table.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
email	varchar(255)	User email address for this donation.	NO	MUL	NULL
prefix	varchar(255)	User name prefix.	NO		NULL
first_name	varchar(255)	User first name.	NO		NULL
middle_name	varchar(255)	User middle name.	NO		NULL
last_name	varchar(255)	User last name.	NO		NULL
suffix	varchar(255)	User name suffix.	NO		NULL
address1	varchar(255)	User address	NO		NULL
address2	varchar(255)	User address	NO		NULL
city	varchar(255)	User city	NO		NULL
state	varchar(255)	User state	NO		NULL
region	varchar(255)	International user region.	NO		NULL
postal	varchar(255)	International user postal code.	NO		NULL
zip	varchar(5)	User zip code.	NO	MUL	NULL
plus4	varchar(4)	User zip plus 4 digit code.	NO		NULL
country	varchar(255)	User country.	NO		NULL
source	varchar(255)	Source of the action. Matches the source shown for this action in core_action.	NO	MUL	NULL

core_orderrecurring

Information about recurring donation commitments made by a user.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
order_id	int(11)	Joins to core_order.	NO	MUL	NULL
action_id	int(11)	Joins to core_action with the most recent action ID that created or updated the order.	NO	MUL	NULL
exp_date	varchar(6)	Credit card expiration date.	NO		NULL
card_num	varchar(4)	Last 4 digits.	NO		NULL
recurring_id	varchar(255)	the profile or subscription ID with the payment gateway	YES		NULL
account	varchar(255)	Name of your vendor/account. See “Payment account” dropdown when you create a donation page.	YES		NULL
user_id	int(11)	Joins to core_user.	NO	MUL	NULL
start	date	Recurring billing start date. This is not the date of the first payment for this profile, it’s the date of the first automatically processed payment. Query core_transaction to find the first payment date.	NO		NULL
period	varchar(255)	months, weeks, years, quarters	NO		NULL
amount	decimal(10,2)	Recurring payment amount.	NO		NULL
currency	varchar(3)	The original currency for the transaction.	NO		USD
amount_converted	decimal(10,2)	Recurring payment amount approximately converted into USD.	NO		0.00
status	varchar(255)	active canceled_by_admin canceled_by_expired canceled_by_failure canceled_by_processor canceled_by_user disabled failed pending past_due	NO

core_paymentaccount

Configuration information for payment accounts

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
hidden	tinyint(1)	1=hidden	NO	MUL	NULL
name	varchar(255)	Payment account name	NO	UNI	NULL
processor	varchar(255)	Payment processor	NO		NULL
auth	longtext	Processor authentication information (encrypted)	NO		NULL
extra	json	Additional configuration information specific to the processor	NO		{}

core_product

Name, price and other key information for products to be used on donation pages.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
name	varchar(255)	Product name.	NO	UNI	NULL
description	longtext	Description of product.	NO		NULL
price	decimal(10,2)	Price for product. Can be 0.	NO		NULL
currency	varchar(3)	The original currency for the transaction.	NO		USD
shippable	tinyint(1)	If the product is shippable (value=1), AK will ask for the user’s shipping address.	NO		NULL
status	varchar(255)	Active or inactive.	NO		NULL
maximum_order	int(11)	The maximum number of this product an end user can order.	NO		NULL
hidden	tinyint(1)	1=hidden	NO	MUL	NULL
admin_name	varchar(255)		YES		NULL

core_product_tags

Associates a product with a tag or tags.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
product_id	int(11)	Joins to core_product.	NO	MUL	NULL
tag_id	int(11)	Joins to core_tag.	NO	MUL	NULL

core_transaction

Transactions are created for every donation processed through ActionKit.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
type	varchar(255)	recurring_order_cancel, recurring_order_create,recurring_order_update, or sale	NO	MUL	NULL
order_id	int(11)	Joins to core_order.	NO	MUL	NULL
account	varchar(255)	Merchant account vendor. Payflow Pro, Braintree or Authorize.net.	NO		NULL
amount	decimal(10,2)	Payment total.	NO		NULL
amount_converted	decimal(10,2)	Payment total approximately converted to USD.	NO		0.00
test_mode	tinyint(1)	not in use	NO		NULL
success	tinyint(1)	1=yes	NO		NULL
trans_id	varchar(255)	ID of transaction with the merchant account vendor.	YES		NULL
failure_description	varchar(255)	If the transaction failed, explains why.	NO		NULL
failure_code	int(11)	Vendor provided failure code.	YES		NULL
failure_message	varchar(255)	More detail about why the transaction failed.	NO		NULL
status	varchar(255)	Completed, failed or reversed.	NO		NULL
currency	varchar(3)	The original currency for the transaction.	NO		USD
ref_transaction_id	int(11)	For refunds or credits this is a reference to the original transaction.	YES

Mailing Tables

Related to mailings created and sent from the mailings tab.

The following core mailing tables are described below:

• core_allowedemailwrapperfield

• core_allowedmailingfield

• core_blackholeddomain

• core_blackholedemail

• core_blackholedhistory

• core_bounce

• core_bounce_soft

• core_click

• core_click_raw

• core_clickurl

• core_clientdomain

• core_emailwrapper

• core_emailwrapperfield

• core_failedusermailing

• core_fromline

• core_mailboxprovideractivity

• core_mailing

• core_mailing_proof_users

• core_mailing_reviewers

• core_mailing_tags

• core_mailingerror

• core_mailingfield

• core_mailinghaiku

• core_mailingsubject

• core_mailingvariation

• core_mailingvariationdetail

• core_mailingvariation_users

• core_mailingtargeting

• core_mailingtargetingsummary

• core_mailingtargeting_actions

• core_mailingtargeting_campaigns

• core_mailingtargeting_languages

• core_mailingtargeting_lists

• core_mailingtargeting_mailings

• core_mailingtargeting_target_groups

• core_mailingtargeting_tags

• core_mailingtargeting_users

• core_mailingtargeting_user_groups

• core_mailingtargeting_was_monthly_donor

• core_mailingtestgroup

• core_mailingadditionaltargeting

• core_mergefile

• core_mergequeryparam

• core_message_event_raw

• core_open

• core_open_raw

• core_queuedemail

• core_recurringdonortargetingoption

• core_recurringmailingschedule

• core_redirect

• core_targetingactionfield

• core_targetingqueryreport

• core_targetingqueryreportparam

• core_userdailysummary

• core_usermailing

• core_amptap

core_allowedemailwrapperfield

Field created by your group to customize settings in your email wrapper. Similar to templateset fields, but for email wrappers.

Field	Type	Description	Null	Key	Default	Extra
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
hidden	tinyint(1)	1=hidden	NO		NULL
name	varchar(255)	Unique name	NO	PRI	NULL
always_show	tinyint(1)	1 = shows this custom mailing field when creating wrappers.	NO	1=show	NULL
display_name	varchar(255)	The display name is shown when selecting a custom field and may be changed in the future. Spaces, punctuation, etc are permitted.	NO	UNI	NULL
order_index	int(1)	Sets the order of display on the Create screen for email wrapper fields.	NO		NULL
description	longtext	Description of custom email wrapper field.	YES
field_default	longtext	Provide a default value that will be pre-filled wherever this field is displayed in the admin.	NO		NULL
field_choices	longtext	Values available if the list type is Select From List or Select From List with Other.	NO		NULL
field_regex	longtext	You can provide a regular expression to validate input here.	NO		NULL
field_type	varchar(32)	Choose how data should be entered in this field.	NO		NULL
field_length	int(11)	Maximum number of characters; leave blank for unlimited.	YES		NULL
required	tinyint(1)	A value must be entered for this field before the email wrapper can be saved.	NO		NULL

core_allowedmailingfield

Field created by your group to customize settings in your mailing.

Field	Type	Description	Null	Key	Default	Extra
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
hidden	tinyint(1)	1=hidden	NO		NULL
name	varchar(255)	Unique name	NO	PRI	NULL
always_show	tinyint(1)	1 = shows this custom mailing field when creating mailings.	NO	1=show	NULL
display_name	varchar(255)	The display name is shown when selecting a custom field and may be changed in the future. Spaces, punctuation, etc are permitted.	NO	UNI	NULL
order_index	int(1)	Sets the order of display on the Create screen for mailing fields that are not used in the wrapper and in the pull down display.	NO		NULL
description	longtext	Description of custom mailing field.	YES
field_default	longtext	Provide a default value that will be pre-filled wherever this field is displayed in the admin.	NO		NULL
field_choices	longtext	Values available if the list type is Select From List or Select From List with Other.	NO		NULL
field_regex	longtext	You can provide a regular expression to validate campaigners’ input here.	NO		NULL
field_type	varchar(32)	Choose how data should be entered in this field.	NO		NULL
field_length	int(11)	Maximum number of characters; leave blank for unlimited.	YES		NULL
required	tinyint(1)	A value must be entered for this field before the mailing can be saved.	NO		NULL

core_blackholeddomain

List of email domains to suppress from bulk and transactional mailings.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
domain	varchar(255)	Domain to be suppressed.	NO	UNI	NULL

core_blackholedemail

List of email addresses to suppress from bulk and transactional mailings.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
email	varchar(255)	Email address to be suppressed.	NO	UNI	NULL

core_blackholedhistory

Log of all email addresses that were suppressed from bulk or transactional mailings, along with mailing_id or action_id if available.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
email	varchar(255)	Email address that was suppressed.	NO	MUL	NULL
mailing_id	int(11)	Joins to core_mailing.	YES		NULL
action_id	int(11)	Joins to core_action.	YES		NULL
matched_email	tinyint(1)	1=matched an email address in core_blackholedemail.	NO		NULL
matched_domain	tinyint(1)	1=matched a domain in core_blackholeddomain.	NO		NULL

core_bounce

User and mailing id for all hard bounces. Bounced users are unsubscribed.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
user_id	int(11)	Joins to core_user.	NO	MUL	NULL
mailing_id	int(11)	Joins to core_mailing.	YES	MUL	NULL
action_id	int(11)	Joins to core_action.	YES	MUL	NULL
timestamp	timestamp	Time of the bounce.	NO		CURRENT_TIMESTAMP	on update CURRENT_TIMESTAMP
bounce_type	varchar(6)	“bounce” or “shared”	YES		bounce
bounce_class	int(11)	Sparkpost bounce classification code	YES		NULL

core_bounce_soft

User and mailing id for soft bounces that get recorded by ActionKit.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
user_id	int(11)	Joins to core_user.	NO	MUL	NULL
mailing_id	int(11)	Joins to core_mailing.	YES	MUL	NULL
action_id	int(11)	Joins to core_action.	YES	MUL	NULL
bounce_class	int(11)	Sparkpost bounce classification code	YES		NULL
created_at	datetime		NO	MUL	NULL

core_click

Tracks clicks to a page. Only clicks with a mailing_id are associated with a mailing.

Field	Type	Description	Null	Key	Default	Extra
clickurl_id	int(11)	Pulls in the url. Joins to core_clickurl on (core_click.clickurl_id= coreclickurl.id)	NO	MUL	NULL
user_id	int(11)	User who clicked the link.	YES	MUL	NULL
mailing_id	int(11)	Email with the link the user clicked. Joins on (core_click.mailing_id= core_mailing.id)	YES	MUL	NULL
link_number	int(11)	Describes which link in the email the user clicked.	YES		NULL
source	varchar(255)	The source value from the mailing link	YES	MUL	NULL
referring_user_id	int(11)	User_id of referrer, if the source of this action was TAF	YES		NULL
created_at	timestamp		NO		CURRENT_TIMESTAMP
id	bigint(20)	Unique identifier.	NO	PRI	NULL	auto_increment
useragent_id	int(11)	ADD	YES		NULL

core_click_raw

As core_click, but tracks clicks to a page, which includes real clicks and those believed to be created by software or email providers hiding actual user activity. Only clicks with a mailing_id are associated with a mailing. Raw clicks older than 90 days are deleted automatically.

core_clickurl

Relates url for click tracking to the page.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
url	varchar(255)	Url for links in a mailing.	NO	UNI	NULL
page_id	int(11)	Page associated with that URL. Joins on (core_clickurl.page_id= core_page.id)	YES	MUL	NULL
created_at	datetime		NO	MUL	NULL

core_clientdomain

Other domains you control and for which links in emails should be tracked as ActionKit domains.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
domain	varchar(255)	The URL.	NO	UNI	NULL

core_emailwrapper

Sets the appearance of an email.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
name	varchar(255)	Wrapper name.	NO	UNI	NULL
template	longtext	Html defining the appearance and where the text is inserted.	NO		NULL
text_template	longtext	Text only version of template defining the appearance and where the email body is inserted.	NO		NULL
hidden	tinyint(1)	1=hidden	NO	MUL	NULL
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
unsubscribe_text	text	Required link to an unsubscribe page and related description (text only version).	YES		NULL
unsubscribe_html	text	Required link to an unsubscribe page and related description (HTML version).	YES		NULL
is_default	int(11)	Used to set this as the default template.	YES		0
lang_id	int(11)	Optional language setting for this wrapper. Joins to core_language.	YES	MUL	NULL

core_emailwrapperfield

Custom email wrapper field value. Joins to core_emailwrapper.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
parent_id	int(11)	Joins to core_emailwrapper.	NO	MUL	NULL
name	varchar(255)	Field name	NO	MUL	NULL
value	longtext	Field value	NO		NULL

core_failedusermailing

Record of mailings where a user was targeted but not sent an email because of a missing or bad snippet value.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for this failed mailing and user combo.	NO	PRI	NULL	auto_increment
mailing_id	int(11)	Identifies which mailing_id. Joins to core_mailing.	NO	MUL	NULL
user_id	int(11)	Identifies the user who didn’t get the mailing. Joins to core_user.	NO		NULL
subject_id	int(11)	Identifies the subject of the mailing. Joins to core_mailingsubject.	YES	MUL	NULL
created_at	datetime		NO		NULL
reasons	longtext	Failure reason.	NO		NULL

core_fromline

Names and email addresses from which emails can be sent.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
from_line	text	Ex.:Your Organization <info@example.com>	NO	UNI
hidden	tinyint(1)	1=hidden	NO	MUL	NULL
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL

core_mailboxprovideractivity

Matches users based on their recent engagement history and mailbox provider, in order to allow you to target mailings. This is commonly used to target active users or exclude inactive users.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI		auto_increment
created_at	datetime		NO
updated_at	datetime		NO
name	varchar(255)	Name, which must be unique.	NO	UNI
description	varchar(255)	Description	NO
type	varchar(16)	‘includes’ or ‘excludes’, which determines how this is used.	NO
criteria	JSON	JSON representation of the criteria used in matching users.	NO
hidden	tinyint(1)	1=hidden	NO

core_mailing

Content and key information for all sent and draft emails.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Mailing id.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL
updated_at	datetime		NO
fromline_id	int(11)	Specifies who will show in the from line of the email (generally name and email address). Joins on (core_mailing.fromline_id= core_fromline.id)	YES	MUL	NULL
custom_fromline	text	Empty unless the sender created a from line for use in this mailing only, in which case this overrides fromline_id above.	NO
reply_to	varchar(255)	Email address that will receive responses if recipients hit reply.	YES		NULL
notes	varchar(255)	Notes field for internal use.	YES		NULL
html	longtext	Html and content of the email.	YES		NULL
lang_id	int(11)	Joins to core_language.	YES	MUL	NULL
text	longtext	Text version of the email.	YES		NULL
emailwrapper_id	int(11)	Defines the appearance of the email. Joins on (core_mailing.emailwrapper_id= core_emailwrapper.id)	YES	MUL	NULL
web_viewable	tinyint(1)	1=Mailing can be viewed on the web.<	YES		0
html_only	tinyint(1)	1=Only send an HTML (or AMP) version of the mailing.	NO		0
landing_page_id	int(11)	For emails linking to call and petition pages, pulls the related targeting. Joins on (core_mailing.landing_page_id= core_page.id)	YES	MUL	NULL
winning_subject_id	int(11)	not in use)	YES	MUL	NULL
requested_proofs	int(11)	Number of proofs requested.	YES		NULL
submitter_id	int(11)	User_id of staff user who submitted the email.	YES	MUL	NULL
queue_task_id	varchar(255)	Internal identifier.	YES		NULL
queued_at	datetime	Date/time when the mailing was added to the send queue.	YES		NULL
queued_by_id	int(11)	ID of staff user who hit send.	YES	MUL	NULL
expected_send_count	int(11)	Estimated number of emails that will be sent.	YES		NULL
started_at	datetime	Time the mailing began sending to the targets.	YES		NULL
finished_at	datetime	Time the mailing finished sending.	YES		NULL
query_queued_at	datetime	Time the query was queued.	YES		NULL
query_started_at	datetime	Time the query started building.	YES		NULL
query_completed_at	datetime	Time the query finished building.	YES		NULL
query_previous_runtime	int(11)	Time the query took to run on previous submit.	YES		NULL
query_status	varchar(255)	Query build status.	YES		NULL
query_task_id	varchar(255)	Query task unique identifier.	YES		NULL
targeting_version	int(11)	Needs description	YES		0
targeting_version_saved	int(11)	Needs description	YES		NULL
status	varchar(255)	Draft, queued (in line to send), sending, completed, stopped, died, recurring, and model.	YES		NULL
includes_id	int(11)	Identifies group of criteria selected under include. Joins on (core_mailing.includes_id= core_mailingtargeting.id)	YES	MUL	NULL
excludes_id	int(11)	Identifies group of criteria selected under exclude. Joins on (core_mailing.excludes_id= core_mailingtargeting.id)	YES	MUL	NULL
limit	int(11)	Shows if the submitter set a limit on the number of emails to be sent. The limit applies if it’s less than the total users who meet the targeting criteria. Generally used in testing.	YES		NULL
sort_by	varchar(32)	Random (generally used in testing), scorepool_userscore (most engaged to least engaged), or zip (sends from the east to the west).	YES		NULL
rate	double	Send rate.	YES		NULL
progress	int(11)	Number sent so far	YES		NULL
pid	int(11)		YES		NULL
hidden	tinyint(1)	1=hidden	NO	MUL	NULL
target_group_from_landing_page	tinyint(1)	Advocacy targets selected on landing page (petition, call, letter, whipcount only)	NO		0
scheduled_for	datetime	Time the mailing will send (scheduled mailings only).	YES		NULL
scheduled_by_id	int(11)	User that scheduled the mailing.	YES	MUL	NULL
sent_proofs	int(11)	Needs description	NO		0
rebuild_query_at_send	tinyint(1)	1=YES	NO		0
limit_percent	int(11)	not in use.	YES		NULL
mergefile_id	int(11)	Merge file unique identifier.	YES	MUL	NULL
target_mergefile	tinyint(1)	1 if AK should use the merge file identifier column to target recipients	NO		0
mergequery_report_id	int(11)	ID of the query report to be used as a merge query. Joins to reports_report_id.	YES	MUL	NULL
target_mergequery	tinyint(1)	1 if AK should use the merge query identifier column to target recipients	NO		0
mails_per_second	double	count of mails sent per second	YES		NULL
recurring_schedule_id	int(11)	Join to recurringmailingschedule table.	YES	MUL	NULL
recurring_source_mailing_id	int(11)	Joins to master recurring mailing they were copied from.	YES	MUL	NULL
requested_proof_date	datetime		YES		NULL
send_date	varchar(255)	Date to be used for auto-exclusion.	NO	MUL
exclude_ordering	int(11)	Ordering for auto-excludes send date.	Yes
test_group_id	int(11)	Mailing’s test group.	YES	MUL
test_remainder	int(11)		YES
version	smallint(6)		NO		NULL
archive	longtext	Archived HTML from the sent mailing. The content will be generated for the same random user as the final proofs.	YES
amp_archive	longtext	Archived AMP HTML from the sent mailing, if any. The content will be generated for the same random user as the final proofs.	YES
bee_json	longtext	Generated JSON used to re-construct mailing blocks for the Drag-and-Drop Editor.	YES		NULL
bee_session	varchar(36)	ID of the active collaborative editing session when using the Drag-and-Drop Editor.	YES		NULL
use_autotest	tinyint(1)	Whether this mailing is using Automatic Subject Line Testing	YES		NULL
autotest_status	varchar(255)	One of: (default, canceled_manually, or canceled_unsubs)	YES		default
autotest_resend	int(11)	Foreign key of the winning subject Mailing. Joins to core_mailing on (core_mailing.id = autotest_resend)	YES		NULL
autotest_wait_minutes	int(11)	How long in minutes to wait after sending the test mailing before choosing a winner. Uses 10-minute increments.	YES		NULL
autotest_status	varchar(32)	Which result metric to use for choosing the winner. One of: (opens, clicks, actions, amount)	YES		default
autotest_max_unsub_rate	double	If the unsubscribe rate is higher than this, the rest of the mailing will not be automatically sent.	YES		NULL

core_mailing_proof_users

Shows user_ids entered under “see proofs for specific users” and the mailing_id.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
mailing_id	int(11)	Identifies the mailing. Joins to core_mailing.	NO	MUL	NULL
user_id	int(11)	Identifies the user. Joins to core_user	NO	MUL	NULL

core_mailing_reviewers

Shows which mailings were sent as proofs to which staff users.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
mailing_id	int(11)	Joins to core_mailing.	NO	MUL	NULL
user_id	int(11)	Joins to core_user.	NO	MUL	NULL

core_mailing_tags

Associates a mailing with a tag.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
mailing_id	int(11)	Mailing unique identifier, joins with core_mailing.	NO	MUL	NULL
tag_id	int(11)	Identifies the tag. Joins to core_tag.	NO	MUL	NULL

core_mailingerror

Information that may be helpful in identifying the cause of a mailing error.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
mailing_id	int(11)	Identifies which mailing had the error. Joins to core_mailing.	NO	MUL	NULL
queue_task_id	varchar(255)	Internal use only.	NO		NULL
traceback	longtext	Info about the error.	NO		NULL

core_mailingfield

Custom mailing field value. Joins to core_mailing.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
parent_id	int(11)	Joins to core_mailing.	NO	MUL	NULL
name	varchar(255)	Field name	NO	MUL	NULL
value	longtext	Field value	NO		NULL

core_mailinghaiku

Mailer haikus.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for haiku.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
text	longtext	Haiku text.	NO		NULL

core_mailingsubject

Subject or subjects associated with an email

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for each subject.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
text	longtext	Subject text.	NO		NULL
preview_text	longtext	Preview text.	YES		NULL
mailing_id	int(11)	Specifies the mailing. Joins on (core_mailingsubject.mailing_id= core_mailing.id)	NO	MUL	NULL

core_mailingvariation

The variations of an A/B mailing test.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for each variation.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO	MUL	NULL
mailing_id	int(11)	Reference to id in the core_mailing table.	NO	MUL	NULL
letter	varchar(2)	The letter (A, B, C, etc.) of this variation, used for ordering. This is unique when combined with mailing_id.	NO		NULL
notes	varchar(255)	Your notes about this test variation.	YES		NULL
archive	longtext	A sample of the HTML that was sent for this variation.	YES		NULL

core_mailingvariationdetail

The content changes for variations in A/B mailing tests. The built-in fields are treated as variation A and all other variations are here.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for each variation detail.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO	MUL	NULL
variation_id	int(11)	Reference to id in the core_mailingvariation table.	NO	MUL	NULL
field_type	varchar(255)	Type of mailing field this change applies to, either standard or custom.	NO		NULL
field_name	varchar(255)	Name of the field this change applies to.	NO		NULL
value	longtext	The content to substitute for the default (variation A) content on this field.	NO		NULL

core_mailingvariation_users

Mapping between A/B test variations and the users who received them.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for each row.	NO	PRI	NULL	auto_increment
variation_id	int(11)	Reference to id in the core_mailingvariation table.	NO	MUL	NULL
user_id	int(11)	Reference to id in the core_user table.	NO	MUL	NULL

core_mailingtargeting

Criteria for inclusion or exclusion from the select recipients screen. Joins to core_mailing on core_mailingtargeting.id=core_mailing.includes_id or core_mailing.excludes_id.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Identifier for all criteria under “include” or all criteria under “exclude” for a given mailing.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
states	longtext	U.S. states.	YES		NULL
cds	longtext	Congressional Districts	YES		NULL
zips	longtext	U.S. zip codes, or city, state, or city, country or postcode country (for use with zip radius except for zip which can be a stand alone).	YES		NULL
zip_radius	int(11)	Radius for zip code or other geographic points	YES		NULL
has_donated	tinyint(1)	1=yes; previous donations checkbox.	YES		NULL
is_monthly_donor	tinyint(1)	Not in use.	YES		NULL
raw_sql	longtext	Raw SQL.	YES		NULL
state_house_districts	longtext	U.S. state house districts.	YES		NULL
state_senate_districts	longtext	U.S. state senate districts.	YES		NULL
is_delivery	tinyint(1)	1=Yes if mailing is a petition or letter signature delivery.	YES		0
delivery_job_id	int(11)	Joins to core_petitiondeliveryjob.	YES	MUL	NULL
counties	longtext	U.S. counties.	YES		NULL
campaign_radius	int(11)	Radius around the zip of events within selected event campaign.	YES		NULL
countries	text	Countries.	YES		NULL
divisions	text	Ids of international boundaries.	YES		NULL
campaign_samestate_only	tinyint(1)	Only invite members to events in their own state.	NO		0
campaign_same_county_only	tinyint(1)	Only invite members to events in their own county.	NO		0
campaign_same_district_only	tinyint(1)	Only invite members to events in their own US House District.	NO		0
mirror_mailing_excludes	tinyint(1)	Excludes sent mailings that excluded this one.	NO		1
regions	longtext	Non-U.S. regions.	YES		NULL
scorepool_score_min	int(11)	Matches users with at least this Scorepool User Score.	YES		NULL
scorepool_score_max	int(11)	Matches users whose Scorepool User Score is less than this value.	YES		NULL
scorepool_score_include_missing	tinyint(1)	Whether to match users who do not have a Scorepool User Score.	YES		NULL
reports_use_and	tinyint(1)	Whether to combine query reports using AND logic instead of default OR logic.	YES		NULL

core_mailingtargetingsummary

Statistics about this mailing set’s users, frozen at the time of the mailing set build. Uses summary_user in order to calculate all stats. All data should be interpreted in the context of when the mailing was built. Can be compared with core_userdailysummary when the created_at dates of both are equal to determine whether this mailing set is average, better than average, or worse than average.

Field	Type	Description	Null	Key	Default	Extra
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
mailing_id	int(11)	Primary Key. Joins to core_mailing on core_mailing.id = core_mailingsummarytargeting.mailing_id	NO	PRI
targeting_version	int(11)	Which targeting version this summary is valid for, or NULL if it’s still being calculated.	YES		NULL
avg_last_mailed	int(11)	Number of days between when this mailing set was built and the date of the average non-null value for summary_user.last_mailed for users in this mailing set.	YES		NULL
avg_last_open	int(11)	Number of days between when this mailing set was built and the date of the average non-null value for summary_user.last_open for users in this mailing set.	YES		NULL
avg_last_click	int(11)	Number of days between when this mailing set was built and the date of the average non-null value for summary_user.last_click for users in this mailing set.	YES		NULL
avg_last_mailing_action	int(11)	Number of days between when this mailing set was built and the date of the average non-null value for summary_user.last_mailing_action for users in this mailing set.	YES		NULL
avg_last_donation	int(11)	Number of days between when this mailing set was built and the date of the average non-null value for summary_user.last_donation for users in this mailing set.	YES		NULL
avg_actions_last_90_days	int(11)	Average number of actions taken in the last 90 days by all users in this mailing set.	YES		NULL
avg_scorepool_userscore	int(11)	Average ScorePool User Score for all users in this mailing set. (NULL if you are not enrolled in ScorePool)	YES		NULL
users_without_summary	int(11)	Number of users in this mailing set who do not have an entry in the summary_user table. (In late 2023, summary_user was changed so all users would have an entry.)	YES		NULL
users_without_last_mailed	int(11)	Number of users in this mailing set who have a NULL value for summary_user.last_mailed.	YES		NULL
users_without_last_open	int(11)	Number of users in this mailing set who have a NULL value for summary_user.last_open.	YES		NULL
users_without_last_click	int(11)	Number of users in this mailing set who have a NULL value for summary_user.last_click.	YES		NULL
users_without_last_mailing_action	int(11)	Number of users in this mailing set who have a NULL value for summary_user.last_mailing_action.	YES		NULL
users_without_last_donation	int(11)	Number of users in this mailing set who have a NULL value for summary_user.last_donation.	YES		NULL
users_without_scorepool_userscore	int(11)	Number of users in this mailing set who have no entry in scorepool_userscore.	YES		NULL
recipients	int(11)	Number of users who will receive this mailing, or who can receive this mailing OR its automatic subject line test winner.	YES		NULL

core_mailingtargeting_actions

Targeting by whether user has taken action on a given page. Additional criteria (for inclusion or exclusion) added to set defined in core_mailingtargeting.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for each targeting and page combination. One target set will have multiple rows if multiple pages are targeted.	NO	PRI	NULL	auto_increment
mailingtargeting_id	int(11)	Identifies the set of criteria to which this one is added. Can be for either inclusion or exclusion. See table above.	NO	MUL	NULL
page_id	int(11)	Identifies the page. Joins on (core_mailing_targeting_actions.page_id= core_page.id)	NO	MUL	NULL

Other tables following the same formula

Adding targeting criteria (for inclusion or exclusion) to sets of criteria identified in the core_mailingtargeting table.

Table	Description
core_mailingtargeting_lists	Targeting by whether user is on a given list.
core_mailingtargeting_mailings	Targeting by whether user is included in the targeting for another mailing.
core_mailingtargeting_users	Targeting by user_id.
core_mailingtargeting_user_groups	Targeting by usergroup_id.
core_mailingtargeting_languages	Targeting by whether user took action on a page associated with the given language.
core_mailingtargeting_was_monthly_donor	Targeting by recurring donor status. Joins to core_recurringdonortargetingoption .
core_mailingtargeting_target_groups	Targeting constituents of advocacy targets in specified target group (as defined from links on the pages tab).
core_mailingtargeting_campaigns	Targeting users by proximity (specified in core_mailingtargeting ) to event in the campaign in this table.
core_mailingtargeting_tags	Targeting by whether the user took action on a page associated with the designated tag.
core_targetingqueryreport	Targeting by results of a query report. Joins to reports_report using report_id .

core_mailingadditionaltargeting

Associates additional targeting sets with a mailing for OR targeting functionality.

Field	Type	Description	Null	Key	Default	Extra
mailingtargeting_ptr_id	int(11)	Joins to core_mailingtargeting.id	NO	PRI	NULL
mailing_id	int(11)	Joins to core_mailing.id	NO	MUL	NULL

core_mailingtestgroup

A group of mailings for launching and viewing test results together.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI		auto_increment
created_at	datetime		NO	MUL
updated_at	datetime		NO
title	longtext	Mailing subject used for this test.	YES
number_of_mailings	int(11)	Count of mailings within this group.	NO
prime	int(11)	Prime number used for modulo.	NO
status	varchar(255)	Status of the mailing.	YES

core_mergefile

Merge files uploaded for use in mailings.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
name	varchar(255)	Merge file name.	NO		NULL
path	varchar(255)	merge file path.	NO		NULL
status	varchar(20)	Upload status	YES		NULL
lookup_table	varchar(255)	Table that will return user_ids for targeting based on the value in the lookup_column (e.g., core_user or core_location)	YES		NULL
lookup_column	varchar(255)	Name of the column to match on to identify users (e.g. id or zip or city,state)	YES		NULL
started_at	datetime	Start time for merge table upload.	YES		NULL
finished_at	datetime	End time for merge table upload.	YES		NULL
row_count	int(11)	Rows with valid match, available for use in mailing.	YES		NULL
line_count	int(11)	Number of lines in the merge file (including header row)	YES		NULL
error	longtext	Errors encountered while loading merge file.	NO		NULL

core_mergequeryparam

Parameters to use with the merge query for a specific mailing.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
mailing_id	int(11)	Joins to core_mailing.id	NO	MUL	NULL
name	varchar(255)	Parameter name.	NO		NULL
value	varchar(255)	Parameter value.	NO		NULL

core_message_event_raw

Stores the last 90 days of raw deliverability data, such as bounces and delays.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
user_id	int(11)	User identifier, joins with core_user.	YES	MUL	NULL
mailing_id	int(11)	Mailing identifier, joins with core_mailing.	YES	MUL	NULL
action_id	int(11)	Action identifier, joins with core_action.	YES	MUL	NULL
created_at	datetime		NO		CURRENT_TIMESTAMP
timestamp	datetime	Date time from mailing event json	YES		NULL
event_type	varchar(25)	e.g.: “bounce”, “delay”, etc.	NO	MUL	NULL
bounce_class	int(11)	See Bounce Classification Codes	YES	MUL	NULL
num_retries	int(11)	Index of retry for this mailing/message. (0 = first try)	YES	MUL	NULL
smtp_error_code	varchar(3)	See SMTP error codes	YES		NULL
ext_event_id	varchar(25)	Unique vendor-provided ID of this event	NO	UNI	NULL
enhanced_status	varchar(25)	Enhanced mail system status codes (See rfc3463)	YES		NULL

core_open

Tracks all real opens by mailing and user.

Field	Type	Description	Null	Key	Default	Extra
user_id	int(11)	User identifier, joins with core_user.	YES	MUL	NULL
mailing_id	int(11)	Mailing identifier, joins with core_mailing.	YES	MUL	NULL
created_at	timestamp		NO		CURRENT_TIMESTAMP
id	bigint(20)		NO	PRI	NULL	auto_increment
useragent_id	int(11)		YES		NULL

core_open_raw

As core_open, but tracks all opens by mailing and user, which includes real opens and those believed to be created by software or email providers hiding actual user activity. Raw opens older than 90 days are deleted automatically.

core_queuedemail

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
envelope_sender	longtext		NO		NULL
to	longtext		NO		NULL
message	longtext		NO		NULL
metadata	longtext		NO		NULL

core_recurringdonortargetingoption

Recurring donor statuses available in mailer targeting “Monthly Donors” box.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for status. 1-5.	NO	PRI	NULL	auto_increment
code	varchar(255)	Short status descriptions (i.e., expires_this_month)	NO		NULL
description	varchar(255)	Status description (i.e., Card will expire at the end of the month )	NO		NULL

core_recurringmailingschedule

Table for storage of recurring series information.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
hidden	tinyint(1)		NO	MUL	NULL
name	varchar(255)		NO		NULL
tz_name	varchar(64)		NO		NULL
schedule_type	varchar(255)		YES		NULL
hours	varchar(255)		YES		NULL
days_of_week	varchar(255)		YES		NULL
days_of_month	varchar(255)		YES		NULL
send_finished_notice	tinyint(1)		NO		NULL

core_redirect

See short links section of user guide.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
short_code	varchar(255)	Use links with a name and no number with this code.	YES	UNI	NULL
url	varchar(4096)	URL to be redirected.	YES		NULL
created_at	datetime		NO	MUL	NULL

core_targetingactionfield

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime(6)		NO	MUL	NULL
updated_at	datetime(6)		NO		NULL
targeting_id	int(11)		NO	MUL	NULL
page_id	int(11)		YES	MUL	NULL
name	varchar(255)		NO		NULL
values	longtext		YES		NULL

core_targetingqueryreport

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
report_id	int(11)		NO	MUL	NULL
targeting_id	int(11)		NO	MUL	NULL

core_targetingqueryreportparam

Additional parameters provided by staffer when using a query report to target a mailing.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
query_id	int(11)	Query identifier.	NO	MUL	NULL
name	varchar(255)	Parameter name.	NO		NULL
value	varchar(255)	Value entered by staffer for the parameter.	NO		NULL

core_targetinguserfield

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime(6)		NO	MUL	NULL
updated_at	datetime(6)		NO		NULL
targeting_id	int(11)		NO	MUL	NULL
field_id	varchar(255)		NO	MUL	NULL
values	longtext		YES		NULL

core_userdailysummary

Statistics about your subscribed users who have a record in summary_user and have received at least 1 mailing in the last 30 days. Uses summary_user in order to calculate all stats. All data should be interpreted in the context of when the record was created. Can be compared with core_mailingtargetingsummary when the created_at dates of both are equal to determine whether that mailing set is average, better than average, or worse than average.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Primary key	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
avg_last_mailed	int(11)	Average number of days between when this snapshot was created and the date of the average non-null value for summary_user.last_mailed for recently-mailed subscribed users.	YES		NULL
avg_last_open	int(11)	Average number of days between when this snapshot was created and the date of the average non-null value for summary_user.last_open for recently-mailed subscribed users.	YES		NULL
avg_last_click	int(11)	Average number of days between when this snapshot was created and the date of the average non-null value for summary_user.last_click for recently-mailed subscribed users.	YES		NULL
avg_last_mailing_action	int(11)	Average number of days between when this snapshot was created and the date of the average non-null value for summary_user.last_mailing_action for recently-mailed subscribed users.	YES		NULL
avg_last_donation	int(11)	Average number of days between when this snapshot was created and the date of the average non-null value for summary_user.last_donation for recently-mailed subscribed users.	YES		NULL
avg_actions_last_90_days	int(11)	Average number of actions taken in the last 90 days by all recently-mailed subscribed users, using summary_user.actions_last_90_days.	YES		NULL
avg_scorepool_userscore	int(11)	Average value of scorepool_userscore.score for all recently-mailed subscribed users.	YES		NULL

core_usermailing

Record of every mailing sent to every user.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for this mailing and user combo.	NO	PRI	NULL	auto_increment
mailing_id	int(11)	Identifies which mailing_id. Joins to core_mailing.	NO	MUL	NULL
user_id	int(11)	Identifies the user who got the mailing. Joins to core_user.	NO	MUL	NULL
subject_id	int(11)	Identifies the subject of the mailing. Joins to core_mailingsubject.	YES	MUL	NULL
created_at	datetime		NO	MUL	NULL

core_amptap

Records when AMP Emails are clicked/tapped.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for this mailing and user combo.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
user_id	int(11)	Identifies the user who received the mailing. Joins to core_user.	NO	MUL	NULL
mailing_id	int(11)	Identifies which mailing the user received. Joins to core_mailing.	NO	MUL	NULL
useragent_id	int(11)	Identifies the user’s browser. Joins to core_useragent.	YES	MUL	NULL

Transactional mailing Tables

Related to transactional mailings sent as a result of actions.

The following transactional mailing tables are described below:

• core_transactionalmailing

• core_notificationmailing

• core_tafmailing

• core_confirmationmailing

• core_transactionalmailingsent

• core_transactionalmailingopen

• core_transactionalmailingclick

• core_transactionalmailingaction

• core_transactionalmailingunsub

core_transactionalmailing

Content and key information for all sent transactional emails.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for each transactional mailing.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
hidden	tinyint(1)	1=hidden	NO	MUL	NULL
page_id	int(11)	Page associated with this transactional mailing. Joins to core_page.	NO	MUL	NULL
variation_id	int(11)	A/B testing variation associated with the page at the time of action, if any. Joins to lab_variation.	YES	MUL	NULL
wrapper_id	int(11)	Joins to core_emailwrapper.	YES	MUL	NULL
from_line_id	int(11)	Specifies who will show in the from line of the email (generally name and email address). Joins to core_fromline.	YES	MUL	NULL
custom_from	varchar(255)	Empty unless the sender created a from line for use in this mailing only, in which case this overrides fromline_id above.	NO		NULL
reply_to	varchar(255)	Email address that will receive responses if recipients hit reply.	YES		NULL
subject	varchar(255)	Mailing subject text.	NO		NULL
body	longtext	Mailing content.	YES		NULL
status	varchar(20)	Active, inactive, or test if page a/b test sets transactional email behavior.	YES	MUL	NULL
type	varchar(20)	confirmation, taf, notification	NO	MUL	NULL
signature	varchar(255)	Not used.	YES		NULL

core_notificationmailing

Records every action notification mailing and joins to core_transactionalmailing.

Field	Type	Description	Null	Key	Default	Extra
transactionalmailing_ptr_id	int(11)	Joins to core_transactionalmailing.	NO	PRI	NULL
notification_id	int(11)	Joins to core_actionnotification.	NO	MUL	NULL

core_tafmailing

Records every tell-a-friend mailing sent through ActionKit and joins to core_transactionalmailing.

Field	Type	Description	Null	Key	Default	Extra
transactionalmailing_ptr_id	int(11)	Joins to core_transactionalmailing.	NO	PRI	NULL

core_confirmationmailing

Records every confirmation mailing and joins to core_transactionalmailing.

Field	Type	Description	Null	Key	Default	Extra
transactionalmailing_ptr_id	int(11)	Joins to core_transactionalmailing.	NO	PRI	NULL

core_transactionalmailingsent

The core_transactionalmailingsent table stores a row each time a transactional mailing is sent.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for this transactional mailing and user/email combo.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
action_id	int(11)	Joins to core_action on the action that triggered the transactional mail to be sent.	NO	MUL	NULL
transactional_mailing_id	int(11)	Joins to core_transactionalmailing.	NO	MUL	NULL
user_id	int(11)	Joins to core_user.	YES	MUL	NULL
email	varchar(255)	Recipient email address.	NO	MUL	NULL

core_transactionalmailingopen

The core_transactionalmailingopen table stores a row each time a transactional mailing is opened.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for this open.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
transactional_mailing_sent_id	int(11)	Joins to core_transactionalmailingsent.	NO	MUL	NULL

core_transactionalmailingclick

The core_transactionalmailingclick table stores a row each time a transactional mailing is clicked.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for this click.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
transactional_mailing_sent_id	int(11)	Joins to core_transactionalmailingsent.	NO	MUL	NULL
clickurl_id	int(11)	Joins to core_clickurl.	NO	MUL	NULL
link_number	int(11)	Describes which link in the email the user clicked.	YES		NULL
source	varchar(255)	The source value from the mailing link which will provide the ‘source’ for any clicks or actions it generates.	NO	MUL	NULL

core_transactionalmailingaction

The core_transactionalmailingaction table stores a row each time a user takes action after clicking on a transactional mailing link.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for this combination of action and transactional mailing send.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
transactional_mailing_sent_id	int(11)	Joins to core_transactionalmailingsent.	NO	MUL	NULL
action_id	int(11)	Joins to core_action on the action taken from the transactional mailing.	NO	MUL	NULL

core_transactionalmailingunsub

The core_transactionalmailingaction table stores a row each time a user unsubscribes on a confirmation mailing.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for this click.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
action_id	int(11)	Joins to core_action on the action taken from the transactional mailing.	NO	MUL	NULL
transactional_mailing_sent_id	int(11)	Joins to core_transactionalmailingsent.	NO	MUL	NULL

core_useragent

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
useragent_string	longtext		NO		NULL
hash	varchar(64)		NO	UNI	NULL
browser	varchar(255)		NO		NULL
browser_version	varchar(30)		NO		NULL
os	varchar(255)		NO		NULL
os_version	varchar(30)		NO		NULL
device	varchar(255)		NO		NULL
is_mobile	tinyint(1)		NO	MUL	NULL
is_phone	tinyint(1)		NO	MUL	NULL
is_tablet	tinyint(1)		NO	MUL	NULL
is_desktop	tinyint(1)		NO	MUL	NULL

Texting Tables

texting_action

Action_id and message_id for every action coming from a broadcast or transactional text.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for each action from a text	NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO		NULL
message_id	int(11)	Joins to ????	NO	MUL	NULL
action_id	int(11)	Joins to core_action using (core_action.action_id=texting_action.action_id)	NO	MUL	NULL

texting_adminreplymessage

Pointer to ad hoc text message which was send by an admin to an individual user

Field	Type	Description	Null	Key	Default	Extra
message_ptr_id	int(11)	Links to texting_message	NO	PRI	NULL
admin_user_id	int(11)	Join to auth_user	NO	MUL	NULL
change_subscription_status	varchar(32)	One of: “none”, “subscribe”, “unsubscribe”	YES	MUL	NULL

texting_afteractionmessage

Pointer to text message which may be used as an after-action message. N.b.: Joins to core_pagefollowup via core_pagefollowup.confirmation_text_id

Field	Type	Description	Null	Key	Default	Extra
message_ptr_id	int(11)	Links to texting_message	NO	PRI	NULL

texting_allowedtextmessagefield

Custom field created by your group to display text or activate custom code on a particular page.

Field	Type	Description	Null	Key	Default	Extra
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
hidden	tinyint(1)	1=hidden	NO	MUL	NULL
order_index	int(11)	Sets the display order for custom text fields.	NO		NULL
display_name	varchar(255)	The display name is shown when selecting a custom field and may be changed in the future. Spaces, punctuation, etc are permitted.	NO	UNI	NULL
name	varchar(128)	Name of the custom field. No punctuation supported except underscores.	NO	PRI	NULL
always_show	tinyint(1)	1=show when creating broadcasts.	NO		0
required	tinyint(1)	Value must be entered for this field before the broadcast can be saved.	NO		NULL
description	longtext	Description of custom text field.	YES		NULL
field_type	varchar(32)	Choose how data should be entered in this field.	NO		NULL
field_default	longtext	Provide a default value that will be pre-filled wherever this field is displayed in the admin.	NO		NULL
field_choices	longtext	Values available if the list type is Select From List or Select From List with Other.	NO		NULL
field_regex	longtext	You can provide a regular expression to validate campaigners’ input here.	NO		NULL
field_length	int(11)	Maximum number of characters; leave blank for unlimited.	YES		NULL
allow_multiple	tinyint(1)	If 1, you can associated multiple of the field with one broadcast.	NO		NULL

texting_keywordresponsemessage

Field	Type	Description	Null	Key	Default	Extra
message_ptr_id	int(11)	Links to ???	NO	PRI	NULL
subscription_status	varchar(32)	Links to ???	YES	MUL	NULL
keywords	varchar(255)	???	YES		NULL
created_at	datetime		NO	MUL	NULL

texting_binding

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	MUL	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO	MUL	NULL
hidden	tiny_int(1)		NO	MUL	NULL
is_default	tiny_int(1)		NO	MUL	NULL
title	varchar(64)	???	NO		NULL
notes	varchar(255)	???	NO		NULL
enabled	tiny_int(1)		NO		NULL

texting_binding_originators

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	MUL	NULL	auto_increment
binding_id	int(11)		NO	MUL	NULL
originator_id	int(11)		NO	MUL	NULL

texting_blockedrecipient

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for each action from a text	NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO	MUL	NULL
address	varchar(64)	???	NO	UNI	NULL

texting_blockhistory

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for each action from a text	NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO	MUL	NULL
address	varchar(255)	???	NO	MUL	NULL
message_id	int(11)		YES		NULL
action_id	int(11)		YES		NULL
matched_address	tiny_int(1)		NO		NULL

texting_broadcast

Field	Type	Description	Null	Key	Default	Extra
message_ptr_id	int(11)	Links to ???	NO	PRI	NULL
target_group_from_landing_page	tinyint(1)		NO	PRI	NULL
respect_recipient_time	tinyint(1)	Send only to users in allowed local hours	NO	PRI	NULL
limit	int(11)		YES		NULL
limit_percent	int(11)		YES		NULL
sort_by	varchar(32)		YES		NULL
max_per_second	double		YES		NULL
scheduled_for	datetime		YES		NULL
scheduled_by_id	int(11)		YES	MUL	NULL
landing_page_id	int(11)		YES	MUL	NULL
status	varchar(255)		YES	MUL	NULL
sent_proofs	int(11)		NO		NULL
mergefile_id	int(11)		YES	MUL	NULL
target_mergefile	tiny_int(1)		NO	MUL	NULL
mergequery_report_id	int(11)		YES	MUL	NULL
target_mergequery	tiny_int(1)		NO		NULL
targeting_version	int(11)		YES		NULL
targeting_version_saved	int(11)		YES		NULL
rate	double		YES		NULL
progress	int(11)		YES		NULL
query_queued_at	datetime		YES		NULL
query_started_at	datetime		YES		NULL
query_completed_at	datetime		YES		NULL
query_previous_runtime	int(11)		YES		NULL
query_status	varchar(255)		YES		NULL
query_task_id	varchar(255)		YES		NULL
queue_task_id	varchar(255)		YES		NULL
queued_at	datetime		YES		NULL
queued_by_id	int(11)		YES	MUL	NULL
expected_send_count	int(11)		YES		NULL
started_at	datetime		YES	MUL	NULL
finished_at	datetime		YES	MUL	NULL
requested_proofs	int(11)		YES		NULL
requested_proof_date	datetime		YES		NULL
submitter_id	int(11)		YES	MUL	NULL
rebuild_query_at_send	tinyint(1)		NO		NULL

texting_broadcast_proof_users

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
broadcast_id	int(11)		NO	MUL	NULL
user_id	int(11)		NO	MUL	NULL

texting_broadcast_reviewers

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
broadcast_id	int(11)		NO	MUL	NULL
user_id	int(11)		NO	MUL	NULL

texting_click

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO	MUL	NULL
message_id	int(11)		NO	MUL	NULL
page_id	int(11)		YES	MUL	NULL
click_id	int(11)		NO	MUL	NULL

texting_confirmationmessage

Field	Type	Description	Null	Key	Default	Extra
message_ptr_id	int(11)	Links to ???	NO	PRI	NULL
status_trigger	varchar(32)		NO	MUL	NULL

texting_deactrun

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO	MUL	NULL
last_deact_notice_id	int(11)		NO	MUL	NULL

texting_deliveryreceipt

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO	MUL	NULL
for_message_id	int(11)		YES	MUL	NULL
payload	json		NO		NULL

texting_incomingmessage

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO	MUL	NULL
status	varchar(16)		NO	MUL	NULL
source_address	varchar(24)		NO		NULL
our_address	varchar(24)		NO		NULL
subscriber_id	int(11)		YES	MUL	NULL
originator_id	int(11)		YES	MUL	NULL
prior_send_id	int(11)		YES	MUL	NULL
content	longtext		NO		NULL

texting_incomingsegment

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO	MUL	NULL
status	varchar(16)		NO	MUL	NULL
message_at	datetime		NO	MUL	NULL
external_uid	varchar(24)		NO		NULL
source_address	varchar(24)		NO		NULL
our_address	varchar(24)		NO		NULL
multipart_uid	int(11)		YES		NULL
multipart_total	int(11)		YES		NULL
multipart_part	int(11)		YES		NULL
content_type	varchar(24)		NO		NULL
content_udh	varchar(24)		NO		NULL
content_data	longtext(24)		NO		NULL

texting_list

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO	MUL	NULL
hidden	tiny_int(1)		NO	MUL	NULL
is_default	tiny_int(1)		NO		NULL
name	varchar(255)		NO	UNI	NULL
notes	varchar(255)		YES		NULL

texting_mergequeryparam

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO	MUL	NULL
message_id	int(11)		NO	MUL	NULL
name	varchar(255)		NO		NULL
value	varchar(255)		NO		NULL

texting_message

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO	MUL	NULL
hidden	tiny_int(1)		NO	MUL	NULL
type	varchar(32)		NO	MUL	NULL
notes	longtext		NO		NULL
send_type	varchar(32)	SMS/MMS	NO		NULL
template	longtext		NO		NULL
media_url	varchar(200)	MMS media URL	NO		NULL
binding_id	int(11)		NO	MUL	NULL
lang_id	int(11)		NO	MUL	NULL

texting_message_tags

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
message_id	int(11)		NO	MUL	NULL
tag_id	int(11)		NO	MUL	NULL

texting_messageerror

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
message_id	int(11)		NO	MUL	NULL
queue_task_id	varchar(255)		NO		NULL
traceback	longtext		NO		NULL

texting_messagefailed

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
message_id	int(11)		NO	MUL	NULL
subscriber_id	int(11)		NO	MUL	NULL
originator_id	int(11)		NO	MUL	NULL
reason	longtext		NO		NULL

texting_messagesent

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO	MUL	NULL
message_id	int(11)		NO	MUL	NULL
subscriber_id	int(11)		YES	MUL	NULL
originator_id	int(11)		NO	MUL	NULL
send_type	varchar(32)	SMS/MMS	NO		NULL
external_id	varchar(255)		NO	MUL	NULL
segments	int(11)		NO		NULL
is_proof	tiny_int(1)		NO		NULL
sent_address	varchar(64)		YES	MUL	NULL
sent_in_reply_to_id	integer		YES	MUL	NULL

texting_messagetargeting

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO	MUL	NULL
message_id	int(11)		NO	MUL	NULL
exclude	tinyint(1)		NO		NULL
raw_sql	longtext	Raw SQL.	YES		NULL
countries	text	Countries.	YES		NULL
states	longtext	U.S. states.	YES		NULL
regions	longtext	Non-U.S. regions.	YES		NULL
counties	longtext	U.S. counties.	YES		NULL
divisions	text	Ids of international boundaries.	YES		NULL
zips	longtext	U.S. zip codes, or city, state, or city, country or postcode country (for use with zip radius except for zip which can be a stand alone).	YES		NULL
zip_radius	int(11)	Radius for zip code or other geographic points	YES		NULL
cds	longtext	Congressional Districts	YES		NULL
state_senate_districts	longtext	U.S. state senate districts.	YES		NULL
state_house_districts	longtext	U.S. state house districts.	YES		NULL
has_donated	tinyint(1)	1=yes; previous donations checkbox.	YES		NULL
is_monthly_donor	tinyint(1)	Not in use.	YES		NULL
campaign_radius	int(11)	Radius around the zip of events within selected event campaign.	YES		NULL
campaign_samestate_only	tinyint(1)	Only invite members to events in their own state.	NO		0
campaign_same_county_only	tinyint(1)	Only invite members to events in their own county.	NO		0
campaign_same_district_only	tinyint(1)	Only invite members to events in their own US House District.	NO		0
campaign_first_date	varchar(16)		NO		NULL
campaign_last_date	varchar(16)		NO		NULL
mirror_message_excludes	tinyint(1)	Excludes sent broadcasts that excluded this one.	NO		1

texting_messagetargeting_actions

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
messagetargeting_id	int(11)		NO	MUL	NULL
page_id	int(11)	Joins to core_page on core_page.id=page_id.	NO	MUL	NULL

texting_messagetargeting_boundaries

texting_messagetargeting_boundary_groups

texting_messagetargeting_campaigns

texting_messagetargeting_languages

texting_messagetargeting_lists

texting_messagetargeting_mailings

texting_messagetargeting_messages

texting_messagetargeting_tags

texting_messagetargeting_target_groups

texting_messagetargeting_text_lists

texting_messagetargeting_user_groups

texting_messagetargeting_users

texting_messagetargeting_was_monthly_donor

texting_mockgatewayreceived

texting_mockgatewaysent

texting_originator

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO	MUL	NULL
hidden	tiny_int(1)		NO	MUL	NULL
gateway	varchar(32)		NO	MUL	NULL
address	varchar(32)		NO		NULL
display	varchar(32)		NO		NULL
enabled	tiny_int(1)		NO		NULL
rate_per_minute	int(11)		NO		NULL

texting_referredaction

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO	MUL	NULL
referring_message_id	int(11)		NO	MUL	NULL
action_id	int(11)		NO	UNI	NULL

texting_savedquerytimelog

texting_savedtextquerylog

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
message_id	int(11)		NO	MUL	NULL
process_id	int(11)		YES		NULL
action	varchar(255)		NO		NULL
reason	varchar(255)		NO		NULL
targeting_version	int(11)		NO		NULL
triggered_by_id	int(11)		YES	MUL	NULL
created_at	datetime	Creation date/time	NO	MUL	NULL

texting_shortlink

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO	MUL	NULL
link	varchar(4096)		NO		NULL
message_id	int(11)		YES	MUL	NULL

texting_subscriber

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO	MUL	NULL
user_id	int(11)		NO	MUL	NULL
address	varchar(64)		NO	MUL	NULL
status	varchar(16)		NO		NULL

texting_subscription

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO	MUL	NULL
subscriber_id	int(11)		NO	MUL	NULL
list_id	int(11)		NO	MUL	NULL

texting_subscriptionchangetype

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO	MUL	NULL
name	varchar(24)		NO	UNI	NULL
description	varchar(255)		NO		NULL
subscribed	tiny_int(1)		NO		NULL

texting_subscriptioncounthistory

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO	MUL	NULL
list_id	int(11)		YES	MUL	NULL
date	date		NO		NULL
subscribers	int(11)		NO		NULL

texting_targetingactionfield

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO	MUL	NULL
targeting_id	int(11)		NO	MUL	NULL
page_id	int(11)		YES	MUL	NULL
name	varchar(255)		NO		NULL
values	longtext		YES		NULL

texting_targetingeventfield

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO	MUL	NULL
targeting_id	int(11)		NO	MUL	NULL
name	varchar(255)		NO		NULL
values	longtext		YES		NULL

texting_targetingqueryreport

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO	MUL	NULL
report_id	int(11)		NO	MUL	NULL
targeting_id	int(11)		NO	MUL	NULL

texting_targetingqueryreportparam

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO	MUL	NULL
query_id	int(11)		NO	MUL	NULL
name	varchar(255)		NO		NULL
value	varchar(4096)		NO		NULL

texting_targetinguserfield

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time	NO	MUL	NULL
updated_at	datetime	Date/time the action was updated	NO	MUL	NULL
targeting_id	int(11)		NO	MUL	NULL
field_id	varchar(128)		NO	MUL	NULL
values	longtext		YES		NULL

texting_textingsendbroadcastjob

Field	Type	Description	Null	Key	Default	Extra
job_ptr_id	int(11)		NO	PRI	NULL

texting_textmessagecountjob

Field	Type	Description	Null	Key	Default	Extra
job_ptr_id	int(11)		NO	PRI	NULL

texting_textmessagefield

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL	auto_increment
value	longtext		NO	MUL	NULL
parent_id	int(11)		NO		NULL
name	varchar(128)		NO	MUL	NULL

Import Tables

These tables information about import jobs (or uploads).

The following upload tables are described below:

• core_upload

• core_uploaderror

• core_uploadprogress

• core_uploadwarning

core_upload

Record for each import.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time.	NO	MUL	NULL
updated_at	datetime	Update date/time.	NO		NULL
path	varchar(255)	File path, in hostname:filename format.	NO		NULL
submitter_id	int(11)	Admin ID submitting the upload.	NO	MUL	NULL
page_id	int(11)	Import Page ID. Joins to core_page.	NO	MUL	NULL
started_at	datetime	Upload start date/time.	NO		NULL
finished_at	datetime	Upload finish date/time.	NO		NULL
rate	double	Upload rate (rows/sec).	NO		NULL
status	varchar(20)	Upload status - loading, completed, etc.	NO		NULL
format	varchar(10)	Upload format - csv, tsv.	YES		NULL
compression	varchar(20)	Needs description	YES		NULL
autocreate_user_fields	tinyint(1)	=1 creates custom user fields if they exist in the import file.	NO		NULL
original_header	longtext	Header row in JSON format.	NO		NULL
override_header	longtext	Edited header row in JSON format.	NO		NULL
line_count	int(11)	Approximate row count.	YES		NULL
job_id	int(11)	Joins to core_job.id	YES	MUL
user_updater_id	int(11)	Joins to reports_userupdater.id	YES	MUL

core_uploaderror

Errors encountered during imports.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time.	NO	MUL	NULL
update_at	datetime	Update date/time.	NO		NULL
upload_id	int(11)	Upload ID - joins to core_upload.id.	NO	MUL	NULL
worker_pid	int(11)	Process ID of worker task.	YES		NULL
row	int(11)	Row where the error occurred - header is row 1.	YES		NULL
col	int(11)	Column where the error occurred.	YES		NULL
message	longtext	Error message.	NO		NULL
exception	longtext	Python exception if the error was caused by one.	YES		NULL
value	varchar(255)	Value which caused the error.	YES		NULL
raw_row	longtext	Row data from the row with the error.	YES		NULL

core_uploadprogress

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
upload_id	int(11)	Upload identifier.	NO	MUL	NULL
worker_pid	int(11)	Needs description .	NO		NULL
ok	int(11)	Needs description .	NO		NULL
warnings	int(11)	Warning messages displayed on upload report screen.	NO		NULL
errors	int(11)	Error messages displayed on upload report screen.	NO		NULL
rate	double	Upload speed.	YES		NULL

core_uploadwarning

Warnings encountered during imports. Warnings indicate possible data problems but they don’t cause your import to fail like errors.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time.	NO	MUL	NULL
updated_at	datetime	Update date/time.	NO	MUL	NULL
upload_id	int(11)	Upload ID - joins to core_upload.id.	NO	MUL	NULL
worker_pid	int(11)	Process ID of worker task.	YES		NULL
row	int(11)	Row where the warning occurred - header is row 1.	YES		NULL
col	int(11)	Column where the warning occurred.	YES		NULL
message	longtext	Warning message.	NO		NULL
exception	longtext	Python exception if the warning was caused by one.	YES		NULL
value	varchar(255)	Value which caused the warning.	YES		NULL
raw_row	longtext	Row data from the row with the warning.	YES		NULL

User Tables

The User tables contain information about individual users.

The following core user tables are described below:

• core_alloweduserfield

• core_location

• core_phone

• core_user

• core_userfield

• core_usergroup

• core_user_groups

• core_usermerge

• core_usermerge_users

• core_userstaffnote

• core_userdivision

core_alloweduserfield

Field created by your group to capture user-specific data.

Field	Type	Description	Null	Key	Default	Extra
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
hidden	tinyint(1)	1=hidden	NO		NULL
order_index	int(11)	Sets the display order for user fields show on the user record and in the pull down display.	NO		NULL
display_name	varchar(255)		NO	UNI	NULL
name	varchar(255)	The name of the custom user field.	NO	PRI
always_show	tinyint(1)	1=always show on the individual user record (even if there is no value entered)	NO		0
required	tinyint(1)	A value must be entered for this field on the user record before saving.	NO		NULL
description	longtext	Description of custom user field.	YES
field_type	varchar(32)	Choose how data should be entered in this field.	NO		NULL
field_default	longtext	Provide a default value that will be pre-filled wherever this field is displayed in the admin.	NO		NULL
field_choices	longtext	Values available if the list type is Select From List or Select From List with Other.	NO		NULL
field_regex	longtext	You can provide a regular expression to validate campaigners’ input here.	NO		NULL
field_length	int(11)	Maximum number of characters; leave blank for unlimited.	YES		NULL

core_location

Geography info for each user.

Field	Type	Description	Null	Key	Default	Extra
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
user_id	int(11)	joins on core_user.id.	NO	PRI	NULL
us_district	varchar(5)	User’s Congressional District (based on zip and, if available, plus4).	NO		NULL
us_state_senate	varchar(6)	User’s state senate district if known (based on zip plus4).	NO		NULL
us_state_district	varchar(6)	User’s state house district if known (based on zip plus4).	NO		NULL
us_county	varchar(255)	User’s county if known (based on zip). US only.	NO		NULL
loc_code	varchar(30)	ActionKit generated data used for radius targeting.	YES	MUL	NULL
longitude	double	ActionKit assigned longitude for user location.	YES		NULL
latitude	double	ActionKit assigned latitude for user location.	YES		NULL
country_code	varchar(2)	=Two-letter ISO code	YES	MUL
region_code	varchar(20)	For international users - region code for user location.	YES
lat_lon_precision	varchar(32)	Needs description	YES
timezone	varchar(255)	User’s timezone if known	NO		NULL

core_phone

All phone numbers associated with a given user.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
user_id	int(11)	joins on core_user.id.	NO	MUL	NULL
type	varchar(25)	Types are home, mobile, work, emergency, home fax, work fax.	NO		NULL
phone	varchar(25)	Phone number.	NO		NULL
source	varchar(25)	Source of phone number.	NO		NULL
normalized_phone	varchar(25)	Digits with no spaces or punctuation.	NO	MUL	NULL

core_user

User contact info, user_id, and source of the first action the user took.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for each email address (user) and related data.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
email	varchar(255)	User email address.	NO	UNI	NULL
prefix	varchar(255)	User name prefix.	NO
first_name	varchar(255)	User first name.	NO		NULL
middle_name	varchar(255)	User middle name.	NO		NULL
last_name	varchar(255)	User last name.	NO	MUL	NULL
suffix	varchar(255)	User name suffix.	NO		NULL
password	varchar(255)	User password	NO		NULL
subscription_status	varchar(255)	Subscribed, unsubscribed, bounced, never, blocked.	NO	MUL	NULL
address1	varchar(255)	User address.	NO		NULL
address2	varchar(255)	User address.	NO		NULL
city	varchar(255)	User city.	NO		NULL
state	varchar(255)	User state.	NO	MUL	NULL
region	varchar(255)	International user region.	NO		NULL
postal	varchar(255)	International user postal code.	NO		NULL
zip	varchar(5)	User zip code.	NO	MUL	NULL
plus4	varchar(4)	User zip plus 4 digit code.	NO		NULL
country	varchar(255)	User country.	NO	MUL	NULL
source	varchar(255)	Source of the first action the user took (see core_action.)	NO	MUL	NULL
lang_id	int(11)	If the user took action on a page associated with a language the id shows here. Joins to core_language.	YES	MUL	NULL
rand_id	int(11)	Not in use.	NO	MUL	NULL

core_userfield

User field values.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
parent_id	int(11)	User id. Joins to core_user on (core_userfield.parent_id= core_user.id)	NO	MUL	NULL
name	varchar(255)	field name	NO	MUL	NULL
value	longtext	User’s response.	NO		NULL
action_id	int(11)	The action that set this field to its current value. Joins to core_action. NULL for fields before this feature was added and for fields edited by staff.			NULL
updated_at	datetime(6)	Date/time this record was last updated. NULL for fields before this feature was added.			NULL

core_usergroup

Groups that users can be added to. Similar to tags, except users can be manually added to and removed from groups.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
hidden	tinyint(1)		NO	MUL	NULL
name	varchar(255)	Name used to identify group	NO	MUL	NULL
description	varchar(255)	Description of the group	NO	MUL	NULL

core_user_groups

Record of which users belong to which groups.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
user_id	int(11)	User ID, joins to core_user	NO	MUL	NULL
usergroup_id	int(11)	UserGroup ID, joins to core_usergroup	NO		NULL

core_usermerge

Record of users merged.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
primary_id	int(11)	The ID of the primary user selected in a user merge. Joins to core_user.	NO	MUL	NULL
status	varchar(255)	Complete or pending.	NO	MUL	NULL
parent_id	int(11)	The ID of the merge oif which this merge is a part. Joins back to core_usermerge.	YES	MUL	NULL
sms_primary_id	int(11)	The ID of the SMS source user selected in a user merge. Joins to core_user.	YES	MUL	NULL

core_usermerge_users

Secondary user records merged into primary user. Primary shown in core_usermerge.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
usermerge_id	int(11)	Joins to core_usermerge.	NO	MUL	NULL
user_id	int(11)	Each secondary user_id merged to primary in the core_usermerge record.	NO	MUL	NULL

core_userstaffnote

Staff notes on users.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
user_id	int(11)	User id. Joins to core_user on (core_userstaffnote.user_id = core_user.id)	NO	MUL	NULL
staff_id	int(11)	Staff User id. Joins to auth_user on (core_userstaffnote.staff_id = auth_user.id	NO	MUL	NULL
note	longtext	Staffer’s note.	NO		NULL

core_userdivision

Match user to international geopolitical divisions.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
user_id	int(11)	User id. Joins to core_user on (core_userdivision.user_id = core_user.id)	NO	MUL	NULL
division_id	int(11)	Division ID	NO	MUL	NULL

core_user_page_tags

De-normalized record of user tags. Updated every 10 minutes.

Field	Type	Description	Null	Key	Default	Extra
user_id	int(11)	Joins to core_user.id	NO	MUL
tag_id	int(11)	Joins to core_tag.id	NO	MUL

core_reengagementlog

Daily counts for users engaged and unengaged per the most recently run count, added to the re-engagement list, removed from the re-engagement list, and unsubscribed through list migration.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI		auto_increment
created_at	datetime	Created date/time.	NO	MUL	NULL
updated_at	datetime	Updated date/time.	NO		NULL
dry_run	tinyint(1)	1=Counted users but did not move.	NO		NULL
engaged	int(11)	Count of engaged users.	NO		NULL
unengaged	int(11)	Count of unengaged users.	NO		NULL
added	int(11)	Count of users added to re-engagement list.	NO		NULL
removed	int(11)	Count of users removed from re-engagement list.	NO		NULL
unsubscribed	int(11)	Count of users unsubscribed.	NO		NULL

oneclick_storeduser

Users that are enrolled in the shared FastAction pool.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI		auto_increment
created_at	datetime	Created date/time.	NO	MUL	NULL
updated_at	datetime	Updated date/time.	NO		NULL
user_id	int(11)	Joins to core_user.id	NO	MUL
fastaction_id	varchar(64)	Internal use only.	NO

oneclick_use

Use of a oneclick donation link in a mailing.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI		auto_increment
created_at	datetime	Created date/time.	NO	MUL	NULL
updated_at	datetime	Updated date/time.	NO		NULL
user_id	int(11)	Joins to core_user.id	NO	MUL
mailing_id	int(11)	Joins to core_mailing.id	NO	MUL

Subscription Tables

The Subscription tables relate to users’ list membership and subscription history.

The following core subscription tables are described below:

• core_list

• core_subscription

• core_subscriptionchangetype

• core_subscriptioncounthistory

• core_subscriptionhistory

• gm_subscriptioncounthistory

core_list

Name and id of mailing lists.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	Null
updated_at	datetime		NO		Null
name	varchar(255)	Name of the list.	NO	UNI	Null
notes	varchar(255)	Notes field for internal use.	YES
hidden	tinyint(1)	1=hidden	NO	MUL	NULL
is_default	tinyint(1)	1=default mailing list	YES		0

core_subscription

List membership for each subscribed users.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for each user/list combination.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
user_id	int(11)	Joins on core_user.id.	NO	MUL	NULL
list_id	int(11)	Joins on core_list.id.	NO	MUL	NULL

core_subscriptionchangetype

Descriptions of each of the types of changes that are possible to a user’s subscription to a particular list.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
name	varchar(255)	Name of change: subscribe, subscribe_api, subscribe_import, subscribe_merge, subscribe_notspamcheck, subscribe_uploader, unsubscribe, unsubscribe_admin, unsubscribe_bounce, unsubscribe_email, unsubscribe_import, unsubscribe_merge, unsubscribe_reengagement, unsubscribe_spamcheck	NO	UNI	NULL
description	varchar(255)	Definition (ex: Subscribe, Subscribe by import, Unsubscribe Bounce, etc.)	NO		NULL
subscribed	tinyint(1)	0 = unsubscribed; 1 = subscribed	NO		NULL

core_subscriptioncounthistory

Daily subscription counts for each list, and overall.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
list_id	int(11)	Joins on core_list.id. NULL = across all lists.	YES	MUL	NULL
date	date		NO		NULL
subscribers	int(11)	Count of subscribers to the list.	NO		NULL

core_subscriptionhistory

Changes in subscription status for each user w/ id that ties to changetype table.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
user_id	int(11)	Joins on core_user.id.	NO	MUL	NULL
list_id	int(11)	The list this user was added or removed from. Joins to core_list.	NO	MUL	NULL
change_id	int(11)	Change type defined in core_subscriptionchangetype table above.	NO	MUL	NULL
action_id	int(11)	The action that led to the subscription status change. Joins on (core_action.id= core_subscriptionhistory.action_id)	YES	MUL	NULL

gm_subscriptioncounthistory

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
list_id	int(11)	Joins on core_list.id. NULL = across all lists.	YES	MUL	NULL
date	date		NO		NULL
subscribers	int(11)	Count of subscribers to the list.	NO		NULL

Job table

core_job

Table with information about back end processing jobs in ActionKit (like uploads or reports).

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
job_type	varchar(255)	Types include merge file, ping, report, upload.	NO		NULL
priority	int(11)		YES		NULL
parameters	longtext		YES		NULL
result_data	longtext		YES		NULL
submitter_id	int(11)	user_id of person submitting job	YES	MUL	NULL
started_at	datetime	job start	YES		NULL
finished_at	datetime	job end	YES		NULL
server	varchar(255)		YES		NULL
pid	int(11)		YES		NULL
rate	double		YES		NULL
progress	int(11)		YES		NULL
goal	int(11)		YES		NULL
estimated_finish_at	datetime		YES		NULL
status	varchar(20)	Job status (e.g. completed, died).	YES		NULL
django_version	varchar(255)		YES		NULL
polled_at	datetime	Last time this report’s status was polled (by keeping its window open) while it was running. (If a report is running but has not been checked in ten minutes, it’s considered abandoned and is killed).	YES		NULL

CMS tables

The CMS tables relate to the appearance and text of pages, like petitions, call actions, and unsubscribes.

The following cms tables are described below:

• cms_allowedtemplatesetfield

• cms_call_form

• cms_campaign_volunteer_form

• cms_cannedletter

• cms_donation_form

• cms_donationamount

• cms_event_create_form

• cms_event_moderate_form

• cms_event_signup_form

• cms_event_volunteer_form

• cms_githubconnection

• cms_githubevent

• cms_githubrepository

• cms_githubwebhooksecret

• cms_letter_form

• cms_lte_form

• cms_petition_form

• cms_recurringdonationcancel_form

• cms_recurringdonationupdate_form

• cms_signup_form

• cms_survey_form

• cms_survey_question

• cms_template

• cms_templatecode

• cms_templatehistory

• cms_templateset

• cms_templatesetfield

• cms_unsubscribe_form

• cms_uploadedfile

• cms_user_form_field

• cms_whipcount_form

• cms_whipcountresponseoverride

cms_allowedtemplatesetfield

Allowed templateset fields.

Field	width=100pxType	Description	Null	Key	Default	Extra
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
hidden	tinyint(1)		NO	MUL	NULL
order_index	int(11)	Sets display order for list of fields.	NO		NULL
display_name	varchar(255)	The display name is shown when selecting a custom field and may be changed in the future. Spaces, punctuation, etc are permitted.	NO	UNI	NULL
name	varchar(255)		NO	PRI	NULL
always_show	tinyint(1)	1=always show	NO		NULL
description	longtext	Add a description to help your campaigners use this custom field. We will display your description just below the form input.	YES		NULL
field_default	longtext	Provide a default value that will be pre-filled wherever this field is displayed in the admin.	NO		NULL
field_choices	longtext	Choices displayed for this field.	NO		NULL
field_regex	longtext	You can provide a regular expression to validate campaigners’ input here.	NO		NULL
field_type	varchar(32)	Choose how data should be entered in this field.	NO		NULL
field_length	int(11)	Maximum number of characters; leave blank for unlimited.	YES		NULL
required	tinyint(4)	1 if the field is required.	NO		NULL

cms_call_form

Call page content.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
templateset_id	int(11)	Id of the templateset, which defines the page look and feel. Pulls from cms_templateset on (cms_template.id= cms_call_form.templateset_id)	NO	MUL	NULL
page_id	int(11)	ID of the page, which defines action basics and follow-up. Pulls from core_ page on (cms_call_form.page_id= core_page.id)	NO	UNI	NULL
thank_you_text	longtext	Text displayed on the thank you page (URL defined in core_page table) after end user takes action.	NO		NULL
script_text	longtext	Sample call script displayed to the user.	NO		NULL
introduction_text	longtext	Introductory text about call campaign, encouraging user to call.	NO		NULL
survey_question_text	longtext	Question for users about the call, such as “how did it go?”.	NO		NULL
client_hosted	int(11)	1 if the page is hosted outside of the ActionKit CMS	YES		0
client_url	varchar(255)	URL of a page hosted outside of the ActionKit CMS. Used for the “View” link in the admin interface.	YES

cms_cannedletter

Sample letters displayed on LTE forms.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for each canned letter.	NO	PRI	NULL	auto_increment
lte_form_id	int(11)	ID of the lte page content form.	NO	MUL	NULL
subject	varchar(80)	Canned letter subject line.	NO		NULL
letter_text	longtext	Sample letter text.	NO		NULL

cms_campaign_volunteer_form

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
thank_you_text	longtext	Text displayed on the thank you page (URL defined in core_page table) after end user takes action.	NO		NULL
templateset_id	int(11)	Id of the templateset, which defines the page look and feel. Pulls from cms_templateset on (cms_template.id= cms_campaign_volunteer_form.templateset_id)	NO	MUL	NULL
page_id	int(11)	ID of the page, which defines action basics and follow-up. Pulls from core_ page on (cms_campaign_volunteer_form.page_id= core_page.id)	NO	UNI	NULL
client_hosted	tinyint(1)	1 if the page is hosted outside of the ActionKit CMS	NO		NULL
client_url	varchar(255)	URL of a page hosted outside of the ActionKit CMS. Used for the “View” link in the admin interface.	NO		NULL
ground_rules	longtext	Ground rules you require volunteer moderators to agree to before they can sign up.	NO		NULL
volunteer_text	longtext	Content that displays on the volunteer moderator sign up form.	NO		NULL

cms_donation_form

Donation page content.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
templateset_id	int(11)	Id of the templateset, which defines the page look and feel. Pulls from cms_templateset on (cms_template.id= cms_donation_form.templateset_id)	NO	MUL	NULL
page_id	int(11)	ID of the page, which defines action basics and follow-up. Pulls from core_ page on (cms_donation_form.page_id= core_page.id)	NO	UNI	NULL
thank_you_text	longtext	Text displayed on the thank you page (URL defined in core_page table) after end user takes action.	NO		NULL
ask_text	longtext	Donation request.	NO		NULL
is_recurring	tinyint(1)		NO		NULL
show_other_amount	tinyint(1)	1=show other amount checkbox to user.	NO		NULL
amount_order	varchar(255)	Options are “High-to-Low”, “Low-to-High”.	NO		NULL
client_hosted	int(11)	1 if the page is hosted outside of the ActionKit CMS	YES		0
client_url	varchar(255)	URL of a page hosted outside of the ActionKit CMS. Used for the “View” link in the admin interface.	YES

cms_donationamount

Donations also have a subsidiary table showing suggested donation amounts to be displayed on a donation page to the end user.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
amount	varchar(10)	Amount to be displayed.	NO		NULL
donation_form_id	int(11)	Joins to cms_donation_form.	NO	MUL	NULL
is_default	tinyint(1)	1 if this amount is selected by default	YES		0

cms_event_create_form

Host event creation page content.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
templateset_id	int(11)	Id of the templateset, which defines the page look and feel. Pulls from cms_templateset on (cms_template.id= cms_event_create_form.templateset_id)	NO	MUL	NULL
page_id	int(11)	ID of the page, which defines action basics and follow-up. Pulls from core_ page on (cms_event_create_form.page_id= core_page.id)	NO	UNI	NULL
thank_you_text	longtext	Text displayed on the thank you page (URL defined in core_page table) after end user takes action.	NO		NULL
ground_rules	longtext	Text contains any event ground rules such as legal requirements.	NO		NULL
host_requirements	longtext	Text containing any requirements specific to the event host.	NO		NULL
host_text	longtext	Intro text on the host sign up page.	NO		NULL
custom_field_html	longtext		NO		NULL
tools_text	longtext	Text displayed on the event tools page, where the host can manage their own event.	NO		NULL
tools_sidebar	longtext	Sidebar on host event tools page - enter URLs for resources like event guide.	NO		NULL
client_hosted	int(11)	1 if the page is hosted outside of the ActionKit CMS	YES		0
client_url	varchar(255)	URL of a page hosted outside of the ActionKit CMS. Used for the “View” link in the admin interface.	YES

cms_event_moderate_form

Volunteer moderator form for reviewing events, flagging issues, emailing hosts, etc.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
thank_you_text	longtext	Text displayed on the thank you page (URL defined in core_page table) after user submits an event moderation action.	NO		NULL
templateset_id	int(11)	ID of the templateset, which defines the page look and feel. Pulls from cms_templateset on (cms_template.id= cms_event_moderate_form.templateset_id)	NO	MUL	NULL
page_id	int(11)	ID of the page, which defines action basics and follow-up. Pulls from core_ page on (cms_event_moderate_form.page_id= core_page.id)	NO	UNI	NULL
client_hosted	tinyint(1)	1 if the page is hosted outside of the ActionKit CMS	NO		NULL
client_url	varchar(255)	URL of a page hosted outside of the ActionKit CMS. Used for the “View” link in the admin interface.	NO		NULL
custom_field_html	longtext	Used to define criteria or questions for volunteers when reviewing events. Must start with ‘action_’.	NO		NULL
tools_text	longtext	Text displayed in the moderation box for volunteer moderators.	NO		NULL
tools_sidebar	longtext	Sidebar for moderator view.	NO		NULL
host_tools_sidebar	longtext	Not in use.	NO		NULL

cms_event_signup_form

Attendee event sign up page content.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
templateset_id	int(11)	Id of the templateset, which defines the page look and feel. Pulls from cms_templateset on (cms_template.id= cms_event_signup_form.templateset_id)	NO	MUL	NULL
page_id	int(11)	ID of the page, which defines action basics and follow-up. Pulls from core_ page on (cms_event_signup_form.page_id= core_page.id)	NO	UNI	NULL
thank_you_text	longtext	Text displayed on the thank you page (URL defined in core_page table) after end user takes action.	NO		NULL
ground_rules	longtext	Text contains any event ground rules such as legal requirements.	NO		NULL
search_page_text	longtext	Intro text on the page where users can search for events by zip or city.	NO		NULL
signup_text	longtext	Text displayed on the screen where users sign up for a particular event.	NO		NULL
custom_field_html	longtext		NO		NULL
tools_text	longtext	Text containing information about the attendee event tool page.	NO		NULL
tools_sidebar	longtext	URLs for attendee materials.	NO		NULL
client_hosted	int(11)	1 if the page is hosted outside of the ActionKit CMS	YES		0
client_url	varchar(255)	URL of a page hosted outside of the ActionKit CMS. Used for the “View” link in the admin interface.	YES

cms_event_volunteer_form

Event moderator sign up page content.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
thank_you_text	longtext	Text displayed on the thank you page (URL defined in core_page table) after user submits an event moderation action.	NO		NULL
templateset_id	int(11)	ID of the templateset, which defines the page look and feel. Pulls from cms_templateset on (cms_template.id= cms_event_moderate_form.templateset_id)	NO	MUL	NULL
page_id	int(11)	ID of the page, which defines action basics and follow-up. Pulls from core_ page on (cms_event_moderate_form.page_id= core_page.id)	NO	UNI	NULL
client_hosted	tinyint(1)	1 if the page is hosted outside of the ActionKit CMS	NO		NULL
client_url	varchar(255)	URL of a page hosted outside of the ActionKit CMS. Used for the “View” link in the admin interface.	NO		NULL
ground_rules	longtext	Text contains any rules for moderators to agree to.	NO		NULL

cms_githubconnection

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
templateset_id	int(11)		NO	UNI	NULL
repository_id	int(11)		NO	MUL	NULL
path	varchar(255)		NO		NULL
live_branch	varchar(255)		NO		NULL
preview_branch	varchar(255)		NO		NULL

cms_githubevent

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
body	longtext		NO		NULL
repository_id	int(11)		YES	MUL	NULL
processed_by_id	int(11)		YES	MUL	NULL

cms_githubrepository

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime(6)		NO	MUL	NULL
updated_at	datetime(6)		NO		NULL
owner	varchar(255)		NO	MUL	NULL
repos	varchar(255)		NO		NULL
private	tinyint(1)		NO		NULL
public_key	longtext		YES		NULL
private_key	longtext		YES		NULL
webhook	varchar(255)		YES		NULL
deploy_key	varchar(255)		YES		NULL

cms_githubwebhooksecret

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
secret	varchar(255)		NO		NULL

cms_letter_form

Letter page content.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
templateset_id	int(11)	Id of the templateset, which defines the letter look and feel. Pulls from cms_templateset on (cms_template.id= cms_letter_form.templateset_id)	NO	MUL	NULL
page_id	int(11)	ID of the page, which defines action basics and follow-up. Pulls from core_ page on (cms_letter_form.page_id= core_page.id)	NO	UNI	NULL
thank_you_text	longtext	Text displayed on the thank you page (URL defined in core_page table) after end user takes action.	NO		NULL
statement_leadin	longtext	Letter lead in text.	NO		NULL
letter_text	longtext	Default letter text that end users can edit.	NO		NULL
about_text	longtext	Letter page intro.	NO		NULL
client_hosted	int(11)	1 if the page is hosted outside of the ActionKit CMS	YES		0
client_url	varchar(255)	URL of a page hosted outside of the ActionKit CMS. Used for the “View” link in the admin interface.	YES

cms_lte_form

LTE page content.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
templateset_id	int(11)	Id of the templateset, which defines the lte look and feel. Pulls from cms_templateset on (cms_template.id= cms_lte_form.templateset_id)	NO	MUL	NULL
page_id	int(11)	ID of the page, which defines action basics and follow-up. Pulls from core_ page on (cms_lte_form.page_id= core_page.id)	NO	UNI	NULL
thank_you_text	longtext	Text displayed on the thank you page (URL defined in core_page table) after end user takes action.	NO		NULL
introduction_text	longtext	LTE intro.	NO		NULL
talking_points	longtext	Main points for end user to include in lte.	NO		NULL
writing_tips	longtext	Tips to end user about writing letters to the editor.	NO		NULL
client_hosted	int(11)	1 if the page is hosted outside of the ActionKit CMS	YES		0
client_url	varchar(255)	URL of a page hosted outside of the ActionKit CMS. Used for the “View” link in the admin interface.	YES

cms_petition_form

Petition content.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for each petition form.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
templateset_id	int(11)	Id of the templateset, which defines the petition look and feel. Pulls from cms_templateset on (cms_template.id= cms_petition_form.templateset_id)	NO	MUL	NULL
page_id	int(11)	ID of the page, which defines action basics and follow-up. Pulls from core_ page on (cms_petition_form.page_id= core_page.id)	NO	UNI	NULL
thank_you_text	longtext	Text displayed on the thank you page (URL defined in core_page table) after end user takes action.	NO		NULL
statement_leadin	longtext	Optional text displayed to end user saying who target is.	NO		NULL
statement_text	longtext	Petition statement text. Displayed to end user.	NO		NULL
about_text	longtext	Text about why the user should sign the petition. Displayed to end user.	NO		NULL
client_hosted	int(11)	1 if the page is hosted outside of the ActionKit CMS	YES		0
client_url	varchar(255)	URL of a page hosted outside of the ActionKit CMS. Used for the “View” link in the admin interface.	YES

cms_recurringdonationcancel_form

Recurring donation cancellation page content.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
templateset_id	int(11)	Id of the templateset, which defines the recurring donation cancel page look and feel. Pulls from cms_templateset on (cms_template.id= cms_recurringdonationcancel_form.templateset_id)	NO	MUL	NULL
page_id	int(11)	ID of the page, which defines action basics and follow-up. Pulls from core_ page on (cms_recurringdonationcancel_form.page_id= core_page.id)	NO	UNI	NULL
thank_you_text	longtext	Text displayed on the thank you page (URL defined in core_page table) after end user takes action.	NO		NULL
please_stay_text	longtext	Optional text displayed to end user requesting that they not cancel their donation.	NO		NULL
client_hosted	int(11)	1 if the page is hosted outside of the ActionKit CMS	YES		0
client_url	varchar(255)	URL of a page hosted outside of the ActionKit CMS. Used for the “View” link in the admin interface.	YES

cms_recurringdonationupdate_form

Recurring donation update page content.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
templateset_id	int(11)	Id of the templateset, which defines the recurring donation update page look and feel. Pulls from cms_templateset on (cms_template.id= cms_recurringdonationupdate_form.templateset_id)	NO	MUL	NULL
page_id	int(11)	ID of the page, which defines action basics and follow-up. Pulls from core_ page on (cms_recurringdonationupdate_form.page_id= core_page.id)	NO	UNI	NULL
thank_you_text	longtext	Text displayed on the thank you page (URL defined in core_page table) after end user takes action.	NO		NULL
update_card_text	longtext	Text to end user about options on this page.	NO		NULL
client_hosted	int(11)	1 if the page is hosted outside of the ActionKit CMS	YES		0
client_url	varchar(255)	URL of a page hosted outside of the ActionKit CMS. Used for the “View” link in the admin interface.	YES

cms_signup_form

Sign up page content.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
templateset_id	int(11)	Id of the templateset, which defines the signup look and feel. Pulls from cms_templateset on (cms_template.id= cms_signup_form.templateset_id)	NO	MUL	NULL
page_id	int(11)	ID of the page, which defines action basics and follow-up. Pulls from core_ page on (cms_sign_form.page_id= core_page.id)	NO	UNI	NULL
thank_you_text	longtext	Text displayed on the thank you page (URL defined in core_page table) after end user takes action.	NO		NULL
introduction_text	longtext	Optional text displayed to end user asking them to signup.	NO		NULL
client_hosted	int(11)	1 if the page is hosted outside of the ActionKit CMS	YES		0
client_url	varchar(255)	URL of a page hosted outside of the ActionKit CMS. Used for the “View” link in the admin interface.	YES

cms_survey_form

Survey page content.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
templateset_id	int(11)	Id of the templateset, which defines the survey look and feel. Pulls from cms_templateset on (cms_template.id= cms_survey_form.templateset_id)	NO	MUL	NULL
page_id	int(11)	ID of the page, which defines action basics and follow-up. Pulls from core_ page on (cms_survey_form.page_id= core_page.id)	NO	UNI	NULL
thank_you_text	longtext	Text displayed on the thank you page (URL defined in core_page table) after end user takes action.	NO		NULL
introduction_text	longtext	Optional text displayed to end user explaining the survey.	NO		NULL
client_hosted	int(11)	1 if the page is hosted outside of the ActionKit CMS	YES		0
client_url	varchar(255)	URL of a page hosted outside of the ActionKit CMS. Used for the “View” link in the admin interface.	YES

cms_survey_question

Surveys also have a subsidiary table for the survey question html.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for all survey questions on this survey form.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
question_label	varchar(255)	Survey question label.	NO		NULL
question_html	longtext	Html to display the question and answer choices (as checkboxes, or a textbox, etc.) for the end user.	NO		NULL
survey_form_id	int(11)	Joins to general survey content, as outlined in the table above, on (cms_survey_form.id= cms_survey_question.survey_form_id)	NO	MUL	NULL
ordering	int(11)	Sets the question order on the survey page.	YES		0
field_type	varchar(16)	Display format for field (e.g. ‘text’, ‘checkbox’, etc.)	YES		NULL
field_name	varchar(255)	The name of the action field that the user entry is saved under (e.g. select value from core_actionfield where name=’[field_name entry]’).	YES		NULL
alternatives	longtext	Text of alternatives if the field type offers options to select from.	YES		NULL
options_json	longtext	Description needed.	YES		NULL
is_required	tinyint(1)	1 if required.	YES		0

cms_template

HTML for each template. A template sets the appearance for a page type (like petition) and related items (like list of states).

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
filename	varchar(255)	Identifies page type or name of related item.	NO	MUL	NULL
code	longtext	Template HTML.	NO		NULL
templateset_id	int(11)	Joins to templateset on (cms_templateset.id= cms_template.templateset_id).	NO	MUL	NULL
code_hash	varchar(64)	Holds a hash of the template’s code	NO	MUL	NULL

cms_templatecode

Stored text of old and current versions of templates for history.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
code_hash	varchar(64)	Holds a hash of the template’s code	NO	MUL	NULL
code	longtext	html for displaying this type of page or item.	NO		NULL

cms_templatehistory

Stores old versions of templates.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
templateset_id	int(11)	Joins to templateset on (cms_templateset.id= cms_templatehistory.templateset_id).	NO	MUL	NULL
filename	varchar(255)	Identifies name of particular template.	NO		NULL
code_hash	varchar(64)	Holds a hash of the template’s code	NO		NULL
user_name	varchar(64)	Identifies which admin user made this edit.	YES		NULL
edit_type	varchar(64)	Contains a designation like “edit”, “copy”, or “patch”	YES		NULL
github_sha	varchar(64)	Description needed.	YES		NULL
github_message	longtext	Description needed.	YES		NULL

cms_templateset

Name and description of a set of templates. Each set has the same templates.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	unique identifier	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
name	varchar(255)	Name of set	NO	UNI	NULL
description	varchar(255)	Description of set	NO		NULL
lang_id	int(11)	Joins to core_language on (cms_templateset.lang_id= core_language.id)	YES	MUL	NULL
editable	tinyint(1)	0 prevents overwriting built-in Original templatesets	NO		1
hidden	tinyint(1)	1=yes, templateset is hidden	NO	MUL	NULL
is_default	tinyint(1)	1 if this templateset is to be selected by default during page creation	YES		0

cms_templatesetfield

Templateset field values.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
parent_id	int(11)	User id. Joins to core_template on (core_templatesetfield.parent_id= core_template.id)	NO	MUL	NULL
name	varchar(255)	field name	NO	MUL	NULL
value	longtext	Value to be applied to the template.	NO		NULL

cms_unsubscribe_form

Unsubscribe page content.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
templateset_id	int(11)	Id of the templateset, which defines the unsubscribe look and feel. Pulls from cms_templateset on (cms_template.id= cms_unsubscribe_form.templateset_id)	NO	MUL	NULL
page_id	int(11)	ID of the page, which defines action basics and follow-up. Pulls from core_ page on (cms_unsubscribe_form.page_id= core_page.id)	NO	UNI	NULL
thank_you_text	longtext	Text displayed on the thank you page (URL defined in core_page table) after end user takes action.	NO		NULL
introduction_text	longtext	Optional text displayed to end user.	NO		NULL
suvery_question_text	longtext	Text asking user why they want to unsubscribe.	NO		NULL
client_hosted	int(11)	1 if the page is hosted outside of the ActionKit CMS	YES		0
client_url	varchar(255)	URL of a page hosted outside of the ActionKit CMS. Used for the “View” link in the admin interface.	YES

cms_uploadedfile

Images, etc. for use in pages.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	unique identifier	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
bucket	varchar(255)	Needs description	NO		NULL
directory	varchar(255)	location of the file	NO		NULL
filename	varchar(255)	name of the file	NO		NULL
url	varchar(255)	address which you use to access the file	NO	UNI	NULL
etag	varchar(255)	(For internal use; helps to identify duplicate files even when the filenames are different)	NO		NULL
size	int(11)	Size, in bytes. Divide by 1024 for KB or again by 1024 for MB. May be NULL for old files.	YES		NULL

cms_user_form_field

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI		auto_increment
created_at	datetime		NO	MUL
updated_at	datetime		NO
form_type_id	int(11)	Joins to django_content_type.id	NO	MUL
form_id	int(10) unsigned	Joins to the unique identifier of the CMS form table for the content type identified by form_type_id.	NO
type	varchar(8)	User, action, custom, or HTML.	NO
label	longtext	Field input label.	NO
field_name	varchar(96)	Name of the field	NO
input	varchar(16)	HTML input type.	NO
alternatives	longtext	The options provided for this input.	NO
html	longtext	Custom input HTML when type=HTML.	NO
status	varchar(8)	visible=the field will show on the user form, but a user can submit without entering a value. Required=the user cannot submit on this page without filling in this field. Hidden=the field will be included if required by an selected advocacy target.	NO
ordering	int(11)	Used to reorder form fields.	NO

cms_whipcount_form

Whipcount page content.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
templateset_id	int(11)	Id of the templateset, which defines the whipcount look and feel. Pulls from cms_templateset on (cms_template.id= cms_whipcount_form.templateset_id)	NO	MUL	NULL
page_id	int(11)	ID of the page, which defines action basics and follow-up. Pulls from core_ page on (cms_whipcount_form.page_id= core_page.id)	NO	UNI	NULL
thank_you_text	longtext	Text displayed on the thank you page (URL defined in core_page table) after end user takes action.	NO		NULL
introduction_text	longtext	Page intro.	NO		NULL
script_text	longtext	Call script.	NO		NULL
survey_question_text	longtext	Question for the user about the call (e.g. “Who did you speak to?”).	NO		NULL
results_source	varchar(255)	Source used to determine target’s position. Possible values are User submitted, Admin configured, and User submitted with admin overrides.	NO		users
minimum_response_agreement	decimal(3,2)	Percentage value that must agree before the results are displayed on the page.	NO		NULL
minimum_calls	int(11)	The number of calls that must be made before the results are displayed on the page.	NO		NULL
client_hosted	int(11)	1 if the page is hosted outside of the ActionKit CMS	YES		0
client_url	varchar(255)	URL of a page hosted outside of the ActionKit CMS. Used for the “View” link in the admin interface.	YES

cms_whipcountresponseoverride

Holds the admin configuration for overrides for target stances on a whipcount page.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
whipcount_form_id	int(11)	Joins to cms_whipcount_form	NO	MUL	NULL
target_id	int(11)	Joins to core_target	NO	MUL	NULL
stance	varchar(255)	Holds the target’s position: either “supportive,” “opposed,” or “uncommitted”	NO		NULL

Page testing and statistics Tables

A/B page test tables record variations, trials, views and actions associated with page tests.

• lab_test

• lab_variation

• lab_trial

• lab_enrollment

• lab_view

• lab_enrolledview

• lab_enrolledaction

• lab_enrolledshare

• lab_test_pages

• lab_tag

• lab_test_tags

lab_test

An A/B test containing two or more variations, which override selected attributes of the page, like its title or sharing text.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
name	varchar(255)	Either the given or auto-generated name for the A/B test.	YES		NULL
notes	varchar(255)	Notes field for internal use.	YES		NULL
scope	varchar(12)	Not in use.	NO		NULL
allocation	varchar(32)	Method for assigning users to test variants: equal, custom, or optimize.	NO		NULL
optimize_for	varchar(32)	If allocation=optimize, the ratio that the test will try to optimize.	YES		NULL
change_page_title	tinyint(1)	1=Test variants change page titles.	NO		NULL
change_intro_text	tinyint(1)	1=Test variants change page intro text.	NO		NULL
change_thanks_text	tinyint(1)	1=Test variants change page thank-you text.	NO		NULL
change_templateset	tinyint(1)	1=Test variants may change page templatesets.	NO		NULL
change_custom_fields	tinyint(1)	Not used.	NO		NULL
change_followup_url	tinyint(1)	1=Test variants change follow-up URLs.	NO		NULL
change_email_enabled	tinyint(1)	1=Test variants may change whether thank-you emails are sent.	NO		NULL
change_email_subject	tinyint(1)	1=Test variants change thank-you email subject.	NO		NULL
change_email_body	tinyint(1)	1=Test variants change thank-you email body.	NO		NULL
change_taf_enabled	tinyint(1)	1=Test variants may change whether tell-a-friend is enabled.	NO		NULL
change_taf_subject	tinyint(1)	1=Test variants change tell-a-friend email subject.	NO		NULL
change_taf_body	tinyint(1)	1=Test variants change tell-a-friend email body.	NO		NULL
change_share_title	tinyint(1)	1=Test variants change share title.	NO		NULL
change_share_description	tinyint(1)	1=Test variants change Facebook share description.	NO		NULL
change_share_image	tinyint(1)	1=Test variants change Facebook share image.	NO		NULL
change_twitter_message	tinyint(1)	1=Test variants change Twitter message.	NO		NULL

lab_variation

Variations override selected attributes of page in a test, like its title or sharing text.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
test_id	int(11)	Joins to lab_test.	NO	MUL	NULL
letter	varchar(2)	Letter identifying this variant, e.g. A or B.	NO		NULL
weight	double	Allocation weight for this variant. Variants with a greater weight are shown more frequently.	NO		NULL
disabled	tinyint(1)	1=Users will not see or be enrolled in a test using this variation.	NO		NULL
page_title	varchar(255)	Page title shown for this variation. If empty, page’s original value will be used.	NO		NULL
intro_text	longtext	Intro text to display for users seeing this variation. If empty, page’s original value will be used.	NO		NULL
thanks_text	longtext	Thank-you text to display for users seeing this variation. If empty, page’s original value will be used.	NO		NULL
templateset_id	int(11)	Templateset to use for users seeing this variation. If empty, page’s original value will be used.	YES	MUL	NULL
custom_fields	longtext	Not used.	NO		NULL
followup_url	varchar(255)	Follow-up URL to use for users taking action on this variation. If empty, page’s original value will be used.	NO		NULL
email_enabled	varchar(1)	0=Thank-you email disabled, 1=thank-you text enabled. If empty, page’s original value will be used.	NO		NULL
email_subject	varchar(255)	Thank-you email subject to use for users seeing this variation. If empty, page’s original value will be used.	NO		NULL
email_body	longtext	Thank-you email body to use for users seeing this variation. If empty, page’s original value will be used.	NO		NULL
taf_enabled	varchar(1)	0=Tell-a-friend disabled, 1=tell-a-friend enabled. If empty, page’s original value will be used.	NO		NULL
taf_subject	varchar(255)	Tell-a-friend subject to use for users seeing this variation. If empty, page’s original value will be used.	NO		NULL
taf_body	longtext	tell-a-friend email body use for users seeing this variation. If empty, page’s original value will be used.	NO		NULL
share_title	varchar(255)	Facebook share title to display for users seeing this variation. If empty, page’s original value will be used.	NO		NULL
share_description	longtext	Facebook share description to display for users seeing this variation. If empty, page’s original value will be used.	NO		NULL
share_image	varchar(255)	Facebook share image to display for users seeing this variation. If empty, page’s original value will be used.	NO		NULL
twitter_message	varchar(255)	Twitter message to display for users seeing this variation. If empty, page’s original value will be used.	NO		NULL

lab_trial

A period during which a test was active.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
test_id	int(11)	Joins to lab_test.	NO	MUL	NULL
page_id	int(11)	Joins to core_page.	YES	MUL	NULL
started_at	datetime	Start date for this trial.	NO		NULL
ended_at	datetime	End date for this trial.	YES		NULL

lab_enrollment

When a test is active, users who visit a page are “enrolled” with one variation or another, and see that version of the page. Enrollments are sticky between requests, so if a user reloads a page, or clicks away and then returns, they’ll see the same variation again.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
test_id	int(11)	Joins to lab_test.	NO	MUL	NULL
variation_id	int(11)	Joins to lab_variation.	NO	MUL	NULL
trial_id	int(11)	Joins to lab_trial.	YES	MUL	NULL
user_id	int(11)	Joins to core_user.	YES	MUL	NULL
session_key	varchar(255)	Session identifier used to recognize a user across pageviews.	YES		NULL

lab_view

The lab_view table stores a row for each view of a page that is involved in a test.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
page_id	int(11)	Joins to core_page.	NO	MUL	NULL
filename	varchar(255)	Not used.	NO		NULL
user_id	int(11)	Joins to core_user.	YES	MUL	NULL
mailing_id	int(11)	Joins to core_mailing.	YES	MUL	NULL
share_id	int(11)	Joins to share_link.	YES	MUL	NULL

lab_enrolledview

Extending lab_view, the lab_enrolledview table records a row for each page view made by a user enrolled in a test.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
view_id	int(11)	Joins to lab_view.	NO	MUL	NULL
enrollment_id	int(11)	Joins to lab_enrollment.	NO	MUL	NULL

lab_enrolledaction

Records actions taken by users that have been enrolled in a test.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
action_id	int(11)	Joins to core_action.	NO	MUL	NULL
enrollment_id	int(11)	Joins to core_enrollment.	NO	MUL	NULL

lab_enrolledshare

Records a row each time a user enrolled in a test clicks a tracking-enable share button to post a link to a social network.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
share_id	int(11)	Joins to share_link.	NO	MUL	NULL
enrollment_id	int(11)	Joins to lab_enrollment.	NO	MUL	NULL

lab_test_pages

Pages that have been assigned to a test.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
test_id	int(11)	Joins to lab_test.	NO	MUL	NULL
page_id	int(11)	Joins to core_page.	NO	MUL	NULL

lab_tag

Categories that can be associated with a test.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
hidden	tinyint(1)	1=yes, tag is hidden	NO		NULL
name	varchar(255)	Tag name.	NO	UNI	NULL

lab_test_tags

Categories that have been associated with a test.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
test_id	int(11)	Joins to lab_test.	NO	MUL	NULL
tag_id	int(11)	Joins to lab_tag.	NO	MUL	NULL

Privacy Tables

The Privacy tables provide an audit log of privacy records, used for GDPR and other compliance.

The following core privacy tables are described below:

• core_privacynotes

• core_privacyrecord

• core_privacytext

• eraser_eraserlog

core_privacynotes

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime(6)		NO		NULL
updated_at	datetime(6)		NO		NULL
hidden	tinyint(1)		NO		NULL
text	longtext		NO		NULL

core_privacyrecord

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime(6)		NO		NULL
updated_at	datetime(6)		NO		NULL
version_id	int(11)		NO	MUL	NULL
status	varchar(32)		NO		NULL
user_id	int(11)		NO	MUL	NULL
action_id	int(11)		YES	MUL	NULL

core_privacytext

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime(6)		NO		NULL
updated_at	datetime(6)		NO		NULL
text	longtext		NO		NULL
type	longtext		NO		NULL
lang_id	int(11)		YES	MUL	NULL
hash	varchar(64)		NO	UNI	NULL
accepted	tinyint(1)		NO		NULL

eraser_eraserlog

Field	Type	Description	Null	Key	Default	Extra
created_at	datetime(6)		NO	MUL	NULL
updated_at	datetime(6)		NO		NULL
user_id	int(11)		NO	PRI	NULL
hashed_email	varchar(255)		NO		NULL

Reports Tables

The Reports tables define queries and display for reports.

The following core reports tables are described below:

• reports_dashboardreport

• reports_queryreport

• reports_querytemplate

• reports_report

• reports_report_categories

• reports_reportcategory

• reports_userupdater

• reports_userupdater_staff

• core_defaultexcludequery

• core_defaultexcludequeryparam

• core_engagementqueryreport

• core_engagementqueryreportparam

• core_databaseaccount

• zip_proximity

• numeric_9999

• numeric_date

• numeric_digit

reports_dashboardreport

HTML for multi query (or dashboard) reports.

Field	Type	Description	Null	Key	Default	Extra
report_ptr_id	int(11)	Identifies the report. Joins to report_report.	NO	PRI	Null
template	longtext	HTML and display instructions for dashboard report.	NO		Null

reports_queryreport

SQL queries.

Field	Type	Description	Null	Key	Default	Extra
report_ptr_id	int(11)	Joins to reports_report above.	NO	PRI	Null
sql	longtext	The sql query.	NO		Null
display_as_id	int(11)	The template to be used to display the query. Joins to reports_querytemplate.	NO	MUL	Null
email_always_csv	tinyint(1)	Needs description	YES		Null
refresh	varchar(255)	For mailer library queries: every time, hourly or daily.	YES		NULL

reports_querytemplate

Layouts for the queries.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for each query layout.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	Null
updated_at	datetime		NO		Null
name	varchar(255)	Template name.	NO	UNI	Null
template	longtext	Template HTML and display instructions.	NO		Null
hidden	tinyint(1)	1=hidden	NO	MUL	NULL

reports_report

Name and basic info about all reports (query or dashboard).

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for each report.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	Null
updated_at	datetime		NO		Null
name	varchar(255)	Report name.	NO	UNI	Null
short_name	varchar(255)	Reference name.	YES	UNI	NULL
description	varchar(255)	Description of report.	NO		Null
type	varchar(255)	Report type: query or dashboard.	NO		Null
run_every	varchar(255)	How frequently this should run: hourly, daily, weekly, or monthly.	NO		NULL
to_emails	varchar(4000)	Emails to receive the report.	NO		NULL
hidden	tinyint(1)	1=hidden	NO	MUL	NULL
help_text	longtext	Additional text giving user direction for input.	NO		NULL
send_if_no_rows	tinyint(1)	1=send the report, whether or not there are any matching rows	NO		1
run_day	int(11)	Day of month	YES		1
run_weekday	int(11)	Day of week	YES		1
run_hour	int(11)	Time of day	YES		8
editable	tinyint(1)	1=the report is editable.	YES		1

reports_report_categories

Links report to category.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
report_id	int(11)	Joins reports_report.id.	NO	MUL	NULL
reportcategory_id	int(11)	Joins reports_reportcategory.id	NO	MUL	NULL

reports_reportcategory

All available report categories.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for each category.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL
updated_at	datetime		NO
name	varchar(255)	Homepage and mailer, plus whatever categories you add.	NO	UNI	NULL
hidden	tinyint(1)	1=hidden	NO	MUL	0
is_internal	tinyint(1)	Needs description	NO		0

reports_userupdater

Used to update custom user fields automatically.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	Null
created_at	datetime		NO	MUL
updated_at	datetime		NO
hidden	tinyint(1)	1=hidden	NO		NULL
name	varchar(255)	Display name	NO		NULL
description	varchar(255)	Description	NO		NULL
report_id	int(11)	Joins to reports_report.id.	NO	MUL	NULL
run_every	varchar(255)	How frequently this should run: daily, weekly, or monthly	NO		NULL
run_day	int(11)	Day of month	YES		1
run_weekday	int(11)	Day of week	YES		1
run_hour	int(11)	Time of day	YES		8
last_run_job_id	int(11)	ID of the last ReportUserUpdaterJob or ReportUserUpdaterUploadJob, if any. Joins to core_job.	YES		NULL
last_run_datetime	datetime	Date/timestamp of the last run, if any.	YES		NULL
last_run_status	varchar(255)	Status of the last run, if any.	YES		NULL
last_run_count	int(11)	Number of users updated during the last run, if any.	YES		NULL

reports_userupdater_staff

Used to determine which staff members get notified of user updater runs.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier	NO	PRI	Null
userupdater_id	int(11)	Joins to reports_userupdater.	NO	PRI	Null
user_id	int(11)	Joins to auth_user.	NO	PRI	Null

core_defaultexcludequery

Query report that will be excluded by default when a new mailing is created.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI		auto_increment
created_at	datetime	Creation date/time.	NO	MUL
updated_at	datetime	Updated date/time.	NO
report_id	int(11)	Joins to reports_report.id	NO	MUL

core_defaultexcludequeryparam

Additional parameters provided by staffer when using a query report as an auto excludes query.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time.	NO	MUL	NULL
updated_at	datetime	Updated date/time.	NO		NULL
query_id	int(11)	Query identifier.	NO	MUL	NULL
name	varchar(255)	Parameter name.	NO		NULL
value	varchar(255)	Value entered by staffer for the parameter.	NO		NULL

core_engagementqueryreport

Query report used to identify engaged users for re-engagement processing.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI		auto_increment
created_at	datetime	Creation date/time.	NO	MUL
updated_at	datetime	Updated date/time.	NO
report_id	int(11)	Joins to reports_report.id	NO	MUL

core_engagementqueryreportparam

Additional parameters provided by staffer when using a query report to identify engaged users.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime	Creation date/time.	NO	MUL	NULL
updated_at	datetime	Updated date/time.	NO		NULL
query_id	int(11)	Query identifier.	NO	MUL	NULL
name	varchar(255)	Parameter name.	NO		NULL
value	varchar(255)	Value entered by staffer for the parameter.	NO		NULL

core_databaseaccount

Accounts that have been granted access to the MySQL client analytics database.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI		auto_increment
created_at	datetime		NO
updated_at	datetime		NO
username	varchar(32)	Database username.	NO	UNI
email	varchar(255)	Database user's email address.	YES
auth_user_id	int(11)	Staff user associated with account.	YES	MUL

zip_proximity

All zip code pairs within 50 miles of each other.

Field	Type	Description	Null	Key	Default	Extra
zip	char(5)	Zip code.	NO
nearby	char(5)	Another zip with 50 miles.	NO
same_state	tinyint(1)	1=yes if the second zip is in the same state as the first.	YES		NULL
distance	decimal (3,1)	Distance to second zip.	YES		NULL

numeric_date

All dates from 1998-09-11 until 2026-01-26. Particularly useful for aggregating actions over a date ranges that may include days with 0 actions.

Field	Type	Description	Null	Key	Default	Extra
date	varbinary(29)		YES		NULL

numeric_9999

All integers from 0 to 9999.

Field	Type	Description	Null	Key	Default	Extra
number	bigint(25)		NO		0

numeric_digit

All integers from 0 to 10.

Field	Type	Description	Null	Key	Default	Extra
digit	bigint(20)		NO		0

Sharing Tables

The Sharing tables record share tracking links and any clicks and actions that are associated with them.

share_type

Records the names and two-letter type codes associated with various types of sharing, including Facebook, Twitter, and other.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
type	varchar(2)	Contains a share type code like “fb”, “tw”, or “ot”	NO		NULL
name	varchar(255)	Title of the sharing type, like “Facebook” or “Twitter”	NO		NULL

share_link

The share_link table stores a row each time a user clicks a tracking-enabled share button to post a link to a social network.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
type	varchar(2)	Contains a share type code like “fb”, “tw”, or “ot”	NO		NULL
page_id	int(11)	ID of the page that was shared.	NO	MUL	NULL
user_id	int(11)	ID of the user who shared the link, if known.	YES	MUL	NULL
action_id	int(11)	ID of the action taken before the link was shared, if any.	YES	MUL	NULL
referring_share_id	int(11)	ID of the share link the user clicked on before sharing this link, if any.	YES	MUL	NULL
generation	smallint(5) unsigned	Stores 1 for shares created by users who arrived from regular web or mailing links, 2 for shares created by users who had followed a generation 1 share, and so forth.	YES		NULL
source	varchar(255)	A value passed when creating the share link which will provide the ‘source’ for any clicks or actions it generates.	NO		NULL

share_click

The share_click table stores a row each time a user clicks on a trackable share link.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
page_id	int(11)	ID of the page that was clicked to.	NO	MUL	NULL
share_id	int(11)	ID of the share link that was clicked.	NO	MUL	NULL

share_action

The share_action table stores a row each time a user takes action after clicking on a trackable share link.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
share_id	int(11)	ID of the share link that was clicked to take this action.	NO	MUL	NULL
action_id	int(11)	ID of the core_action row created for this action.	NO	MUL	NULL

Delivery Tables

• core_batchdelivery

• core_deliveryerror

• core_petitiondeliveryfile

• core_petitiondeliveryfile_targets

• core_petitiondeliveryfilecollector

• core_petitiondeliveryfiledownload

• core_petitiondeliveryjob

• core_petitiondeliveryjobbuilder

core_batchdelivery

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
target_id	int(11)		NO	MUL	NULL
page_id	int(11)		NO	MUL	NULL
message	longtext		YES		NULL
subject	varchar(255)		YES		NULL
from_line	longtext		YES		NULL
recent_signatures	int(11)		NO		NULL
recent_since	datetime		NO		NULL
delivered	tinyint(1)		NO		NULL
traceback	longtext		YES		NULL

core_deliveryerror

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime(6)		NO	MUL	NULL
updated_at	datetime(6)		NO		NULL
page_id	int(11)		NO	MUL	NULL
target_id	int(11)		YES	MUL	NULL
user_id	int(11)		YES	MUL	NULL
subject	longtext		NO		NULL
body	longtext		NO		NULL
reason	varchar(255)		NO		NULL
delivery_type	varchar(255)		NO		NULL

core_petitiondeliveryfile

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
job_id	int(11)		NO	MUL	NULL
target_count	int(11)		NO		NULL
signatures	int(11)		YES		NULL
format	varchar(255)		NO		NULL
hostname	varchar(255)		NO		NULL
filename	varchar(255)		NO	UNI	NULL
status	varchar(255)		NO	MUL	NULL

core_petitiondeliveryfile_targets

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
petitiondeliveryfile_id	int(11)		NO	MUL	NULL
target_id	int(11)		NO	MUL	NULL

core_petitiondeliveryfilecollector

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
task_id	varchar(255)		YES	MUL	NULL
queued	int(11)		NO		NULL
completed	int(11)		NO		NULL
status	varchar(255)		NO		NULL
started_at	datetime		YES		NULL
completed_at	datetime		YES		NULL
job_id	int(11)		NO	MUL	NULL
format	varchar(255)		NO		NULL
archive	varchar(255)		YES		NULL

core_petitiondeliveryfiledownload

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
file_id	int(11)		NO	MUL	NULL
downloaded_by_id	int(11)		NO	MUL	NULL

core_petitiondeliveryjob

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
single_file	tinyint(1)		NO		NULL
cover_html	longtext		NO		NULL
print_template_id	int(11)		NO	MUL	NULL
header_content	longtext		NO		NULL
footer_content	longtext		NO		NULL
allow_pdf_download	tinyint(1)		YES
allow_csv_download	tinyint(1)		YES
template_set_id	int(11)		YES	MUL	NULL
limit_delivery	tinyint(1)		NO
all_to_all	tinyint(1)		YES
include_email_in_csv	tinyint(1)		NO		NULL
date_from	date		YES		NULL
date_to	date		YES		NULL

core_petitiondeliveryjobbuilder

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
single_file	tinyint(1)		NO		NULL
cover_html	longtext		NO		NULL
print_template_id	int(11)		NO	MUL	NULL
header_content	longtext		NO		NULL
footer_content	longtext		NO		NULL
allow_pdf_download	tinyint(1)		YES
allow_csv_download	tinyint(1)		YES
template_set_id	int(11)		YES	MUL	NULL
limit_delivery	tinyint(1)		NO
all_to_all	tinyint(1)		YES
include_email_in_csv	tinyint(1)		NO		NULL
date_from	date		YES		NULL
date_to	date		YES		NULL

Salesforce Integration Tables

core_salesforcefieldmap

User field mappings for your Salesforce integration.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
ak_field	varchar(255)	Field in ActionKit mapping to Salesforce field.	NO		NULL
sf_field	varchar(255)	Field in Salesforce mapping to ActionKit field.	NO		NULL
readonly	tinyint(1)	1 = mapping is not editable (for email and last_name).	YES		NULL
direction	varchar(255)	Shows how data will flow for this pair of fields: ‘all’ for bi-directional, ak_to_sf or sf_to_ak.	NO		NULL

core_salesforcelog

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
last_sf_datetime	datetime		YES	Not in use.	NULL
last_ak_user_id	int(11)	Last ActionKit user ID synced.	YES		NULL
last_ak_action_id	int(11)	Last ActionKit action ID synced.	YES		NULL
last_ak_updated_at	datetime(6)	Last ActionKit user updated_at synced.	YES		NULL
last_ak_uf_updated_at	datetime(6)	Last ActionKit custom user field updated_at synced.	YES		NULL
created_ak_users	int(11)	Not in use.	NO		NULL
created_ak_orders	int(11)	Not in use.	NO		NULL
created_sf_users	int(11)	Number of Salesforce contacts created.	NO		NULL
created_sf_opportunities	int(11)	Number of Salesforce opportunities created.	NO		NULL
created_sf_recurring	int(11)	Number of Salesforce recurring donations created.	NO		NULL
updated_ak_users	int(11)	Not in use.	NO		NULL
updated_sf_users	int(11)	Number of users who were updated in SF during the sync.	NO		NULL
failed_ak_users	int(11)	Number of users who failed to sync from AK to SF.	NO		NULL
failed_sf_users	int(11)	Not in use.	NO		NULL
status	varchar(20)	failed or success	NO		NULL
error	longtext	Detailed error message.	YES		NULL

core_salesforceorderfieldmap

Order field mappings for your Salesforce integration.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime(6)		NO	MUL	NULL
updated_at	datetime(6)		NO		NULL
ak_field	varchar(255)	Field in ActionKit mapping to Salesforce field.	NO		NULL
ak_literal	varchar(255)	Description needed	NO		NULL
sf_field	varchar(255)	Field in Salesforce mapping to ActionKit field.	NO		NULL
sf_literal	varchar(255)	Description needed	NO		NULL
readonly	tinyint(1)	1 = mapping is not editable (currently no fields).	YES		NULL
builtin	tinyint(1)	Description needed	YES		NULL
direction	varchar(255)	Shows how data will flow for this pair of fields: ‘all’ for bi-directional, ak_to_sf or sf_to_ak.	NO		NULL

core_salesforceordermap

Record of synced donations.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime(6)		NO	MUL	NULL
updated_at	datetime(6)		NO		NULL
order_id	int(11)	ActionKit order_id. Joins to core_order.	NO	MUL	NULL
salesforce_id	varchar(18)	Unique identifier in Salesforce, displayed in the opportunity record URL.	NO		NULL
origin	varchar(2)	System the donation is coming from: sf or ak.	NO		NULL

core_salesforcerecurringorderfieldmap

Recurring order field mappings for your Salesforce integration.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime(6)		NO	MUL	NULL
updated_at	datetime(6)		NO		NULL
ak_field	varchar(255)	Field in ActionKit mapping to Salesforce field.	NO		NULL
ak_literal	varchar(255)	Description needed	NO		NULL
sf_field	varchar(255)	Field in Salesforce mapping to ActionKit field.	NO		NULL
sf_literal	varchar(255)	Description needed	NO		NULL
readonly	tinyint(1)	1 = mapping is not editable (currently no fields).	YES		NULL
builtin	tinyint(1)	Description needed	YES		NULL
direction	varchar(255)	Shows how data will flow for this pair of fields: ‘all’ for bi-directional, ak_to_sf or sf_to_ak.	NO		NULL

core_salesforcesyncrule

Not in use.

core_salesforcetransactionmap

Maps individual payments on recurring orders from core_transaction to the corresponding Salesforce opportunity.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime(6)		NO	MUL	NULL
updated_at	datetime(6)		NO		NULL
transaction_id	int(11)	ActionKit transaction_id. Joins to core_transaction.	NO	MUL	NULL
salesforce_id	varchar(18)	Unique identifier in Salesforce, displayed in the opportunity record URL.	NO		NULL

core_salesforceusermap

Record of user to contact mapping and whether the record was newly created in each system.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime(6)		NO	MUL	NULL
updated_at	datetime(6)		NO		NULL
user_id	int(11)	ActionKit user_id. Joins to core_user.	NO	MUL	NULL
salesforce_id	varchar(18)	Unique identifier in Salesforce, displayed in the user record URL.	NO		NULL
match_type	varchar(255)	‘primary_email’ if there’s a match between systems.	NO		NULL
created_ak_user	tinyint(1)	1 if the sync created a new user in ActionKit.	NO		NULL
created_sf_user	tinyint(1)	1 if the sync created a new contact in Salesforce.	NO		NULL
last_sync_at	datetime(6)	Deprecated; use updated_at instead. Last time the user/contact were synced.	YES		NULL

core_salesforceuserfailedsync

Record of failed sync attempts for specific users.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime(6)		NO	MUL	NULL
updated_at	datetime(6)		NO		NULL
user_id	int(11)	ActionKit user_id. Joins to core_user.	NO	MUL	NULL
reason	longtext	Reason the sync failed.	NO		NULL

Salesforce historical tables

Each historical table stores previous versions of an object. In addition to the object’s regular fields, there are additional fields available on each historical table:

Field	Type	Description	Null	Key	Default	Extra
history_id	int(11)	Unique identifier of the mapping’s history record. Not to be confused with id, the unique identifier of the mapping.	NO	PRI	NULL	auto_increment
history_date	datetime	Date/time this mapping was updated, and this history record was saved as a result	NO		NULL
history_user	integer	Which staff user made this change.	NO		NULL
history_change_reason	varchar(100)	For internal use only.	NO		NULL

core_historicalsalesforcefieldmap

This stored previous version of user field mappings. Joins to core_salesforcefieldmap.

core_historicalsalesforceorderfieldmap

This stored previous version of order field mappings. Joins to core_salesforceorderfieldmap.

core_historicalsalesforcerecurringorderfieldmap

This stored previous version of recurring order field mappings. Joins to core_salesforcerecurringorderfieldmap.

NGP/EveryAction Integration Tables

core_everyactionaccountmap

Mapping of ActionKit payment accounts to NGP/EveryAction designations.

Field	Type	Description	Null	Key	Default	Extra
id	int		NO	PRI		auto_increment
created_at	datetime(6)		NO	MUL
updated_at	datetime(6)		NO	MUL
account	varchar(255)	ActionKit account name	NO	UNI
designation_name	varchar(255)	NGP/EveryAction designation name	NO

core_everyactionapilog

Log of all NGP/EveryAction API calls made

Field	Type	Description	Null	Key	Default	Extra
id	int		NO	PRI		auto_increment
created_at	datetime(6)		NO	MUL
updated_at	datetime(6)		NO	MUL
method	varchar(255)	API method called	NO
filename	varchar(255)	ActionKit source filename	NO
line	int	ActionKit source line number	NO

core_everyactionbulkmapping

Stores mapping data for use with the NGP/EveryAction Bulk Upload API

Field	Type	Description	Null	Key	Default	Extra
id	int		NO	PRI		auto_increment
created_at	datetime(6)		NO	MUL
updated_at	datetime(6)		NO	MUL
name	varchar(255)		NO
result_name	varchar(255)		NO
readonly	tinyint(1)		NO
sync	varchar(255)		NO
hidden	tinyint(1)		NO
direction	varchar(8)		NO
virtual	tinyint(1)		NO

core_everyactionbulkmappingfield

Stores field definitions for bulk mappings, used to construct input for the NGP/EveryAction Bulk Upload API.

Field	Type	Description	Null	Key	Default	Extra
id	int		NO	PRI		auto_increment
created_at	datetime(6)		NO	MUL
updated_at	datetime(6)		NO	MUL
mapping_id	int		NO	MUL
name	varchar(255)		NO
readonly	tinyint(1)		NO
hidden	tinyint(1)		NO
column	varchar(255)		YES
ak_field	varchar(255)		YES
fmt	varchar(255)		YES
static	varchar(255)		YES
output	tinyint(1)		NO
ord	int		NO

core_everyactionlog

This tables stores a row for every run of the NGP/EveryAction sync, recording status info.

Field	Type	Description	Null	Key	Default	Extra
id	int		NO	PRI		auto_increment
created_at	datetime(6)		NO	MUL
updated_at	datetime(6)		NO	MUL
last_ak_user_id	int		YES
last_ak_action_id	int		YES
last_ak_updated_at	datetime(6)		YES
last_ak_uf_updated_at	datetime(6)		YES
last_ea_contact_update	datetime(6)		YES
created_ea_contacts	int		NO
updated_ea_contacts	int		NO
failed_ea_contacts	int		NO
created_ak_users	int		NO
updated_ak_users	int		NO
failed_ak_users	int		NO
created_ea_contributions	int		NO
updated_ea_contributions	int		NO
failed_ea_contributions	int		NO
status	varchar(20)	success or failed	NO
error	longtext	if status=failed this field contains the error details	YES

core_everyactionmergequery

This table holds data related to merge queries used in the EA sync.

Field	Type	Description	Null	Key	Default	Extra
id	int		NO	PRI		auto_increment
created_at	datetime(6)		NO	MUL
updated_at	datetime(6)		NO	MUL
sync	varchar(255)		NO
report_id	int		YES	MUL

core_everyactionorderfailedsync

This table holds orders that failed to sync to EA along with error details. This is used to control retry frequency in the sync.

Field	Type	Description	Null	Key	Default	Extra
id	int		NO	PRI		auto_increment
created_at	datetime(6)		NO	MUL
updated_at	datetime(6)		NO	MUL
order_id	int		NO	MUL
reason	longtext	Error description	NO

core_everyactionordermap

Table mapping ActionKit orders (one-time and recurring) to NGP/EveryAction Contributions and Recurring Donations.

Field	Type	Description	Null	Key	Default	Extra
id	int		NO	PRI		auto_increment
created_at	datetime(6)		NO	MUL
updated_at	datetime(6)		NO	MUL
order_id	int		NO	MUL
contribution_id	int		NO	MUL
is_recurring	tinyint(1)		YES
origin	varchar(2)	Currently always set to ak	NO

core_everyactionrestcalllog

Log of calls to the ActionKit REST API NGP/EveryAction resources.

Field	Type	Description	Null	Key	Default	Extra
id	int		NO	PRI		auto_increment
created_at	datetime(6)		NO	MUL
updated_at	datetime(6)		NO	MUL
method	varchar(255)		NO
path	varchar(255)		NO
user_id	int		NO	MUL
body	longtext		NO
status_code	int		NO
result	longtext		NO

core_everyactiontransactionfailedsync

This table holds recurring payments that failed to sync to EA along with error details. This is used to control retry frequency in the sync.

Field	Type	Description	Null	Key	Default	Extra
id	int		NO	PRI		auto_increment
created_at	datetime(6)		NO	MUL
updated_at	datetime(6)		NO	MUL
transaction_id	int		NO	MUL
reason	longtext		NO

core_everyactiontransactionmap

Table mapping ActionKit recurring payments to NGP/EveryAction Contributions.

Field	Type	Description	Null	Key	Default	Extra
id	int		NO	PRI		auto_increment
created_at	datetime(6)		NO	MUL
updated_at	datetime(6)		NO	MUL
transaction_id	int		NO	MUL
contribution_id	int		NO	MUL

core_everyactionuserfailedsync

This table holds users that failed to sync to EA along with error details. This is used to control retry frequency in the sync.

Field	Type	Description	Null	Key	Default	Extra
id	int		NO	PRI		auto_increment
created_at	datetime(6)		NO	MUL
updated_at	datetime(6)		NO	MUL
user_id	int		NO	MUL
reason	longtext		NO

core_everyactionusermap

Table mapping ActionKit users to NGP/EveryAction Contacts.

Field	Type	Description	Null	Key	Default	Extra
id	int		NO	PRI		auto_increment
created_at	datetime(6)		NO	MUL
updated_at	datetime(6)		NO	MUL
user_id	int		NO	MUL
van_id	int		NO	MUL
created_ea_contact	tinyint(1)	Set to 1 if the sync process created a new EA Contact for this user, 0 if it found an existing EA Contact match	NO

ActBlue Integration Tables

webhooks_webhookauthenticationlog

Logs connections (and connection attempts) to the ActionKit ActBlue webhook.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO	MUL	NULL
webhook_path	varchar(255)	Name of webhook (“actblue”)	NO	MUL	NULL
status	varchar(255)	success, bad_password, bad_username, locked_out_ip	NO	MUL	NULL
session_id	varchar(255)	Hash of login session (if any)	YES	MUL	NULL
username	varchar(255)	Attempted username	YES	MUL	NULL
payment_account	varchar(255)	Attempted payment account name	YES		NULL
ip_address	varchar(255)	Source of request	NO		NULL
url	varchar(255)	Path attempted including GET params	YES		NULL

webhooks_webhooknotificationreceived

Stores received webhook events. Only contains recent data; older data is regularly deleted. See webhooks_webhooknotificationreceivedlog for historical data.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
type	varchar(255)	Type of webhook event received. Currently only used for actblue_payment.	NO		NULL
url	varchar(255)	Webhook endpoint URL where this event was received.	NO		NULL
message	longtext	Webhook event data in JSON format.	NO		NULL
status	varchar(255)	Status of this event (handled, error, retry, duplicate)	NO		NULL
error	longtext	Technical error details, if any.	NO		NULL
retries	int(11)	Number of retries attempted, if any.	NO		NULL

webhooks_webhooknotificationreceivedlog

Like webhooks_webhooknotificationreceived, but also contains historical data and the column actblue_id which can be joined to core_order on import_id.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
type	varchar(255)	Type of webhook event received. Currently only used for actblue_payment.	NO		NULL
url	varchar(255)	Webhook endpoint URL where this event was received.	NO		NULL
message	longtext	Webhook event data in JSON format.	NO		NULL
status	varchar(255)	Status of this event (handled, error, retry, duplicate)	NO		NULL
error	longtext	Technical error details, if any.	NO		NULL
actblue_id	varchar(64)	ActBlue orderNumber present in the message JSON body. Joins on core_order.import_id	NO		NULL

core_actbluetransactiondetail

Connects core_transaction and core_order_detail, so we can aggregate multiple ActBlue notifications into a single Transaction without duplicates. This allows us to identify information including amounts donated by candidate on the transaction level.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
transaction_id	int(11)	Joins to core_transaction.	NO	MUL	NULL
detail_id	int(11)	Joins to core_order_detail.	NO	MUL	NULL
candidate_id	int(11)	Joins to core_candidate.	NO	MUL	NULL
amount	decimal(10,2)	Amount donated.	NO		NULL
amount_converted	decimal(10,2)	Amount donated, approximately converted into USD.	NO		0.00
currency	varchar(3)	The original currency for the transaction.	NO		USD
sequence	int(11)	For transactions that are part of a recurring series, indicates how many payments have been previously made as part of that series.	NO	MUL	NULL
lineitem_id	varchar(255)	Indicates which lineitem this payment is associated with.	NO		NULL
type	varchar(255)	Type of transaction (sale, credit, cancel)	NO		NULL

Staff User Tables

auth_user

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier for each staff user.	NO	PRI	NULL	auto_increment
password	varchar(128)	Staff user password	NO		NULL
last_login	datetime(6)	Date and time staff user last logged into admin UI.	YES		NULL
is_superuser	tinyint(1)	1=superuser	NO		NULL
username	varchar(30)	Username for log in.	NO	UNI	NULL
first_name	varchar(30)	Staff user’s first name.	NO		NULL
last_name	varchar(30)	Staff user’s last name.	NO		NULL
email	varchar(254)	Staff user’s email.	NO		NULL
is_staff	tinyint(1)	1=staff	NO		NULL
is_active	tinyint(1)	1=active/able to log into admin UI.	NO		NULL
date_joined	datetime(6)	When the staff user account was created.	NO		NULL

Config/Admin Tables

• core_admineditors

• core_clientsetting

• core_donationconfiguration

• core_mailingsconfig

• core_notice

• core_noticeclosed

• core_supportcontact

core_admineditors

Default settings for text editors in your instance.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
visual_default	varchar(16)	Mode the editor will start in for fields that support the WYSIWYG: ‘on’ for visual, ‘off’ for plain and ‘code’ for code.	NO		NULL
template_default	varchar(16)	Mode the editor will start in for fields that don’t support the WYSIWYG: ‘off’ for plain and ‘code’ for code.	NO		NULL
turn_off_visual	tinyint(1)	1 turns off the visual editor everywhere.	NO		NULL
turn_off_visual_wrapper_only	tinyint(1)	1 turns off the visual editor only for wrapper templates. Defaults to 1 (enabled).	NO		1

core_clientsetting

CONFIG settings.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime(6)		NO	MUL	NULL
updated_at	datetime(6)		NO		NULL
entity	varchar(255)	Category of client settings (e.g. ‘Mailer Targeting Defaults’.)	NO	MUL	NULL
attribute	varchar(255)	Specific setting (e.g. ‘Mailing List’).	NO		NULL
value	longtext	Value for the setting. Blank if not set.	NO		NULL

core_donationconfiguration

Donation processing settings for your instance. Set on CONFIG screen.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
duplicate_window	int(11)	Duration in minutes in which to search for duplicate donations. Set on CONFIG screen.	YES		NULL
send_ip_address	tinyint(1)	Braintree only. 1=send IP address to ‘customer_ip’ custom field you have created in Braintree for this information.	NO

core_notice

Announcements created by Staff Users and displayed for all staff in the admin UI.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	unique identifier	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
title	longtext	Announcement title, displayed in bold.	NO		NULL
message	longtext	Additional content, displayed after title.	NO		NULL
type	varchar(10)	Type of announcement (danger, info, release, warning).	NO		NULL
url	longtext	URL if you include one in the announcement.	NO		NULL
tag	varchar(255)	Description needed	NO		NULL
expiration	datetime	Not in use.	YES		NULL
user_id	int(11)	Not in use.	YES	MUL	NULL
creator_id	int(11)	The user_id of the staff member who added or edited the announcement. Announcements from WAWD have no creator.	NO	PRI	NULL	auto_increment

core_noticeclosed

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO	MUL	NULL
updated_at	datetime		NO		NULL
notice_id	int(11)	Joins to core_notice.	NO	MUL	NULL
user_id	int(11)	The ID of the staff user who closed the announcement.	YES	MUL	NULL

core_mailingsconfig

Settings for your instance for auto-excludes. Set on CONFIG screen.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
use_auto_excludes	tinyint(1)	1=enable auto-excludes for your instance.	NO		NULL
send_date_default	varchar(255)	Default auto-exclude date (none, today or tomorrow).	NO		NULL

push_endpoint

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
hidden	tinyint(1)		NO		NULL
url	varchar(200)	URL to which messages will be posted	NO		NULL
name	varchar(255)	Optional descriptive name	NO		NULL
triggers	json	JSON representation of triggers for this endpoint	NO		[]
ratelimit	int	Rate limit (per second) of deliveries to this endpoint	NO		100
retries	int	Number of retries attempted if delivery fails	NO		3
handler_id	varchar(255)	Vendor provided identifier	NO

core_supportcontact

Field	Type	Description	Null	Key	Default	Extra
id	int(11)	Unique identifier.	NO	PRI	NULL	auto_increment
created_at	datetime		NO		NULL
updated_at	datetime		NO		NULL
hidden	tinyint(1)		NO		NULL
contact_id	int(11)		NO	MUL	NULL

Summary Tables

• summary_user

• summary_mailing

• summary_mailingsubject

• summary_mailingvariation

• summary_mailingmailboxprovider

summary_user

A collection of summary statistics for users, useful for finding active or inactive users. These statistics are updated hourly, but changes to older data, e.g. changing the “Include In Reports of Member Actions” setting on a page or modifying timestamps of existing orders via API, won’t be picked up immediately.

Note: Summary_user used to only recognize timestamps within the past year. In 2023, we changed the functionality to remove this limitation; summary_user now reads the most recent timestamp since 2019.

Field	Type	Description	Null	Key	Default	Extra
user_id	int(11)	Joins to core_user. This table has a one-to-one relationship with core_user.	NO	PRI	NULL
created_at	datetime	When this summary record (not the user) was created.	NO	MUL	NULL
updated_at	datetime	When this summary record (not the user) was last changed.	NO	MUL	NULL
last_action	datetime	Datetime of the last complete action taken by this user on a page with “Include In Reports of Member Actions” . Note that this is not limited to actions from mailings, so may not be proof of a good email address.	YES	MUL	NULL
last_mailing_action	datetime	Datetime of the last complete action taken by this user from a mailing. This is suitable for use in re-engagement queries.	YES	MUL	NULL
last_mailed	datetime	Datetime of the last time this user was sent a mailing. This is suitable for use in re-engagement queries.	YES	MUL	NULL
last_open	datetime	Datetime of the last open by this user.	YES	MUL	NULL
last_raw_open	datetime	Datetime of the last raw open by this user.	YES	MUL	NULL
last_click	datetime	Datetime of the last click (from a mailing) by this user.	YES	MUL	NULL
last_subscribed	datetime	Datetime of the last subscribe/resubscribe for this user to the default list.	YES	MUL	NULL
last_donation	datetime	Datetime of the last complete single or recurring donation with an amount > 0 by this user.	YES	MUL	NULL
actions_last_30_days	smallint	Count of complete actions taken by this user on a page with “Include In Reports of Member Actions” set in the last 30 days.	YES	MUL	NULL
actions_last_60_days	smallint	Count of complete actions taken by this user on a page with “Include In Reports of Member Actions” set in the last 60 days.	YES	MUL	NULL
actions_last_90_days	smallint	Count of complete actions taken by this user on a page with “Include In Reports of Member Actions” set in the last 90 days.	YES	MUL	NULL
actions_last_180_days	smallint	Count of complete actions taken by this user on a page with “Include In Reports of Member Actions” set in the last 180 days.	YES	MUL	NULL
actions_last_270_days	smallint	Count of complete actions taken by this user on a page with “Include In Reports of Member Actions” set in the last 270 days.	YES	MUL	NULL
actions_last_365_days	smallint	Count of complete actions taken by this user on a page with “Include In Reports of Member Actions” set in the last 365 days.	YES	MUL	NULL
mailbox_provider	varchar(16)	Which mailbox provider this user’s email domain is associated with (Examples include gmail, ms, vmg, or other for smaller/less common domains.)	YES	MUL	NULL

summary_mailing

A collection of summary statistics for mailings, useful for reviewing mailing performance.

Field	Type	Description	Null	Key	Default	Extra
mailing_id	int(11)	Joins to core_mailing. This table has a one-to-one relationship with core_mailing.	NO	PRI	NULL
created_at	datetime	When this summary record (not the mailing) was created.	NO	MUL	NULL
updated_at	datetime	When this summary record (not the mailing) was last changed.	NO	MUL	NULL
finished_at	datetime	Date/time this mailing finished its send.	YES	MUL	NULL
recipients	int(11)	Number of users who received this mailing.	YES	MUL	NULL
total_opens	int(11)	Number of times this mailing was opened	YES	MUL	NULL
total_raw_opens	int(11)	Number of times this mailing was opened (using core_open_raw). Note that although core_open_raw regularly deletes old data, original counts will be preserved here.	YES	MUL	NULL
opens	int(11)	Number of users who opened this mailing	YES	MUL	NULL
raw_opens	int(11)	Number of users who opened this mailing (using core_open_raw). Note that although core_open_raw regularly deletes old data, original counts will be preserved here.	YES	MUL	NULL
total_clicks	int(11)	Number of times a link in this mailing was clicked	YES	MUL	NULL
total_raw_clicks	int(11)	Number of times a link in this mailing was clicked (using core_click_raw). Note that although core_click_raw regularly deletes old data, original counts will be preserved here.	YES	MUL	NULL
clicks	int(11)	Number of users who clicked a link in this mailing	YES	MUL	NULL
raw_clicks	int(11)	Number of users who clicked a link in this mailing (using core_click_raw). Note that although core_click_raw regularly deletes old data, original counts will be preserved here.	YES	MUL	NULL
actions	int(11)	Number of times an action was taken from this mailing	YES	MUL	NULL
orders	int(11)	Number of donations associated with this mailing	YES	MUL	NULL
amount	decimal(10,2)	Total amount of donations associated with this mailing	YES	MUL	NULL
amount_converted	decimal(10,2)	Total amount of donations associated with this mailing, converted to USD	YES	MUL	NULL
unsubscribes	int(11)	Number of users who unsubscribed from this mailing	YES	MUL	NULL
total_unsubscribes	int(11)	Number of users who unsubscribed, bounced, or clicked spam from this mailing	YES	MUL	NULL
bounces	int(11)	Number of users who bounced from this mailing. Only includes HARD bounces.	YES	MUL	NULL
complaints	int(11)	Number of users who clicked spam from this mailing	YES	MUL	NULL
bounces_all	int(11)	Number of bounces reported by Sparkpost for this mailing. Includes both HARD and SOFT bounces.	NO	MUL	0
delays	int(11)	Number of delays reported by Sparkpost for this mailing.	NO	MUL	0
deliveries	int(11)	Number of completed deliveries reported by Sparkpost for this mailing.	NO	MUL	NULL

summary_mailingsubject

A collection of summary statistics for mailings, grouped by subject. Subject ID will be 0 in cases where the subject is unknown (forwarded mailings, for example).

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL
mailing_id	int(11)	Joins to core_mailing. This table has a one-to-one relationship with core_mailing.	NO		NULL
subject_id	int(11)	Joins to core_mailingsubject, except when 0 for unknown subjects.	NO		NULL
created_at	datetime	When this summary record (not the mailing/subject) was created.	NO	MUL	NULL
updated_at	datetime	When this summary record (not the mailing/subject) was last changed.	NO	MUL	NULL
finished_at	datetime	Date/time this mailing finished its send.	YES	MUL	NULL
recipients	int(11)	Number of users who received this mailing	YES	MUL	NULL
total_opens	int(11)	Number of times this mailing was opened	YES	MUL	NULL
total_raw_opens	int(11)	Number of times this mailing was opened (using core_open_raw). Note that although core_open_raw regularly deletes old data, original counts will be preserved here.	YES	MUL	NULL
opens	int(11)	Number of users who opened this mailing	YES	MUL	NULL
raw_opens	int(11)	Number of users who opened this mailing (using core_open_raw). Note that although core_open_raw regularly deletes old data, original counts will be preserved here.	YES	MUL	NULL
total_clicks	int(11)	Number of times a link in this mailing was clicked	YES	MUL	NULL
total_raw_clicks	int(11)	Number of times a link in this mailing was clicked (using core_click_raw). Note that although core_click_raw regularly deletes old data, original counts will be preserved here.	YES	MUL	NULL
clicks	int(11)	Number of users who clicked a link in this mailing	YES	MUL	NULL
raw_clicks	int(11)	Number of users who clicked a link in this mailing (using core_click_raw). Note that although core_click_raw regularly deletes old data, original counts will be preserved here.	YES	MUL	NULL
actions	int(11)	Number of times an action was taken from this mailing	YES	MUL	NULL
orders	int(11)	Number of donations associated with this mailing	YES	MUL	NULL
amount	decimal(10,2)	Total amount of donations associated with this mailing	YES	MUL	NULL
amount_converted	decimal(10,2)	Total amount of donations associated with this mailing, converted to USD	YES	MUL	NULL
unsubscribes	int(11)	Number of users who unsubscribed from this mailing	YES	MUL	NULL
total_unsubscribes	int(11)	Number of users who unsubscribed, bounced, or clicked spam from this mailing	YES	MUL	NULL
bounces	int(11)	Number of users who bounced from this mailing	YES	MUL	NULL
complaints	int(11)	Number of users who clicked spam from this mailing	YES	MUL	NULL
bounces_all	int(11)	Number of hard AND soft bounces	NO	MUL	NULL
delays	int(11)	Number of messages delayed at least once	NO	MUL	NULL
deliveries	int(11)	Not currently used	NO	MUL	NULL

summary_mailingvariation

A collection of summary statistics for mailings, grouped by variation when using inline A/B testing.

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL
mailing_id	int(11)	Joins to core_mailing. This table has a one-to-one relationship with core_mailing.	NO		NULL
variation_id	int(11)	Joins to core_mailingvariation, except for 0 for unknown variations.	NO		NULL
created_at	datetime	When this summary record (not the mailing/variation) was created.	NO	MUL	NULL
updated_at	datetime	When this summary record (not the mailing/variation) was last changed.	NO	MUL	NULL
finished_at	datetime	Date/time this mailing finished its send.	YES	MUL	NULL
letter	varchar(2)	Letter used to identify the variation	YES	MUL	NULL
recipients	int(11)	Number of users who received this mailing	YES	MUL	NULL
total_opens	int(11)	Number of times this mailing was opened	YES	MUL	NULL
total_raw_opens	int(11)	Number of times this mailing was opened (using core_open_raw). Note that although core_open_raw regularly deletes old data, original counts will be preserved here.	YES	MUL	NULL
opens	int(11)	Number of users who opened this mailing	YES	MUL	NULL
raw_opens	int(11)	Number of users who opened this mailing (using core_open_raw). Note that although core_open_raw regularly deletes old data, original counts will be preserved here.	YES	MUL	NULL
total_clicks	int(11)	Number of times a link in this mailing was clicked	YES	MUL	NULL
total_raw_clicks	int(11)	Number of times a link in this mailing was clicked (using core_click_raw). Note that although core_click_raw regularly deletes old data, original counts will be preserved here.	YES	MUL	NULL
clicks	int(11)	Number of users who clicked a link in this mailing	YES	MUL	NULL
raw_clicks	int(11)	Number of users who clicked a link in this mailing (using core_click_raw). Note that although core_click_raw regularly deletes old data, original counts will be preserved here.	YES	MUL	NULL
actions	int(11)	Number of times an action was taken from this mailing	YES	MUL	NULL
orders	int(11)	Number of donations associated with this mailing	YES	MUL	NULL
amount	decimal(10,2)	Total amount of donations associated with this mailing	YES	MUL	NULL
amount_converted	decimal(10,2)	Total amount of donations associated with this mailing, converted to USD	YES	MUL	NULL
unsubscribes	int(11)	Number of users who unsubscribed from this mailing	YES	MUL	NULL
total_unsubscribes	int(11)	Number of users who unsubscribed, bounced, or clicked spam from this mailing	YES	MUL	NULL
bounces	int(11)	Number of users who bounced from this mailing	YES	MUL	NULL
complaints	int(11)	Number of users who clicked spam from this mailing	YES	MUL	NULL
bounces_all	int(11)	Number of hard AND soft bounces	NO	MUL	NULL
delays	int(11)	Number of messages delayed at least once	NO	MUL	NULL
deliveries	int(11)	Not currently used	NO	MUL	NULL

summary_mailingmailboxprovider

A collection of summary statistics for mailings, grouped by mailbox provider (e.g., gmail.com, yahoo.com, outlook.com).

Field	Type	Description	Null	Key	Default	Extra
id	int(11)		NO	PRI	NULL
mailing_id	int(11)	Joins to core_mailing.	NO		NULL
mailbox_provider	varchar(255)	The mailbox provider (e.g., gmail.com, yahoo.com) for this set of statistics.	NO	MUL	NULL
created_at	datetime	When this summary record was created.	NO	MUL	NULL
updated_at	datetime	When this summary record was last changed.	NO	MUL	NULL
finished_at	datetime	Date/time this mailing finished its send.	YES	MUL	NULL
recipients	int(11)	Number of users who received this mailing	YES	MUL	NULL
total_opens	int(11)	Number of times this mailing was opened	YES	MUL	NULL
total_raw_opens	int(11)	Number of times this mailing was opened (using core_open_raw). Note that although core_open_raw regularly deletes old data, original counts will be preserved here.	YES	MUL	NULL
opens	int(11)	Number of users who opened this mailing	YES	MUL	NULL
raw_opens	int(11)	Number of users who opened this mailing (using core_open_raw). Note that although core_open_raw regularly deletes old data, original counts will be preserved here.	YES	MUL	NULL
total_clicks	int(11)	Number of times a link in this mailing was clicked	YES	MUL	NULL
total_raw_clicks	int(11)	Number of times a link in this mailing was clicked (using core_click_raw). Note that although core_click_raw regularly deletes old data, original counts will be preserved here.	YES	MUL	NULL
clicks	int(11)	Number of users who clicked a link in this mailing	YES	MUL	NULL
raw_clicks	int(11)	Number of users who clicked a link in this mailing (using core_click_raw). Note that although core_click_raw regularly deletes old data, original counts will be preserved here.	YES	MUL	NULL
actions	int(11)	Number of times an action was taken from this mailing	YES	MUL	NULL
orders	int(11)	Number of donations associated with this mailing	YES	MUL	NULL
amount	decimal(10,2)	Total amount of donations associated with this mailing	YES	MUL	NULL
amount_converted	decimal(10,2)	Total amount of donations associated with this mailing, converted to USD	YES	MUL	NULL
unsubscribes	int(11)	Number of users who unsubscribed from this mailing	YES	MUL	NULL
total_unsubscribes	int(11)	Number of users who unsubscribed, bounced, or clicked spam from this mailing	YES	MUL	NULL
bounces	int(11)	Number of users who bounced from this mailing	YES	MUL	NULL
complaints	int(11)	Number of users who clicked spam from this mailing	YES	MUL	NULL
bounces_all	int(11)	Number of hard AND soft bounces	NO	MUL	NULL
delays	int(11)	Number of messages delayed at least once	NO	MUL	NULL
deliveries	int(11)	Not currently used	NO	MUL	NULL
new_users	int(11)	Number of new users acquired through this mailing	YES	MUL	NULL

Internal use only Tables

The following is the list of internal tables. These tables are not for use by client.

• auth_* tables

• axes_accessattempt

• cache

• celery_*

• core_adminprefs

• core_adminlocation

• core_adminnoticelog

• core_bounce_state

• core_donationattemptlog

• core_facebookapp

• core_faxaccount

• core_googleanalytics

• core_hostingplatform

• core_jobcron

• core_joberror

• core_jobsignal

• core_job_state

• core_jobstatuslog

• core_pagefollowup_pushes

• core_previous_page_tags

• core_redirectpage

• core_s3connection

• core_salesforcesyncrule

• core_savedquerylog

• core_savedquerybuildstep

• core_session

• core_subscriptionhistory_synced_to_sendgrid

• core_targetcontact

• core_tellafriendaction

• core_todaytimezone

• core_timezonepreference

• core_transactionalmailing_tags

• core_unsub_email

• core_unsub_email_state

• core_usergeofield

• core_usermailing_archive_model

• core_usermailing_archive_state

• core_useroriginal

• core_geocodequeue

• django_* tables

• lab_metric

• lab_pagetype

• lab_test_custom_fields

• lab_test_page_types

• mergefile_1

• renamed_core_transactions_core_payment

• reports_cachedqueryresult

• spam_checkeractionstate

• tastypie_* tables