{ "database": "email_management", "generated": "2026-04-14T00:51:15.212Z", "tables": [ { "name": "account_limits", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('account_limits_id_seq'::regclass)", "position": 1 }, { "name": "mailchimp_account_id", "type": "integer", "maxLength": null, "nullable": false, "default": null, "position": 2 }, { "name": "monthly_send_limit", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 3 }, { "name": "current_monthly_sends", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 4 }, { "name": "total_subscribers", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 5 }, { "name": "subscriber_limit", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 6 }, { "name": "api_calls_remaining", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 7 }, { "name": "api_calls_reset_time", "type": "timestamp with time zone", "maxLength": null, "nullable": true, "default": null, "position": 8 }, { "name": "daily_api_limit", "type": "integer", "maxLength": null, "nullable": true, "default": "10000", "position": 9 }, { "name": "plan_type", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 10 }, { "name": "plan_name", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 11 }, { "name": "billing_cycle", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 12 }, { "name": "last_fetched_at", "type": "timestamp with time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 13 }, { "name": "created_at", "type": "timestamp with time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 14 }, { "name": "updated_at", "type": "timestamp with time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 15 } ] }, { "name": "account_settings", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('account_settings_id_seq'::regclass)", "position": 1 }, { "name": "mailchimp_account_id", "type": "integer", "maxLength": null, "nullable": false, "default": null, "position": 2 }, { "name": "api_rate_limit", "type": "integer", "maxLength": null, "nullable": true, "default": "10000", "position": 3 }, { "name": "api_timeout", "type": "integer", "maxLength": null, "nullable": true, "default": "30000", "position": 4 }, { "name": "max_retries", "type": "integer", "maxLength": null, "nullable": true, "default": "3", "position": 5 }, { "name": "retry_delay", "type": "integer", "maxLength": null, "nullable": true, "default": "1000", "position": 6 }, { "name": "auto_sync_enabled", "type": "boolean", "maxLength": null, "nullable": true, "default": "false", "position": 7 }, { "name": "sync_frequency", "type": "integer", "maxLength": null, "nullable": true, "default": "3600", "position": 8 }, { "name": "sync_lists", "type": "ARRAY", "maxLength": null, "nullable": true, "default": null, "position": 9 }, { "name": "sync_segments", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 10 }, { "name": "sync_subscribers", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 11 }, { "name": "sync_tags", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 12 }, { "name": "sync_custom_fields", "type": "boolean", "maxLength": null, "nullable": true, "default": "false", "position": 13 }, { "name": "keep_unsubscribed", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 14 }, { "name": "keep_cleaned", "type": "boolean", "maxLength": null, "nullable": true, "default": "false", "position": 15 }, { "name": "data_retention_days", "type": "integer", "maxLength": null, "nullable": true, "default": "365", "position": 16 }, { "name": "notify_sync_complete", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 17 }, { "name": "notify_sync_errors", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 18 }, { "name": "notify_api_limits", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 19 }, { "name": "notification_email", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 20 }, { "name": "notification_webhook", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 21 }, { "name": "use_double_optin", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 22 }, { "name": "merge_duplicate_contacts", "type": "boolean", "maxLength": null, "nullable": true, "default": "false", "position": 23 }, { "name": "update_existing_contacts", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 24 }, { "name": "preserve_existing_tags", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 25 }, { "name": "created_at", "type": "timestamp with time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 26 }, { "name": "updated_at", "type": "timestamp with time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 27 }, { "name": "created_by", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 28 }, { "name": "updated_by", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 29 } ] }, { "name": "active_subscribers_by_account", "columns": [ { "name": "account_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 1 }, { "name": "account_name", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 2 }, { "name": "account_nickname", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 3 }, { "name": "total_subscribers", "type": "bigint", "maxLength": null, "nullable": true, "default": null, "position": 4 }, { "name": "subscribed_count", "type": "bigint", "maxLength": null, "nullable": true, "default": null, "position": 5 }, { "name": "unsubscribed_count", "type": "bigint", "maxLength": null, "nullable": true, "default": null, "position": 6 }, { "name": "cleaned_count", "type": "bigint", "maxLength": null, "nullable": true, "default": null, "position": 7 } ] }, { "name": "api_usage_tracking", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('api_usage_tracking_id_seq'::regclass)", "position": 1 }, { "name": "mailchimp_account_id", "type": "integer", "maxLength": null, "nullable": false, "default": null, "position": 2 }, { "name": "date_hour", "type": "timestamp with time zone", "maxLength": null, "nullable": false, "default": null, "position": 3 }, { "name": "requests_count", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 4 }, { "name": "successful_requests", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 5 }, { "name": "failed_requests", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 6 }, { "name": "rate_limited_requests", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 7 }, { "name": "avg_response_time", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 8 }, { "name": "max_response_time", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 9 }, { "name": "min_response_time", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 10 }, { "name": "error_codes", "type": "jsonb", "maxLength": null, "nullable": true, "default": "'{}'::jsonb", "position": 11 }, { "name": "created_at", "type": "timestamp with time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 12 } ] }, { "name": "batch_progress", "columns": [ { "name": "batch_number", "type": "integer", "maxLength": null, "nullable": false, "default": null, "position": 1 }, { "name": "segment_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 2 }, { "name": "segment_name", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 3 }, { "name": "page_number", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 4 }, { "name": "total_pages", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 5 }, { "name": "member_count", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 6 }, { "name": "records_processed", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 7 }, { "name": "processed_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 8 }, { "name": "workflow_run_id", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 9 }, { "name": "status", "type": "character varying", "maxLength": 50, "nullable": true, "default": "'completed'::character varying", "position": 10 } ] }, { "name": "campaigns", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('campaigns_id_seq'::regclass)", "position": 1 }, { "name": "name", "type": "character varying", "maxLength": 255, "nullable": false, "default": null, "position": 2 }, { "name": "campaign_type", "type": "character varying", "maxLength": 50, "nullable": true, "default": null, "position": 3 }, { "name": "platform", "type": "character varying", "maxLength": 20, "nullable": true, "default": null, "position": 4 }, { "name": "external_campaign_id", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 5 }, { "name": "sent_date", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 6 }, { "name": "subject_line", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 7 }, { "name": "total_sent", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 8 }, { "name": "total_opens", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 9 }, { "name": "total_clicks", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 10 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 11 }, { "name": "mailchimp_account_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 12 }, { "name": "mailchimp_list_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 13 } ] }, { "name": "city_geo_mapping", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('city_geo_mapping_id_seq'::regclass)", "position": 1 }, { "name": "city_name", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 2 }, { "name": "country_code", "type": "character varying", "maxLength": 2, "nullable": true, "default": null, "position": 3 }, { "name": "state_region", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 4 }, { "name": "mailchimp_geo_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 5 }, { "name": "geo_location_name", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 6 }, { "name": "confidence_level", "type": "integer", "maxLength": null, "nullable": true, "default": "85", "position": 7 }, { "name": "is_major_city", "type": "boolean", "maxLength": null, "nullable": true, "default": "false", "position": 8 }, { "name": "subscriber_count", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 9 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 10 }, { "name": "updated_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 11 } ] }, { "name": "coordinate_geo_boundaries", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('coordinate_geo_boundaries_id_seq'::regclass)", "position": 1 }, { "name": "mailchimp_geo_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 2 }, { "name": "geo_location_name", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 3 }, { "name": "country_code", "type": "character varying", "maxLength": 2, "nullable": true, "default": null, "position": 4 }, { "name": "region_name", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 5 }, { "name": "city_name", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 6 }, { "name": "geo_bounds", "type": "USER-DEFINED", "maxLength": null, "nullable": true, "default": null, "position": 7 }, { "name": "confidence_level", "type": "integer", "maxLength": null, "nullable": true, "default": "95", "position": 8 }, { "name": "is_primary_market", "type": "boolean", "maxLength": null, "nullable": true, "default": "false", "position": 9 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 10 } ] }, { "name": "coordinate_geo_mapping", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('coordinate_geo_mapping_id_seq'::regclass)", "position": 1 }, { "name": "geo_bounds_north", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 2 }, { "name": "geo_bounds_south", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 3 }, { "name": "geo_bounds_east", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 4 }, { "name": "geo_bounds_west", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 5 }, { "name": "mailchimp_geo_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 6 }, { "name": "geo_location_name", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 7 }, { "name": "country_code", "type": "character varying", "maxLength": 2, "nullable": true, "default": null, "position": 8 }, { "name": "region_name", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 9 }, { "name": "confidence_level", "type": "integer", "maxLength": null, "nullable": true, "default": "95", "position": 10 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 11 }, { "name": "city_name", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 12 }, { "name": "population", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 13 }, { "name": "metro_area_population", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 14 }, { "name": "importance_rank", "type": "integer", "maxLength": null, "nullable": true, "default": "100", "position": 15 }, { "name": "venue_category", "type": "character varying", "maxLength": 50, "nullable": true, "default": null, "position": 16 }, { "name": "time_zone", "type": "character varying", "maxLength": 50, "nullable": true, "default": null, "position": 17 }, { "name": "country_name", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 18 } ] }, { "name": "country_geo_fallback", "columns": [ { "name": "country_code", "type": "character varying", "maxLength": 2, "nullable": false, "default": null, "position": 1 }, { "name": "mailchimp_geo_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 2 }, { "name": "geo_location_name", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 3 }, { "name": "confidence_level", "type": "integer", "maxLength": null, "nullable": true, "default": "40", "position": 4 }, { "name": "importance_rank", "type": "integer", "maxLength": null, "nullable": true, "default": "100", "position": 5 } ] }, { "name": "country_geo_mapping", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('country_geo_mapping_id_seq'::regclass)", "position": 1 }, { "name": "country_code", "type": "character varying", "maxLength": 2, "nullable": true, "default": null, "position": 2 }, { "name": "default_mailchimp_geo_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 3 }, { "name": "geo_location_name", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 4 }, { "name": "is_primary_market", "type": "boolean", "maxLength": null, "nullable": true, "default": "false", "position": 5 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 6 } ] }, { "name": "cross_account_subscriber_summary", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 1 }, { "name": "email", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 2 }, { "name": "first_name", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 3 }, { "name": "last_name", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 4 }, { "name": "account_count", "type": "bigint", "maxLength": null, "nullable": true, "default": null, "position": 5 }, { "name": "account_names", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 6 }, { "name": "avg_open_rate", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 7 }, { "name": "avg_click_rate", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 8 }, { "name": "last_open_date", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 9 } ] }, { "name": "flodesk_integrations", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('flodesk_integrations_id_seq'::regclass)", "position": 1 }, { "name": "mailchimp_account_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 2 }, { "name": "integration_name", "type": "character varying", "maxLength": 255, "nullable": false, "default": null, "position": 3 }, { "name": "flodesk_api_key", "type": "text", "maxLength": null, "nullable": false, "default": null, "position": 4 }, { "name": "flodesk_workspace_id", "type": "character varying", "maxLength": 50, "nullable": true, "default": null, "position": 5 }, { "name": "default_segment_id", "type": "character varying", "maxLength": 50, "nullable": true, "default": null, "position": 6 }, { "name": "is_active", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 7 }, { "name": "last_sync_date", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 8 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 9 }, { "name": "updated_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 10 } ] }, { "name": "geo_id_migration_map", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('geo_id_migration_map_id_seq1'::regclass)", "position": 1 }, { "name": "old_geo_id", "type": "integer", "maxLength": null, "nullable": false, "default": null, "position": 2 }, { "name": "new_iso_geo_id", "type": "integer", "maxLength": null, "nullable": false, "default": null, "position": 3 }, { "name": "migration_status", "type": "character varying", "maxLength": 20, "nullable": true, "default": "'pending'::character varying", "position": 4 }, { "name": "migration_date", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 5 }, { "name": "notes", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 6 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 7 } ] }, { "name": "geo_id_migration_map_backup_008", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('geo_id_migration_map_id_seq'::regclass)", "position": 1 }, { "name": "mailchimp_geo_id", "type": "integer", "maxLength": null, "nullable": false, "default": null, "position": 2 }, { "name": "iso_geo_id", "type": "integer", "maxLength": null, "nullable": false, "default": null, "position": 3 }, { "name": "mapping_type", "type": "character varying", "maxLength": 20, "nullable": true, "default": "'direct'::character varying", "position": 4 }, { "name": "confidence_level", "type": "integer", "maxLength": null, "nullable": true, "default": "95", "position": 5 }, { "name": "notes", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 6 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 7 } ] }, { "name": "geography_columns", "columns": [ { "name": "f_table_catalog", "type": "name", "maxLength": null, "nullable": true, "default": null, "position": 1 }, { "name": "f_table_schema", "type": "name", "maxLength": null, "nullable": true, "default": null, "position": 2 }, { "name": "f_table_name", "type": "name", "maxLength": null, "nullable": true, "default": null, "position": 3 }, { "name": "f_geography_column", "type": "name", "maxLength": null, "nullable": true, "default": null, "position": 4 }, { "name": "coord_dimension", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 5 }, { "name": "srid", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 6 }, { "name": "type", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 7 } ] }, { "name": "geometry_columns", "columns": [ { "name": "f_table_catalog", "type": "character varying", "maxLength": 256, "nullable": true, "default": null, "position": 1 }, { "name": "f_table_schema", "type": "name", "maxLength": null, "nullable": true, "default": null, "position": 2 }, { "name": "f_table_name", "type": "name", "maxLength": null, "nullable": true, "default": null, "position": 3 }, { "name": "f_geometry_column", "type": "name", "maxLength": null, "nullable": true, "default": null, "position": 4 }, { "name": "coord_dimension", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 5 }, { "name": "srid", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 6 }, { "name": "type", "type": "character varying", "maxLength": 30, "nullable": true, "default": null, "position": 7 } ] }, { "name": "hierarchical_geo_view", "columns": [ { "name": "country_code", "type": "character varying", "maxLength": 2, "nullable": true, "default": null, "position": 1 }, { "name": "country_name", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 2 }, { "name": "region_name", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 3 }, { "name": "city_name", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 4 }, { "name": "geo_location_name", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 5 }, { "name": "mailchimp_geo_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 6 }, { "name": "confidence_level", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 7 }, { "name": "country_location_count", "type": "bigint", "maxLength": null, "nullable": true, "default": null, "position": 8 }, { "name": "region_location_count", "type": "bigint", "maxLength": null, "nullable": true, "default": null, "position": 9 }, { "name": "city_location_count", "type": "bigint", "maxLength": null, "nullable": true, "default": null, "position": 10 } ] }, { "name": "ip_geo_cache", "columns": [ { "name": "ip_address", "type": "inet", "maxLength": null, "nullable": false, "default": null, "position": 1 }, { "name": "mailchimp_geo_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 2 }, { "name": "geo_location_name", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 3 }, { "name": "country_code", "type": "character varying", "maxLength": 2, "nullable": true, "default": null, "position": 4 }, { "name": "city_name", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 5 }, { "name": "lookup_source", "type": "character varying", "maxLength": 20, "nullable": true, "default": null, "position": 6 }, { "name": "confidence_score", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 7 }, { "name": "lookup_count", "type": "integer", "maxLength": null, "nullable": true, "default": "1", "position": 8 }, { "name": "last_used", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 9 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 10 } ] }, { "name": "iso_coordinate_mapping", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('iso_coordinate_mapping_id_seq'::regclass)", "position": 1 }, { "name": "iso_geo_id", "type": "integer", "maxLength": null, "nullable": false, "default": null, "position": 2 }, { "name": "iso_geo_location", "type": "character varying", "maxLength": 255, "nullable": false, "default": null, "position": 3 }, { "name": "iso_country_code", "type": "integer", "maxLength": null, "nullable": false, "default": null, "position": 4 }, { "name": "confidence_level", "type": "integer", "maxLength": null, "nullable": true, "default": "85", "position": 5 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 6 } ] }, { "name": "iso_geo_mapping", "columns": [ { "name": "iso_geo_id", "type": "integer", "maxLength": null, "nullable": false, "default": null, "position": 1 }, { "name": "geo_location_name", "type": "character varying", "maxLength": 255, "nullable": false, "default": null, "position": 2 }, { "name": "country_code", "type": "character varying", "maxLength": 2, "nullable": false, "default": null, "position": 3 }, { "name": "iso_country_code", "type": "integer", "maxLength": null, "nullable": false, "default": null, "position": 4 }, { "name": "city_name", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 5 }, { "name": "region_name", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 6 }, { "name": "is_country_level", "type": "boolean", "maxLength": null, "nullable": true, "default": "false", "position": 7 }, { "name": "confidence_level", "type": "integer", "maxLength": null, "nullable": true, "default": "90", "position": 8 }, { "name": "population", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 9 }, { "name": "timezone", "type": "character varying", "maxLength": 50, "nullable": true, "default": null, "position": 10 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 11 }, { "name": "updated_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 12 } ] }, { "name": "mailchimp_accounts", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('mailchimp_accounts_id_seq'::regclass)", "position": 1 }, { "name": "account_name", "type": "character varying", "maxLength": 255, "nullable": false, "default": null, "position": 2 }, { "name": "account_nickname", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 3 }, { "name": "api_key", "type": "character varying", "maxLength": 255, "nullable": false, "default": null, "position": 4 }, { "name": "api_server", "type": "character varying", "maxLength": 200, "nullable": false, "default": null, "position": 5 }, { "name": "datacenter", "type": "character varying", "maxLength": 10, "nullable": false, "default": null, "position": 6 }, { "name": "mailchimp_account_id", "type": "character varying", "maxLength": 50, "nullable": true, "default": null, "position": 7 }, { "name": "account_email", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 8 }, { "name": "company_name", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 9 }, { "name": "total_subscribers", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 10 }, { "name": "is_active", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 11 }, { "name": "sync_enabled", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 12 }, { "name": "last_sync_date", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 13 }, { "name": "api_calls_today", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 14 }, { "name": "api_limit_per_day", "type": "integer", "maxLength": null, "nullable": true, "default": "10000", "position": 15 }, { "name": "last_api_reset", "type": "date", "maxLength": null, "nullable": true, "default": "CURRENT_DATE", "position": 16 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 17 }, { "name": "updated_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 18 }, { "name": "connection_status", "type": "character varying", "maxLength": 20, "nullable": true, "default": "'pending'::character varying", "position": 19 }, { "name": "last_test_at", "type": "timestamp with time zone", "maxLength": null, "nullable": true, "default": null, "position": 20 }, { "name": "description", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 21 } ] }, { "name": "mailchimp_geo_mapping", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('mailchimp_geo_mapping_id_seq'::regclass)", "position": 1 }, { "name": "mailchimp_geo_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 2 }, { "name": "geo_location_name", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 3 }, { "name": "country_code", "type": "character varying", "maxLength": 2, "nullable": true, "default": null, "position": 4 }, { "name": "region_name", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 5 }, { "name": "city_name", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 6 }, { "name": "confidence_level", "type": "integer", "maxLength": null, "nullable": true, "default": "80", "position": 7 }, { "name": "is_primary_market", "type": "boolean", "maxLength": null, "nullable": true, "default": "false", "position": 8 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 9 } ] }, { "name": "mailchimp_lists", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('mailchimp_lists_id_seq'::regclass)", "position": 1 }, { "name": "mailchimp_account_id", "type": "integer", "maxLength": null, "nullable": false, "default": null, "position": 2 }, { "name": "list_id", "type": "character varying", "maxLength": 50, "nullable": false, "default": null, "position": 3 }, { "name": "list_name", "type": "character varying", "maxLength": 255, "nullable": false, "default": null, "position": 4 }, { "name": "permission_reminder", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 5 }, { "name": "use_archive_bar", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 6 }, { "name": "campaign_defaults", "type": "jsonb", "maxLength": null, "nullable": true, "default": null, "position": 7 }, { "name": "notify_on_subscribe", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 8 }, { "name": "notify_on_unsubscribe", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 9 }, { "name": "member_count", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 10 }, { "name": "unsubscribe_count", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 11 }, { "name": "cleaned_count", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 12 }, { "name": "member_count_since_send", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 13 }, { "name": "unsubscribe_count_since_send", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 14 }, { "name": "cleaned_count_since_send", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 15 }, { "name": "is_primary", "type": "boolean", "maxLength": null, "nullable": true, "default": "false", "position": 16 }, { "name": "sync_enabled", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 17 }, { "name": "last_sync_date", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 18 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 19 }, { "name": "updated_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 20 } ] }, { "name": "manual_ip_ranges", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('manual_ip_ranges_id_seq'::regclass)", "position": 1 }, { "name": "ip_start", "type": "inet", "maxLength": null, "nullable": true, "default": null, "position": 2 }, { "name": "ip_end", "type": "inet", "maxLength": null, "nullable": true, "default": null, "position": 3 }, { "name": "mailchimp_geo_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 4 }, { "name": "geo_location_name", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 5 }, { "name": "notes", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 6 }, { "name": "confidence_level", "type": "integer", "maxLength": null, "nullable": true, "default": "90", "position": 7 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 8 } ] }, { "name": "schema_migrations", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('schema_migrations_id_seq'::regclass)", "position": 1 }, { "name": "migration_name", "type": "character varying", "maxLength": 255, "nullable": false, "default": null, "position": 2 }, { "name": "applied_at", "type": "timestamp with time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 3 } ] }, { "name": "segment_mappings", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('segment_mappings_id_seq'::regclass)", "position": 1 }, { "name": "mailchimp_segment_id", "type": "character varying", "maxLength": 50, "nullable": false, "default": null, "position": 2 }, { "name": "mailchimp_segment_name", "type": "character varying", "maxLength": 255, "nullable": false, "default": null, "position": 3 }, { "name": "flodesk_segment_id", "type": "character varying", "maxLength": 100, "nullable": false, "default": null, "position": 4 }, { "name": "flodesk_segment_name", "type": "character varying", "maxLength": 255, "nullable": false, "default": null, "position": 5 }, { "name": "active", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 6 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "CURRENT_TIMESTAMP", "position": 7 }, { "name": "updated_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "CURRENT_TIMESTAMP", "position": 8 } ] }, { "name": "segment_rule_templates", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('segment_rule_templates_id_seq'::regclass)", "position": 1 }, { "name": "name", "type": "character varying", "maxLength": 255, "nullable": false, "default": null, "position": 2 }, { "name": "description", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 3 }, { "name": "rule_definition", "type": "json", "maxLength": null, "nullable": true, "default": null, "position": 4 }, { "name": "category", "type": "character varying", "maxLength": 50, "nullable": true, "default": null, "position": 5 }, { "name": "is_system_template", "type": "boolean", "maxLength": null, "nullable": true, "default": "false", "position": 6 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 7 } ] }, { "name": "segment_sync_status", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('segment_sync_status_id_seq'::regclass)", "position": 1 }, { "name": "segment_id", "type": "integer", "maxLength": null, "nullable": false, "default": null, "position": 2 }, { "name": "provider", "type": "character varying", "maxLength": 50, "nullable": false, "default": null, "position": 3 }, { "name": "status", "type": "character varying", "maxLength": 50, "nullable": false, "default": null, "position": 4 }, { "name": "sync_type", "type": "character varying", "maxLength": 50, "nullable": true, "default": "'full'::character varying", "position": 5 }, { "name": "synced_count", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 6 }, { "name": "failed_count", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 7 }, { "name": "total_count", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 8 }, { "name": "error_message", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 9 }, { "name": "error_details", "type": "jsonb", "maxLength": null, "nullable": true, "default": null, "position": 10 }, { "name": "execution_id", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 11 }, { "name": "started_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 12 }, { "name": "completed_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 13 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "CURRENT_TIMESTAMP", "position": 14 }, { "name": "updated_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "CURRENT_TIMESTAMP", "position": 15 }, { "name": "duration_seconds", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 16 } ] }, { "name": "segments", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('segments_id_seq'::regclass)", "position": 1 }, { "name": "name", "type": "character varying", "maxLength": 255, "nullable": false, "default": null, "position": 2 }, { "name": "description", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 3 }, { "name": "mailchimp_account_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 4 }, { "name": "scope", "type": "character varying", "maxLength": 20, "nullable": true, "default": "'account'::character varying", "position": 5 }, { "name": "mailchimp_segment_id", "type": "character varying", "maxLength": 50, "nullable": true, "default": null, "position": 6 }, { "name": "flodesk_segment_id", "type": "character varying", "maxLength": 50, "nullable": true, "default": null, "position": 7 }, { "name": "segment_type", "type": "character varying", "maxLength": 20, "nullable": false, "default": null, "position": 8 }, { "name": "platform", "type": "character varying", "maxLength": 20, "nullable": true, "default": "'both'::character varying", "position": 9 }, { "name": "segment_rules", "type": "jsonb", "maxLength": null, "nullable": true, "default": null, "position": 10 }, { "name": "is_active", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 11 }, { "name": "auto_update", "type": "boolean", "maxLength": null, "nullable": true, "default": "false", "position": 12 }, { "name": "last_updated", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 13 }, { "name": "subscriber_count", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 14 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 15 }, { "name": "updated_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 16 }, { "name": "last_sync_date", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 17 }, { "name": "mailchimp_updated_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 18 }, { "name": "sync_status", "type": "character varying", "maxLength": 20, "nullable": true, "default": "'pending'::character varying", "position": 19 }, { "name": "error_details", "type": "jsonb", "maxLength": null, "nullable": true, "default": null, "position": 20 }, { "name": "performance_metrics", "type": "jsonb", "maxLength": null, "nullable": true, "default": null, "position": 21 }, { "name": "open_rate", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 22 }, { "name": "click_rate", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 23 }, { "name": "growth_rate", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 24 }, { "name": "last_campaign_sent", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 25 }, { "name": "migration_status", "type": "character varying", "maxLength": 20, "nullable": true, "default": "'pending'::character varying", "position": 26 }, { "name": "old_segment_rules", "type": "jsonb", "maxLength": null, "nullable": true, "default": null, "position": 27 }, { "name": "iso_ready", "type": "boolean", "maxLength": null, "nullable": true, "default": "false", "position": 28 }, { "name": "segment_source", "type": "character varying", "maxLength": 20, "nullable": true, "default": "'mailchimp'::character varying", "position": 29 }, { "name": "created_in_system", "type": "character varying", "maxLength": 20, "nullable": true, "default": "'mailchimp'::character varying", "position": 30 }, { "name": "local_subscriber_count", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 31 }, { "name": "mailchimp_subscriber_count", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 32 }, { "name": "count_discrepancy", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 33 }, { "name": "last_count_sync_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 34 }, { "name": "count_sync_status", "type": "character varying", "maxLength": 20, "nullable": true, "default": "'pending'::character varying", "position": 35 }, { "name": "count_notes", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 36 }, { "name": "flodesk_segment_name", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 37 }, { "name": "sync_subscribe_status", "type": "jsonb", "maxLength": null, "nullable": true, "default": "'[\"subscribed\"]'::jsonb", "position": 38 }, { "name": "sync_frequency", "type": "character varying", "maxLength": 50, "nullable": true, "default": "'manual'::character varying", "position": 39 }, { "name": "batch_size", "type": "integer", "maxLength": null, "nullable": true, "default": "100", "position": 40 }, { "name": "auto_create_segment", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 41 }, { "name": "sync_custom_fields", "type": "jsonb", "maxLength": null, "nullable": true, "default": "'[]'::jsonb", "position": 42 }, { "name": "sync_tags", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 43 }, { "name": "conflict_resolution", "type": "character varying", "maxLength": 50, "nullable": true, "default": "'update_existing'::character varying", "position": 44 }, { "name": "error_handling", "type": "character varying", "maxLength": 50, "nullable": true, "default": "'continue'::character varying", "position": 45 }, { "name": "notification_email", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 46 } ] }, { "name": "segments_backup_geo_fix_20251003", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 1 }, { "name": "name", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 2 }, { "name": "description", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 3 }, { "name": "mailchimp_account_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 4 }, { "name": "scope", "type": "character varying", "maxLength": 20, "nullable": true, "default": null, "position": 5 }, { "name": "mailchimp_segment_id", "type": "character varying", "maxLength": 50, "nullable": true, "default": null, "position": 6 }, { "name": "flodesk_segment_id", "type": "character varying", "maxLength": 50, "nullable": true, "default": null, "position": 7 }, { "name": "segment_type", "type": "character varying", "maxLength": 20, "nullable": true, "default": null, "position": 8 }, { "name": "platform", "type": "character varying", "maxLength": 20, "nullable": true, "default": null, "position": 9 }, { "name": "segment_rules", "type": "jsonb", "maxLength": null, "nullable": true, "default": null, "position": 10 }, { "name": "is_active", "type": "boolean", "maxLength": null, "nullable": true, "default": null, "position": 11 }, { "name": "auto_update", "type": "boolean", "maxLength": null, "nullable": true, "default": null, "position": 12 }, { "name": "last_updated", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 13 }, { "name": "subscriber_count", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 14 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 15 }, { "name": "updated_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 16 }, { "name": "last_sync_date", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 17 }, { "name": "mailchimp_updated_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 18 }, { "name": "sync_status", "type": "character varying", "maxLength": 20, "nullable": true, "default": null, "position": 19 }, { "name": "error_details", "type": "jsonb", "maxLength": null, "nullable": true, "default": null, "position": 20 }, { "name": "performance_metrics", "type": "jsonb", "maxLength": null, "nullable": true, "default": null, "position": 21 }, { "name": "open_rate", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 22 }, { "name": "click_rate", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 23 }, { "name": "growth_rate", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 24 }, { "name": "last_campaign_sent", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 25 }, { "name": "migration_status", "type": "character varying", "maxLength": 20, "nullable": true, "default": null, "position": 26 }, { "name": "old_segment_rules", "type": "jsonb", "maxLength": null, "nullable": true, "default": null, "position": 27 }, { "name": "iso_ready", "type": "boolean", "maxLength": null, "nullable": true, "default": null, "position": 28 }, { "name": "segment_source", "type": "character varying", "maxLength": 20, "nullable": true, "default": null, "position": 29 }, { "name": "created_in_system", "type": "character varying", "maxLength": 20, "nullable": true, "default": null, "position": 30 } ] }, { "name": "settings_audit_log", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('settings_audit_log_id_seq'::regclass)", "position": 1 }, { "name": "mailchimp_account_id", "type": "integer", "maxLength": null, "nullable": false, "default": null, "position": 2 }, { "name": "table_name", "type": "text", "maxLength": null, "nullable": false, "default": null, "position": 3 }, { "name": "record_id", "type": "integer", "maxLength": null, "nullable": false, "default": null, "position": 4 }, { "name": "action", "type": "text", "maxLength": null, "nullable": false, "default": null, "position": 5 }, { "name": "old_values", "type": "jsonb", "maxLength": null, "nullable": true, "default": null, "position": 6 }, { "name": "new_values", "type": "jsonb", "maxLength": null, "nullable": true, "default": null, "position": 7 }, { "name": "changed_fields", "type": "ARRAY", "maxLength": null, "nullable": true, "default": null, "position": 8 }, { "name": "changed_by", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 9 }, { "name": "change_reason", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 10 }, { "name": "ip_address", "type": "inet", "maxLength": null, "nullable": true, "default": null, "position": 11 }, { "name": "user_agent", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 12 }, { "name": "created_at", "type": "timestamp with time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 13 } ] }, { "name": "spatial_ref_sys", "columns": [ { "name": "srid", "type": "integer", "maxLength": null, "nullable": false, "default": null, "position": 1 }, { "name": "auth_name", "type": "character varying", "maxLength": 256, "nullable": true, "default": null, "position": 2 }, { "name": "auth_srid", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 3 }, { "name": "srtext", "type": "character varying", "maxLength": 2048, "nullable": true, "default": null, "position": 4 }, { "name": "proj4text", "type": "character varying", "maxLength": 2048, "nullable": true, "default": null, "position": 5 } ] }, { "name": "subscriber_mailchimp_accounts", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('subscriber_mailchimp_accounts_id_seq'::regclass)", "position": 1 }, { "name": "subscriber_id", "type": "integer", "maxLength": null, "nullable": false, "default": null, "position": 2 }, { "name": "mailchimp_account_id", "type": "integer", "maxLength": null, "nullable": false, "default": null, "position": 3 }, { "name": "mailchimp_list_id", "type": "integer", "maxLength": null, "nullable": false, "default": null, "position": 4 }, { "name": "mailchimp_member_id", "type": "character varying", "maxLength": 50, "nullable": false, "default": null, "position": 5 }, { "name": "status", "type": "character varying", "maxLength": 20, "nullable": false, "default": null, "position": 6 }, { "name": "member_rating", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 7 }, { "name": "last_changed", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 8 }, { "name": "opt_in_time", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 9 }, { "name": "merge_fields", "type": "jsonb", "maxLength": null, "nullable": true, "default": null, "position": 10 }, { "name": "interests", "type": "jsonb", "maxLength": null, "nullable": true, "default": null, "position": 11 }, { "name": "last_synced_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 12 }, { "name": "sync_errors", "type": "jsonb", "maxLength": null, "nullable": true, "default": null, "position": 13 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 14 }, { "name": "updated_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 15 } ] }, { "name": "subscriber_segments", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('subscriber_segments_id_seq'::regclass)", "position": 1 }, { "name": "email", "type": "character varying", "maxLength": 255, "nullable": false, "default": null, "position": 2 }, { "name": "mailchimp_segment_id", "type": "character varying", "maxLength": 50, "nullable": false, "default": null, "position": 3 }, { "name": "mailchimp_segment_name", "type": "character varying", "maxLength": 255, "nullable": false, "default": null, "position": 4 }, { "name": "subscriber_hash", "type": "character varying", "maxLength": 32, "nullable": false, "default": null, "position": 5 }, { "name": "sync_date", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "CURRENT_TIMESTAMP", "position": 6 }, { "name": "flodesk_segment_id", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 7 }, { "name": "subscriber_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 8 }, { "name": "segment_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 9 }, { "name": "source_mailchimp_account_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 10 }, { "name": "join_method", "type": "character varying", "maxLength": 20, "nullable": true, "default": "'manual'::character varying", "position": 11 }, { "name": "join_date", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 12 }, { "name": "synced_to_mailchimp", "type": "boolean", "maxLength": null, "nullable": true, "default": "false", "position": 13 }, { "name": "synced_to_flodesk", "type": "boolean", "maxLength": null, "nullable": true, "default": "false", "position": 14 }, { "name": "mailchimp_synced_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 15 }, { "name": "flodesk_synced_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 16 }, { "name": "sync_errors", "type": "jsonb", "maxLength": null, "nullable": true, "default": null, "position": 17 }, { "name": "is_active", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 18 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 19 }, { "name": "last_synced_to_flodesk", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 20 } ] }, { "name": "subscribers", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('subscribers_id_seq'::regclass)", "position": 1 }, { "name": "email", "type": "character varying", "maxLength": 255, "nullable": false, "default": null, "position": 2 }, { "name": "first_name", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 3 }, { "name": "last_name", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 4 }, { "name": "primary_mailchimp_account_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 5 }, { "name": "account_statuses", "type": "jsonb", "maxLength": null, "nullable": true, "default": null, "position": 6 }, { "name": "country", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 7 }, { "name": "city", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 8 }, { "name": "postal_code", "type": "character varying", "maxLength": 20, "nullable": true, "default": null, "position": 9 }, { "name": "timezone", "type": "character varying", "maxLength": 50, "nullable": true, "default": null, "position": 10 }, { "name": "language", "type": "character varying", "maxLength": 10, "nullable": true, "default": null, "position": 11 }, { "name": "signup_date", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 12 }, { "name": "last_open_date", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 13 }, { "name": "last_click_date", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 14 }, { "name": "total_opens", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 15 }, { "name": "total_clicks", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 16 }, { "name": "avg_open_rate", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 17 }, { "name": "avg_click_rate", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 18 }, { "name": "custom_fields", "type": "jsonb", "maxLength": null, "nullable": true, "default": null, "position": 19 }, { "name": "flodesk_id", "type": "character varying", "maxLength": 50, "nullable": true, "default": null, "position": 20 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 21 }, { "name": "updated_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 22 }, { "name": "mailchimp_member_id", "type": "character varying", "maxLength": 50, "nullable": true, "default": null, "position": 23 }, { "name": "unique_email_id", "type": "character varying", "maxLength": 50, "nullable": true, "default": null, "position": 24 }, { "name": "subscriber_hash", "type": "character varying", "maxLength": 32, "nullable": true, "default": null, "position": 25 }, { "name": "status", "type": "character varying", "maxLength": 20, "nullable": false, "default": "'subscribed'::character varying", "position": 26 }, { "name": "email_type", "type": "character varying", "maxLength": 10, "nullable": true, "default": "'html'::character varying", "position": 27 }, { "name": "vip", "type": "boolean", "maxLength": null, "nullable": true, "default": "false", "position": 28 }, { "name": "member_rating", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 29 }, { "name": "timestamp_signup", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 30 }, { "name": "timestamp_opt", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 31 }, { "name": "ip_signup", "type": "character varying", "maxLength": 45, "nullable": true, "default": null, "position": 32 }, { "name": "ip_opt", "type": "character varying", "maxLength": 45, "nullable": true, "default": null, "position": 33 }, { "name": "source", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 34 }, { "name": "latitude", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 35 }, { "name": "longitude", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 36 }, { "name": "country_code", "type": "character varying", "maxLength": 2, "nullable": true, "default": null, "position": 37 }, { "name": "dstoff", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 38 }, { "name": "gmtoff", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 39 }, { "name": "tags", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 40 }, { "name": "computed_geo_id", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 41 }, { "name": "computed_geo_location", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 42 }, { "name": "geo_data_source", "type": "character varying", "maxLength": 20, "nullable": true, "default": null, "position": 43 }, { "name": "geo_confidence_score", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 44 }, { "name": "geo_updated_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 45 }, { "name": "geo_processing_notes", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 46 }, { "name": "iso_geo_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 47 }, { "name": "iso_geo_location", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 48 }, { "name": "iso_country_code", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 49 }, { "name": "iso_confidence_level", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 50 }, { "name": "iso_data_source", "type": "character varying", "maxLength": 50, "nullable": true, "default": null, "position": 51 }, { "name": "iso_updated_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 52 }, { "name": "migration_status", "type": "character varying", "maxLength": 20, "nullable": true, "default": "'pending'::character varying", "position": 53 }, { "name": "geo_status", "type": "character varying", "maxLength": 20, "nullable": true, "default": "NULL::character varying", "position": 54 } ] }, { "name": "sync_activity", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('sync_activity_id_seq'::regclass)", "position": 1 }, { "name": "email", "type": "character varying", "maxLength": 255, "nullable": false, "default": null, "position": 2 }, { "name": "action", "type": "character varying", "maxLength": 100, "nullable": false, "default": null, "position": 3 }, { "name": "details", "type": "jsonb", "maxLength": null, "nullable": true, "default": null, "position": 4 }, { "name": "success", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 5 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "CURRENT_TIMESTAMP", "position": 6 } ] }, { "name": "sync_analytics", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('sync_analytics_id_seq'::regclass)", "position": 1 }, { "name": "sync_date", "type": "date", "maxLength": null, "nullable": false, "default": "CURRENT_DATE", "position": 2 }, { "name": "workflow_instance", "type": "character varying", "maxLength": 50, "nullable": true, "default": "'prod1'::character varying", "position": 3 }, { "name": "total_subscribers", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 4 }, { "name": "active_subscribers", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 5 }, { "name": "vip_subscribers", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 6 }, { "name": "new_subscribers_today", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 7 }, { "name": "new_subscribers_7d", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 8 }, { "name": "new_subscribers_30d", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 9 }, { "name": "overall_open_rate", "type": "numeric", "maxLength": null, "nullable": true, "default": "0.00", "position": 10 }, { "name": "overall_click_rate", "type": "numeric", "maxLength": null, "nullable": true, "default": "0.00", "position": 11 }, { "name": "total_opens_today", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 12 }, { "name": "total_clicks_today", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 13 }, { "name": "ultra_engaged", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 14 }, { "name": "high_engaged", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 15 }, { "name": "standard_engaged", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 16 }, { "name": "low_engaged", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 17 }, { "name": "countries_count", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 18 }, { "name": "uk_subscribers", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 19 }, { "name": "uk_percentage", "type": "numeric", "maxLength": null, "nullable": true, "default": "0.00", "position": 20 }, { "name": "international_subscribers", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 21 }, { "name": "synced_to_flodesk", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 22 }, { "name": "sync_success_rate", "type": "numeric", "maxLength": null, "nullable": true, "default": "0.00", "position": 23 }, { "name": "total_sync_errors", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 24 }, { "name": "rating_5_stars", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 25 }, { "name": "rating_4_stars", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 26 }, { "name": "rating_3_stars", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 27 }, { "name": "rating_2_stars", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 28 }, { "name": "rating_1_star", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 29 }, { "name": "estimated_mailchimp_cost", "type": "numeric", "maxLength": null, "nullable": true, "default": "0.00", "position": 30 }, { "name": "actual_flodesk_cost", "type": "numeric", "maxLength": null, "nullable": true, "default": "35.00", "position": 31 }, { "name": "monthly_savings", "type": "numeric", "maxLength": null, "nullable": true, "default": "0.00", "position": 32 }, { "name": "last_sync_time", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 33 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 34 }, { "name": "updated_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 35 } ] }, { "name": "sync_jobs", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('sync_jobs_id_seq'::regclass)", "position": 1 }, { "name": "job_type", "type": "character varying", "maxLength": 50, "nullable": false, "default": null, "position": 2 }, { "name": "mailchimp_account_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 3 }, { "name": "segment_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 4 }, { "name": "status", "type": "character varying", "maxLength": 20, "nullable": true, "default": "'pending'::character varying", "position": 5 }, { "name": "started_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 6 }, { "name": "completed_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 7 }, { "name": "records_processed", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 8 }, { "name": "records_successful", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 9 }, { "name": "records_failed", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 10 }, { "name": "error_details", "type": "jsonb", "maxLength": null, "nullable": true, "default": null, "position": 11 }, { "name": "duration_seconds", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 12 }, { "name": "api_calls_made", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 13 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 14 } ] }, { "name": "sync_schedules", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('sync_schedules_id_seq'::regclass)", "position": 1 }, { "name": "mailchimp_account_id", "type": "integer", "maxLength": null, "nullable": false, "default": null, "position": 2 }, { "name": "schedule_name", "type": "text", "maxLength": null, "nullable": false, "default": null, "position": 3 }, { "name": "schedule_type", "type": "text", "maxLength": null, "nullable": false, "default": null, "position": 4 }, { "name": "interval_minutes", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 5 }, { "name": "cron_expression", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 6 }, { "name": "timezone", "type": "text", "maxLength": null, "nullable": true, "default": "'UTC'::text", "position": 7 }, { "name": "sync_type", "type": "text", "maxLength": null, "nullable": true, "default": "'incremental'::text", "position": 8 }, { "name": "target_lists", "type": "ARRAY", "maxLength": null, "nullable": true, "default": null, "position": 9 }, { "name": "target_segments", "type": "ARRAY", "maxLength": null, "nullable": true, "default": null, "position": 10 }, { "name": "is_active", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 11 }, { "name": "last_run_at", "type": "timestamp with time zone", "maxLength": null, "nullable": true, "default": null, "position": 12 }, { "name": "next_run_at", "type": "timestamp with time zone", "maxLength": null, "nullable": true, "default": null, "position": 13 }, { "name": "created_at", "type": "timestamp with time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 14 }, { "name": "updated_at", "type": "timestamp with time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 15 }, { "name": "created_by", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 16 } ] }, { "name": "sync_state", "columns": [ { "name": "workflow_instance", "type": "character varying", "maxLength": 10, "nullable": false, "default": null, "position": 1 }, { "name": "current_offset", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 2 }, { "name": "last_successful_batch", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 3 }, { "name": "total_processed", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 4 }, { "name": "total_added", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 5 }, { "name": "total_updated", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 6 }, { "name": "total_errors", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 7 }, { "name": "last_update_time", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 8 }, { "name": "status", "type": "character varying", "maxLength": 20, "nullable": true, "default": null, "position": 9 }, { "name": "recovery_point", "type": "character varying", "maxLength": 50, "nullable": true, "default": null, "position": 10 }, { "name": "batch_size", "type": "integer", "maxLength": null, "nullable": true, "default": "50", "position": 11 }, { "name": "offset_start", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 12 }, { "name": "offset_end", "type": "integer", "maxLength": null, "nullable": true, "default": "1000", "position": 13 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "CURRENT_TIMESTAMP", "position": 14 }, { "name": "updated_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "CURRENT_TIMESTAMP", "position": 15 } ] }, { "name": "synced_subscribers", "columns": [ { "name": "email", "type": "character varying", "maxLength": 255, "nullable": false, "default": null, "position": 1 }, { "name": "first_name", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 2 }, { "name": "last_name", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 3 }, { "name": "status", "type": "character varying", "maxLength": 50, "nullable": true, "default": null, "position": 4 }, { "name": "mailchimp_id", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 5 }, { "name": "tags", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 6 }, { "name": "segments", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 7 }, { "name": "segment_ids_json", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 8 }, { "name": "workflow_instance", "type": "character varying", "maxLength": 10, "nullable": false, "default": null, "position": 9 }, { "name": "current_offset", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 10 }, { "name": "subscriber_index", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 11 }, { "name": "import_date", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 12 }, { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('synced_subscribers_id_seq'::regclass)", "position": 13 }, { "name": "flodesk_action", "type": "character varying", "maxLength": 50, "nullable": true, "default": "'processed'::character varying", "position": 14 }, { "name": "flodesk_success", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 15 }, { "name": "flodesk_error", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 16 }, { "name": "processed_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "CURRENT_TIMESTAMP", "position": 17 }, { "name": "type", "type": "character varying", "maxLength": 50, "nullable": true, "default": "'manual_sync'::character varying", "position": 18 }, { "name": "list_id", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 20 }, { "name": "sync_direction", "type": "character varying", "maxLength": 20, "nullable": true, "default": "'mc_to_flodesk'::character varying", "position": 21 }, { "name": "sync_source", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 22 }, { "name": "retry_count", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 23 }, { "name": "last_retry_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 24 }, { "name": "mailchimp_account_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 25 } ] }, { "name": "tags", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('tags_id_seq'::regclass)", "position": 1 }, { "name": "name", "type": "character varying", "maxLength": 100, "nullable": false, "default": null, "position": 2 }, { "name": "description", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 3 }, { "name": "color", "type": "character varying", "maxLength": 7, "nullable": true, "default": null, "position": 4 }, { "name": "category", "type": "character varying", "maxLength": 50, "nullable": true, "default": null, "position": 5 }, { "name": "mailchimp_account_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 6 }, { "name": "mailchimp_tag_id", "type": "character varying", "maxLength": 50, "nullable": true, "default": null, "position": 7 }, { "name": "created_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 8 } ] }, { "name": "v_engagement_trends", "columns": [ { "name": "sync_date", "type": "date", "maxLength": null, "nullable": true, "default": null, "position": 1 }, { "name": "ultra_engaged", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 2 }, { "name": "high_engaged", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 3 }, { "name": "standard_engaged", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 4 }, { "name": "low_engaged", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 5 }, { "name": "ultra_engaged_pct", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 6 }, { "name": "high_engaged_pct", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 7 }, { "name": "standard_engaged_pct", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 8 }, { "name": "low_engaged_pct", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 9 }, { "name": "overall_open_rate", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 10 }, { "name": "overall_click_rate", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 11 } ] }, { "name": "v_exec_summary", "columns": [ { "name": "sync_date", "type": "date", "maxLength": null, "nullable": true, "default": null, "position": 1 }, { "name": "total_subscribers", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 2 }, { "name": "active_subscribers", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 3 }, { "name": "vip_subscribers", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 4 }, { "name": "open_rate", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 5 }, { "name": "click_rate", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 6 }, { "name": "global_reach", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 7 }, { "name": "uk_market", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 8 }, { "name": "premium_audience", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 9 }, { "name": "cost_benefit", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 10 }, { "name": "last_sync_time", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 11 } ] }, { "name": "v_geo_country_distribution", "columns": [ { "name": "country_name", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 1 }, { "name": "country_code", "type": "character varying", "maxLength": 2, "nullable": true, "default": null, "position": 2 }, { "name": "flag_emoji", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 3 }, { "name": "city_count", "type": "bigint", "maxLength": null, "nullable": true, "default": null, "position": 4 }, { "name": "total_subscribers", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 5 }, { "name": "avg_subscribers_per_city", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 6 } ] }, { "name": "v_growth_tracking", "columns": [ { "name": "sync_date", "type": "date", "maxLength": null, "nullable": true, "default": null, "position": 1 }, { "name": "total_subscribers", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 2 }, { "name": "active_subscribers", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 3 }, { "name": "new_subscribers_7d", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 4 }, { "name": "new_subscribers_30d", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 5 }, { "name": "avg_daily_signups", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 6 }, { "name": "prev_total", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 7 }, { "name": "net_growth", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 8 }, { "name": "vip_subscribers", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 9 }, { "name": "synced_to_flodesk", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 10 }, { "name": "sync_rate", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 11 } ] }, { "name": "v_segment_count_health", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 1 }, { "name": "name", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 2 }, { "name": "local_subscriber_count", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 3 }, { "name": "mailchimp_subscriber_count", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 4 }, { "name": "count_discrepancy", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 5 }, { "name": "count_sync_status", "type": "character varying", "maxLength": 20, "nullable": true, "default": null, "position": 6 }, { "name": "last_count_sync_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 7 }, { "name": "last_updated", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 8 }, { "name": "count_notes", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 9 }, { "name": "account_name", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 10 }, { "name": "health_status", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 11 }, { "name": "sync_freshness", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 12 } ] }, { "name": "v_sync_summary", "columns": [ { "name": "mailchimp_account_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 1 }, { "name": "account_nickname", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 2 }, { "name": "account_name", "type": "character varying", "maxLength": 255, "nullable": true, "default": null, "position": 3 }, { "name": "list_id", "type": "character varying", "maxLength": 100, "nullable": true, "default": null, "position": 4 }, { "name": "type", "type": "character varying", "maxLength": 50, "nullable": true, "default": null, "position": 5 }, { "name": "sync_direction", "type": "character varying", "maxLength": 20, "nullable": true, "default": null, "position": 6 }, { "name": "total_syncs", "type": "bigint", "maxLength": null, "nullable": true, "default": null, "position": 7 }, { "name": "successful_syncs", "type": "bigint", "maxLength": null, "nullable": true, "default": null, "position": 8 }, { "name": "failed_syncs", "type": "bigint", "maxLength": null, "nullable": true, "default": null, "position": 9 }, { "name": "avg_retry_count", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 10 }, { "name": "last_sync_time", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 11 }, { "name": "first_sync_time", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 12 } ] }, { "name": "v_top_geo_locations", "columns": [ { "name": "display_name", "type": "character varying", "maxLength": null, "nullable": true, "default": null, "position": 1 }, { "name": "type", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 2 }, { "name": "country_name", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 3 }, { "name": "subscriber_count", "type": "bigint", "maxLength": null, "nullable": true, "default": null, "position": 4 }, { "name": "flag_emoji", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 5 }, { "name": "mailchimp_geo_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 6 }, { "name": "percentage", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 7 } ] }, { "name": "v_unified_geo_locations", "columns": [ { "name": "sort_order", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 1 }, { "name": "id", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 2 }, { "name": "display_name", "type": "character varying", "maxLength": null, "nullable": true, "default": null, "position": 3 }, { "name": "type", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 4 }, { "name": "legacy_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 5 }, { "name": "computed_geo_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 6 }, { "name": "mailchimp_geo_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 7 }, { "name": "iso_geo_id", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 8 }, { "name": "iso_alpha2", "type": "character varying", "maxLength": 2, "nullable": true, "default": null, "position": 9 }, { "name": "iso_country_code", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 10 }, { "name": "country_code", "type": "character varying", "maxLength": 2, "nullable": true, "default": null, "position": 11 }, { "name": "country_name", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 12 }, { "name": "region_name", "type": "character varying", "maxLength": null, "nullable": true, "default": null, "position": 13 }, { "name": "city_name", "type": "character varying", "maxLength": null, "nullable": true, "default": null, "position": 14 }, { "name": "population", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 15 }, { "name": "confidence_level", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 16 }, { "name": "importance_rank", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 17 }, { "name": "venue_category", "type": "character varying", "maxLength": null, "nullable": true, "default": null, "position": 18 }, { "name": "subscriber_count", "type": "bigint", "maxLength": null, "nullable": true, "default": null, "position": 19 }, { "name": "bounds_north", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 20 }, { "name": "bounds_south", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 21 }, { "name": "bounds_east", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 22 }, { "name": "bounds_west", "type": "numeric", "maxLength": null, "nullable": true, "default": null, "position": 23 }, { "name": "search_terms", "type": "ARRAY", "maxLength": null, "nullable": true, "default": null, "position": 24 }, { "name": "flag_emoji", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 25 }, { "name": "time_zone", "type": "character varying", "maxLength": null, "nullable": true, "default": null, "position": 26 }, { "name": "data_source", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 27 }, { "name": "last_updated", "type": "timestamp with time zone", "maxLength": null, "nullable": true, "default": null, "position": 28 } ] }, { "name": "webhook_configurations", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('webhook_configurations_id_seq'::regclass)", "position": 1 }, { "name": "mailchimp_account_id", "type": "integer", "maxLength": null, "nullable": false, "default": null, "position": 2 }, { "name": "webhook_url", "type": "text", "maxLength": null, "nullable": false, "default": null, "position": 3 }, { "name": "webhook_secret", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 4 }, { "name": "webhook_id", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 5 }, { "name": "events", "type": "ARRAY", "maxLength": null, "nullable": true, "default": "ARRAY['subscribe'::text, 'unsubscribe'::text, 'profile'::text, 'cleaned'::text, 'upemail'::text, 'campaign'::text]", "position": 6 }, { "name": "sources", "type": "ARRAY", "maxLength": null, "nullable": true, "default": "ARRAY['user'::text, 'admin'::text, 'api'::text]", "position": 7 }, { "name": "is_active", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 8 }, { "name": "ssl_verification", "type": "boolean", "maxLength": null, "nullable": true, "default": "true", "position": 9 }, { "name": "status", "type": "text", "maxLength": null, "nullable": true, "default": "'pending'::text", "position": 10 }, { "name": "last_success_at", "type": "timestamp with time zone", "maxLength": null, "nullable": true, "default": null, "position": 11 }, { "name": "last_error_at", "type": "timestamp with time zone", "maxLength": null, "nullable": true, "default": null, "position": 12 }, { "name": "last_error_message", "type": "text", "maxLength": null, "nullable": true, "default": null, "position": 13 }, { "name": "success_count", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 14 }, { "name": "error_count", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 15 }, { "name": "created_at", "type": "timestamp with time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 16 }, { "name": "updated_at", "type": "timestamp with time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 17 } ] }, { "name": "workflow_state", "columns": [ { "name": "id", "type": "integer", "maxLength": null, "nullable": false, "default": "nextval('workflow_state_id_seq'::regclass)", "position": 1 }, { "name": "workflow_name", "type": "character varying", "maxLength": 255, "nullable": true, "default": "'mailchimp_segment_sync'::character varying", "position": 2 }, { "name": "last_completed_batch", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 3 }, { "name": "total_batches", "type": "integer", "maxLength": null, "nullable": true, "default": null, "position": 4 }, { "name": "started_at", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": null, "position": 5 }, { "name": "last_updated", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 6 }, { "name": "status", "type": "character varying", "maxLength": 50, "nullable": true, "default": "'running'::character varying", "position": 7 } ] }, { "name": "workflow_sync_state", "columns": [ { "name": "workflow_name", "type": "character varying", "maxLength": 50, "nullable": false, "default": null, "position": 1 }, { "name": "next_offset", "type": "integer", "maxLength": null, "nullable": true, "default": "0", "position": 2 }, { "name": "last_updated", "type": "timestamp without time zone", "maxLength": null, "nullable": true, "default": "now()", "position": 3 } ] } ] }