Physical DB: billdump

Logical Database name	Tables	Path for query
Temp	bill_test_temp_table.sql	billdump.Temp.bill_test_temp_table
emf_replay	emf_event_logs.sql	billdump.emf_replay.emf_event_logs
emf_replay	emf_event_logs_new.sql	billdump.emf_replay.emf_event_logs_new
emf_replay	emf_replay_logs.sql	billdump.emf_replay.emf_replay_logs
subscription_management	merge_customer_summary.sql	billdump.subscription_management.merge_customer_summary
subscription_management	subscription_import_files_history.sql	billdump.subscription_management.subscription_import_files_history
subscription_management	supported_tags.sql	billdump.subscription_management.supported_tags
subscription_management	users_govt_status_log.sql	billdump.subscription_management.users_govt_status_log
subscription_management	gateway_param_values.sql	billdump.subscription_management.gateway_param_values
subscription_management	nsadmin_skipped_logs.sql	billdump.subscription_management.nsadmin_skipped_logs
subscription_management	email_params.sql	billdump.subscription_management.email_params
subscription_management	merge_status_log.sql	billdump.subscription_management.merge_status_log
subscription_management	user_feedback.sql	billdump.subscription_management.user_feedback
subscription_management	users_external_status.sql	billdump.subscription_management.users_external_status
subscription_management	users_govt_status.sql	billdump.subscription_management.users_govt_status
subscription_management	nsadmin_communication_logs.sql	billdump.subscription_management.nsadmin_communication_logs
subscription_management	rule_param_mappings.sql	billdump.subscription_management.rule_param_mappings
subscription_management	subscription_services.sql	billdump.subscription_management.subscription_services
subscription_management	campaign_veneno_tracker.sql	billdump.subscription_management.campaign_veneno_tracker
subscription_management	subscription_rules_history.sql	billdump.subscription_management.subscription_rules_history
subscription_management	sms_params.sql	billdump.subscription_management.sms_params
subscription_management	sms_params_logs.sql	billdump.subscription_management.sms_params_logs
subscription_management	user_subscription_status_log.sql	billdump.subscription_management.user_subscription_status_log
subscription_management	user_subscription_status.sql	billdump.subscription_management.user_subscription_status
subscription_management	user_campaign_subscriptions.sql	billdump.subscription_management.user_campaign_subscriptions
subscription_management	supported_channels.sql	billdump.subscription_management.supported_channels
subscription_management	org_param_values.sql	billdump.subscription_management.org_param_values
subscription_management	subscription_scopes.sql	billdump.subscription_management.subscription_scopes
subscription_management	default_content.sql	billdump.subscription_management.default_content
subscription_management	org_gateways_mapping.sql	billdump.subscription_management.org_gateways_mapping
subscription_management	subscription_rules.sql	billdump.subscription_management.subscription_rules
subscription_management	email_params_logs.sql	billdump.subscription_management.email_params_logs
product_management	inventory_item_attributes.sql	billdump.product_management.inventory_item_attributes
product_management	org_colors.sql	billdump.product_management.org_colors
product_management	inventory_masters.sql	billdump.product_management.inventory_masters
product_management	categories.sql	billdump.product_management.categories
product_management	sizes.sql	billdump.product_management.sizes
product_management	inventory_returnable.sql	billdump.product_management.inventory_returnable
product_management	brands.sql	billdump.product_management.brands
product_management	colors.sql	billdump.product_management.colors
product_management	meta_sizes.sql	billdump.product_management.meta_sizes
product_management	styles.sql	billdump.product_management.styles
points_checker	pa_tree_imbalance.sql	billdump.points_checker.pa_tree_imbalance
emigran	versions.sql	billdump.emigran.versions
file_services	namespaces.sql	billdump.file_services.namespaces
file_services	files_tags_map.sql	billdump.file_services.files_tags_map
file_services	tags.sql	billdump.file_services.tags
file_services	audit_logs.sql	billdump.file_services.audit_logs
file_services	files_delete_log.sql	billdump.file_services.files_delete_log
file_services	versions.sql	billdump.file_services.versions
file_services	files.sql	billdump.file_services.files
file_services	tag_values.sql	billdump.file_services.tag_values
performance_logs	intouch_ke_api_logs.sql	billdump.performance_logs.intouch_ke_api_logs
performance_logs	store_server_till_reports.sql	billdump.performance_logs.store_server_till_reports
performance_logs	store_server_bulk_upload.sql	billdump.performance_logs.store_server_bulk_upload
performance_logs	async_message_api_requests.sql	billdump.performance_logs.async_message_api_requests
performance_logs	api_hit_table.sql	billdump.performance_logs.api_hit_table
performance_logs	store_server_wcf_report.sql	billdump.performance_logs.store_server_wcf_report
performance_logs	till_diagnostics_system_info.sql	billdump.performance_logs.till_diagnostics_system_info
performance_logs	till_diagnostics_sync_report.sql	billdump.performance_logs.till_diagnostics_sync_report
performance_logs	store_server_health.sql	billdump.performance_logs.store_server_health
performance_logs	store_server_sync_logs.sql	billdump.performance_logs.store_server_sync_logs
performance_logs	store_server_sql_svr_health.sql	billdump.performance_logs.store_server_sql_svr_health
performance_logs	api_summary_table.sql	billdump.performance_logs.api_summary_table
performance_logs	till_error_report.sql	billdump.performance_logs.till_error_report
performance_logs	till_diagnostics_bulk_upload.sql	billdump.performance_logs.till_diagnostics_bulk_upload
performance_logs	till_diagnostics.sql	billdump.performance_logs.till_diagnostics
performance_logs	extended_properties.sql	billdump.performance_logs.extended_properties
performance_logs	api_user_agents.sql	billdump.performance_logs.api_user_agents

