Turfs

Turfs

 
The turfs table contains information about turfs added to Blocks. This table will tell you each turf name, turf level and parent-to-child relationships between turfs.
 

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
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
ㅤ
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
ㅤ
default_phone_verification_script_id
foreign key (int)
unique id of phone verification script
ㅤ
qc_turnaround_days
integer
count of qc turnaround deadline
ㅤ
qc_config
jsonb
qc settings on the turf - what qc steps are enabled, delivery settings, reupload grace time
ㅤ
min_phone_verification_percent
integer
percentage of forms to be verified for a shift to finish phone verification
ㅤ
min_phone_verification_rounds
integer
minimum rounds of calls for a shift to finish phone verification
ㅤ
voter_registration_enabled
text
true/false field
ㅤ
voter_registration_config
jsonb
options for data entry
ㅤ
archived
text
true/false field
ㅤ
options
jsonb
location_turfable (locations shared across state, or turfed to organizations), custom_field_configs (any custom fields for cover sheets)
ㅤ
reporting_config
jsonb
reporting options such as target party, target district, etc.
ㅤ
turf_level
text
turf level name
ㅤ