Tables


SchemaSpy Analysis of vztsjLC2yZnC6yvbvtvg.public

Generated on Wed Jun 14 16:54 GMT 2023

XML Representation
Insertion Order Deletion Order
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