Table: `bill_test_temp_table`

Column Name	Data Type	Index
id	INT(11)	PRIMARY KEY (id)
name	VARCHAR(255)	None
created_at	DATETIME	None

Table: `emf_event_logs`

Column Name	Data Type	Index
event_id	BIGINT(20)	PRIMARY KEY (event_id)
event_name	VARCHAR(255)	None
event_time	TIMESTAMP	None

Table: `emf_event_logs_new`

Column Name	Data Type	Index
event_id	BIGINT(20)	PRIMARY KEY (event_id)
user_id	BIGINT(20)	None
event_type	VARCHAR(255)	None
created_at	DATETIME	None

Table: `emf_replay_logs`

Column Name	Data Type	Index
replay_id	BIGINT(20)	PRIMARY KEY (replay_id)
status	VARCHAR(50)	None
timestamp	TIMESTAMP	None

Table: `merge_customer_summary`

Column Name	Data Type	Index
customer_id	BIGINT(20)	PRIMARY KEY (customer_id)
summary_data	TEXT	None
updated_at	DATETIME	None

Table: `subscription_import_files_history`

Column Name	Data Type	Index
file_id	BIGINT(20)	PRIMARY KEY (file_id)
file_name	VARCHAR(255)	None
imported_at	DATETIME	None

Table: `supported_tags`

Column Name	Data Type	Index
tag_id	INT(11)	PRIMARY KEY (tag_id)
tag_name	VARCHAR(100)	None

Table: `users_govt_status_log`

Column Name	Data Type	Index
log_id	BIGINT(20)	PRIMARY KEY (log_id)
user_id	BIGINT(20)	None
status	VARCHAR(50)	None
updated_on	TIMESTAMP	None

Table: `gateway_param_values`

Column Name	Data Type	Index
param_id	INT(11)	PRIMARY KEY (param_id)
gateway_name	VARCHAR(255)	None
param_value	TEXT	None

Table: `nsadmin_skipped_logs`

Column Name	Data Type	Index
skipped_id	BIGINT(20)	PRIMARY KEY (skipped_id)
reason	VARCHAR(255)	None
created_at	DATETIME	None

