members

18553774 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('members_id_seq'::regclass)
addresses.member_id fk_rails_18a9df9ab1 R
area_memberships.member_id fk_rails_3220cbd6a0 R
audits.member_id fk_rails_fdd86575f6 R
campaigns.author_id fk_rails_2715f9086d R
contacts.contactee_id fk_rails_107de0f05c R
contacts.contactor_id fk_rails_4b3dad1b77 R
custom_fields.member_id fk_rails_0a09f3f1ab R
dedupe_blocks.member_id fk_rails_a60817dd0c R
donations.member_id fk_rails_6298a41285 R
event_rsvps.member_id fk_rails_88992ed519 R
events.host_id fk_rails_d56a268962 R
failed_donations.member_id fk_rails_9cb46fff72 R
flows.author_id fk_rails_02c94a94b2 R
follow_ups.contactee_id fk_rails_e3ac2a52aa R
follow_ups.member_id fk_rails_477dc3d944 R
groups_members.member_id fk_rails_b7405996ff R
journey_coordinators.member_id fk_rails_6d8c2de59b R
lists.author_id fk_rails_05248244fd R
member_actions.member_id fk_rails_baca983cb7 R
member_external_ids.member_id fk_autog808c2ef20 R
member_journeys.member_id fk_autog808c2ef21 R
member_mailings.member_id fk_autogcb69f22b1 R
member_notifications.member_id fk_autog808c2ef23 R
member_open_click_rate.member_id fk_rails_1b2ee2eb18 R
member_resources.member_id fk_autog808c2ef26 R
member_skills.member_id fk_autog808c2ef28 R
member_stages.member_id fk_autog808c2ef29 R
member_subscriptions.member_id fk_autog808c2ef230 R
member_top_issues.member_id fk_rails_5d13462797 R
member_unsubscribe_holding_pens.member_id fk_rails_efa3ad1bf1 R
member_volunteer_tasks.member_id fk_autog808c2ef212 R
members_on_ice.member_id fk_rails_1dd08a34cc R
members_on_ice_exclusions.member_id fk_rails_7a80f723a0 R
notes.user_id fk_rails_7f2323ad43 R
notification_endpoints.member_id fk_autog808c2ef215 R
organisation_memberships.member_id fk_autog808c2ef218 R
phone_numbers.member_id fk_autog808c2ef220 R
regular_donations.member_id fk_autog808c2ef222 R
searches.author_id fk_rails_f9f5eddc13 R
smses.member_id fk_autog808c2ef225 R
spam_exclude.member_id fk_rails_6ad08f77bf R
syncs.author_id fk_rails_06f7ecb52e R
email text 2147483647 √ null
created_at timestamp 29,6 √ null
updated_at timestamp 29,6 √ null
joined_at timestamp 29,6 √ null
crypted_password text 2147483647 √ null
guid text 2147483647 √ null
action_history json 2147483647 √ null
reset_token text 2147483647 √ null
authy_id int4 10 √ null
role_id int4 10 √ null
roles.id fk_rails_ba7343b1aa R
last_donated timestamp 29,6 √ null
donations_count int4 10 √ null
average_donation float4 8,8 √ null
highest_donation float4 8,8 √ null
mosaic_group text 2147483647 √ null
mosaic_code text 2147483647 √ null
entry_point text 2147483647 √ null
latitude float8 17,17 √ null
longitude float8 17,17 √ null
email_sha256 varchar 255 √ null
first_name text 2147483647 √ null
middle_names text 2147483647 √ null
last_name text 2147483647 √ null
title varchar 2147483647 √ null
gender varchar 2147483647 √ null
donation_preference varchar 20 √ null

Indexes

Constraint Name Type Sort Column(s)
members_pkey Primary key Asc id
guid Performance Asc guid
index_members_on_email_gin Performance Asc email
index_members_on_full_name_gin Performance
index_members_on_role_id Performance Asc role_id
members_btree_on_email Performance Asc email
members_index_on_email Performance Asc email
members_index_on_email_unique_partial Must be unique Asc email
members_index_on_mosaic Performance Asc mosaic_group
members_index_on_mosaic_code Performance Asc mosaic_code
members_on_updated Performance Asc updated_at

Relationships

Close relationships within degrees of separation