People

Field	Type	Description	Joins
id	primary key (int)	unique id of person record	ㅤ
registered_state	text	state the person was registered in	unique to table
last_name	text	last name of person	unique to table
first_name	text	first name of person	unique to table
suffix_name	text	name suffix of person	unique to table
middle_name	text	middle name of person	unique to table
birth_date	integer	date of birth of person	unique to table
gender	text	gender of person	unique to table
created_at	timestamp	date&time person record was created	unique to table
updated_at	timestamp	date&time person record was last updated	unique to table
best_contact_method	text	best contact method selected for person - phone/email/sms	unique to table
receives_sms	text	t/f if the person has opted in to SMS	unique to table
prefix	text	name prefix of person	unique to table
primary_language	text	primary language of person	unique to table
assigned_to_user_id	foreign key (int)	id of user assigned to this person record as their organizer	id in users table
position	text	position of person	unique to table
interest_level	integer	numerical representation selected as interest level of person	unique to table
primary_email_address	text	primary email of persson	unique to table
primary_phone_number	integer	primary phone of person	unique to table
issues	jsonb	issues associated with person	unique to table
skills	jsonb	skills associated with person	unique to table
languages	jsonb	languages associated with person	unique to table
creator_id	foreign key (int)	id of user who created the person record	id in users table
external_id	foreign key (int)	external ID added via import to person record	unique to table
call_stoppage	text	t/f if there is an active call stoppage from a phone bank response	unique to table
pronouns	text	pronouns of person	unique to table
denominations	jsonb	denomination of person	unique to table
ethnicities	jsonb	ethnicity of person	unique to table
social_links	jsonb	social media links of person	unique to table
custom_field_data	jsonb	custom field data collected on person	unique to table
deceased	text	t/f if the person is deceased	unique to table

No result found