TABLES
158
VIEWS
5
COLUMNS
1334
Constraints
125
Anomalies
38
Routines
1526
Database Properties
Database Type: PostgreSQL - 11.19
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| member_external_ids | 0 | 1 | 6 | 10659373 | Table | |
| gdpr_bug_fix | 0 | 0 | 1 | 37774 | Table | |
| groups | 2 | 1 | 18 | 335 | Table | |
| member_actions | 4 | 3 | 7 | 161528544 | Table | |
| settings | 0 | 0 | 5 | 8 | Table | |
| smses | 0 | 2 | 13 | 237618 | Table | |
| member_actions_data | 0 | 2 | 6 | 334898176 | Table | |
| cby_gdpr_fix_member_actions | 0 | 0 | 9 | 542047 | Table | |
| mailings | 11 | 4 | 54 | 41006 | Table | |
| mailjet_list_cleaning_oldest_100k | 0 | 0 | 7 | 99805 | Table | |
| flows | 0 | 2 | 13 | 2 | Table | |
| member_current_consents_backup_dec_18 | 0 | 0 | 6 | 6166451 | Table | |
| csl_ghost_list_2277387 | 0 | 0 | 3 | 79224 | Table | |
| member_stages | 0 | 2 | 12 | 4 | Table | |
| backup_areas_andrew_20210211 | 0 | 0 | 14 | 1221 | Table | |
| custom_fields | 0 | 2 | 6 | 9 | Table | |
| member_notifications | 1 | 2 | 6 | 305 | Table | |
| spam_exclude | 0 | 1 | 1 | 0 | Table | |
| lists | 5 | 2 | 9 | 1353 | Table | |
| action_keys | 2 | 2 | 5 | 159949 | Table | |
| text_blast_links | 0 | 1 | 7 | 2 | Table | |
| temp_andrew_duplicate_members_20181220 | 0 | 0 | 2 | 191832 | Table | |
| csl_ghost_list_2277831 | 0 | 0 | 3 | 111884 | Table | |
| member_top_issues | 0 | 1 | 3 | 0 | Table | |
| mailing_tests | 0 | 1 | 9 | 17544 | Table | |
| dedupe_index_data | 0 | 0 | 12 | 0 | Table | |
| api_users | 0 | 1 | 7 | 15 | Table | |
| roles | 3 | 0 | 44 | 14 | Table | |
| dedupe_blocks | 0 | 2 | 3 | 0 | Table | |
| opens | 0 | 0 | 7 | 2338807296 | Table | |
| unsubscribe_attempt_logs | 0 | 0 | 8 | 226735 | Table | |
| area_zips | 0 | 1 | 5 | 18529000 | Table | |
| zip_demographic_groups | 0 | 0 | 5 | 1674661 | Table | |
| audits | 0 | 1 | 8 | 276958208 | Table | |
| event_rsvps | 0 | 2 | 8 | 17758 | Table | |
| member_unsubscribe_holding_pens | 0 | 1 | 6 | 0 | Table | |
| mailing_test_cases | 0 | 0 | 5 | 63137 | Table | |
| ar_internal_metadata | 5 | 0 | 4 | 1 | Table | |
| demographic_groups | 0 | 0 | 6 | 12 | Table | |
| actions_mailings | 0 | 2 | 5 | 16060 | Table | |
| clicks | 0 | 1 | 8 | 564822464 | Table | |
| consent_texts | 3 | 0 | 6 | 40 | Table | |
| text_blasts | 2 | 1 | 15 | 166 | Table | |
| phone_numbers | 0 | 2 | 8 | 545568 | Table | |
| custom_field_keys | 1 | 0 | 7 | 3 | Table | |
| stages | 1 | 1 | 11 | 2 | Table | |
| three_month_actives | 0 | 0 | 1 | 0 | Table | |
| actions | 3 | 1 | 15 | 166291 | Table | |
| dataset_rows_backup | 0 | 1 | 5 | 46510664 | Table | |
| mailing_variations | 0 | 1 | 12 | 78119 | Table | |
| zips | 0 | 0 | 11 | 0 | Table | |
| schema_migrations | 0 | 0 | 1 | 325 | Table | |
| member_open_click_rate | 0 | 1 | 3 | 0 | Table | |
| notifications | 1 | 1 | 12 | 14 | Table | |
| events_members | 0 | 0 | 3 | 0 | Table | |
| one_month_actives | 0 | 0 | 1 | 0 | Table | |
| demographic_attribute_values | 0 | 0 | 9 | 0 | Table | |
| mailing_components | 0 | 1 | 9 | 7830 | Table | |
| failed_donations | 0 | 2 | 10 | 1568 | Table | |
| journeys | 3 | 0 | 5 | 2 | Table | |
| organisation_memberships | 0 | 2 | 6 | 1094 | Table | |
| mailing_logs | 0 | 1 | 11 | 3699014 | Table | |
| mailing_templates | 1 | 0 | 9 | 33 | Table | |
| member_resources | 0 | 2 | 6 | 0 | Table | |
| canonical_questions | 0 | 0 | 8 | 21 | Table | |
| mailing_activity_records | 0 | 1 | 13 | 0 | Table | |
| member_skills | 0 | 2 | 7 | 938 | Table | |
| conditional_journeys | 0 | 0 | 8 | 2 | Table | |
| mosaic | 0 | 0 | 6 | 1757611 | Table | |
| role_permissions | 0 | 2 | 3 | 36 | Table | |
| contact_campaigns | 3 | 0 | 7 | 0 | Table | |
| organisations | 2 | 1 | 15 | 6 | Table | |
| mosaic_attributes | 0 | 0 | 7 | 44 | Table | |
| issue_categories | 1 | 0 | 4 | 32 | Table | |
| member_subscription_logs | 0 | 0 | 9 | 1722055 | Table | |
| member_merge_logs | 0 | 0 | 7 | 242865 | Table | |
| temp_incorrectly_ghosted_csl_ids_20191220 | 0 | 0 | 1 | 585029 | Table | |
| list_members | 0 | 1 | 6 | 1314124540 | Table | |
| variables | 0 | 0 | 5 | 21 | Table | |
| conditional_list_members | 0 | 1 | 5 | 6965532 | Table | |
| donations | 0 | 3 | 12 | 3096608 | Table | |
| areas_canonical_addresses | 0 | 2 | 5 | 0 | Table | |
| contacts | 1 | 3 | 14 | 0 | Table | |
| volunteering_tasks | 1 | 0 | 7 | 0 | Table | |
| locations | 0 | 0 | 10 | 17973 | Table | |
| permissions | 1 | 0 | 4 | 31 | Table | |
| events | 1 | 3 | 25 | 3673 | Table | |
| member_direct_debit_probabilities | 0 | 0 | 6 | 390127 | Table | |
| action_keys_canonical_questions | 0 | 0 | 5 | 93 | Table | |
| issue_categories_issues | 0 | 2 | 5 | 245 | Table | |
| delayed_jobs | 0 | 0 | 12 | 57711 | Table | |
| csl_ghost_list_2277226 | 0 | 0 | 3 | 167414 | Table | |
| canonical_addresses | 2 | 0 | 14 | 0 | Table | |
| member_mailings | 0 | 1 | 10 | 3387041020 | Table | |
| note_types | 1 | 0 | 4 | 4 | Table | |
| csl_ghost_list_2277187 | 0 | 0 | 3 | 153679 | Table | |
| active_record_audits | 0 | 0 | 15 | 373088064 | Table | |
| controlshift_consent_mappings | 0 | 2 | 10 | 52 | Table | |
| follow_ups | 0 | 2 | 8 | 11 | Table | |
| members | 42 | 1 | 27 | 18553774 | Table | |
| syncs | 0 | 3 | 16 | 2194 | Table | |
| csl_ghost_list_2277083 | 0 | 0 | 3 | 2 | Table | |
| skills | 1 | 0 | 5 | 13 | Table | |
| datasets | 1 | 0 | 9 | 78 | Table | |
| member_subscriptions | 0 | 3 | 11 | 34385384 | Table | |
| member_action_consents | 1 | 3 | 9 | 107129856 | Table | |
| mailing_variation_test_cases | 0 | 0 | 3 | 62275 | Table | |
| member_demographic_groups | 0 | 0 | 6 | 2090540 | Table | |
| addresses | 0 | 2 | 11 | 41904736 | Table | |
| area_memberships | 0 | 2 | 5 | 56908248 | Table | |
| spam_exclude_rules | 0 | 0 | 5 | 17 | Table | |
| call_sessions | 0 | 0 | 11 | 0 | Table | |
| csl_ghost_list_2277355 | 0 | 0 | 3 | 343586 | Table | |
| mailjet_list_cleaning_newest_100k | 0 | 0 | 7 | 99313 | Table | |
| first_names | 0 | 0 | 6 | 3438 | Table | |
| member_volunteer_tasks | 0 | 2 | 5 | 0 | Table | |
| spatial_ref_sys | 3 | 0 | 5 | 5692 | Table | |
| phone_circles | 1 | 0 | 5 | 0 | Table | |
| regular_donations | 2 | 2 | 17 | 88379 | Table | |
| groups_members | 0 | 2 | 8 | 10811 | Table | |
| members_on_ice | 0 | 1 | 1 | 0 | Table | |
| searches | 2 | 1 | 17 | 36152 | Table | |
| campaigns | 3 | 2 | 19 | 100746 | Table | |
| ctrlshift_webhooks | 0 | 0 | 8 | 10057322 | Table | |
| conditional_lists | 1 | 0 | 5 | 65 | Table | |
| notification_links | 0 | 1 | 6 | 268 | Table | |
| member_subscription_events | 0 | 0 | 11 | 40078192 | Table | |
| temporary_500k_ghosty_table | 0 | 0 | 1 | 585215 | Table | |
| sources | 1 | 1 | 8 | 574004 | Table | |
| notes | 0 | 2 | 7 | 70752920 | Table | |
| post_consent_methods | 0 | 2 | 8 | 35 | Table | |
| csl_ghost_list_2277604 | 0 | 0 | 3 | 323132 | Table | |
| postcodes | 0 | 0 | 6 | 0 | Table | |
| anonymization_log | 0 | 0 | 6 | 10183398 | Table | |
| contact_responses | 0 | 2 | 6 | 0 | Table | |
| controlshift_consents | 1 | 0 | 4 | 59 | Table | |
| member_journeys | 0 | 2 | 10 | 3 | Table | |
| api_logs | 0 | 0 | 8 | 1881104 | Table | |
| mosaic_attribute_values | 0 | 0 | 6 | 2774 | Table | |
| areas | 5 | 0 | 14 | 1872 | Table | |
| resources | 1 | 0 | 5 | 0 | Table | |
| dataset_rows | 0 | 2 | 5 | 3727931 | Table | |
| subscriptions | 2 | 0 | 8 | 7 | Table | |
| issue_links | 0 | 1 | 3 | 23 | Table | |
| members_on_ice_exclusions | 0 | 1 | 2 | 2 | Table | |
| mailing_links | 1 | 1 | 10 | 171695 | Table | |
| temp_areas_backup_20190107_pre_mp_database | 0 | 0 | 13 | 1221 | Table | |
| issues | 3 | 0 | 5 | 202 | Table | |
| questions | 0 | 1 | 5 | 8092 | Table | |
| short_links | 0 | 0 | 7 | 1737 | Table | |
| backup_geography_zips_andrew_20210211 | 0 | 0 | 19 | 2629419 | Table | |
| group_campaigns | 0 | 2 | 7 | 895 | Table | |
| fd_contacts | 0 | 0 | 2 | 694604 | Table | |
| contact_response_keys | 1 | 2 | 5 | 0 | Table | |
| notification_endpoints | 0 | 1 | 7 | 18 | Table | |
| journey_coordinators | 0 | 2 | 5 | 0 | Table | |
| backup_area_zips_andrew_20210211 | 0 | 0 | 5 | 13160073 | Table | |
| demographic_attributes | 0 | 0 | 6 | 0 | Table | |
| geography_columns | 0 | 1 | 7 | 0 | View | |
| pg_stat_statements | 0 | 0 | 19 | 0 | View | |
| geometry_columns | 0 | 1 | 7 | 0 | View | |
| raster_columns | 0 | 1 | 17 | 0 | View | |
| raster_overviews | 0 | 0 | 9 | 0 | View |