Table: `email_params`

Column Name	Data Type	Index
param_id	INT(11)	PRIMARY KEY (param_id)
email_type	VARCHAR(100)	None
template	TEXT	None

Table: `merge_status_log`

Column Name	Data Type	Index
log_id	BIGINT(20)	PRIMARY KEY (log_id)
status	VARCHAR(50)	None
updated_at	TIMESTAMP	None

Table: `user_feedback`

Column Name	Data Type	Index
feedback_id	BIGINT(20)	PRIMARY KEY (feedback_id)
user_id	BIGINT(20)	None
feedback_text	TEXT	None
submitted_on	DATETIME	None

Table: `users_external_status`

Column Name	Data Type	Index
external_id	BIGINT(20)	PRIMARY KEY (external_id)
user_id	BIGINT(20)	None
external_status	VARCHAR(100)	None

Table: `users_govt_status`

Column Name	Data Type	Index
user_id	BIGINT(20)	PRIMARY KEY (user_id)
govt_status	VARCHAR(100)	None
verified_on	TIMESTAMP	None

Table: `nsadmin_communication_logs`

Column Name	Data Type	Index
comm_id	BIGINT(20)	PRIMARY KEY (comm_id)
message	TEXT	None
sent_on	TIMESTAMP	None

Table: `rule_param_mappings`

Column Name	Data Type	Index
mapping_id	BIGINT(20)	PRIMARY KEY (mapping_id)
rule_id	BIGINT(20)	None
param_key	VARCHAR(255)	None
param_value	TEXT	None

Table: `subscription_services`

Column Name	Data Type	Index
service_id	BIGINT(20)	PRIMARY KEY (service_id)
service_name	VARCHAR(255)	None
active	TINYINT(1)	None

Table: `campaign_veneno_tracker`

Column Name	Data Type	Index
tracker_id	BIGINT(20)	PRIMARY KEY (tracker_id)
campaign_id	BIGINT(20)	None
event_logged_at	DATETIME	None

Table: `subscription_rules_history`

Column Name	Data Type	Index
history_id	BIGINT(20)	PRIMARY KEY (history_id)
rule_id	BIGINT(20)	None
changed_at	DATETIME	None

Table: `sms_params`

Column Name	Data Type	Index
param_id	INT(11)	PRIMARY KEY (param_id)
sms_type	VARCHAR(100)	None
template	TEXT	None

Table: `sms_params_logs`

Column Name	Data Type	Index
log_id	BIGINT(20)	PRIMARY KEY (log_id)
sms_type	VARCHAR(100)	None
template_snapshot	TEXT	None
logged_on	TIMESTAMP	None

Table: `user_subscription_status_log`

Column Name	Data Type	Index
log_id	BIGINT(20)	PRIMARY KEY (log_id)
user_id	BIGINT(20)	None
status	VARCHAR(50)	None
updated_at	TIMESTAMP	None

Table: `user_subscription_status`

Column Name	Data Type	Index
user_id	BIGINT(20)	PRIMARY KEY (user_id)
subscription_status	VARCHAR(50)	None
last_updated	TIMESTAMP	None

Table: `user_campaign_subscriptions`

Column Name	Data Type	Index
subscription_id	BIGINT(20)	PRIMARY KEY (subscription_id)
user_id	BIGINT(20)	None
campaign_id	BIGINT(20)	None

Table: `supported_channels`

Column Name	Data Type	Index
channel_id	INT(11)	PRIMARY KEY (channel_id)
channel_name	VARCHAR(100)	None

Table: `org_param_values`

Column Name	Data Type	Index
param_id	INT(11)	PRIMARY KEY (param_id)
org_id	BIGINT(20)	None
param_key	VARCHAR(255)	None
param_value	TEXT	None

Table: `subscription_scopes`

Column Name	Data Type	Index
scope_id	INT(11)	PRIMARY KEY (scope_id)
scope_name	VARCHAR(100)	None

