Turfs

Field

Type

Description

Turfs

id

primary key (int)

unique turf id

canvassers.turf_id, deliveries.office_id, field_management_goals.turf_id, field_management_projections.turf_id, flag_triggers_turfs.turf_id locations.turf_id, quality_control_phone_verification_scripts.turf_id, scheduled_exports_turfs.turf_id

name

text

name of the turf

unique to table

parent_id

foreign key (int)

unique id of parent role

joins: turf_id in user table and location table

lft/rgt

integer

numerical representation of where the turf is in the overall turf hierarchy

sort by these columns to view turfs in hierarchical order

depth

integer

numeric level of the turf

matches: depth in turf_levels table

created_at

timestamp

date&time turf was created

unique to table

updated_at

timestamp

date&time turf was last updated

unique to table

states

text

abbreviation of state represented in turf

unique to table

phone_verification_language

text

en/es field

unique to table

qc_turnaround_days

integer

count of qc turnaround deadline

unique to table

qc_config

jsonb

qc settings on the turf - what qc steps are enabled, delivery settings, reupload grace time

unique to table

min_phone_verification_percent

integer

percentage of forms to be verified for a shift to finish phone verification

unique to table

min_phone_verification_rounds

integer

minimum rounds of calls for a shift to finish phone verification

unique to table

voter_registration_enabled

text

true/false field

unique to table

petition_requirements

text

list of petition requirements set for the turf

unique to table

voter_registration_config

jsonb

options for data entry

unique to table

archived

text

true/false field

unique to table

options

jsonb

list of options selected for turf - location_turfable, (locations shared across state, or turfed to organizations), custom_field_configs (any custom fields for cover sheets), calling options, performance review reasons, performance review outcomes

unique to table

reporting_config

jsonb

reporting options such as target party, target district, etc.

unique to table

turf_level

text

turf level name

unique to table

programs

jsonb

list of program tags associated with the turf

unique to table