Physical DB: nsadmin
| Logical DB | Tables |
|---|---|
| emigran | versions.sql |
| log | comm_system_audit_logs.sql |
| darknight | email_status_log.sql |
| darknight | customer_communication_status.sql |
| darknight | client_type.sql |
| darknight | darknight_config_values.sql |
| darknight | job_info.sql |
| darknight | org_email.sql |
| darknight | mobile_segment_strategy.sql |
| darknight | email_status.sql |
| darknight | suppress_email.sql |
| darknight | darknight_config_keys.sql |
| darknight | suppress_log.sql |
| darknight | mobile_status.sql |
| nsadmin | bounced_email_unanalyzed.sql |
| nsadmin | credit_transaction_details.sql |
| nsadmin | credit_utilization_run_status.sql |
| nsadmin | email_sending_rules.sql |
| nsadmin | contact_info.sql |
| nsadmin | gateway_org_configs.sql |
| nsadmin | brand_poc_details.sql |
| nsadmin | credit_utilization_details.sql |
| nsadmin | gateways.sql |
| nsadmin | email_gateway_config.sql |
| nsadmin | message_status.sql |
| nsadmin | message_failure_summary.sql |
| nsadmin | users_ndnc_status.sql |
| nsadmin | org_payments_log.sql |
| nsadmin | cron_run_log.sql |
| nsadmin | credit_channel_details.sql |
| nsadmin | summary.sql |
| nsadmin | message_s3_archival.sql |
| nsadmin | domain_gateway_validation_log.sql |
| nsadmin | org_gateways.sql |
| nsadmin | utilization_meta_details.sql |
| nsadmin | bounced_email_report.sql |
| nsadmin | credit_chunk_details.sql |
| nsadmin | gateway_delivery_analysis.sql |
| nsadmin | data_archival_run.sql |
| nsadmin | config_values.sql |
| nsadmin | message_campaign_metatable.sql |
| nsadmin | client.sql |
| nsadmin | sms_channel_details.sql |
| nsadmin | countries.sql |
| nsadmin | archived_messages_metatable.sql |
| nsadmin | WECHAT_DLR_LOG.sql |
| nsadmin | tag_gateways.sql |
| nsadmin | bounced_email_list.sql |
| nsadmin | domain_properties_gateway_map.sql |
| nsadmin | org_gateways_price_details.sql |
| nsadmin | org_status.sql |
| nsadmin | org_sms_credits.sql |
| nsadmin | domain_properties.sql |
| nsadmin | gateway_not_found_summary.sql |
| nsadmin | mobilepush_messages.sql |
| nsadmin | contact_info_ou_mapping.sql |
| nsadmin | gateway_conn_configs.sql |
| nsadmin | message_wise_cost.sql |
| nsadmin | whatsapp_channel_details.sql |
| nsadmin | archived_table_suffix.sql |
| nsadmin | org_credit_supported_channel_details.sql |
| nsadmin | org_credit_rates.sql |
| nsadmin | sms_sending_rules.sql |
| nsadmin | config_keys.sql |
| nsadmin | org_regulation_status.sql |
| nsadmin | credits_log.sql |
| nsadmin | queue_config.sql |
| nsadmin | error_handlers.sql |
| nsadmin | org_credit_status_details.sql |
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: comm_system_audit_logs
comm_system_audit_logs| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| message_id | bigint(20) | Part of KEY (message_id) |
| action | varchar(255) | None |
| timestamp | timestamp | None |
| host | varchar(255) | None |
Table: email_status_log
email_status_log| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| varchar(100) | Part of KEY (email) | |
| verifier | varchar(100) | Part of KEY (verifier) |
| reason | text | None |
| status | enum('VALID','INVALID','UNKNOWN') | Part of KEY (status) |
| previous_status | enum('VALID','INVALID','UNKNOWN') | Part of KEY (previous_status) |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: customer_communication_status
customer_communication_status| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of UNIQUE KEY (org_id) |
| customer_id | int | Part of UNIQUE KEY (customer_id) |
| blocked_communication | tinyint(1) | None |
| last_updated_time | timestamp | Part of KEY (last_updated_time) |
Table: client_type
client_type| Column Name | Data Type | Index |
|---|---|---|
| id | tinyint(5) | Part of PRIMARY KEY (id) |
| type | varchar(20) | None |
Table: darknight_config_values
darknight_config_values| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| key_id | int(11) | None |
| org_id | int(11) | Part of PRIMARY KEY (org_id) |
| value | varchar(256) | None |
| is_active | tinyint(1) | None |
| created_by | int(11) | None |
| auto_update_time | timestamp | None |
Table: job_info
job_info| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| status | enum('NEW','SUBMITTED','PROCESSING','COMPLETED','FAILED','INQUEUE') | Part of KEY (status) |
| expected_count | bigint(10) | None |
| processed_count | bigint(10) | None |
| queued_time | timestamp | None |
| created_time | timestamp | None |
| channel | enum('EMAIL') | None |
| priority | enum('BULK','TRANS','CAMPAIGN') | None |
| client_id | varchar(30) | None |
| routing_key | varchar(30) | None |
| error_detail | varchar(1000) | None |
| error_code | int(10) | None |
| client_context_id | bigint(20) | Part of KEY (client_context_id) |
| client_type_id | tinyint(5) | Part of KEY (client_type_id) |
| org_id | int(11) | None |
Table: org_email
org_email| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| whitelisted_on | timestamp | None |
| verifier | enum('ROBIN','BRITE','GATEWAY','NONE') | None |
| email_id | varchar(100) | Part of KEY (email_id) |
| user_id | bigint(20) | Part of UNIQUE KEY (user_id) |
| job_id | bigint(20) | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: mobile_segment_strategy
mobile_segment_strategy| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| name | varchar(256) | None |
| strategy | varchar(500) | None |
| expiry_days | int(11) | None |
| is_reachable | tinyint(1) | None |
| created_date | datetime | None |
Table: email_status
email_status| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| varchar(100) | Part of UNIQUE KEY (email) | |
| status | enum('VALID','INVALID','UNKNOWN') | Part of KEY (status) |
| verifier | enum('ROBIN','BRITE','GATEWAY') | None |
| hard_bounce_count | tinyint(8) | None |
| soft_bounce_count | tinyint(8) | None |
| success_count | int(10) | None |
| failed_count | tinyint(9) | None |
| last_success_on | timestamp | None |
| last_failed_on | timestamp | None |
| last_status_changed | timestamp | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: suppress_email
suppress_email| Column Name | Data Type | Index |
|---|---|---|
| varchar(100) | Part of PRIMARY KEY (email) |
Table: darknight_config_keys
darknight_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: suppress_log
suppress_log| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| varchar(100) | Part of KEY (email) | |
| verifier | varchar(100) | Part of KEY (verifier) |
| reason | text | None |
| status | enum('VALID','INVALID','UNKNOWN') | Part of KEY (status) |
| previous_status | enum('VALID','INVALID','UNKNOWN') | Part of KEY (previous_status) |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: mobile_status
mobile_status| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| mobile | bigint(20) | Part of UNIQUE KEY (mobile) |
| segment_id | int(11) | None |
| delivery_stats | varchar(256) | None |
| last_success_on | datetime | None |
| last_failed_on | datetime | None |
| auto_update_time | timestamp | None |
Table: bounced_email_unanalyzed
bounced_email_unanalyzed| Column Name | Data Type | Index |
|---|---|---|
| imap_uid | bigint(20) | Part of KEY (imap_uid) |
| reason | enum('notabounce','couldntparse') | None |
Table: credit_transaction_details
credit_transaction_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| credit_count | double | None |
| transaction_date | datetime | Part of KEY (transaction_date) |
| transaction_type | enum('ADDED','REMOVED','EXPIRED','ADJUSTED') | Part of KEY (transaction_type) |
| credit_chunk_details_id | int(11) | Part of KEY (credit_chunk_details_id) |
| comments | varchar(255) | None |
| created_by | int(11) | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
| transaction_uuid | varchar(50) | None |
Table: credit_utilization_run_status
credit_utilization_run_status| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| start_date | datetime | Part of UNIQUE KEY (start_date) |
| end_date | datetime | Part of UNIQUE KEY (end_date) |
| status | enum('OPEN','ERROR','PROCESSING','CLOSED','UTILIZED') | None |
| error_message | varchar(255) | None |
| auto_update_time | timestamp | None |
Table: email_sending_rules
email_sending_rules| Column Name | Data Type | Index |
|---|---|---|
| varchar(50) | Part of UNIQUE KEY (email) | |
| org_id | bigint(20) | Part of UNIQUE KEY (org_id) |
| sending_rule | enum('ALL','NOBULK','NOPERSONALIZED','NONE','UNSUBSCRIBE') | None |
Table: contact_info
contact_info| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| domain_prop_id | int(11) | Part of KEY (domain_prop_id) |
| org_id | int(11) | Part of KEY (org_id) |
| org_entity_id | int(11) | None |
| org_entity_type | varchar(50) | None |
| message_class | enum('SMS','EMAIL','WECHAT','VOICECALL','LINE','WHATSAPP','RCS','ZALO','VIBER') | Part of KEY (message_class) |
| type | varchar(50) | None |
| label | varchar(50) | None |
| value | varchar(255) | None |
| description | mediumtext | None |
| is_valid | tinyint(1) | None |
| is_default | tinyint(1) | None |
| auto_update_time | timestamp | None |
Table: gateway_org_configs
gateway_org_configs| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | None |
| short_name | varchar(50) | Part of KEY (short_name) |
| host_name | varchar(25) | None |
| full_name | varchar(100) | None |
| username | varchar(50) | None |
| password | varchar(100) | None |
| connection_properties | mediumtext | None |
| service_ip | varchar(100) | None |
| service_url | varchar(500) | None |
| status_check_url | varchar(500) | None |
| message_class | enum('SMS','EMAIL','WECHAT','ANDROID','IOS','VOICECALL','LINE','VIBER', | None |
| message_priority | enum('HIGH','DEFAULT','BULK') | None |
| channel_count | int(4) | None |
| status | enum('ACTIVE','INACTIVE','DISABLED') | Part of KEY (status) |
| is_private | tinyint(1) | None |
| status_check_type | enum('PULL','PUSH','NONE') | Part of KEY (status_check_type) |
| properties | mediumtext | None |
| start_time | datetime | None |
| end_time | datetime | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: brand_poc_details
brand_poc_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| created_by | double | None |
| auto_update_time | timestamp | None |
| user_id | int(11) | None |
Table: credit_utilization_details
credit_utilization_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| org_credit_rates_id | int(11) | Part of KEY (org_credit_rates_id) |
| credit_count | double | None |
| transaction_type | enum('UTILIZED') | None |
| transaction_date | datetime | Part of KEY (transaction_date) |
| utilization_date | datetime | None |
| credit_chunk_details_id | int(11) | Part of KEY (credit_chunk_details_id) |
| utilization_meta_details_id | int(11) | Part of KEY (utilization_meta_details_id) |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
| transaction_uuid | varchar(50) | Part of KEY (transaction_uuid) |
Table: gateways
gateways| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| host_name | varchar(25) | Part of KEY (host_name) |
| short_name | varchar(50) | Part of UNIQUE KEY (short_name) |
| full_name | varchar(100) | None |
| username | varchar(50) | None |
| password | varchar(100) | None |
| connection_properties | mediumtext | None |
| service_url | varchar(500) | None |
| status_check_url | varchar(500) | None |
| message_class | enum('SMS','EMAIL','WECHAT','LINE') | None |
| message_priority | enum('HIGH','DEFAULT','BULK') | None |
| channel_count | int(3) | None |
| status | enum('ACTIVE','INACTIVE','DISABLED') | Part of KEY (status) |
| status_check_type | enum('PULL','PUSH','NONE') | Part of KEY (status_check_type) |
| properties | mediumtext | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: email_gateway_config
email_gateway_config| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| short_name | varchar(50) | None |
| username | varchar(50) | None |
| password | varchar(100) | None |
| added_on | datetime | None |
Table: message_status
message_status| Column Name | Data Type | Index |
|---|---|---|
| id | smallint(6) | None |
| status | varchar(50) | None |
| chargeable_type | enum('CHARGEABLE','NOT_CHARGEABLE') | None |
Table: message_failure_summary
message_failure_summary| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| gateway | varchar(255) | Part of UNIQUE KEY (gateway) |
| sending_org_id | int(11) | Part of UNIQUE KEY (sending_org_id) |
| message_class | enum('SMS','EMAIL') | Part of UNIQUE KEY (message_class) |
| message_priority | enum('HIGH','DEFAULT','BULK') | Part of UNIQUE KEY (message_priority) |
| campaign_id | int(11) | Part of UNIQUE KEY (campaign_id) |
| client_id | bigint(20) | Part of UNIQUE KEY (client_id) |
| date | date | Part of UNIQUE KEY (date) |
| failure_reason | varchar(160) | Part of UNIQUE KEY (failure_reason) |
| message_count | int(11) | None |
Table: users_ndnc_status
users_ndnc_status| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| user_id | bigint(20) | Part of UNIQUE KEY (user_id) |
| org_id | int(11) | Part of UNIQUE KEY (org_id) |
| mobile | varchar(15) | Part of UNIQUE KEY (mobile) |
| status | enum('NDNC','INVALID','DND','UNKNOWN') | None |
| added_on | datetime | None |
| updated_on | datetime | None |
Table: org_payments_log
org_payments_log| Column Name | Data Type | Index |
|---|---|---|
| id | int(10) | Part of PRIMARY KEY (id) |
| org_id | int(10) | None |
| payment_amount | int(11) | None |
| added_by | int(11) | None |
| added_on | date | None |
| comments | text | None |
| is_deleted | int(1) | None |
Table: cron_run_log
cron_run_log| Column Name | Data Type | Index |
|---|---|---|
| id | int(20) | Part of PRIMARY KEY (id) |
| cron_type | enum('CREDIT_UTILIZATION', | Part of KEY (cron_type) |
| run_date | date | None |
| cron_start_time | datetime | None |
| cron_end_time | datetime | None |
| status | enum('OPEN', | Part of KEY (status) |
| error_message | longtext | None |
| auto_update_time | timestamp | None |
Table: credit_channel_details
credit_channel_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| channel | enum('SMS','EMAIL','ANDROID','IOS','WHATSAPP','WECHAT','LINE', | Part of UNIQUE KEY (channel) |
| priority_type | enum('HIGH','BULK') | Part of UNIQUE KEY (priority_type) |
| channel_details_id | int(11) | Part of UNIQUE KEY (channel_details_id) |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: summary
summary| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| sending_org_id | int(11) | Part of KEY (sending_org_id) |
| message_priority | enum('HIGH','DEFAULT','BULK') | Part of KEY (message_priority) |
| gateway | varchar(255) | Part of KEY (gateway) |
| date | date | Part of KEY (date) |
| message_class | enum('SMS','EMAIL','WECHAT','ANDROID','IOS') | Part of KEY (message_class) |
| campaign_id | int(11) | Part of UNIQUE KEY (campaign_id) |
| client_id | bigint(20) | Part of UNIQUE KEY (client_id) |
| message_status | smallint(6) | Part of KEY (message_status) |
| message_count | int(11) | None |
| auto_update_time | timestamp | None |
Table: message_s3_archival
message_s3_archival| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| nsadmin_start_id | bigint(20) | Part of KEY (nsadmin_start_id) |
| nsadmin_end_id | bigint(20) | Part of KEY (nsadmin_end_id) |
| s3_path | varchar(512) | None |
| messages_start_time | datetime | None |
| messages_end_time | datetime | None |
| run_id | bigint(20) | None |
| is_active | tinyint(1) | None |
| auto_update_time | timestamp | None |
Table: domain_gateway_validation_log
domain_gateway_validation_log| Column Name | Data Type | Index |
|---|---|---|
| domain_gateway_map_id | int(11) | Part of KEY (domain_gateway_map_id) |
| domain_prop_id | int(11) | Part of KEY (domain_prop_id) |
| status | varchar(20) | None |
| gateway_id | int(11) | Part of KEY (gateway_id) |
| org_id | int(11) | Part of KEY (org_id) |
| is_manually_triggered | tinyint(1) | None |
| details | mediumtext | None |
| triggered_by | int(11) | None |
| validation_time | timestamp | None |
| id | int(11) | Part of PRIMARY KEY (id) |
Table: org_gateways
org_gateways| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of PRIMARY KEY (org_id) |
| gateway | varchar(50) | None |
| service_ip | varchar(100) | None |
| msg_priority | enum('HIGH','DEFAULT','BULK') | None |
| weight | int(3) | None |
| campaign_id | bigint(20) | None |
| effective_start_time | datetime | None |
| effective_end_time | datetime | None |
| added_by | int(11) | None |
| added_on | datetime | None |
| is_default | tinyint(1) | None |
| is_valid | tinyint(1) | None |
| is_whitelisting_gateway | tinyint(1) | None |
| subscription_parameters | text | None |
Table: utilization_meta_details
utilization_meta_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| client_id | int(11) | Part of UNIQUE KEY (client_id) |
| reference_id | int(11) | Part of UNIQUE KEY (reference_id) |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: bounced_email_report
bounced_email_report| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| imap_uid | bigint(20) | None |
| varchar(100) | None | |
| date | timestamp | None |
| smtp_code | varchar(30) | None |
| std_reason | varchar(30) | None |
Table: credit_chunk_details
credit_chunk_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of PRIMARY KEY (org_id) |
| order_number | varchar(255) | None |
| credit_chunk_balance | double | None |
| expiry_date | datetime | Part of KEY (expiry_date) |
| auto_update_time | timestamp | None |
Table: gateway_delivery_analysis
gateway_delivery_analysis| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| gateway | varchar(50) | Part of UNIQUE KEY (gateway) |
| delivery_date | date | Part of UNIQUE KEY (delivery_date) |
| total_count | int(11) | None |
| delivery_report_recieved | int(11) | None |
| five_sec_delivery | int(11) | None |
| ten_sec_delivery | int(11) | None |
| thirty_sec_delivery | int(11) | None |
| sixty_sec_delivery | int(11) | None |
| sixtysecplus_delivery | int(11) | None |
| auto_update_time | timestamp | None |
Table: data_archival_run
data_archival_run| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| nsadmin_start_id | bigint(20) | None |
| nsadmin_end_id | bigint(20) | None |
| run_date | date | None |
| execution_start | datetime | None |
| execution_end | datetime | None |
| status | enum('OPEN','PROCESSING','PREV_TABLE_PROCESSING','CLOSED') | None |
| auto_update_time | timestamp | None |
Table: config_values
config_values| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| key_id | int(11) | None |
| org_id | int(11) | Part of PRIMARY KEY (org_id) |
| value | varchar(256) | None |
| is_active | tinyint(1) | None |
| created_by | int(11) | None |
| auto_update_time | timestamp | None |
Table: message_campaign_metatable
message_campaign_metatable| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | None |
| table_name | varchar(50) | Part of UNIQUE KEY (table_name) |
| org_id | int(11) | Part of UNIQUE KEY (org_id) |
| campaign_id | int(11) | Part of UNIQUE KEY (campaign_id) |
| min_inbox_id | int(11) | None |
| max_inbox_id | int(11) | None |
| last_message_date | datetime | None |
Table: client
client| Column Name | Data Type | Index |
|---|---|---|
| id | INT(11) | Part of PRIMARY KEY (id) |
| code | VARCHAR(50) | None |
| name | VARCHAR(100) | None |
| description | VARCHAR(255) | None |
| status_updates_enabled | BOOLEAN | None |
Table: sms_channel_details
sms_channel_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| country_code | int(11) | None |
| auto_update_time | timestamp | None |
Table: countries
countries| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| name | varchar(100) | Part of UNIQUE KEY (name) |
| capital | varchar(100) | None |
| code | varchar(2) | None |
| short_name | varchar(3) | None |
| numeric_code | int(11) | None |
| iso_name | varchar(100) | None |
| mobile_country_code | varchar(5) | None |
| mobile_regex | varchar(250) | None |
| mobile_length_csv | varchar(255) | None |
| last_updated_by | int(11) | None |
| last_updated | datetime | None |
Table: archived_messages_metatable
archived_messages_metatable| Column Name | Data Type | Index |
|---|---|---|
| table_name | varchar(50) | Part of UNIQUE KEY (table_name) |
| start_date | datetime | None |
| end_date | datetime | None |
| first_message_id | bigint(20) | None |
| last_message_id | bigint(20) | None |
| is_available | tinyint(1) | None |
Table: WECHAT_DLR_LOG
WECHAT_DLR_LOG| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| campaign_id | bigint(20) | Part of KEY (campaign_id) |
| org_id | int(11) | Part of KEY (org_id) |
| msg_id | varchar(20) | Part of KEY (msg_id) |
| status | varchar(10) | None |
| totalCount | int(7) | None |
| filterCount | int(7) | None |
| sentCount | int(7) | None |
| errorCount | int(7) | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: tag_gateways
tag_gateways| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| tag_name | varchar(25) | None |
| gateway | varchar(50) | None |
| weight | int(3) | None |
| effective_start_time | datetime | None |
| effective_end_time | datetime | None |
| added_by | int(11) | None |
| added_on | datetime | None |
| is_valid | tinyint(1) | None |
Table: bounced_email_list
bounced_email_list| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| varchar(100) | Part of UNIQUE KEY (email) | |
| hard | tinyint(8) | None |
| soft | tinyint(8) | None |
| temp | tinyint(8) | None |
| unknown | tinyint(8) | None |
| created | timestamp | Part of KEY (created) |
| lastcreated | timestamp | Part of KEY (lastcreated) |
Table: org_gateways_price_details
org_gateways_price_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | None |
| gateway | varchar(255) | None |
| short_name | varchar(255) | None |
| price | double | None |
| currency | varchar(3) | None |
| country | varchar(45) | None |
| effective_date | date | None |
| valid_till | date | None |
| auto_update_time | timestamp | None |
Table: org_status
org_status| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | bigint(11) | Part of PRIMARY KEY (org_id) |
| is_active | tinyint(1) | None |
| rate_limit_threshold | int(11) | None |
| updated_by | bigint(20) | None |
| updated_at | datetime | None |
| is_valid | tinyint(1) | None |
Table: org_sms_credits
org_sms_credits| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| org_id | bigint(20) | Part of UNIQUE KEY (org_id) |
| message_class | enum('SMS','EMAIL','WECHAT','ANDROID','IOS','VOICECALL','LINE') | Part of UNIQUE KEY (message_class) |
| value_sms_credits | int(11) | None |
| bulk_sms_credits | int(11) | None |
| user_credits | int(11) | None |
| bulk_credits_threshold | int(11) | None |
| value_credits_threshold | int(11) | None |
| created_by | bigint(20) | None |
| last_updated_by | bigint(20) | None |
Table: domain_properties
domain_properties| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| org_entity_id | int(11) | None |
| org_entity_type | varchar(50) | None |
| name | varchar(50) | Part of KEY (name) |
| description | mediumtext | None |
| auto_update_time | timestamp | None |
Table: gateway_not_found_summary
gateway_not_found_summary| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| gateway | varchar(255) | Part of UNIQUE KEY (gateway) |
| sending_org_id | int(11) | Part of UNIQUE KEY (sending_org_id) |
| message_class | enum('SMS','EMAIL') | Part of UNIQUE KEY (message_class) |
| message_priority | enum('HIGH','DEFAULT','BULK') | Part of UNIQUE KEY (message_priority) |
| campaign_id | int(11) | Part of UNIQUE KEY (campaign_id) |
| client_id | bigint(20) | Part of UNIQUE KEY (client_id) |
| date | date | Part of UNIQUE KEY (date) |
| gtw_not_found_reason | varchar(160) | Part of UNIQUE KEY (gtw_not_found_reason) |
| message_count | int(11) | None |
Table: mobilepush_messages
mobilepush_messages| Column Name | Data Type | Index |
|---|---|---|
| id | bigint(20) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| nsadmin_id | bigint(20) | Part of UNIQUE KEY (nsadmin_id) |
| cuid | varchar(255) | Part of KEY (cuid) |
| license_code | varchar(255) | Part of KEY (license_code) |
| auto_update_time | timestamp | None |
Table: contact_info_ou_mapping
contact_info_ou_mapping| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| contact_info_id | int(11) | None |
| org_id | int(11) | Part of KEY (org_id) |
| ou_id | int(11) | Part of KEY (ou_id) |
| is_valid | tinyint(1) | None |
| is_default | tinyint(1) | None |
Table: gateway_conn_configs
gateway_conn_configs| Column Name | Data Type | Index |
|---|---|---|
| host_name | varchar(25) | Part of PRIMARY KEY (host_name) |
| config | mediumtext | None |
| is_host_telecom_regulated | tinyint(1) | None |
Table: message_wise_cost
message_wise_cost| Column Name | Data Type | Index |
|---|---|---|
| nsadmin_id | bigint(20) | Part of PRIMARY KEY (nsadmin_id) |
| receiver | varchar(255) | None |
| call_duration | int(5) | None |
| total_cost | float(8,4) | None |
| auto_update_time | timestamp | None |
Table: whatsapp_channel_details
whatsapp_channel_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| country_code | int(11) | None |
| auto_update_time | timestamp | None |
Table: archived_table_suffix
archived_table_suffix| Column Name | Data Type | Index |
|---|---|---|
| table_name | varchar(50) | Part of UNIQUE KEY (table_name) |
| start_date | datetime | None |
| end_date | datetime | None |
| first_message_id | bigint(20) | None |
| last_message_id | bigint(20) | None |
| is_available | tinyint(1) | None |
Table: org_credit_supported_channel_details
org_credit_supported_channel_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of UNIQUE KEY (org_id) |
| channel | enum('SMS','EMAIL','ANDROID','IOS','WHATSAPP','WECHAT','LINE', | Part of UNIQUE KEY (channel) |
| org_base_country_id | int(6) | None |
| auto_update_time | timestamp | None |
Table: org_credit_rates
org_credit_rates| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of KEY (org_id) |
| credit_channel_details_id | int(11) | None |
| credit_rate | double | None |
| effective_date | datetime | Part of KEY (effective_date) |
| expiry_date | datetime | Part of KEY (expiry_date) |
| comments | varchar(255) | None |
| created_date | datetime | None |
| created_by | int(11) | None |
| auto_update_time | timestamp | Part of KEY (auto_update_time) |
Table: sms_sending_rules
sms_sending_rules| Column Name | Data Type | Index |
|---|---|---|
| mobile_number | varchar(20) | Part of UNIQUE KEY (mobile_number) |
| org_id | bigint(20) | Part of UNIQUE KEY (org_id) |
| sending_rule | enum('ALL','NOBULK','NOPERSONALIZED','NONE','UNSUBSCRIBE') | None |
Table: config_keys
config_keys| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| key | varchar(256) | None |
| default_value | varchar(256) | None |
| auto_update_time | timestamp | None |
Table: org_telecom_regulation_status
org_telecom_regulation_status| Column Name | Data Type | Index |
|---|---|---|
| org_id | int(11) | Part of PRIMARY KEY (org_id) |
| org_unit_id | int(11) | Part of PRIMARY KEY (org_unit_id) |
| type | enum('DLT') | None |
| status | tinyint(1) | None |
| entity_id | varchar(64) | None |
| auto_update_time | timestamp | None |
Table: credits_log
credits_log| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | bigint(20) | Part of PRIMARY KEY (org_id) |
| message_class | enum('SMS','EMAIL','WECHAT','ANDROID','IOS','VOICECALL','LINE') | None |
| value_sms_credits | int(11) | None |
| bulk_sms_credits | int(11) | None |
| user_credits | int(11) | None |
| created_by | bigint(20) | None |
| added | timestamp | Part of KEY (added) |
| comments | text | None |
| is_deleted | int(1) | None |
Table: queue_config
queue_config| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| exchange_name | varchar(50) | None |
| queue_name | enum('DELAYED_SCHEDULED','RECEIVED','READ','FINAL_STATE_TRANS','FINAL_STATE_BULK') | None |
| queue_type | enum('SEDA','RABBITMQ') | None |
| properties | mediumtext | None |
| is_active | bit(1) | None |
| created_on | datetime | None |
Table: error_handlers
error_handlers| Column Name | Data Type | Index |
|---|---|---|
| id | int(10) | Part of PRIMARY KEY (id) |
| host_name | varchar(50) | Part of UNIQUE KEY (host_name) |
| error_code | varchar(15) | Part of UNIQUE KEY (error_code) |
| error_handler | enum('CREDIT_EXPIRED','HTTP_TIMEOUT','INCORRECT_AUTH','INVALID_DEST','INVALID_ENC','INVALID_HTTP_RESP','INVALID_MSG','INVALID_MSG_ID','INVALID_SNDR','INVALID_SMS_LEN','NDNC','SRVC_UNAVL','FAIL_XML_PARSE','MSG_RETRY') | None |
| error_desc | varchar(100) | None |
Table: org_credit_status_details
org_credit_status_details| Column Name | Data Type | Index |
|---|---|---|
| id | int(11) | Part of PRIMARY KEY (id) |
| org_id | int(11) | Part of UNIQUE KEY (org_id) |
| credit_balance | double | None |
| threshold_credits | double | None |
| auto_update_time | timestamp | None |
| credit_management_enabled | tinyint(1) | None |
| last_utilized_date | datetime | Part of KEY (last_utilized_date) |
Updated 1 day ago