Campaigns

The campaigns table contains information about campaigns added to Blocks. Campaigns are used for Organizing - this table will tell you basic information about campaigns which can be linked to people, events and meetings.

Field	Type	Description	Notes
id	primary key (int)	unique turf id	joins: turf_id in users table, canvassers table, locations table, and quality_control_phone_verification_scripts table
name	text	name of the turf	unique to table
start_date	timestamp	date&time set for the campaign to start	unique to table
end_date	timestamp	date&time set for the campaign to end	unique to table
campaign_type	text	type of campaign as selected in Blocks	unique to table
created_at	timestamp	date&time campaign was created in Blocks	unique to table
updated_at	timestamp	date&time campaign was last updated in Blocks	unique to table
creator_id	foreign key (int)	unique id of user that created the campaign in Blocks	joins: id in user table

No result found