Table: `default_content`

Column Name	Data Type	Index
content_id	INT(11)	PRIMARY KEY (content_id)
content_key	VARCHAR(255)	None
content_value	TEXT	None

Table: `org_gateways_mapping`

Column Name	Data Type	Index
mapping_id	INT(11)	PRIMARY KEY (mapping_id)
org_id	BIGINT(20)	None
gateway_name	VARCHAR(255)	None

Table: `inventory_item_attributes`

Column Name	Data Type	Index
attribute_id	INT(11)	PRIMARY KEY (attribute_id)
item_id	BIGINT(20)	None
attribute_name	VARCHAR(255)	None
attribute_value	VARCHAR(255)	None

Table: `org_colors`

Column Name	Data Type	Index
color_id	INT(11)	PRIMARY KEY (color_id)
org_id	BIGINT(20)	None
color_name	VARCHAR(100)	None

Table: `inventory_masters`

Column Name	Data Type	Index
inventory_id	BIGINT(20)	PRIMARY KEY (inventory_id)
item_code	VARCHAR(255)	None
item_description	TEXT	None

Table: `categories`

Column Name	Data Type	Index
category_id	INT(11)	PRIMARY KEY (category_id)
category_name	VARCHAR(100)	None

Table: `sizes`

Column Name	Data Type	Index
size_id	INT(11)	PRIMARY KEY (size_id)
size_name	VARCHAR(100)	None

Table: `inventory_returnable`

Column Name	Data Type	Index
returnable_id	INT(11)	PRIMARY KEY (returnable_id)
inventory_id	BIGINT(20)	None
is_returnable	TINYINT(1)	None

Table: `brands`

Column Name	Data Type	Index
brand_id	INT(11)	PRIMARY KEY (brand_id)
brand_name	VARCHAR(100)	None

Table: `colors`

Column Name	Data Type	Index
color_id	INT(11)	PRIMARY KEY (color_id)
color_name	VARCHAR(100)	None

Table: `meta_sizes`

Column Name	Data Type	Index
meta_size_id	INT(11)	PRIMARY KEY (meta_size_id)
size_name	VARCHAR(100)	None

Table: `styles`

Column Name	Data Type	Index
style_id	INT(11)	PRIMARY KEY (style_id)
style_name	VARCHAR(255)	None

Table: `pa_tree_imbalance`

Column Name	Data Type	Index
tree_id	BIGINT(20)	PRIMARY KEY (tree_id)
imbalance_score	INT(11)	None

Table: `versions` (from emigran)

Column Name	Data Type	Index
id	INT(11)	Part of UNIQUE KEY (country_id)
uuId	VARCHAR(250)	Part of UNIQUE KEY (country_id)
is_active	INT(1)	None

Table: `namespaces`

Column Name	Data Type	Index
namespace_id	INT(11)	PRIMARY KEY (namespace_id)
namespace_name	VARCHAR(255)	None

Table: `files_tags_map`

Column Name	Data Type	Index
map_id	BIGINT(20)	PRIMARY KEY (map_id)
file_id	BIGINT(20)	None
tag_id	INT(11)	None

Table: `tags`

Column Name	Data Type	Index
tag_id	INT(11)	PRIMARY KEY (tag_id)
tag_name	VARCHAR(100)	None

Table: `audit_logs`

Column Name	Data Type	Index
log_id	BIGINT(20)	PRIMARY KEY (log_id)
action	VARCHAR(255)	None
timestamp	DATETIME	None

Table: `files_delete_log`

Column Name	Data Type	Index
delete_id	BIGINT(20)	PRIMARY KEY (delete_id)
file_id	BIGINT(20)	None
deleted_at	DATETIME	None

Table: `versions` (from file_services)

Column Name	Data Type	Index
version_id	INT(11)	PRIMARY KEY (version_id)
file_id	BIGINT(20)	None
created_at	TIMESTAMP	None

Table: `intouch_ke_api_logs`

