Organizations

Field	Type	Description	Joins
id	primary key (int)	id of membership record	unique to table
name	text	name of organization	unique to table
phone_number	integer	phone number of organization	unique to table
contact_name	text	name of primary contact for organization	unique to table
created_at	timestamp	date&time membership record was created	unique to table
updated_at	timestamp	date&time membership record was last updated	unique to table
address_id	foreign key (int)	id of address associated with the organization	id in addresses table
leader_id	foreign key (int)	id of person listed as leader of the organization	id in people table
organization_type	text	type of organization	unique to table
soft_member_count	integer	count of members	unique to table
influence_level	integer	level of influence set for the organization	unique to table
created_by_user_id	foreign key (int)	id of user who created the organization	id in users table
notes	text	content of note	unique to table
mailing_street_address	text	mailing street address of organization	unique to table
mailing_city	text	city of organization	unique to table
mailing_state	text	state of organization	unique to table
mailing_zipcode	integer	zipcode of organization	unique to table
issues	jsonb	list of issues associated with the organization	unique to table
active	text	t/f if the organization is active	unique to table
turf_id	foreign key (int)	id of turf associated with the organization	id in turfs table
membership_type	text	type of membership listed for the organization	unique to table
denominations	jsonb	denomination of the organization	unique to table

No result found