Physical DB: campaigns
| Logical DB | Tables |
|---|---|
| Temp | dummy_table.sql |
| veneno_data_details | inbox_drafts.sql |
| veneno_data_details | control_group_users_history.sql |
| temporal_engine_bootstrap | simple_property_meta.sql |
| temporal_engine_bootstrap | sharding_config.sql |
| temporal_engine_bootstrap | rule_action_info.sql |
| temporal_engine_bootstrap | rule_case_action_list.sql |
| temporal_engine_bootstrap | rule_info.sql |
| temporal_engine_bootstrap | simple_property_info.sql |
| temporal_engine_bootstrap | org_config_ruleset_mapping.sql |
| temporal_engine_bootstrap | ruleset_info.sql |
| temporal_engine_bootstrap | action_meta.sql |
| veneno_meta_info | shard_details.sql |
| veneno_meta_info | bucket_details.sql |
| emigran | versions.sql |
| temporal_engine_2000000_1 | timelines.sql |
| temporal_engine_2000000_1 | event_milestone_mapping.sql |
| temporal_engine_2000000_1 | current_milestone_contexts.sql |
| temporal_engine_2000000_1 | user_activity_skip_criteria.sql |
| temporal_engine_2000000_1 | current_message_context.sql |
| temporal_engine_2000000_1 | phases.sql |
| temporal_engine_2000000_1 | activity_context_history.sql |
| temporal_engine_2000000_1 | org_config_time_prefs.sql |
| temporal_engine_2000000_1 | org_config.sql |
| temporal_engine_2000000_1 | offers.sql |
| temporal_engine_2000000_1 | activity_context_attrs.sql |
| temporal_engine_2000000_1 | skip_levels.sql |
| temporal_engine_2000000_1 | offer_sms_templates.sql |
| temporal_engine_2000000_1 | offer_filters.sql |
| temporal_engine_2000000_1 | event_categories.sql |
| temporal_engine_2000000_1 | milestones.sql |
| temporal_engine_2000000_1 | milestone_context_history.sql |
| temporal_engine_2000000_1 | category_attrs.sql |
| temporal_engine_2000000_1 | offer_email_templates.sql |
| temporal_engine_2000000_1 | events.sql |
| temporal_engine_2000000_1 | org_config_properties.sql |
| temporal_engine_2000000_1 | timeline_properties.sql |
| temporal_engine_2000000_1 | temp_activity_context_history.sql |
| temporal_engine_2000000_1 | user_initialization_history.sql |
| campaign_data_details | dummy_data_details.sql |
| veneno | recipient_social_list_map.sql |
| veneno | veneno_service_monitor_status.sql |
| veneno | variant_execution_status.sql |
| veneno | precheck_errors_types.sql |
| veneno | veneno_monitor_status.sql |
| veneno | skipped_error_types.sql |
| veneno | notification_context.sql |
| veneno | replay_skipped_batches.sql |
| veneno | rate_limiting_strategy.sql |
| veneno | legend_label_category_mapping.sql |
| veneno | social_adset_info.sql |
| veneno | delivery_status_priority.sql |
| veneno | aggregated_summary_report_nsadmin.sql |
| veneno | social_coupon_upload_info.sql |
| veneno | reload_sync_details.sql |
| veneno | summary_report_veneno.sql |
| veneno | campaign_config_keys.sql |
| veneno | rate_limiting_stats.sql |
| veneno | legend_labels.sql |
| veneno | aggregation_details.sql |
| veneno | veneno_service_configs.sql |
| veneno | summary_report_nsadmin.sql |
| veneno | pre_execution_job_status.sql |
| veneno | delivery_status.sql |
| veneno | status_type_legends.sql |
| veneno | service_details.sql |
| veneno | veneno_batch_details.sql |
| veneno | campaign_replay_stats.sql |
| veneno | user_actions_run.sql |
| veneno | communication_details_dlr_update_log.sql |
| veneno | sms_link_track_org_status.sql |
| veneno | pre_execution_msg_status.sql |
| veneno | campaign_config_values.sql |
| veneno | social_audience_list.sql |
| veneno | xengage_adchannels_delivery_details.sql |
| veneno | social_message_info.sql |
| veneno | social_offer_info.sql |
| veneno | communication_details.sql |
| migration | migration_run.sql |
| migration | migration_run_statistics.sql |
| campaign_meta_details | reachability_channel_types.sql |
| campaign_meta_details | group_custom_tags.sql |
| campaign_meta_details | reloadable_group.sql |
| campaign_meta_details | reachability_job_details.sql |
| campaign_meta_details | group_details.sql |
| campaign_meta_details | reachability_batch_details.sql |
| campaign_meta_details | shard_details.sql |
| campaign_meta_details | reload_sync_details.sql |
| campaign_meta_details | group_reload_log.sql |
| campaign_meta_details | reachability_status_mapping.sql |
| campaign_meta_details | audience_v2_org_status.sql |
| campaign_meta_details | bucket_details.sql |
| campaign_meta_details | group_version_details.sql |
| campaign_meta_details | campaign_audience_export_job.sql |
| campaign_meta_details | create_audience_job_logs.sql |
| campaign_meta_details | reachability_summary_report.sql |
| campaign_meta_details | create_audience_job.sql |
| campaign_meta_details | reachability_category_labels.sql |
| campaign_meta_details | campaign_hash_lookup.sql |
| campaign_meta_details | group_event_subscription.sql |
Table: dummy_table
dummy_table| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | None |
Table: inbox_drafts
inbox_drafts| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | None |
| msg_state | enum('OPENED','PICKED','DELIVERED') | Part of UNIQUE KEY (msg_state) |
| message_id | int(11) | Part of UNIQUE KEY (message_id) |
| recipient_id | int(11) | Part of UNIQUE KEY (recipient_id) |
| created_time | datetime | None |
| retrieved_time | datetime | None |
| resolved_tags | mediumtext | None |
| target_value | varchar(255) | None |
| is_deleted | tinyint(4) | None |
Table: control_group_users_history
control_group_users_history| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| user_id | int(11) | Part of UNIQUE KEY (user_id) |
| org_id | int(11) | Part of KEY (org_id) |
| group_id | int(11) | None |
| campaign_id | int(11) | Part of KEY (campaign_id) |
| message_id | int(11) | Part of KEY (message_id) |
| created_time | timestamp | None |
| last_updated_time | timestamp | Part of KEY (last_updated_time) |
Table: simple_property_meta
simple_property_meta| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| property_name | mediumtext | None |
| data_type | enum('STRING','BOOLEAN','INTEGER','DATE','REAL','ENUM') | None |
| is_mandatory | tinyint(1) | None |
| default_value | mediumtext | None |
| allowed_values | mediumtext | None |
| is_multi_select | tinyint(1) | None |
| action_meta_id | int(11) | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: sharding_config
sharding_config| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of UNIQUE KEY (org_id) |
| org_config_id | int(11) | Part of UNIQUE KEY (org_config_id) |
| org_config_name | varchar(100) | Part of UNIQUE KEY (org_config_name) |
| campaign_id | int(11) | None |
| status | enum('ACTIVE','INACTIVE','PAUSED') | Part of KEY (status) |
| database_name | varchar(100) | None |
| shard_id | int(11) | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: rule_action_info
rule_action_info| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| name | mediumtext | None |
| class | mediumtext | None |
| description | mediumtext | None |
| case_action_list_id | int(11) | Part of KEY (case_action_list_id) |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: rule_case_action_list
rule_case_action_list| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| rule_id | int(11) | Part of KEY (rule_id) |
| case_id | int(11) | None |
| value | mediumtext | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: rule_info
rule_info| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| ruleset_id | int(11) | Part of KEY (ruleset_id) |
| name | varchar(100) | None |
| description | mediumtext | None |
| expression | mediumtext | None |
| expression_json | longtext | None |
| sequence_id | int(11) | None |
| is_active | tinyint(1) | None |
| start_date | datetime | None |
| end_date | datetime | None |
| created_by | int(11) | None |
| created_on | datetime | None |
| last_modified | datetime | None |
| last_modified_by | int(11) | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: simple_property_info
simple_property_info| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| action_info_id | int(11) | Part of KEY (action_info_id) |
| property_key | mediumtext | None |
| property_value | mediumtext | None |
| initialized | tinyint(1) | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: org_config_ruleset_mapping
org_config_ruleset_mapping| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| org_config_id | int(11) | Part of KEY (org_config_id) |
| ruleset_info_id | int(11) | None |
| last_modified_on | datetime | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: ruleset_info
ruleset_info| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| context_id | bigint(20) | None |
| context_type | varchar(50) | None |
| name | varchar(256) | None |
| description | mediumtext | None |
| start_date | datetime | None |
| end_date | datetime | None |
| is_active | tinyint(1) | None |
| created_by | int(11) | None |
| created_on | datetime | None |
| last_modified | datetime | None |
| last_modified_by | int(11) | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: action_meta
action_meta| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| name | varchar(20) | None |
| action_class | varchar(100) | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: shard_details
shard_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| permission | enum('READ','WRITE') | None |
| database_name | varchar(255) | None |
| description | varchar(255) | None |
| service_name | varchar(255) | None |
| created_on | datetime | None |
Table: bucket_details
bucket_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| shard_id | int(11) | None |
| bucket_name | varchar(100) | None |
| hit_rate | int(11) | None |
| rows_count | int(11) | None |
| last_visited_on | date | None |
| has_sub_delivery_status | tinyint(1) | None |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of UNIQUE KEY (id) |
| uuId | varchar(250) | Part of UNIQUE KEY (uuId) |
| is_active | int(1) | None |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| name | varchar(100) | Part of KEY (name) |
| user_defined_name | varchar(100) | None |
| description | varchar(255) | None |
| org_id | int(11) | Part of KEY (org_id) |
| org_config_id | int(11) | Part of KEY (org_config_id) |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| scope_id | int(11) | Part of KEY (scope_id) |
| event_id | int(11) | Part of KEY (event_id) |
| milestone_id | int(11) | Part of KEY (milestone_id) |
| org_id | int(11) | Part of KEY (org_id) |
| org_config_id | int(11) | Part of KEY (org_config_id) |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| source | varchar(25) | Part of KEY (source) |
| status | varchar(50) | Part of KEY (status) |
| state | varchar(255) | None |
| execution_time | datetime | Part of KEY (execution_time) |
| milestone_id | int(11) | Part of KEY (milestone_id) |
| phase_id | int(11) | Part of KEY (phase_id) |
| timeline_id | int(11) | Part of KEY (timeline_id) |
| user_id | int(11) | Part of KEY (user_id) |
| org_id | int(11) | Part of KEY (org_id) |
| org_config_id | int(11) | Part of KEY (org_config_id) |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| skip_level_id | int(11) | Part of UNIQUE KEY (skip_level_id) |
| skip_level_type | varchar(50) | Part of KEY (skip_level_type) |
| org_id | int(11) | Part of KEY (org_id) |
| org_config_id | int(11) | Part of KEY (org_config_id) |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| msg_id | int(11) | Part of KEY (msg_id) |
| msg_type | varchar(10) | None |
| batch_id | varchar(100) | None |
| group_id | bigint(20) | Part of KEY (group_id) |
| org_id | int(11) | None |
| org_config_id | int(11) | None |
| user_id | bigint(20) | Part of KEY (user_id) |
| status | varchar(50) | Part of KEY (status) |
| activity_context_history_id | bigint(20) | None |
| current_milestone_context_id | bigint(20) | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| name | varchar(100) | Part of UNIQUE KEY (name) |
| user_defined_name | varchar(100) | None |
| description | varchar(255) | None |
| idx | int(11) | None |
| phase_changer_ruleset | varchar(100) | None |
| state_analyzer_ruleset | varchar(100) | None |
| org_id | int(11) | Part of KEY (org_id) |
| org_config_id | int(11) | Part of KEY (org_config_id) |
| timeline_id | int(11) | Part of KEY (timeline_id) |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| name | varchar(100) | Part of KEY (name) |
| status_context | varchar(255) | None |
| activity_type | varchar(25) | Part of KEY (activity_type) |
| status | varchar(50) | Part of KEY (status) |
| execution_time | datetime | None |
| milestone_id | int(11) | Part of KEY (milestone_id) |
| phase_id | int(11) | Part of KEY (phase_id) |
| timeline_id | int(11) | Part of KEY (timeline_id) |
| user_id | int(11) | Part of KEY (user_id) |
| org_id | int(11) | Part of KEY (org_id) |
| org_config_id | int(11) | Part of KEY (org_config_id) |
| milestone_context_history_id | bigint(20) | Part of KEY (milestone_context_history_id) |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| org_config_id | int(11) | Part of KEY (org_config_id) |
| start_minute | int(4) | Part of UNIQUE KEY (start_minute) |
| end_minute | int(4) | Part of UNIQUE KEY (end_minute) |
| scope | varchar(100) | Part of KEY (scope) |
| weight | int(3) | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| name | varchar(100) | Part of KEY (name) |
| user_defined_name | varchar(100) | None |
| state_timeline_mapping | longtext | None |
| user_init_ruleset | varchar(100) | None |
| org_id | int(11) | Part of KEY (org_id) |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| name | varchar(255) | Part of KEY (name) |
| send_pref | enum('SEND_FIRST','SEND_ALL') | None |
| org_id | int(11) | Part of UNIQUE KEY (org_id) |
| org_config_id | int(11) | Part of UNIQUE KEY (org_config_id) |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| name | varchar(100) | Part of KEY (name) |
| val | longtext | None |
| org_id | int(11) | Part of KEY (org_id) |
| org_config_id | int(11) | Part of KEY (org_config_id) |
| activity_context_history_id | bigint(20) | Part of KEY (activity_context_history_id) |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| type | varchar(100) | Part of PRIMARY KEY (type) |
| description | varchar(250) | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| idx | int(11) | None |
| template | varchar(255) | None |
| filter_id | int(11) | Part of KEY (filter_id) |
| offer_id | int(11) | Part of KEY (offer_id) |
| org_id | int(11) | Part of UNIQUE KEY (org_id) |
| org_config_id | int(11) | Part of UNIQUE KEY (org_config_id) |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| name | varchar(255) | Part of KEY (name) |
| type | varchar(50) | None |
| value | longtext | None |
| org_id | int(11) | Part of UNIQUE KEY (org_id) |
| org_config_id | int(11) | Part of UNIQUE KEY (org_config_id) |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| name | varchar(100) | Part of KEY (name) |
| org_id | int(11) | Part of KEY (org_id) |
| org_config_id | int(11) | Part of KEY (org_config_id) |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| name | varchar(100) | Part of KEY (name) |
| user_defined_name | varchar(100) | None |
| description | varchar(255) | None |
| idx | int(11) | None |
| starting_ruleset | varchar(100) | None |
| org_id | int(11) | Part of KEY (org_id) |
| org_config_id | int(11) | Part of KEY (org_config_id) |
| phase_id | int(11) | Part of KEY (phase_id) |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| source | varchar(25) | Part of KEY (source) |
| status | varchar(50) | Part of KEY (status) |
| state | varchar(255) | None |
| execution_time | datetime | None |
| milestone_id | int(11) | Part of KEY (milestone_id) |
| phase_id | int(11) | Part of KEY (phase_id) |
| timeline_id | int(11) | Part of KEY (timeline_id) |
| user_id | int(11) | Part of KEY (user_id) |
| org_id | int(11) | Part of KEY (org_id) |
| org_config_id | int(11) | Part of KEY (org_config_id) |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| name | varchar(100) | Part of KEY (name) |
| description | varchar(255) | None |
| org_id | int(11) | Part of KEY (org_id) |
| org_config_id | int(11) | Part of KEY (org_config_id) |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| idx | int(11) | None |
| sub_template | varchar(255) | None |
| body_template | longtext | None |
| filter_id | int(11) | Part of KEY (filter_id) |
| offer_id | int(11) | Part of KEY (offer_id) |
| org_id | int(11) | Part of UNIQUE KEY (org_id) |
| org_config_id | int(11) | Part of UNIQUE KEY (org_config_id) |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| name | varchar(100) | Part of KEY (name) |
| description | varchar(255) | None |
| grp | varchar(50) | None |
| scope_type | varchar(25) | Part of KEY (scope_type) |
| category_id | int(11) | Part of KEY (category_id) |
| org_id | int(11) | Part of KEY (org_id) |
| org_config_id | int(11) | Part of KEY (org_config_id) |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of UNIQUE KEY (org_id) |
| org_config_id | int(11) | Part of KEY (org_config_id) |
| prop_name | varchar(100) | Part of UNIQUE KEY (prop_name) |
| prop_value | text | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| prop_name | varchar(100) | Part of UNIQUE KEY (prop_name) |
| prop_value | varchar(255) | None |
| org_id | int(11) | Part of KEY (org_id) |
| org_config_id | int(11) | Part of KEY (org_config_id) |
| timeline_id | int(11) | Part of KEY (timeline_id) |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| activity_context_id | bigint(20) | Part of UNIQUE KEY (activity_context_id) |
| status_context | varchar(100) | None |
| status | varchar(10) | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: IF
IF| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| user_id | int(11) | Part of KEY (user_id) |
| user_init_time | datetime | None |
| timeline_id | int(11) | Part of KEY (timeline_id) |
| state | varchar(255) | None |
| org_id | int(11) | None |
| org_config_id | int(11) | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: dummy_data_details
dummy_data_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | None |
Table: recipient_social_list_map
recipient_social_list_map| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| recipient_list_id | int(11) | Part of UNIQUE KEY (recipient_list_id) |
| social_audience_list_id | int(11) | Part of UNIQUE KEY (social_audience_list_id) |
Table: veneno_service_monitor_status
veneno_service_monitor_status| Column Name | Data Type | Index |
|---|---|---|
| message_id | int(11) | Part of UNIQUE KEY (message_id) |
| message_version | int(11) | Part of UNIQUE KEY (message_version) |
| status | enum('STUCK_AT_VENENO','STUCK_AT_NSADMIN','SKIPPED_AT_VENENO','FAILED_AT_NSADMIN','FAILED_AT_SOCIAL_GATEWAY') | Part of UNIQUE KEY (status) |
| org_id | int(11) | None |
| auto_updated | timestamp | None |
Table: variant_execution_status
variant_execution_status| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| campaign_id | int(11) | Part of KEY (campaign_id) |
| message_id | varchar(30) | None |
| message_variant_id | varchar(30) | Part of KEY (message_variant_id) |
| message_queue_id | int(11) | None |
| status | enum('OPEN','PROCESSING','SUBMITTED','TEMPORARY_FAILURE','SUCCESS','PERMANENT_FAILURE') | None |
| start_date | datetime | None |
| end_date | datetime | None |
| auto_update_time | timestamp | None |
Table: precheck_errors_types
precheck_errors_types| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| error_code | varchar(250) | None |
| error_type | enum('PERMANENT_FAILURE', | None |
| error_message | varchar(250) | None |
| action_message | varchar(250) | None |
Table: veneno_monitor_status
veneno_monitor_status| Column Name | Data Type | Index |
|---|---|---|
| message_id | int(11) | Part of UNIQUE KEY (message_id) |
| message_version | int(11) | Part of UNIQUE KEY (message_version) |
| processed_status | tinyint(1) | None |
| service_status | tinyint(1) | None |
| last_updated | datetime | None |
Table: skipped_error_types
skipped_error_types| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| error_type | varchar(100) | None |
| description | varchar(250) | None |
| actionMessage | varchar(250) | None |
| is_replayable | tinyint(1) | None |
Table: notification_context
notification_context| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| campaign_id | int(11) | Part of KEY (campaign_id) |
| message_id | varchar(30) | Part of KEY (message_id) |
| message_variant_id | varchar(30) | None |
| communication_details_id | int(11) | None |
| notification_type | enum('PRECHECK','POSTPONE','FAILURE','SUCCESS','MESSAGE_APPROVAL','MESSAGE_PROCESSING_ERROR','MESSAGE_APPROVED','MESSAGE_DELIVERY') | None |
| execution_stage | enum('REMIND','EXECUTE','POST_EXECUTE','PRE_REMIND') | None |
| status | enum('OPEN','PROCESSING','CLOSED','ERROR') | None |
| created_date | datetime | None |
| auto_update_time | timestamp | None |
Table: replay_skipped_batches
replay_skipped_batches| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| message_id | int(11) | Part of KEY (message_id) |
| message_version | int(11) | Part of KEY (message_version) |
| batch_id | varchar(250) | Part of KEY (batch_id) |
| s3_key | varchar(250) | None |
| auto_update_time | timestamp | None |
Table: rate_limiting_strategy
rate_limiting_strategy| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of UNIQUE KEY (org_id) |
| window | enum('DAILY','WEEKLY','MONTHLY') | Part of UNIQUE KEY (window) |
| channel | varchar(20) | Part of UNIQUE KEY (channel) |
| limit | int(11) | None |
| is_active | tinyint(1) | None |
| last_updated_by | int(11) | None |
| auto_update_time | timestamp | None |
Table: legend_label_category_mapping
legend_label_category_mapping| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| legend_label_id | int(11) | None |
| sub_legend_label_id | int(11) | None |
Table: social_adset_info
social_adset_info| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of UNIQUE KEY (org_id) |
| name | varchar(250) | None |
| message_id | int(11) | Part of UNIQUE KEY (message_id) |
| message_version | int(11) | Part of UNIQUE KEY (message_version) |
| remote_adset_id | varchar(32) | None |
| remote_campaign_id | varchar(32) | None |
| remote_offer_id | varchar(32) | None |
| custom_audience_id | varchar(32) | None |
| remote_ad_id | varchar(32) | None |
| ad_name | varchar(250) | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: delivery_status_priority
delivery_status_priority| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| delivery_status_id | int(11) | Part of UNIQUE KEY (delivery_status_id) |
| priority | int(11) | None |
| created_on | timestamp | None |
| last_updated_on | timestamp | None |
Table: aggregated_summary_report_nsadmin
aggregated_summary_report_nsadmin| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of UNIQUE KEY (org_id) |
| msg_id | int(11) | Part of UNIQUE KEY (msg_id) |
| delivery_status_id | int(11) | Part of UNIQUE KEY (delivery_status_id) |
| count | int(11) | None |
| last_updated_on | timestamp | None |
Table: social_coupon_upload_info
social_coupon_upload_info| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of UNIQUE KEY (org_id) |
| message_id | int(11) | Part of UNIQUE KEY (message_id) |
| message_version | int(11) | Part of UNIQUE KEY (message_version) |
| s3_key | varchar(250) | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: reload_sync_details
reload_sync_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| sync_time | datetime | None |
| reload_time | datetime | None |
| created_date | datetime | None |
| auto_update_time | timestamp | None |
Table: summary_report_veneno
summary_report_veneno| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of UNIQUE KEY (org_id) |
| msg_id | int(11) | Part of UNIQUE KEY (msg_id) |
| message_version | int(11) | Part of UNIQUE KEY (message_version) |
| report_type | varchar(255) | Part of UNIQUE KEY (report_type) |
| sub_type | varchar(255) | Part of UNIQUE KEY (sub_type) |
| count | int(11) | None |
| last_updated_on | timestamp | None |
Table: campaign_config_keys
campaign_config_keys| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| key | varchar(20) | None |
| default_value | varchar(256) | None |
| auto_update_time | timestamp | None |
Table: rate_limiting_stats
rate_limiting_stats| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of UNIQUE KEY (org_id) |
| user_id | int(11) | Part of UNIQUE KEY (user_id) |
| strategy_id | int(11) | Part of UNIQUE KEY (strategy_id) |
| window_value | int(11) | None |
| no_of_attempts | int(11) | None |
| auto_update_time | timestamp | None |
Table: legend_labels
legend_labels| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| legend_label | varchar(50) | None |
| parent_legend_label_ids_csv | varchar(100) | None |
| last_updated_on | timestamp | None |
Table: aggregation_details
aggregation_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | None |
| message_id | bigint(20) | Part of UNIQUE KEY (message_id) |
| batch_start_id | int(11) | None |
| job_type | enum('COUPON_REVOKE','LIST_DELETE','COUPON_ISSUED','LIST_PUBLISHED','POST_PROCESS','SOCIAL_ADSET','AD_CREATION') | Part of UNIQUE KEY (job_type) |
| job_status | enum('PROCESSING','DONE','ERROR') | None |
| retrial_count | int(11) | None |
| start_time | datetime | None |
| auto_update_time | timestamp | None |
Table: veneno_service_configs
veneno_service_configs| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| key | varchar(20) | None |
| value | int(11) | None |
| is_active | tinyint(1) | None |
| auto_update_time | timestamp | None |
Table: summary_report_nsadmin
summary_report_nsadmin| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | None |
| msg_id | int(11) | Part of UNIQUE KEY (msg_id) |
| delivery_status_id | int(11) | Part of UNIQUE KEY (delivery_status_id) |
| count | int(11) | None |
| last_updated_on | timestamp | None |
Table: pre_execution_job_status
pre_execution_job_status| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| campaign_id | int(11) | Part of KEY (campaign_id) |
| message_id | varchar(30) | Part of KEY (message_id) |
| message_variant_id | varchar(30) | Part of KEY (message_variant_id) |
| job_type | enum('GROUP_RELOAD_NFS','GROUP_RELOAD_CREATE_AUDIENCE','PRECHECK','COMMUNICATION_DETAIL_CREATION','BASIC_REMIND_CHECKS','RECURRING_CHECKS','BASIC_EXECUTE_CHECKS','AUDIENCE_LIST_EXPORT','EXTERNAL_TAGS_CREATE_JOB','EXTERNAL_TAGS_EXPORT','AUDIENCE_GROUP_RELOAD') | Part of KEY (job_type) |
| job_status | enum('OPEN','PROCESSING','SUBMITTED','TEMPORARY_FAILURE','SUCCESS','PERMANENT_FAILURE') | Part of KEY (job_status) |
| event_type | enum('REMIND','EXECUTE') | Part of KEY (event_type) |
| error_description | varchar(512) | None |
| params | varchar(500) | None |
| start_date | datetime | Part of KEY (start_date) |
| end_date | datetime | None |
| auto_update_time | timestamp | None |
| is_valid | tinyint(1) | Part of KEY (is_valid) |
Table: delivery_status
delivery_status| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| status | varchar(50) | None |
| description | varchar(250) | None |
Table: status_type_legends
status_type_legends| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| status_type | varchar(100) | None |
| status_id | int(11) | None |
| status_label | varchar(100) | None |
| legend_label | int(11) | None |
| category | varchar(100) | None |
| last_updated_on | timestamp | None |
Table: service_details
service_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of UNIQUE KEY (org_id) |
| communication_message_id | int(11) | Part of UNIQUE KEY (communication_message_id) |
| message_version | int(11) | Part of UNIQUE KEY (message_version) |
| batch_type | varchar(200) | Part of UNIQUE KEY (batch_type) |
| picked_time | datetime | None |
| processed_count | int(11) | None |
| batches_processed | int(11) | None |
| last_updated_on | datetime | None |
Table: veneno_batch_details
veneno_batch_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| batch_type | enum('FEEDER','TAG_RESOLVER','DELIVERY_SERVER','INBOX_CONSUMER','NSADMIN_SERVER','FB_GATEWAY') | Part of UNIQUE KEY (batch_type) |
| status | enum('PROCESSING','CLOSED','ERROR','FAILED', | None |
| message_id | int(11) | Part of UNIQUE KEY (message_id) |
| message_version | int(11) | None |
| batch_id | varchar(250) | Part of UNIQUE KEY (batch_id) |
| start_time | datetime | None |
| end_time | datetime | None |
| error_report | longtext | None |
| last_updated_on | datetime | None |
| batch_start_id | int(11) | None |
Table: campaign_replay_stats
campaign_replay_stats| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| message_id | int(11) | None |
| message_version | int(11) | None |
| received_time | datetime | None |
| picked_time | datetime | None |
| skipped_count | int(11) | None |
| skipped_error_csv | varchar(200) | None |
| auto_update_time | timestamp | None |
Table: user_actions_run
user_actions_run| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| status | enum('STARTED','PROCESSING','ENDED') | Part of KEY (status) |
| type | enum('OPENED','CLICKED') | Part of KEY (type) |
| processed_count | int(11) | None |
| start_date | timestamp | None |
| end_date | timestamp | None |
| last_run | timestamp | None |
| auto_update_time | timestamp | None |
Table: communication_details_dlr_update_log
communication_details_dlr_update_log| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| msg_id | int(11) | Part of UNIQUE KEY (msg_id) |
| created_on | timestamp | None |
| last_updated_on | timestamp | Part of KEY (last_updated_on) |
Table: sms_link_track_org_status
sms_link_track_org_status| Column Name | Data Type | Index |
|---|---|---|
| org_id | int(11) | Part of PRIMARY KEY (org_id) |
| status | tinyint(1) | None |
| auto_update_time | timestamp | None |
Table: pre_execution_msg_status
pre_execution_msg_status| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| campaign_id | int(11) | Part of KEY (campaign_id) |
| message_id | varchar(30) | Part of KEY (message_id) |
| message_variant_id | varchar(30) | Part of KEY (message_variant_id) |
| event_type | enum('REMIND','EXECUTE') | Part of KEY (event_type) |
| status | enum('OPEN','PROCESSING','SUBMITTED','TEMPORARY_FAILURE','SUCCESS','PERMANENT_FAILURE') | Part of KEY (status) |
| start_date | datetime | Part of KEY (start_date) |
| end_date | datetime | None |
| auto_update_time | timestamp | None |
| is_valid | tinyint(1) | Part of KEY (is_valid) |
Table: campaign_config_values
campaign_config_values| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| key_id | int(11) | None |
| org_id | int(11) | None |
| value | varchar(256) | None |
| is_active | tinyint(1) | None |
| created_by | int(11) | None |
| auto_update_time | timestamp | None |
Table: social_audience_list
social_audience_list| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| message_id | int(11) | Part of KEY (message_id) |
| type | enum('FACEBOOK','GOOGLE','TWITTER') | Part of KEY (type) |
| recipient_list_id | int(11) | None |
| account_id | varchar(32) | Part of UNIQUE KEY (account_id) |
| remote_list_id | varchar(32) | Part of UNIQUE KEY (remote_list_id) |
| name | mediumtext | None |
| description | mediumtext | None |
| approximate_count | int(64) | None |
| created_on | timestamp | None |
| remote_updated_on | timestamp | None |
| cached_on | timestamp | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: xengage_adchannels_delivery_details
xengage_adchannels_delivery_details| Column Name | Data Type | Index |
|---|---|---|
| message_id | int(11) | Part of PRIMARY KEY (message_id) |
| org_id | int(11) | Part of PRIMARY KEY (org_id) |
| sub_channel | enum('FACEBOOK', | None |
| ftp_link | varchar(255) | None |
| fresh_service_id | int(11) | None |
| created_time | datetime | None |
Table: social_message_info
social_message_info| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of UNIQUE KEY (org_id) |
| campaign_id | int(11) | None |
| message_id | varchar(300) | None |
| type | enum('FACEBOOK','GOOGLE','TWITTER') | Part of UNIQUE KEY (type) |
| recipient_list_id | int(11) | None |
| account_id | varchar(32) | Part of UNIQUE KEY (account_id) |
| remote_list_id | varchar(32) | Part of UNIQUE KEY (remote_list_id) |
| remote_adset_id | varchar(32) | None |
| remote_ad_id | varchar(32) | None |
| created_on | timestamp | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: social_offer_info
social_offer_info| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| message_id | int(11) | Part of KEY (message_id) |
| message_version | int(11) | Part of KEY (message_version) |
| voucher_series_id | int(11) | Part of KEY (voucher_series_id) |
| remote_offer_id | varchar(32) | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: communication_details
communication_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| guid | varchar(100) | Part of KEY (guid) |
| message_queue_id | int(11) | Part of KEY (message_queue_id) |
| message_id | varchar(30) | Part of KEY (message_id) |
| org_id | int(11) | Part of KEY (org_id) |
| bucket_id | int(11) | None |
| campaign_id | int(11) | Part of KEY (campaign_id) |
| recipient_list_id | int(11) | None |
| attribution_id | int(11) | None |
| recipient_list_name | varchar(500) | None |
| target_type | enum('GROUPED','TIMELINE','EXPIRY_REMINDER','SOCIAL','PROMOTION_EARNED','PROMOTION_EXPIRY', | Part of KEY (target_type) |
| communication_type | enum('SMS','EMAIL','CALL_TASK','WECHAT','PUSH','ANDROID','IOS','FACEBOOK','GOOGLE','TWITTER','LINE','XENGAGE','NO_COMMUNICATION', | None |
| sub_communication_type | enum('SMS','EMAIL','CALL_TASK','WECHAT','PUSH','ANDROID','IOS','FACEBOOK','GOOGLE','TWITTER','LINE','NONE','NO_COMMUNICATION', | None |
| expected_delivery_count | int(11) | None |
| overall_recipient_count | int(10) | None |
| subject | mediumtext | None |
| message_body | longtext | None |
| priority | int(11) | None |
| state | enum('OPENED','PROCESSING','PAUSED','CLOSED','ERROR','REPLAY','REPLAYING','REPLAYED','RETRY') | Part of KEY (state) |
| is_legacy_table | tinyint(4) | None |
| recieved_time | datetime | None |
| picked_time | datetime | Part of KEY (picked_time) |
| resume_from_id | int(11) | None |
| default_arguments | mediumtext | None |
| message_properties | mediumtext | None |
| queued_by | int(11) | None |
| last_updated_on | timestamp | Part of KEY (last_updated_on) |
| last_updated_by | int(11) | None |
Table: migration_run
migration_run| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| status | enum('OPEN','PROCESSING','CLOSED','ERROR') | None |
| last_migration_time | datetime | Part of KEY (last_migration_time) |
| type | enum('MIGRATE','REVERT') | None |
| last_updated | timestamp | None |
Table: migration_run_statistics
migration_run_statistics| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| run_id | int(11) | Part of UNIQUE KEY (run_id) |
| org_id | int(11) | Part of UNIQUE KEY (org_id) |
| campaign_count | int(11) | None |
| message_count | int(11) | None |
| no_of_affected_only_scheduler | int(11) | None |
| not_migrated_msg_q_ids | varchar(255) | None |
Table: reachability_channel_types
reachability_channel_types| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| channel | enum('MOBILE','EMAIL','WECHAT','ANDROID','IOS','LINE','VIBER') | None |
| last_updated_on | timestamp | None |
Table: group_custom_tags
group_custom_tags| Column Name | Data Type | Index |
|---|---|---|
| org_id | int(11) | None |
| group_version_id | int(10) | None |
| group_id | int(1) | None |
| custom_tag_count | varchar(1) | None |
Table: reloadable_group
reloadable_group| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of UNIQUE KEY (id) |
| org_id | int(11) | Part of UNIQUE KEY (org_id) |
| campaign_id | int(11) | None |
| group_id | int(11) | None |
| message_id | int(11) | Part of UNIQUE KEY (message_id) |
| is_campaign_active | tinyint(1) | None |
| is_message_active | tinyint(1) | None |
| auto_update_time | timestamp | None |
Table: reachability_job_details
reachability_job_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | None |
| group_id | int(11) | Part of KEY (group_id) |
| bucket_id | int(11) | None |
| campaign_id | int(11) | None |
| status | enum('OPEN','PROCESSING','CLOSED','ERROR') | None |
| recieved_time | datetime | Part of KEY (recieved_time) |
| start_time | datetime | None |
| end_time | datetime | Part of KEY (end_time) |
| expected_count | int(11) | None |
| processed_count | int(11) | None |
| submit_un_processed_to_wl | tinyint(1) | None |
| last_updated | timestamp | None |
Table: group_details
group_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| campaign_id | int(11) | Part of KEY (campaign_id) |
| uuid | varchar(255) | None |
| group_label | varchar(255) | None |
| description | text | None |
| created_date | datetime | None |
| org_id | int(11) | Part of KEY (org_id) |
| type | enum('CAMPAIGN_USERS','STICKY_GROUP','LOYALTY','TEST_GROUP','NON_LOYALTY','ALL','UPLOAD','FILTER_BASED','DERIVED','ORG_USERS','SPLIT','MERGE') | None |
| bucket_id | int(11) | None |
| group_tags | longtext | None |
| is_favourite | tinyint(4) | None |
| is_reloading | tinyint(1) | None |
| is_visible | tinyint(1) | Part of KEY (is_visible) |
| is_migrated | tinyint(1) | None |
| created_by | int(11) | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
| custom_tag_count | tinyint(1) | None |
| group_relation_params | text | None |
Table: reachability_batch_details
reachability_batch_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| job_id | int(11) | Part of KEY (job_id) |
| status | enum('OPEN','QUEUED','PROCESSING','CLOSED','ERROR') | Part of KEY (status) |
| start_index | int(11) | None |
| end_index | int(11) | None |
| start_time | datetime | None |
| end_time | datetime | None |
| expected_count | int(11) | None |
| processed_count | int(11) | None |
| wl_job_id | int(11) | Part of KEY (wl_job_id) |
| last_updated_on | timestamp | None |
Table: shard_details
shard_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| database_name | varchar(100) | None |
| shard_discription | varchar(100) | None |
| created_on | date | None |
| service_name | varchar(255) | None |
Table: reload_sync_details
reload_sync_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| sync_time | datetime | None |
| reload_time | datetime | None |
| created_date | datetime | None |
| auto_update_time | timestamp | None |
Table: group_reload_log
group_reload_log| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of PRIMARY KEY (org_id) |
| group_id | int(11) | None |
| start_date | datetime | None |
| end_date | datetime | None |
| status | enum('PROCESSING','CLOSED','ERROR') | None |
| error_message | text | None |
Table: reachability_status_mapping
reachability_status_mapping| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| label_id | int(11) | Part of KEY (label_id) |
| channel_id | int(11) | None |
| wl_status | varchar(100) | None |
| ss_status | varchar(100) | None |
| last_updated_on | timestamp | None |
Table: audience_v2_org_status
audience_v2_org_status| Column Name | Data Type | Index |
|---|---|---|
| org_id | int(11) | Part of PRIMARY KEY (org_id) |
| status | tinyint(1) | None |
| auto_update_time | timestamp | None |
Table: bucket_details
bucket_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| shard_id | int(11) | None |
| bucket_name | varchar(100) | None |
| hit_rate | int(11) | None |
| rows_count | int(11) | None |
| last_visited_on | date | None |
Table: group_version_details
group_version_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| campaign_id | int(11) | Part of KEY (campaign_id) |
| group_id | int(11) | Part of KEY (group_id) |
| bucket_id | int(11) | None |
| params | varchar(250) | None |
| target_type | enum('ALL','TEST','CONTROL','EXPERIMENT') | None |
| customer_count | int(11) | None |
| version_number | int(11) | None |
| status | enum('PREPARE','PROCESSING','ACTIVE','ERROR') | None |
| error_description | varchar(512) | None |
| is_active | tinyint(1) | Part of KEY (is_active) |
| test_control | enum('ORG','CUSTOM','SKIP') | Part of KEY (test_control) |
| test_percentage | int(11) | Part of KEY (test_percentage) |
| is_migrated | tinyint(1) | None |
| data_schema | varchar(250) | None |
| created_date | datetime | None |
| last_updated_by | int(11) | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
| group_users_s3_path | varchar(255) | None |
Table: campaign_audience_export_job
campaign_audience_export_job| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of PRIMARY KEY (org_id) |
| group_id | int(11) | None |
| group_version_id | int(11) | Part of UNIQUE KEY (group_version_id) |
| channel | enum('MOBILE','EMAIL','WECHAT','ANDROID','IOS','LINE','FACEBOOK','GOOGLE','VIBER','NONE') | Part of UNIQUE KEY (channel) |
| account_id | varchar(150) | Part of UNIQUE KEY (account_id) |
| status | enum('OPEN','VALIDATING','PROCESSING','ERROR','CLOSED') | None |
| file_url | varchar(1024) | None |
| params | varchar(1024) | None |
| created_on | datetime | None |
| auto_update_time | timestamp | None |
Table: create_audience_job_logs
create_audience_job_logs| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| job_id | int(11) | Part of KEY (job_id) |
| description | varchar(250) | None |
| status | enum('PROCESSING','SUCCESS','ERROR') | Part of KEY (status) |
| start_time | datetime | None |
| end_time | datetime | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: reachability_summary_report
reachability_summary_report| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| group_id | int(11) | Part of KEY (group_id) |
| job_id | int(11) | Part of KEY (job_id) |
| channel_id | int(11) | None |
| reachability_label_id | int(11) | None |
| count | int(11) | None |
| last_updated | timestamp | None |
Table: create_audience_job
create_audience_job| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| group_version_id | int(11) | Part of KEY (group_version_id) |
| uploaded_file_name | varchar(255) | None |
| status | enum('OPEN','VALIDATING','PROCESSING','ERROR','CLOSED') | None |
| total_upload_count | int(11) | None |
| error_count | int(11) | None |
| error_file_url | varchar(1024) | None |
| file_url | varchar(1024) | None |
| params | varchar(1024) | None |
| created_by | int(11) | None |
| created_on | datetime | None |
| auto_update_time | timestamp | None |
Table: reachability_category_labels
reachability_category_labels| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| category | enum('VALID','INVALID','UNSUBSCRIBED','HARDBOUNCED','SOFTBOUNCED','CONTACT_UNAVAILABLE','UNABLE_TO_VERIFY') | Part of UNIQUE KEY (category) |
| label | varchar(400) | None |
| reach_status_ids_csv | varchar(100) | None |
| last_updated_on | timestamp | None |
Table: campaign_hash_lookup
campaign_hash_lookup| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of UNIQUE KEY (org_id) |
| lookup_string | varchar(190) | Part of UNIQUE KEY (lookup_string) |
| auto_update_time | timestamp | None |
Table: group_event_subscription
group_event_subscription| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of UNIQUE KEY (org_id) |
| group_id | int(11) | Part of UNIQUE KEY (group_id) |
| event_type | enum('GROUP_RELOAD') | Part of UNIQUE KEY (event_type) |
| entity | varchar(64) | Part of UNIQUE KEY (entity) |
| entity_id | varchar(64) | Part of UNIQUE KEY (entity_id) |
| subscribed | tinyint(1) | None |
| params_json | varchar(500) | None |
| created_by | int(11) | None |
| created_date | datetime | None |
| last_updated_by | int(11) | None |
| auto_update_time | timestamp | None |
Updated 1 day ago