Column Name	Data Type	Index
log_id	BIGINT(20)	PRIMARY KEY (log_id)
request_url	VARCHAR(255)	None
response_code	INT(11)	None
request_time	TIMESTAMP	None

Table: `store_server_till_reports`

Column Name	Data Type	Index
report_id	BIGINT(20)	PRIMARY KEY (report_id)
till_id	BIGINT(20)	None
generated_on	TIMESTAMP	None

Table: `store_server_bulk_upload`

Column Name	Data Type	Index
upload_id	BIGINT(20)	PRIMARY KEY (upload_id)
file_name	VARCHAR(255)	None
uploaded_on	TIMESTAMP	None

Table: `async_message_api_requests`

Column Name	Data Type	Index
request_id	BIGINT(20)	PRIMARY KEY (request_id)
message_type	VARCHAR(255)	None
requested_at	TIMESTAMP	None

Table: `api_hit_table`

Column Name	Data Type	Index
hit_id	BIGINT(20)	PRIMARY KEY (hit_id)
api_name	VARCHAR(255)	None
hit_timestamp	TIMESTAMP	None

Table: `store_server_wcf_report`

Column Name	Data Type	Index
report_id	BIGINT(20)	PRIMARY KEY (report_id)
store_id	BIGINT(20)	None
report_date	DATE	None

Table: `till_diagnostics_system_info`

Column Name	Data Type	Index
diag_id	BIGINT(20)	PRIMARY KEY (diag_id)
system_info	TEXT	None
collected_on	TIMESTAMP	None

Table: `till_diagnostics_sync_report`

Column Name	Data Type	Index
sync_id	BIGINT(20)	PRIMARY KEY (sync_id)
till_id	BIGINT(20)	None
sync_status	VARCHAR(50)	None
sync_time	TIMESTAMP	None

Table: `store_server_health`

Column Name	Data Type	Index
health_id	BIGINT(20)	PRIMARY KEY (health_id)
till_id	BIGINT(20)	None
status	VARCHAR(50)	None
checked_on	TIMESTAMP	None

Table: `store_server_sync_logs`

Column Name	Data Type	Index
sync_log_id	BIGINT(20)	PRIMARY KEY (sync_log_id)
till_id	BIGINT(20)	None
log_timestamp	TIMESTAMP	None

Table: `store_server_sql_svr_health`

Column Name	Data Type	Index
sql_health_id	BIGINT(20)	PRIMARY KEY (sql_health_id)
server_name	VARCHAR(255)	None
health_status	VARCHAR(50)	None

Table: `api_summary_table`

Column Name	Data Type	Index
summary_id	BIGINT(20)	PRIMARY KEY (summary_id)
api_name	VARCHAR(255)	None
total_hits	INT(11)	None
summary_date	DATE	None

Table: `till_error_report`

Column Name	Data Type	Index
error_id	BIGINT(20)	PRIMARY KEY (error_id)
till_id	BIGINT(20)	None
error_message	TEXT	None
error_time	TIMESTAMP	None

Table: `till_diagnostics_bulk_upload`

Column Name	Data Type	Index
upload_id	BIGINT(20)	PRIMARY KEY (upload_id)
file_name	VARCHAR(255)	None
upload_timestamp	TIMESTAMP	None

Table: `till_diagnostics`

Column Name	Data Type	Index
diagnostics_id	BIGINT(20)	PRIMARY KEY (diagnostics_id)
till_id	BIGINT(20)	None
status	VARCHAR(50)	None
created_at	TIMESTAMP	None

Table: `extended_properties`

Column Name	Data Type	Index
property_id	BIGINT(20)	PRIMARY KEY (property_id)
property_key	VARCHAR(255)	None
property_value	TEXT	None

Table: `api_user_agents`

Column Name	Data Type	Index
agent_id	BIGINT(20)	PRIMARY KEY (agent_id)
user_agent_string	TEXT	None
api_name	VARCHAR(255)	None

Updated 6 months ago

Table: bill_test_temp_table

Table: emf_event_logs

Table: emf_event_logs_new

Table: emf_replay_logs

Table: merge_customer_summary

Table: subscription_import_files_history

Table: supported_tags

Table: users_govt_status_log

Table: gateway_param_values

Table: nsadmin_skipped_logs

Table: email_params

Table: merge_status_log

Table: user_feedback

Table: users_external_status

Table: users_govt_status

Table: nsadmin_communication_logs

Table: rule_param_mappings

Table: subscription_services

Table: campaign_veneno_tracker

Table: subscription_rules_history

Table: sms_params

Table: sms_params_logs

Table: user_subscription_status_log

Table: user_subscription_status

Table: user_campaign_subscriptions

Table: supported_channels

Table: org_param_values

Table: subscription_scopes

Table: default_content

Table: org_gateways_mapping

Table: inventory_item_attributes

Table: org_colors

Table: inventory_masters

Table: categories

Table: sizes

Table: inventory_returnable

Table: brands

Table: colors

Table: meta_sizes

Table: styles

Table: pa_tree_imbalance

Table: versions (from emigran)

Table: namespaces

Table: files_tags_map

Table: tags

Table: audit_logs

Table: files_delete_log

Table: versions (from file_services)

Table: intouch_ke_api_logs

Table: store_server_till_reports

Table: store_server_bulk_upload

Table: async_message_api_requests

Table: api_hit_table

Table: store_server_wcf_report

Table: till_diagnostics_system_info

Table: till_diagnostics_sync_report

Table: store_server_health

Table: store_server_sync_logs

Table: store_server_sql_svr_health

Table: api_summary_table

Table: till_error_report

Table: till_diagnostics_bulk_upload

Table: till_diagnostics

Table: extended_properties

Table: api_user_agents

Table: `bill_test_temp_table`

Table: `emf_event_logs`

Table: `emf_event_logs_new`

Table: `emf_replay_logs`

Table: `merge_customer_summary`

Table: `subscription_import_files_history`

Table: `supported_tags`

Table: `users_govt_status_log`

Table: `gateway_param_values`

Table: `nsadmin_skipped_logs`

Table: `email_params`

Table: `merge_status_log`

Table: `user_feedback`

Table: `users_external_status`

Table: `users_govt_status`

Table: `nsadmin_communication_logs`

Table: `rule_param_mappings`

Table: `subscription_services`

Table: `campaign_veneno_tracker`

Table: `subscription_rules_history`

Table: `sms_params`

Table: `sms_params_logs`

Table: `user_subscription_status_log`

Table: `user_subscription_status`

Table: `user_campaign_subscriptions`

Table: `supported_channels`

Table: `org_param_values`

Table: `subscription_scopes`

Table: `default_content`

Table: `org_gateways_mapping`

Table: `inventory_item_attributes`

Table: `org_colors`

Table: `inventory_masters`

Table: `categories`

Table: `sizes`

Table: `inventory_returnable`

Table: `brands`

Table: `colors`

Table: `meta_sizes`

Table: `styles`

Table: `pa_tree_imbalance`

Table: `versions` (from emigran)

Table: `namespaces`

Table: `files_tags_map`

Table: `tags`

Table: `audit_logs`

Table: `files_delete_log`

Table: `versions` (from file_services)

Table: `intouch_ke_api_logs`

Table: `store_server_till_reports`

Table: `store_server_bulk_upload`

Table: `async_message_api_requests`

Table: `api_hit_table`

Table: `store_server_wcf_report`

Table: `till_diagnostics_system_info`

Table: `till_diagnostics_sync_report`

Table: `store_server_health`

Table: `store_server_sync_logs`

Table: `store_server_sql_svr_health`

Table: `api_summary_table`

Table: `till_error_report`

Table: `till_diagnostics_bulk_upload`

Table: `till_diagnostics`

Table: `extended_properties`

Table: `api_user_agents`