Physical DB: meta

Suggest Edits

Logical DB	Tables
api_gateway_webhooks	org_endpoint_details.sql
api_gateway_webhooks	hmac_auth_details.sql
filters	spark_org_status_mapping.sql
filters	spark_org_voucher_status_mapping.sql
filters	filter_queries.sql
filters	spark_org_segment_status_mapping.sql
extended_fields_custom_data	extended_fields_values.sql
extended_fields_custom_data	language_support_ef_values.sql
api_gateway_extensions	client_credentials.sql
api_gateway_extensions	header_overrides.sql
api_gateway_extensions	prefix_service_mapping.sql
Temp	meta_test_temp_table.sql
api_testing	tenant.sql
api_testing	django_content_type.sql
api_testing	social_auth_partial.sql
api_testing	auth_user.sql
api_testing	apitest_app_gatewaytest.sql
api_testing	social_auth_code.sql
api_testing	django_session.sql
api_testing	social_auth_association.sql
api_testing	extensions_deployment_metadata.sql
api_testing	apitest_app_errorcodes.sql
api_testing	django_migrations.sql
api_testing	extensions_deployment.sql
api_testing	extensions_metrics_org_dashboards.sql
api_testing	apitest_app_import.sql
api_testing	apitest_app_testdata.sql
api_testing	mongo_audit_logs.sql
api_testing	countries.sql
api_testing	webhook_data.sql
api_testing	apitest_app_mappingstatus.sql
api_testing	apitest_app_report.sql
api_testing	apitest_app_session.sql
api_testing	auth_group.sql
api_testing	config_requests.sql
api_testing	apitest_app_customerdata.sql
api_testing	extensions_metrics.sql
api_testing	apitest_app_testcase.sql
api_testing	apitest_app_autoorgdetails.sql
api_testing	social_auth_nonce.sql
api_testing	config.sql
client_metadetails	client_versions.sql
client_metadetails	thin_client_version_mapping.sql
client_metadetails	client_version_mapping.sql
instore_ai_devices	device_details.sql
instore_ai_devices	accessories_details.sql
instore_ai_devices	installation_details.sql
instore_ai_devices	post_installation_details.sql
instore_ai_devices	device_registration_meta.sql
instore_ai_devices	entrance_details.sql
instore_ai_devices	whitelisted_network.sql
internationalization	multi_language_fields.sql
internationalization	multi_language_modules.sql
internationalization	multi_language_entities.sql
internationalization	multi_language_custom_fields.sql
oauth	scope_entities.sql
oauth	integration_client_scope_mapping.sql
oauth	integration_clients.sql
oauth	scope_entity_resource_mapping.sql
oauth	config_key_values.sql
oauth	jwk_keys.sql
oauth	config_keys.sql
facebook_meta	org_blocks.sql
facebook_meta	display_images.sql
facebook_meta	org_actions.sql
facebook_meta	button_types.sql
facebook_meta	actions.sql
facebook_meta	default_messages.sql
facebook_meta	template_types.sql
retail_insights	custom_dimension_values.sql
retail_insights	date.sql
retail_insights	custom_dimension_insights_hierarchy.sql
retail_insights	custom_dimensions.sql
retail_insights	target_data.sql
filters_automation	filter.sql
filters_automation	filter_info.sql
filters_automation	field_properties.sql
filters_automation	form_parts.sql
filters_automation	filter_properties.sql
filters_automation	filter_execution.sql
segmentation_engine	org_configs.sql
validation_suite	vs_kpis_sqls.sql
registrar	org_migration_info.sql
registrar	organizations.sql
registrar	membercare_requests.sql
registrar	campaigns.sql
registrar	associates.sql
registrar	programs.sql
registrar	entities.sql
registrar	audience_groups.sql
api_gateway	whitelist_apis.sql
api_gateway	header_overrides.sql
api_gateway	prefix_service_mapping.sql
subscription_management	merge_customer_summary.sql
subscription_management	subscription_import_files_history.sql
subscription_management	supported_tags.sql
subscription_management	users_govt_status_log.sql
subscription_management	gateway_param_values.sql
subscription_management	nsadmin_skipped_logs.sql
subscription_management	email_params.sql
subscription_management	merge_status_log.sql
subscription_management	user_feedback.sql
subscription_management	users_external_status.sql
subscription_management	users_govt_status.sql
subscription_management	nsadmin_communication_logs.sql
subscription_management	rule_param_mappings.sql
subscription_management	subscription_services.sql
subscription_management	campaign_veneno_tracker.sql
subscription_management	subscription_rules_history.sql
subscription_management	sms_params.sql
subscription_management	sms_params_logs.sql
subscription_management	user_subscription_status_log.sql
subscription_management	user_subscription_status.sql
subscription_management	user_campaign_subscriptions.sql
subscription_management	supported_channels.sql
subscription_management	org_param_values.sql
subscription_management	subscription_scopes.sql
subscription_management	default_content.sql
subscription_management	org_gateways_mapping.sql
subscription_management	subscription_rules.sql
subscription_management	email_params_logs.sql
scheduler	notifications.sql
scheduler	cron_migration_details.sql
scheduler	cron_task_logs.sql
scheduler	notification_parts.sql
scheduler	cron_tasks.sql
scheduler	communications.sql
shard_manager	stats.sql
shard_manager	org_shard_mapping.sql
shard_manager	service_type.sql
shard_manager	shard.sql
shard_manager	service_instance.sql
shard_manager	stats_data.sql
shard_manager	service.sql
shard_manager	shard_policy.sql
bill_import_local	bill_dump_import_attributes_temp.sql
bill_import_local	bill_dump_import_bills.sql
bill_import_local	bill_dump_import_bill_lineitems.sql
bill_import_local	bill_dump_import_attributes.sql
bill_import_local	bill_dump_import_bill_lineitems_attribute_values.sql
ratelimit	event_token_config.sql
ratelimit	token_summary.sql
ratelimit	token_allottment_log.sql
ratelimit	token_consumption_log.sql
ratelimit	rate_limiting_config.sql
ratelimit	rules.sql
ratelimit	rate_limit_hit.sql
emigran	versions.sql
test_utf8	test_data.sql
hotswap	dummy.sql
masters	org_channel_accounts.sql
masters	org_base_tiny_url.sql
masters	cf_transformer_error_logs.sql
masters	channel_config_keys.sql
masters	extended_fields.sql
masters	currency_ratio_inr.sql
masters	cf_transformer_stats.sql
masters	cf_transform_scheduler.sql
masters	cf_transform_scheduler_stats.sql
masters	verticals.sql
masters	extended_fields_standard_enum_values.sql
masters	extended_field_config.sql
masters	campaign_v2_org_status.sql
masters	bulk_job_status.sql
masters	extended_field_function_template_fields.sql
masters	file_processing_status.sql
masters	org_meta_data.sql
masters	product_config_key_values.sql
masters	shipping_address_type.sql
masters	extended_field_functions.sql
masters	extended_fields_possible_enum_values.sql
masters	comm_channel_type.sql
masters	org_source_attribute_priority.sql
masters	channel_config_key_values.sql
masters	org_shipment_types.sql
masters	ota_bank_enum_values.sql
masters	tinyurls.sql
masters	extended_field_functions_meta_fields.sql
masters	product_config_keys.sql
masters	channels.sql
masters	vertical_to_org_mapping.sql
masters	org_delivery_modes.sql
masters	source_comm_channel_type.sql
whatsapp_notifier	template_event_mappings.sql
whatsapp_notifier	communication_event_statuses.sql
whatsapp_notifier	tags.sql
whatsapp_notifier	org_config_keys.sql
whatsapp_notifier	whatsapp_accounts.sql
whatsapp_notifier	orgs.sql
whatsapp_notifier	communication_tags.sql
whatsapp_notifier	whatsapp_config_keys.sql
whatsapp_notifier	org_config_values.sql
whatsapp_notifier	templates.sql
whatsapp_notifier	whatsapp_config_values.sql
whatsapp_notifier	events.sql
whatsapp_notifier	event_statuses.sql
rate_limiter	rate_limit_criteria.sql
rate_limiter	redirection.sql
rate_limiter	default_rate_limit_criteria.sql
rate_limiter	limits.sql
rate_limiter	default_rate_limits.sql
rate_limiter	redirection_criteria.sql
authorization	azn_ag_resource_perms.sql
authorization	group_permissions.sql
authorization	azn_resources.sql
authorization	user_app_features.sql
authorization	modules.sql
authorization	resources.sql
authorization	org_app_features.sql
authorization	group_templates_permissions.sql
authorization	resources_mapping.sql
authorization	permission_hierarchy.sql
authorization	approver_logs.sql
authorization	membership_change_log.sql
authorization	modules_help_url.sql
authorization	tab_based_actions.sql
authorization	workflow_hierarchy.sql
authorization	groups.sql
authorization	group_templates.sql
authorization	user_proxy_orgs.sql
authorization	app_features.sql
authorization	features.sql
authorization	workflows.sql
authorization	actions.sql
authorization	active_modules.sql
authorization	azn_ag_assignments.sql
authorization	memberships.sql
authorization	access_exceptions.sql
authorization	permissions.sql
authorization	vulcan_actions.sql
authorization	vulcan_action_permissions.sql
authorization	azn_resource_endpoints.sql
authorization	org_namespaces.sql
authorization	org_features.sql
authorization	access_logs.sql
authorization	action_permissions.sql
authorization	azn_access_groups.sql
import	import_error_logs.sql
import	ftp_data_dump.sql
import	ftp_sources_templates_audit.sql
import	import_templates_mappings.sql
import	import_running_status.sql
import	import_conf_keys.sql
import	import_ftp_sources.sql
import	ftp_background_import.sql
import	import_point_engine_status.sql
import	import_additional_details.sql
import	import_templates_mappings_bkp.sql
import	import_subscriptions.sql
import	import_logs.sql
import	import_conf_keys_values.sql
import	import_files_history.sql
import	import_templates.sql
import	import_profiles.sql
import	import_subscribed_profile_stages.sql
import	ftp_template_mapping.sql
import	import_points_engine_configs.sql
import	import_subscribed_emails.sql
import	import_profiles_fields.sql
import	import_subscribed_mobiles.sql
import	import_system_configs.sql
downloads	campaign_audience_downloads.sql
downloads	download.sql
authentication	active_logins.sql
authentication	user_cookies.sql
authentication	otp_history.sql
authentication	verification_log.sql
authentication	user_login_history_success_stories.sql
authentication	federated_sso_settings.sql
authentication	username_cart.sql
authentication	user_login_history.sql
authentication	loggable_users.sql
authentication	user_deleted_log.sql
authentication	password_history.sql
authentication	user_activity_log.sql
authentication	user_attributes.sql
authentication	duo_factor_settings.sql
authentication	verification_body_template.sql
instoreai_vlp	visitors.sql
instoreai_vlp	associates.sql

Table: `spark_org_status_mapping`

Column Name	Data Type	Index
org_id	int(11)	None
is_spark_enabled	tinyint(4)	None
is_old_filter_enabled	tinyint(1)	None

Table: `spark_org_voucher_status_mapping`

Column Name	Data Type	Index
org_id	int(11)	None
is_spark_enabled	tinyint(4)	None

Table: `filter_queries`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of KEY (org_id)
session_id	int(11)	Part of KEY (session_id)
filter_name	varchar(50)	None
filter_type	varchar(20)	None
query	text	None
sql_explain	varchar(5000)	None
time_taken_secs	int(11)	Part of KEY (time_taken_secs)
start_time	timestamp	None

Table: `spark_org_segment_status_mapping`

Column Name	Data Type	Index
org_id	int(11)	None
is_spark_enabled	tinyint(1)	None

Table: `extended_fields_values`

Column Name	Data Type	Index
id	int(11)	Part of KEY (id)
org_id	int(11)	Part of KEY (org_id)
value	varchar(100)	Part of UNIQUE KEY (value)
created_on	datetime	None
ef_id	int(11)	Part of KEY (ef_id)
auto_update_time	timestamp	Part of KEY (auto_update_time)

Table: `language_support_ef_values`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
lang_id	int(11)	Part of KEY (lang_id)
ef_value_id	int(11)	Part of KEY (ef_value_id)
label	varchar(250)	None

Table: `client_credentials`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
org_id	bigint(20)	None
client_key	varchar(255)	None
client_secret	varchar(2048)	None
is_active	tinyint(1)	None

Table: `header_overrides`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
mapping_id	bigint(20)	Part of KEY (mapping_id)
header_name	varchar(255)	None
header_value	varchar(2048)	None
is_valid	tinyint(1)	None

Table: `prefix_service_mapping`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
prefix	varchar(100)	None
service_name	varchar(100)	None
service_port	varchar(5)	None
strip_prefix	tinyint(1)	None
is_valid	tinyint(1)	None
is_external	tinyint(1)	None
timeout	int(11)	None

Table: `meta_test_temp_table`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
auto_update_time	timestamp	None

Table: `IF`

Column Name	Data Type	Index
id	INT	Part of PRIMARY KEY (id)
name	VARCHAR(40)	None
git_repo	VARCHAR(200)	None
token	VARCHAR(100)	None
Isactive	TINYINT(1)	None
UpdatedBy	VARCHAR(128)	None
CreatedBy	VARCHAR(128)	None
extensions	VARCHAR(200)	None
clusters	VARCHAR(200)	None
org_ids	VARCHAR(200)	None
auto_update_time	TIMESTAMP	None
gitrepoName	VARCHAR(128)	None
frameworkType	ENUM('robot',	None
slackURL	VARCHAR(200)	None
extensionName	VARCHAR(200)	None

Table: `IF`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
name	varchar(100)	None
app_label	varchar(100)	Part of UNIQUE KEY (app_label)
model	varchar(100)	Part of UNIQUE KEY (model)

Table: `IF`

Column Name	Data Type	Index
id	BIGINT	Part of PRIMARY KEY (id)
token	VARCHAR(32)	Part of KEY (token)
next_step	SMALLINT	None
backend	VARCHAR(32)	None
data	LONGTEXT	None
timestamp	DATETIME(6)	Part of KEY (timestamp)

Table: `IF`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
password	varchar(1000)	None
last_login	datetime	None
is_superuser	tinyint(1)	None
username	varchar(100)	Part of UNIQUE KEY (username)
first_name	varchar(100)	None
last_name	varchar(100)	None
email	varchar(500)	None
is_staff	tinyint(1)	None
is_active	tinyint(1)	None
date_joined	datetime	None

Table: `IF`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
clientId	varchar(30)	None
count	bigint(20)	None
sendingOrgId	bigint(20)	None
cluster	varchar(30)	None
gateway	varchar(30)	None
triggeredOn	varchar(50)	None
triggeredBy	varchar(100)	None
status	varchar(1000)	None

Table: `IF`

Column Name	Data Type	Index
id	BIGINT	Part of PRIMARY KEY (id)
email	VARCHAR(254)	Part of UNIQUE KEY (email)
code	VARCHAR(32)	Part of KEY (code)
verified	TINYINT(1)	None
timestamp	DATETIME(6)	Part of KEY (timestamp)

Table: `IF`

Column Name	Data Type	Index
session_key	varchar(40)	Part of PRIMARY KEY (session_key)
session_data	longtext	None
expire_date	datetime	Part of KEY (expire_date)

Table: `IF`

Column Name	Data Type	Index
id	BIGINT	Part of PRIMARY KEY (id)
server_url	VARCHAR(255)	Part of UNIQUE KEY (server_url)
handle	VARCHAR(255)	Part of UNIQUE KEY (handle)
secret	VARCHAR(255)	None
issued	INT	None
lifetime	INT	None
assoc_type	VARCHAR(64)	None

Table: `IF`

Column Name	Data Type	Index
id	int	None
triggeredBy	varchar(200)	None
extensionName	varchar(200)	None
git_repo	varchar(200)	None
jobName	varchar(200)	None
auto_update_time	timestamp	None
clusters	varchar(200)	None

Table: `IF`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
error_code	int(11)	None
description	varchar(255)	None
resource	varchar(20)	None
success	tinyint(1)	None

Table: `IF`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
app	varchar(255)	None
name	varchar(255)	None
applied	datetime(6)	None

Table: `IF`

Column Name	Data Type	Index
id	int	None
triggeredBy	varchar(200)	None
description	varchar(400)	None
auto_update_time	timestamp	None
status	varchar(1000)	None
extensionName	varchar(200)	None
orgId	int	None
depId	int	None
git_repo	varchar(200)	None
jobName	varchar(200)	None
branchOrTag	varchar(200)	None
version	varchar(200)	None

Table: `IF`

Column Name	Data Type	Index
id	INT	None
dashboard	VARCHAR(255)	None
org_include	VARCHAR(255)	None
org_exclude	VARCHAR(255)	None
dashboardType	ENUM('NEWRELIC','GRAFANA')	None
isEnabled	TINYINT	None
story	VARCHAR(255)	None

Table: `IF`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
start_number	bigint(20)	None
orgId	bigint(20)	None
countryCode	int(11)	None
url	varchar(200)	None
lastUpdatedBy	varchar(128)	None

Table: `IF`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
orgId	bigint(20)	None
module	varchar(300)	None
cluster	varchar(30)	None
value	mediumtext	None
isActive	smallint(6)	None
lastModified	date	None

Table: `IF`

Column Name	Data Type	Index
id	INT	None
query	VARCHAR(400)	None
created_by	VARCHAR(40)	None
created_at	TIMESTAMP	None
query_execution_time	DECIMAL(10,4)	None
status	ENUM('SUCCESS','FAILED','PENDING_APPROVAL','REJECTED','IN_PROGRESS')	None
no_of_records	INT	None
updated_at	TIMESTAMP	None
mongo_database	VARCHAR(80)	None
collection	VARCHAR(80)	None
tenant_id	INT	None
hotswap_id	INT	None
approved_by	VARCHAR(40)	None

Table: `IF`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
name	varchar(100)	None
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: `IF`

Column Name	Data Type	Index
id	INT(11)	Part of PRIMARY KEY (id)
org_id	VARCHAR(255)	Part of UNIQUE KEY (org_id)
ref_id	VARCHAR(255)	Part of UNIQUE KEY (ref_id)
api_request_id	VARCHAR(255)	Part of UNIQUE KEY (api_request_id)
event_name	VARCHAR(255)	Part of UNIQUE KEY (event_name)
json_body	MEDIUMTEXT	None
auto_updated_date	DATETIME	None

Table: `IF`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
mjUrl	varchar(200)	None
esbUrl	varchar(200)	None
checkedOn	varchar(50)	None
mappingStatus	varchar(1000)	None

Table: `IF`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
run_id	varchar(100)	None
status	varchar(1500)	None
result	mediumtext	None
isVisible	tinyint(1)	None
invokedBy	varchar(100)	None

Table: `IF`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
session_name	varchar(200)	None
session_summary	varchar(2000)	None
session_details	mediumtext	None
session_description	varchar(200)	None
createdBy	varchar(100)	None

Table: `IF`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
name	varchar(80)	Part of UNIQUE KEY (name)

Table: `IF`

Column Name	Data Type	Index
id	INT	Part of PRIMARY KEY (id)
request	VARCHAR(255)	None
orgId	VARCHAR(20)	None
cluster	VARCHAR(20)	None
configName	VARCHAR(30)	None
configValue	TEXT	None
defaultValue	VARCHAR(30)	None
isSecret	SMALLINT	None
tags	VARCHAR(100)	None
user	VARCHAR(30)	None
response	MEDIUMTEXT	None
auto_update_time	TIMESTAMP	None
created_at	TIMESTAMP	None
approver	VARCHAR(30)	None
status	ENUM('PENDING_APPROVAL',	None

Table: `IF`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
url	varchar(255)	None
tillUsername	varchar(50)	None
firstName	varchar(50)	None
lastName	varchar(50)	None
mobile	varchar(50)	None
email	varchar(50)	None
gender	varchar(50)	None
externalId	varchar(50)	None
number	varchar(50)	None
storeName	varchar(50)	None
storeCode	varchar(50)	None
tillId	varchar(50)	None
storeId	varchar(50)	None
zoneId	varchar(50)	None
tillName	varchar(50)	None
tillCode	varchar(50)	None
storeExternalId	varchar(50)	None
zoneName	varchar(50)	None
zoneCode	varchar(50)	None

Table: `IF`

Column Name	Data Type	Index
id	int	Part of PRIMARY KEY (id)
org_id	int	None
extension_type	int	None
dashboard	varchar(255)	Part of KEY (dashboard)
chart_id	int	None
nrql_query	text	None
isEnabled	tinyint	None
query_type	enum('FILTER','METRICS')	None

Table: `IF`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
project_name	varchar(200)	None
module_name	varchar(200)	None
testsuite	varchar(200)	None
STR	mediumtext	None
resource_name	varchar(200)	None
lastModified	datetime	None
lastUpdatedBy	varchar(100)	None

Table: `IF`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
orgId	bigint(20)	None
url	varchar(255)	None
orgName	varchar(50)	None
zones	varchar(100)	None
stores	varchar(100)	None
storeTills	varchar(100)	None
shard	varchar(50)	None
tierCount	int(11)	None
isActive	smallint(6)	None
inUseLastTime	datetime	None
inUse	smallint(6)	None

Table: `IF`

Column Name	Data Type	Index
id	BIGINT	Part of PRIMARY KEY (id)
server_url	VARCHAR(255)	Part of UNIQUE KEY (server_url)
timestamp	INT	Part of UNIQUE KEY (timestamp)
salt	VARCHAR(65)	Part of UNIQUE KEY (salt)

Table: `IF`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
name	varchar(20)	None
value	varchar(10000)	None

Table: `client_versions`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
client_type	enum('INTOUCH','STORE_CENTER','THIN_CLIENT')	None
version	varchar(255)	None
framework_version	varchar(50)	None
change_log	mediumtext	None
created_on	datetime	None
version_added_by	int(11)	None
is_active	tinyint(4)	None

Table: `thin_client_version_mapping`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of KEY (org_id)
store_id	int(11)	Part of KEY (store_id)
version_id	int(11)	None
version_set_on	datetime	None
is_active	tinyint(1)	Part of KEY (is_active)
version_set_by	int(11)	None

Table: `client_version_mapping`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of KEY (org_id)
store_id	int(11)	Part of KEY (store_id)
version_id	int(11)	None
version_set_on	datetime	None
is_active	tinyint(1)	Part of KEY (is_active)
version_set_by	int(11)	None

Table: `device_details`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
device_id	bigint(20)	Part of UNIQUE KEY (device_id)
lan_mac_id	varchar(50)	None
wifi_mac_id	varchar(50)	None
po	varchar(50)	None
processor	varchar(15)	None
auto_update_time	timestamp	None

Table: `accessories_details`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
device_id	bigint(20)	Part of KEY (device_id)
with_rf_switch	tinyint(1)	None
device_id_desc	char(2)	None
hardware_extension	varchar(10)	None
camera	varchar(10)	None
case_color	char(5)	None
case_size	char(5)	None
microphone	char(3)	None
auto_update_time	timestamp	None

Table: `installation_details`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
device_id	bigint(20)	None
org_id	bigint(11)	Part of KEY (org_id)
store_id	bigint(20)	None
engagement_type	varchar(7)	None
date_dispatched	datetime	None
date_installed	datetime	None
date_callback	datetime	None
device_name	varchar(50)	None
dispatch_type	varchar(15)	None
auto_update_time	timestamp	Part of KEY (auto_update_time)
is_active	tinyint(1)	None
store_name	varchar(50)	None

Table: `post_installation_details`

Column Name	Data Type	Index
id	int(10)	Part of PRIMARY KEY (id)
org_id	bigint(11)	Part of PRIMARY KEY (org_id)
store_id	bigint(20)	None
till_id	bigint(20)	None
request	text	None
install_correctly	tinyint(1)	None
device_image	blob	None
device_color_request	tinyint(1)	None
with_rf_switch	tinyint(1)	None
with_network	tinyint(1)	None
network_username	varchar(30)	None
network_password	varchar(30)	None
instore_version_update	tinyint(1)	None
install_permission	tinyint(1)	None
walkins__count_config	tinyint(1)	None
damages_install	text	None
walkins_demo	tinyint(1)	None
issues_install	text	None
mn_sy_count_record	tinyint(1)	None
mn_count_process_explain	tinyint(1)	None
visitor_staff_count_sync	tinyint(1)	None
cap_escalation_matrix	tinyint(1)	None
received_signed_copy	tinyint(1)	None
signed_copy	blob	None
updated_on	timestamp	None

Table: `device_registration_meta`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
device_id	bigint(20)	None
device_type	enum('VM','CE','FFC','HeatMap')	None
wifi_mac_id	varchar(50)	None
lan_mac_id	varchar(50)	None
till_id	bigint(20)	None
store_id	bigint(20)	None
org_id	bigint(20)	None
device_name	varchar(50)	None
processor	enum('RaspberryPi_3B','RaspberryPi_3B+')	None
lens	varchar(50)	None
with_staff_switch	tinyint(1)	None
case_version	enum('Acrylic	None
case_color	enum('black','white','blue')	None
is_active	smallint(6)	None
auto_update_time	timestamp	None
notes	varchar(50)	None

Table: `entrance_details`

Column Name	Data Type	Index
id	int(10)	Part of PRIMARY KEY (id)
org_id	bigint(11)	Part of PRIMARY KEY (org_id)
store_id	bigint(20)	None
till_id	bigint(20)	None
device_id	bigint(20)	None
store_address	text	None
width_entrance	varchar(20)	None
height_entrance	varchar(20)	None
height_9ft_entrance	varchar(20)	None
area_covered	varchar(20)	None
router_entrance_distance	varchar(20)	None
network_type	varchar(20)	None
network_username	varchar(30)	None
network_password	varchar(30)	None
updated_on	timestamp	None
entrance_image	longblob	None

Table: `whitelisted_network`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	bigint(11)	Part of PRIMARY KEY (org_id)
store_id	bigint(20)	None
till_id	bigint(20)	None
type	varchar(20)	None
api_base_url	tinyint(1)	None
api_url	tinyint(1)	None
intouch_base_url	tinyint(1)	None
storecare_base_url	tinyint(1)	None
storecenter_base_url	tinyint(1)	None
cap_apps_antivirus_block	tinyint(1)	None
cap_apps_firewall_block	tinyint(1)	None
updated_on	timestamp	None

Table: `multi_language_fields`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
entity_id	int(11)	Part of UNIQUE KEY (entity_id)
field_name	varchar(100)	Part of UNIQUE KEY (field_name)
description	varchar(250)	None
required	tinyint(1)	None
auto_update_time	timestamp	None

Table: `multi_language_modules`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
module_name	varchar(100)	Part of UNIQUE KEY (module_name)
description	varchar(250)	None
auto_update_time	timestamp	None

Table: `multi_language_entities`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
module_id	int(11)	None
entity_name	varchar(100)	Part of UNIQUE KEY (entity_name)
description	varchar(250)	None
auto_update_time	timestamp	None

Table: `multi_language_custom_fields`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of UNIQUE KEY (org_id)
entity_id	int(11)	Part of UNIQUE KEY (entity_id)
field_name	varchar(100)	Part of UNIQUE KEY (field_name)
description	varchar(250)	None
required	tinyint(1)	None
auto_update_time	timestamp	None

Table: `scope_entities`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
entity	varchar(100)	None
auto_update_time	timestamp	None

Table: `integration_client_scope_mapping`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
client_id	bigint(20)	Part of KEY (client_id)
org_id	bigint(20)	Part of KEY (org_id)
permission	enum('READ','WRITE','READWRITE')	None
entity_id	bigint(20)	None
is_valid	tinyint(1)	None
auto_update_time	timestamp	None

Table: `integration_clients`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
client_name	varchar(100)	Part of UNIQUE KEY (client_name)
description	varchar(100)	None
client_key	varchar(100)	Part of UNIQUE KEY (client_key)
client_secret	varchar(100)	None
org_id	bigint(20)	Part of KEY (org_id)
default_till_id	bigint(20)	None
access_group_id	int(11)	Part of KEY (access_group_id)
created_on	timestamp	None
created_by	bigint(20)	None
last_updated_on	timestamp	None
last_updated_by	bigint(20)	None
is_valid	tinyint(1)	None
expiration_token_time	bigint(20)	None
auto_update_time	timestamp	Part of KEY (auto_update_time)

Table: `scope_entity_resource_mapping`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
entity_id	bigint(20)	None
resource	varchar(300)	None
is_valid	tinyint(1)	None
auto_update_time	timestamp	None

Table: `config_key_values`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
org_id	bigint	Part of KEY (org_id)
client_id	bigint	Part of KEY (client_id)
key_id	bigint	Part of KEY (key_id)
value	varchar(255)	None
updated_by	bigint	None
is_active	boolean	None
updated_on	timestamp	None
auto_update_time	timestamp	Part of KEY (auto_update_time)

Table: `jwk_keys`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
jwk_json	mediumtext	None
is_valid	tinyint(1)	None
auto_update_time	timestamp	None
key_id	varchar(10)	None

Table: `config_keys`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
name	varchar(100)	Part of KEY (name)
default_value	varchar(255)	None
is_active	boolean	None
created_on	datetime	None
auto_update_time	timestamp	Part of KEY (auto_update_time)

Table: `org_blocks`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	None
name	varchar(255)	None
json_content	mediumtext	None
template_type_id	int(11)	None
created_by	int(11)	None
created_on	datetime	None
next_block_id	int(11)	None

Table: `display_images`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
type	varchar(255)	None
image_url	varchar(1024)	None

Table: `org_actions`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	None
action_id	int(11)	None
is_active	tinyint(1)	None
created_by	int(11)	None
created_on	datetime	None

Table: `button_types`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
name	varchar(255)	None
default_json	varchar(512)	None
created_by	int(11)	None
created_on	datetime	None

Table: `actions`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
name	varchar(255)	None
label	varchar(255)	None
params	mediumtext	None
created_by	int(11)	None
created_on	datetime	None

Table: `default_messages`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	bigint(20)	None
message	varchar(300)	None

Table: `template_types`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
name	varchar(255)	None
channel	enum('FACEBOOK')	None
default_json	mediumtext	None
created_by	int(11)	None
created_on	datetime	None

Table: `custom_dimension_values`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	None
dimension_id	int(11)	None
label	varchar(250)	None
value_id	varchar(250)	None

Table: `date`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
day_of_month	int(11)	None
month	int(11)	None
year	int(11)	None
day_of_week	int(11)	None
week_number	int(11)	None
date	date	None

Table: `custom_dimension_insights_hierarchy`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of KEY (org_id)
dimension_id	int(11)	None
priority	tinyint(4)	None
base_dimension	varchar(100)	None

Table: `custom_dimensions`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	None
name	varchar(250)	None
type	varchar(250)	None
base_dimension	varchar(100)	None
is_valid	tinyint(1)	None
data	varchar(250)	None

Table: `target_data`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
date_id	int(11)	Part of UNIQUE KEY (date_id)
org_id	int(11)	Part of UNIQUE KEY (org_id)
store_id	int(11)	Part of UNIQUE KEY (store_id)
target	int(11)	None
date	date	None

Table: `filter`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
description	varchar(191)	Part of UNIQUE KEY (description)
resource_name	varchar(255)	None
type	enum('LOYALTY','NON_LOYALTY','ALL')	None
is_active	tinyint(1)	None
supported_orgs	varchar(255)	None
last_updated_on	datetime	None
last_updated_by	int(11)	None

Table: `filter_info`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
filter_id	int(11)	None
display_name	varchar(255)	None
description	varchar(255)	None
is_exact_check	tinyint(1)	None
extra_params	varchar(255)	None
last_updated_on	datetime	None

Table: `field_properties`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
form_part_id	int(11)	Part of UNIQUE KEY (form_part_id)
field_type	varchar(255)	Part of UNIQUE KEY (field_type)
field_value	longtext	None
is_mapping_field	tinyint(1)	None
last_updated_on	datetime	None

Table: `form_parts`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
filter_id	int(11)	None
base_type	varchar(255)	None
is_collection	tinyint(1)	None
last_updated_on	datetime	None

Table: `filter_properties`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
filter_id	int(11)	Part of UNIQUE KEY (filter_id)
property_type	varchar(255)	Part of UNIQUE KEY (property_type)
property_value	mediumtext	None
last_updated_on	datetime	None

Table: `filter_execution`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
filter_id	int(11)	Part of UNIQUE KEY (filter_id)
execution_step_number	int(11)	Part of UNIQUE KEY (execution_step_number)
execution_type	varchar(255)	Part of UNIQUE KEY (execution_type)
execution_value	longtext	None
last_updated_on	datetime	None

Table: `org_configs`

Column Name	Data Type	Index
org_id	int(11)	Part of PRIMARY KEY (org_id)

Table: `vs_kpis_sqls`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	None
file_name	varchar(100)	None
file_handler	varchar(100)	Part of UNIQUE KEY (file_handler)
download_link	varchar(100)	None
priority	int(11)	None
is_active	tinyint(1)	None
is_deleted	tinyint(1)	None
created_on	datetime	None
created_by	int(11)	None
modified_by	int(11)	None
auto_update_time	timestamp	None

Table: `org_migration_info`

Column Name	Data Type	Index
org_id	int(11)	Part of PRIMARY KEY (org_id)
destination_cluster	enum('nightly',	None

Table: `organizations`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
name	varchar(255)	None
added_on	timestamp	None
added_by	int(11)	None
is_active	tinyint(1)	None
cluster	varchar(100)	None
auto_update_time	timestamp	None

Table: `membercare_requests`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of KEY (org_id)
cluster	varchar(100)	None
added_on	timestamp	None
added_by	int(11)	None
is_active	tinyint(1)	None
auto_update_time	timestamp	Part of KEY (auto_update_time)

Table: `campaigns`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of KEY (org_id)
name	varchar(50)	None
type	varchar(20)	None
cluster	varchar(100)	None
added_on	timestamp	None
added_by	int(11)	None
is_active	tinyint(1)	None
auto_update_time	timestamp	Part of KEY (auto_update_time)

Table: `associates`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of KEY (org_id)
cluster	varchar(100)	None
added_on	timestamp	None
added_by	int(11)	None
is_active	tinyint(1)	None
auto_update_time	timestamp	Part of KEY (auto_update_time)

Table: `programs`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of PRIMARY KEY (org_id)
cluster	varchar(100)	None
added_on	timestamp	None
added_by	int(11)	None
is_active	tinyint(1)	None
auto_update_time	timestamp	None

Table: `entities`

Column Name	Data Type	Index
id	int(11)	Part of KEY (id)
org_id	int(11)	Part of KEY (org_id)
type	enum('TILL','STORE','ZONE','CONCEPT','STR_SERVER','ADMIN_USER','ASSOCIATE')	Part of KEY (type)
guid	varchar(255)	None
added_on	timestamp	None
added_by	int(11)	None
cluster	varchar(100)	None
is_active	tinyint(1)	None
auto_update_time	timestamp	None

Table: `audience_groups`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of KEY (org_id)
cluster	varchar(100)	None
added_on	timestamp	None
added_by	int(11)	None
is_active	tinyint(1)	None
auto_update_time	timestamp	Part of KEY (auto_update_time)

Table: `whitelist_apis`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
request_url	varchar(100)	None
is_valid	tinyint(1)	None

Table: `header_overrides`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
mapping_id	bigint(20)	Part of KEY (mapping_id)
header_name	varchar(255)	None
header_value	varchar(2048)	None
is_valid	tinyint(1)	None

Table: `prefix_service_mapping`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
prefix	varchar(100)	None
service_name	varchar(100)	None
service_port	varchar(5)	None
strip_prefix	tinyint(1)	None
is_valid	tinyint(1)	None
is_external	tinyint(1)	None
timeout	int(11)	None

Table: `merge_customer_summary`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of KEY (org_id)
from_customer_id	int(11)	Part of KEY (from_customer_id)
to_customer_id	int(11)	Part of KEY (to_customer_id)
merge_request_id	int(11)	Part of KEY (merge_request_id)
merged_by	int(11)	None
status	enum('SUCCESS','FAIL')	None
error_message	mediumtext	None
notes	mediumtext	None

Table: `subscription_import_files_history`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of PRIMARY KEY (org_id)
import_type	enum('PDPA','NDNC')	None
params	mediumtext	None
token	varchar(20)	None
uploaded_file_handle	varchar(200)	None
error_file_handle	varchar(200)	None
imported_file_handle	varchar(200)	None
temp_table_name	varchar(100)	None
uploaded_by	int(11)	None
uploaded_on	timestamp	None

Table: `supported_tags`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
type	enum('OPTIN','OPTOUT')	None
channel_id	int(11)	None
tag	varchar(255)	None

Table: `users_govt_status_log`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
target_value	varchar(100)	None
target_type	enum('SMS','EMAIL')	None
priority	enum('TRANS','BULK')	None
scope_id	int(11)	None
status	tinyint(1)	None
added_by_id	int(11)	None
source_id	int(11)	None
source_type	varchar(100)	None
added_on	datetime	None
updated_on	datetime	None
auto_update_time	timestamp	None

Table: `gateway_param_values`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of KEY (org_id)
org_gateways_id	int(11)	Part of UNIQUE KEY (org_gateways_id)
param_key	varchar(50)	Part of UNIQUE KEY (param_key)
param_value	varchar(50)	None
auto_update_time	timestamp	Part of KEY (auto_update_time)

Table: `nsadmin_skipped_logs`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
user_id	int(11)	None
org_id	int(11)	Part of PRIMARY KEY (org_id)
resolved_tags	mediumtext	None
last_updated_on	datetime	None

Table: `email_params`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
subject	varchar(255)	None
body	mediumtext	None
email_step_number	varchar(100)	None
email_unsub_type	enum('SIMPLE','PREFERENTIAL')	None
sender_label	varchar(255)	None
sender_email	varchar(255)	None
file_service_url	varchar(255)	None
last_updated_on	datetime	None

Table: `merge_status_log`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of KEY (org_id)
user_subscription_status_id	int(11)	None
merge_customer_summary_id	int(11)	Part of KEY (merge_customer_summary_id)
changed	enum('USERID','EXTERNALREFID')	None
from	int(11)	None
to	int(11)	None

Table: `user_feedback`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
user_id	int(11)	None
org_id	int(11)	Part of PRIMARY KEY (org_id)
reason	varchar(255)	None
last_updated_on	datetime	None

Table: `users_external_status`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
target_value	varchar(100)	Part of UNIQUE KEY (target_value)
target_type	enum('SMS','EMAIL','WECHAT','ANDROID','IOS')	Part of UNIQUE KEY (target_type)
scope_id	int(11)	Part of UNIQUE KEY (scope_id)
added_on	datetime	None
updated_on	datetime	None
auto_update_time	timestamp	Part of KEY (auto_update_time)
account_id	varchar(100)	Part of UNIQUE KEY (account_id)

Table: `users_govt_status`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
external_reference_id	bigint(20)	Part of UNIQUE KEY (external_reference_id)
priority	enum('TRANS','BULK')	Part of UNIQUE KEY (priority)
status	tinyint(1)	None
added_by_id	int(11)	None
added_on	datetime	None
auto_update_time	timestamp	None

Table: `nsadmin_communication_logs`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of PRIMARY KEY (org_id)
user_id	int(11)	None
subscription_rule_id	int(11)	None
nsadmin_id	varchar(255)	None
resolved_tags	mediumtext	None
last_updated_on	datetime	None

Table: `rule_param_mappings`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
rule_id	int(11)	None
param_id	int(11)	None

Table: `subscription_services`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
service_name	varchar(255)	None

Table: `campaign_veneno_tracker`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
last_inserted_id	int(11)	None
auto_update_time	timestamp	None

Table: `subscription_rules_history`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
subscription_rule_id	int(11)	None
org_id	int(11)	Part of PRIMARY KEY (org_id)
channel_id	int(11)	None
type	enum('OPTIN','OPTOUT')	None
subscription_type	enum('SINGLE','DOUBLE','CONFIRMED')	None
channel_params_types	varchar(255)	None
last_updated_on	datetime	None
last_updated_by	int(11)	None

Table: `sms_params`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
body	mediumtext	None
sms_unsub_type	enum('MISSED_CALL','SMS')	None
sms_step_number	varchar(100)	None
optout_number	varchar(255)	Part of UNIQUE KEY (optout_number)
unsub_text	varchar(255)	Part of UNIQUE KEY (unsub_text)
last_updated_on	datetime	None

Table: `sms_params_logs`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
sms_params_id	int(11)	None
body	mediumtext	None
sms_unsub_type	enum('MISSED_CALL','SMS')	None
sms_step_number	varchar(100)	None
optout_number	varchar(255)	None
unsub_text	varchar(255)	None
last_updated_on	datetime	None

Table: `user_subscription_status_log`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
user_subscription_id	int(11)	None
org_id	int(11)	Part of PRIMARY KEY (org_id)
user_id	int(11)	None
type	enum('OPTIN','OPTOUT')	None
channel_id	int(11)	None
priority	enum('BULK','TRANS','ALL')	None
subscription_service_id	int(11)	None
scope_id	int(11)	None
external_reference_id	int(11)	None
added_ip	varchar(255)	None
added_by_user_source	varchar(255)	None
added_by_id	int(11)	None
last_updated_on	datetime	None
auto_update_time	timestamp	None

Table: `user_subscription_status`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of KEY (org_id)
user_id	int(11)	Part of UNIQUE KEY (user_id)
type	enum('OPTIN','OPTOUT')	None
channel_id	int(11)	Part of UNIQUE KEY (channel_id)
priority	enum('BULK','TRANS','ALL')	Part of UNIQUE KEY (priority)
subscription_service_id	int(11)	None
scope_id	int(11)	None
external_reference_id	int(11)	Part of KEY (external_reference_id)
added_ip	varchar(255)	None
added_by_user_source	varchar(255)	None
added_by_id	int(11)	None
last_updated_on	datetime	None
auto_update_time	timestamp	Part of KEY (auto_update_time)

Table: `user_campaign_subscriptions`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of KEY (org_id)
user_id	int(11)	Part of UNIQUE KEY (user_id)
type	enum('OPTIN','OPTOUT')	None
campaign_id	int(11)	Part of KEY (campaign_id)
communication_id	int(11)	Part of KEY (communication_id)
last_updated_on	datetime	None
auto_update_time	timestamp	Part of KEY (auto_update_time)

Table: `supported_channels`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
channel	varchar(255)	None

Table: `org_param_values`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of KEY (org_id)
param_key	varchar(50)	Part of UNIQUE KEY (param_key)
param_value	varchar(50)	None
auto_update_time	timestamp	Part of KEY (auto_update_time)

Table: `subscription_scopes`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
scope	enum('USER','SYSTEM','GOVT')	None
sub_scope	enum('NONE','NDNC','BOUNCED','PDPA')	None
priority	int(11)	None
created_time	datetime	None

Table: `default_content`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
channel_id	int(11)	None
type	enum('OPTIN','OPTOUT')	None
subscription_type	enum('SINGLE','DOUBLE','CONFIRMED')	None
file_service_url	varchar(255)	None

Table: `org_gateways_mapping`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of KEY (org_id)
gateway_name	varchar(50)	Part of UNIQUE KEY (gateway_name)
auto_update_time	timestamp	Part of KEY (auto_update_time)

Table: `subscription_rules`

Column Name	Data Type	Index
rule_id	int(11)	Part of PRIMARY KEY (rule_id)
org_id	int(11)	Part of KEY (org_id)
channel_id	int(11)	None
type	enum('OPTIN','OPTOUT')	None
subscription_type	enum('SINGLE','DOUBLE','CONFIRMED')	None
channel_params_types	varchar(255)	None
org_external_status	enum('NDNC','PDPA','NOT_SET')	None
last_updated_on	datetime	None
last_updated_by	int(11)	None

Table: `email_params_logs`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
email_params_id	int(11)	None
subject	varchar(255)	None
body	mediumtext	None
email_step_number	varchar(100)	None
email_unsub_type	enum('SIMPLE','PREFERENTIAL')	None
sender_label	varchar(255)	None
sender_email	varchar(255)	None
file_service_url	varchar(255)	None
last_updated_on	datetime	None

Table: `notifications`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	None
entity_id	mediumtext	None
entity_type	varchar(50)	None
communication_type	enum('SMS','EMAIL')	None
subject	varchar(50)	None
message	mediumtext	None
params	varchar(250)	None
status	enum('OPEN','RUNNING','EXECUTING','EXECUTED','CLOSED')	None
last_updated_by	int(11)	None
last_updated_on	datetime	None

Table: `cron_migration_details`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of PRIMARY KEY (org_id)
v1_campaign_cron_id	int(11)	None
v1_health_cron_id	int(11)	None
v2_cron_id	int(11)	None
last_updated	timestamp	None

Table: `cron_task_logs`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
ref_id	int(11)	Part of KEY (ref_id)
description	varchar(250)	None
status	enum('SUCCESS','ERROR')	Part of KEY (status)
scheduled_time	datetime	Part of KEY (scheduled_time)
last_updated_time	datetime	Part of KEY (last_updated_time)
org_id	int(11)	Part of PRIMARY KEY (org_id)

Table: `notification_parts`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
code	varchar(50)	None
name	varchar(255)	None
supported_type	varchar(20)	None
last_updated_by	int(11)	None
last_updated_on	datetime	None

Table: `communications`

Column Name	Data Type	Index
id	int(11)	Part of KEY (id)
type	enum('EMAIL','SMS')	None
subject	varchar(50)	None
message	longtext	None
file_id	int(11)	None
admin_user_id	int(11)	None
mobile	varchar(15)	None
email	varchar(50)	None
org_id	int(11)	Part of KEY (org_id)
notification_id	int(11)	Part of KEY (notification_id)
status	enum('OPEN','RUNNING','EXECUTED','BOUNCED')	Part of KEY (status)
nsadmin_id	int(11)	None
last_updated_by	int(11)	None
last_updated_on	datetime	None

Table: `stats`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
name	varchar(255)	None
type	enum('SHARD','ORG','GENERAL')	None
is_active	tinyint(1)	None
added_on	timestamp	None

Table: `org_shard_mapping`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of UNIQUE KEY (org_id)
policy_id	int(11)	Part of UNIQUE KEY (policy_id)
shard_id	int(11)	None
is_active	tinyint(1)	Part of UNIQUE KEY (is_active)
added_on	timestamp	None
auto_update_time	timestamp	None

Table: `service_type`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
name	varchar(255)	Part of UNIQUE KEY (name)
added_on	timestamp	None
is_active	tinyint(1)	None
auto_update_time	timestamp	None

Table: `shard`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
policy_id	int(11)	Part of UNIQUE KEY (policy_id)
name	varchar(100)	Part of UNIQUE KEY (name)
added_on	timestamp	None
is_active	tinyint(1)	None
is_dedicated	tinyint(1)	None
auto_update_time	timestamp	None

Table: `service_instance`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
service_id	int(11)	None
label	varchar(255)	None

Table: `stats_data`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
stat_id	int(11)	None
service_id	int(11)	None
type	enum('SHARD','ORG')	None
ref_id	int(11)	None
value	double	None
added_on	timestamp	None

Table: `service`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
name	varchar(255)	Part of UNIQUE KEY (name)
description	varchar(255)	None
meta_type	enum('SERVICE','DB')	None
type_id	int(11)	None
added_on	timestamp	None
is_sharded	tinyint(1)	None
shard_count	int(11)	None
is_multiple	tinyint(1)	None
instance_count	int(11)	None
policy_id	int(11)	None
is_active	tinyint(1)	None
auto_update_time	timestamp	None

Table: `shard_policy`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
name	varchar(255)	Part of UNIQUE KEY (name)
added_on	timestamp	None
is_active	tinyint(1)	None
is_sharded	tinyint(1)	None
shard_count	int(11)	None

Table: `bill_dump_import_attributes_temp`

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(50)	Part of UNIQUE KEY (name)
extraction_type	enum('UPLOAD','POS','REGEX','USERDEF')	None
extraction_params	mediumtext	None
data_type	enum('String','Int','Boolean','Double')	None

Table: `bill_dump_import_bills`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
org_id	bigint(20)	Part of KEY (org_id)
bill_number	varchar(50)	Part of KEY (bill_number)
date	datetime	Part of KEY (date)
bill_amount	float	None
entered_by	bigint(20)	Part of KEY (entered_by)
processed	datetime	None
loyalty_log_id_ref	bigint(20)	None
external_id_used	mediumtext	None
customer_int	bigint(20)	None
customer_varchar	varchar(50)	None
customer_flag	enum('VALID','INVALID','OUTLIER','FRAUD')	None
auto_update_time	timestamp	Part of KEY (auto_update_time)

Table: `bill_dump_import_bill_lineitems`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
org_id	bigint(20)	Part of KEY (org_id)
bill_dump_import_bills_id	bigint(20)	Part of UNIQUE KEY (bill_dump_import_bills_id)
serial	int(11)	None
item_code	varchar(20)	None
description	mediumtext	None
mrp	double	None
discount_value	double	None
amount	double	None
qty	int(11)	None
entered_by	bigint(20)	Part of UNIQUE KEY (entered_by)
processed	datetime	None
loyalty_bill_lineitems_id_ref	bigint(20)	None
unique_id	bigint(20)	Part of UNIQUE KEY (unique_id)
auto_update_time	timestamp	Part of KEY (auto_update_time)

Table: `bill_dump_import_attributes`

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(50)	Part of UNIQUE KEY (name)
extraction_type	enum('UPLOAD','POS','REGEX','USERDEF')	None
extraction_params	mediumtext	None
data_type	enum('String','Int','Boolean','Double')	None

Table: `bill_dump_import_bill_lineitems_attribute_values`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of KEY (org_id)
bill_dump_import_bill_lineitem_id	bigint(20)	Part of UNIQUE KEY (bill_dump_import_bill_lineitem_id)
bill_dump_import_attribute_id	int(11)	Part of KEY (bill_dump_import_attribute_id)
bill_dump_import_attribute_value	longtext	None
bill_dump_import_attribute_name	varchar(40)	None
auto_update_time	timestamp	Part of KEY (auto_update_time)

Table: `event_token_config`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
resource	varchar(100)	None
method	varchar(100)	None
http_method	varchar(11)	None
version	varchar(100)	None
module	varchar(100)	None
details	varchar(255)	None
token_value	int(11)	None
last_changed_date	datetime	None
is_active	tinyint(1)	None

Table: `token_summary`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of UNIQUE KEY (org_id)
allotted	int(11)	None
consumed	int(11)	None
expired	int(11)	None
is_active	tinyint(1)	None

Table: `token_allottment_log`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	None
allocated_date	datetime	None
expiry_date	datetime	None
value	int(11)	None
created_on	datetime	None
created_by	int(11)	None
last_modified_on	datetime	None
last_modified_by	int(11)	None

Table: `token_consumption_log`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of KEY (org_id)
user_id	int(11)	None
start_date	datetime	None
end_date	datetime	None
value	int(11)	None

Table: `rate_limiting_config`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	None
module	enum('API')	None
context_type	enum('TILL','ADMIN_USER','STR_SERVER','ASSOCIATE','STORE','ZONE','CLIENT_IP','ORG')	None
context_value	varchar(100)	None
unit	enum('DAILY','HOURLY','MINUTE')	None
value	int(11)	None
is_active	tinyint(1)	None
created_on	datetime	None
created_by	int(11)	None
last_modified_on	datetime	None
last_modified_by	int(11)	None
auto_update_time	timestamp	None

Table: `rules`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
type	varchar(45)	Part of KEY (type)
value	varchar(45)	None
api_request_type	varchar(45)	None
is_active	tinyint(1)	Part of KEY (is_active)

Table: `rate_limit_hit`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	bigint(20)	Part of KEY (org_id)
loggable_user_id	int(11)	Part of KEY (loggable_user_id)
resource	varchar(100)	None
method	varchar(100)	None
start_time	datetime	None
end_time	datetime	None
client_ip	bigint(20)	None
api_version	varchar(10)	None
query_params	longtext	None
http_method	enum('GET','POST','HEAD','PUT','DELETE')	None
user_agent_id	int(11)	None
status_codes	mediumtext	None
request_id	mediumtext	None
server_ip	bigint(20)	None
error_message	text	None

Table: `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`

Column Name	Data Type	Index
id	int(11)	None
operation	text	None

Table: `org_channel_accounts`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
channel_id	int(11)	Part of UNIQUE KEY (channel_id)
account_name	varchar(100)	Part of UNIQUE KEY (account_name)
org_id	int(11)	Part of UNIQUE KEY (org_id)
added_by	int(11)	None
added_on	datetime	None
updated_by	int(11)	None
updated_on	datetime	None
uuid	varchar(100)	Part of UNIQUE KEY (uuid)
to_mirror	tinyint(1)	None
source_account_id	varchar(100)	Part of UNIQUE KEY (source_account_id)
auto_update_time	timestamp	None
is_active	tinyint(1)	None

Table: `org_base_tiny_url`

Column Name	Data Type	Index
id	int(20)	Part of PRIMARY KEY (id)
org_id	int(20)	Part of PRIMARY KEY (org_id)
base_tiny_url	varchar(500)	None
last_updated_by	int(11)	None
last_updated_on	timestamp	None

Table: `cf_transformer_error_logs`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
org_id	bigint(20)	Part of KEY (org_id)
cf_id	varchar(50)	Part of KEY (cf_id)
assoc_id	bigint(20)	None
error_log	mediumtext	None
auto_update_time	timestamp	Part of KEY (auto_update_time)

Table: `channel_config_keys`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
channel_id	int(11)	None
key	varchar(255)	None
label	varchar(255)	None
key_type	enum('string','bool','list','number')	None
default_value	varchar(400)	None
display_order	int(3)	None
added_by	int(11)	None
added_on	datetime	None
updated_by	int(11)	None
updated_on	datetime	None
auto_update_time	timestamp	None

Table: `extended_fields`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
name	varchar(100)	Part of UNIQUE KEY (name)
entity_type	enum('customer','transaction','lineitem','profile','lead','company','card','usergroup2')	Part of UNIQUE KEY (entity_type)
label	varchar(100)	None
datatype	enum('integer','string','standard_string','double','datetime','standard_enum','custom_enum','associate_user','country','currency','language','org_entity',	None
created_on	datetime	None
created_by	int(11)	None
modified_on	datetime	None
modified_by	int(11)	None
vertical_id	int(11)	None
auto_update_time	timestamp	None
parent_id	tinyint(1)	None

Table: `currency_ratio_inr`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
currency_id	int(10)	Part of KEY (currency_id)
ratio	decimal(12,3)	None
start_date	date	None
end_date	date	None
is_active	tinyint(1)	Part of KEY (is_active)
auto_update_time	timestamp	Part of KEY (auto_update_time)

Table: `cf_transformer_stats`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
date	date	Part of UNIQUE KEY (date)
org_id	bigint(20)	Part of UNIQUE KEY (org_id)
cf_id	varchar(50)	Part of UNIQUE KEY (cf_id)
count_picked	bigint(20)	None
count_transformed	bigint(20)	None
count_saved	bigint(20)	None

Table: `cf_transform_scheduler`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
cf_Id	int(11)	None
status	enum('COMPLETE','IN_PROGRESS','FAILED')	None
start_time	datetime	None
end_time	datetime	None
total_count	int(11)	None
org_id	int(11)	None
processed_count	int(11)	None
latest_cfv_id_processed	bigint(20)	None
auto_update_time	timestamp	None

Table: `cf_transform_scheduler_stats`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
org_id	int(11)	None
cf_id	int(11)	None
time	datetime	Part of KEY (time)
count_picked	bigint(20)	None
count_transformed	bigint(20)	None
count_processed	bigint(20)	None

Table: `verticals`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
name	varchar(100)	None

Table: `extended_fields_standard_enum_values`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
ef_id	int(11)	Part of UNIQUE KEY (ef_id)
value	varchar(100)	Part of UNIQUE KEY (value)
created_by	int(11)	None
created_on	datetime	None
modified_by	int(11)	None
modified_on	datetime	None
auto_update_time	timestamp	None

Table: `extended_field_config`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of PRIMARY KEY (org_id)
extended_field_id	int(11)	None
created_on	datetime	None
created_by	int(11)	None
modified_on	datetime	None
modified_by	int(11)	None
auto_update_time	timestamp	None
hide_display	tinyint(1)	None
is_mandatory	tinyint(1)	None
is_updatable	tinyint(1)	None
position	int(11)	None
default_value	varchar(200)	None
is_compute_enabled	tinyint(1)	None
function_id	int(11)	None
is_audit_trail_enabled	tinyint(1)	None
is_pii_data	tinyint(1)	None
is_psi_data	tinyint(1)	None
reject_txn_on_invalid_value	tinyint(1)	None

Table: `campaign_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: `bulk_job_status`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
activity_name	varchar(255)	Part of UNIQUE KEY (activity_name)
last_run_time	datetime	None
auto_update_time	timestamp	None

Table: `extended_field_function_template_fields`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
field_id	int(11)	Part of UNIQUE KEY (field_id)
template_id	int(11)	None
field_value	varchar(255)	None
is_active	tinyint(1)	None
entity_type	varchar(50)	None
function_id	int(11)	Part of UNIQUE KEY (function_id)
org_id	int(11)	Part of UNIQUE KEY (org_id)
auto_update_time	timestamp	None
extended_field_id	int(11)	None

Table: `file_processing_status`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of KEY (org_id)
acc_id	int(11)	Part of KEY (acc_id)
key_id	int(11)	Part of KEY (key_id)
value_id	int(11)	Part of KEY (value_id)
file_name	varchar(100)	Part of KEY (file_name)
added_on	datetime	None
last_updated	datetime	None
status	enum('NONE','PROCESSING','FINISHED','ERROR')	None

Table: `org_meta_data`

Column Name	Data Type	Index
id	int(11)	Part of UNIQUE KEY (id)
org_id	int(11)	Part of KEY (org_id)
vertical_id	int(11)	Part of KEY (vertical_id)
finance_id	varchar(250)	None
org_category	enum(	None
cs_category	enum("A",	None
brand_type	varchar(250)	None
business_unit	enum("India",	None
enable_products	varchar(250)	None
auto_update_time	timestamp	None

Table: `product_config_key_values`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
key_id	int(11)	Part of KEY (key_id)
org_id	int(11)	Part of KEY (org_id)
entity_id	int(11)	Part of KEY (entity_id)
scope	enum('STORE','ZONE','ORG','TILL','STR_SERVER','OU')	Part of KEY (scope)
value	mediumtext	None
updated_by	int(11)	None
updated_on	datetime	None
is_valid	tinyint(1)	Part of KEY (is_valid)
parent_id	int(11)	Part of KEY (parent_id)

Table: `shipping_address_type`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of KEY (org_id)
name	varchar(100)	Part of KEY (name)
description	varchar(200)	None
auto_update_time	timestamp	Part of KEY (auto_update_time)

Table: `extended_field_functions`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
name	varchar(255)	None
label	varchar(255)	None
type	varchar(255)	None
Description	varchar(255)	None

Table: `extended_fields_possible_enum_values`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
ef_id	int(11)	Part of UNIQUE KEY (ef_id)
org_id	int(11)	Part of UNIQUE KEY (org_id)
value	varchar(100)	Part of UNIQUE KEY (value)
created_by	int(11)	None
created_on	datetime	None
modified_by	int(11)	None
modified_on	datetime	None
auto_update_time	timestamp	None

Table: `comm_channel_type`

Column Name	Data Type	Index
id	int(2)	Part of PRIMARY KEY (id)
name	varchar(100)	Part of UNIQUE KEY (name)

Table: `org_source_attribute_priority`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
attribute_type	enum('COMM_CHANNEL','IDENTIFIER','EXTENDED_FIELD')	Part of UNIQUE KEY (attribute_type)
attribute_id	int(2)	Part of UNIQUE KEY (attribute_id)
org_source_id	int(11)	Part of UNIQUE KEY (org_source_id)
priority	int(2)	Part of UNIQUE KEY (priority)

Table: `channel_config_key_values`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	bigint(20)	Part of UNIQUE KEY (org_id)
key_id	int(11)	Part of UNIQUE KEY (key_id)
value	text	None
account_id	int(11)	Part of UNIQUE KEY (account_id)
added_by	int(11)	None
added_on	datetime	None
updated_by	int(11)	None
updated_on	datetime	None
auto_update_time	timestamp	None

Table: `org_shipment_types`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of UNIQUE KEY (org_id)
label	varchar(100)	Part of UNIQUE KEY (label)
deliveryHours	double	None
is_active	tinyint(1)	None
description	varchar(100)	None
created_on	datetime	None
created_by	int(11)	None
last_updated_by	int(11)	None
auto_update_time	timestamp	Part of KEY (auto_update_time)

Table: `ota_bank_enum_values`

Column Name	Data Type	Index
id	int(11)	Part of UNIQUE KEY (id)
value	varchar(20)	Part of UNIQUE KEY (value)
auto_update_time	timestamp	None

Table: `tinyurls`

Column Name	Data Type	Index
id	int(20)	Part of PRIMARY KEY (id)
full_url	varchar(500)	None
valid_till	date	None
timestamp	timestamp	None

Table: `extended_field_functions_meta_fields`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
default_value	varchar(50)	None
description	varchar(50)	None
field_name	varchar(50)	None
field_type	varchar(50)	None
function_id	int(11)	None
is_mandatory	tinyint(1)	None
label	varchar(50)	None
data_type	varchar(50)	None
possible_values	varchar(255)	None

Table: `product_config_keys`

Column Name	Data Type	Index
id	int(11)	Part of KEY (id)
name	varchar(250)	Part of KEY (name)
label	varchar(250)	None
scopes	varchar(250)	None
value_type	enum('STRING','NUMERIC','BOOL','LIST','MAP','RANGE')	None
default_value	mediumtext	None
security_group	varchar(250)	None
modules	varchar(250)	None
added_by	int(11)	None
added_on	datetime	None
is_valid	tinyint(1)	Part of KEY (is_valid)
parent_id	int(11)	None

Table: `channels`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
name	varchar(255)	Part of UNIQUE KEY (name)
added_by	int(4)	None
added_on	datetime	None

Table: `vertical_to_org_mapping`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of KEY (org_id)
vertical_id	int(11)	Part of UNIQUE KEY (vertical_id)
is_active	tinyint(1)	None
created_on	datetime	None
created_by	int(11)	None
modified_on	datetime	None
modified_by	int(11)	None
auto_update_timestamp	timestamp	None

Table: `org_delivery_modes`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of UNIQUE KEY (org_id)
label	varchar(100)	Part of UNIQUE KEY (label)
is_active	tinyint(1)	None
description	varchar(100)	None
created_on	datetime	None
created_by	int(11)	None
last_updated_by	int(11)	None
auto_update_time	timestamp	Part of KEY (auto_update_time)

Table: `source_comm_channel_type`

Column Name	Data Type	Index
id	int(5)	Part of PRIMARY KEY (id)
source_type_id	int(2)	Part of UNIQUE KEY (source_type_id)
comm_channel_type_id	int(2)	Part of UNIQUE KEY (comm_channel_type_id)

Table: `template_event_mappings`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
is_enabled	tinyint(1)	None
event_id	bigint(20)	Part of KEY (event_id)
language_code	varchar(255)	None
language_policy	varchar(255)	None
namespace	varchar(255)	None
template_id	varchar(255)	Part of UNIQUE KEY (template_id)
whatsapp_id	bigint(20)	Part of KEY (whatsapp_id)

Table: `communication_event_statuses`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
api_payload	json	None
api_response	json	None
event_id	bigint(20)	Part of KEY (event_id)
api_name	varchar(255)	None
mobile	varchar(255)	None
org_id	bigint(20)	Part of KEY (org_id)
request_id	varchar(255)	None
request_method	varchar(255)	None
webhook_req_id	varchar(255)	None
auto_update_time	TIMESTAMP	None

Table: `tags`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
template_event_map_id	bigint(20)	Part of KEY (template_event_map_id)
name	varchar(255)	None
json_path	varchar(255)	None
type	varchar(255)	None

Table: `org_config_keys`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
config_key	varchar(255)	None
default_val	varchar(255)	None

Table: `whatsapp_accounts`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
is_enabled	tinyint(1)	None
whatsapp_intouch_id	varchar(255)	None
org_id	bigint(20)	Part of KEY (org_id)
uuid	varchar(255)	None

Table: `orgs`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
is_enabled	tinyint(1)	None
name	varchar(255)	None
till	varchar(255)	Part of UNIQUE KEY (till)

Table: `communication_tags`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
name	varchar(255)	None
json_path	varchar(255)	None
event_id	bigint(20)	Part of KEY (event_id)
type	varchar(255)	None

Table: `whatsapp_config_keys`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
config_key	varchar(255)	None
default_val	varchar(255)	None
whatsapp_id	bigint(20)	Part of KEY (whatsapp_id)

Table: `org_config_values`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
config_key_id	bigint(20)	Part of KEY (config_key_id)
org_id	bigint(20)	Part of KEY (org_id)
value	varchar(255)	None

Table: `templates`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
communication_type	varchar(255)	None
event_id	bigint(20)	Part of KEY (event_id)
is_default_set	tinyint(1)	None
language	varchar(255)	None
org_id	bigint(20)	Part of KEY (org_id)
template	varchar(255)	None
role	varchar(255)	None
title	varchar(255)	None
is_enabled	tinyint(1)	None

Table: `whatsapp_config_values`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
config_key_id	bigint(20)	Part of KEY (config_key_id)
value	varchar(255)	None
whatsapp_id	bigint(20)	Part of KEY (whatsapp_id)

Table: `events`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
name	varchar(255)	None

Table: `event_statuses`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
fetch_customer_req_id	varchar(255)	None
customer_subscription_req_id	varchar(255)	None
template_event_map_id	bigint(20)	Part of KEY (template_event_map_id)
message_id	varchar(255)	None
mobile	varchar(255)	Part of KEY (mobile)
org_id	bigint(20)	Part of KEY (org_id)
status	varchar(255)	None
user_id	varchar(255)	None
webhook_req_id	varchar(255)	None
auto_update_time	timestamp	None

Table: `rate_limit_criteria`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
limit_id	int(11)	None
field	varchar(255)	None
operator	varchar(100)	None
value	varchar(255)	None
is_active	tinyint(1)	None

Table: `redirection`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
prefix	varchar(255)	None
is_active	tinyint(1)	None
added_by	varchar(100)	None
added_on	datetime	None
deleted_by	varchar(100)	None
deleted_on	datetime	None

Table: `default_rate_limit_criteria`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
default_limit_id	int(11)	None
field	varchar(255)	None
operator	varchar(100)	None
value	varchar(255)	None
is_active	tinyint(1)	None

Table: `limits`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
entity_id	int(11)	None
name	varchar(200)	None
entity_level	varchar(100)	None
limit	int(11)	None
limit_level	varchar(100)	None
window	varchar(100)	None
is_active	tinyint(1)	None
added_by	varchar(100)	None
added_on	datetime	None
deleted_by	varchar(100)	None
deleted_on	datetime	None

Table: `default_rate_limits`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
entity_id	int(11)	None
entity_level	varchar(100)	None
limit	int(11)	None
limit_level	varchar(100)	None
window	varchar(100)	None
is_active	tinyint(1)	None
added_by	varchar(100)	None
added_on	datetime	None

Table: `redirection_criteria`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
redirection_id	int(11)	None
field	varchar(255)	None
operator	varchar(100)	None
value	varchar(255)	None
is_active	tinyint(1)	None

Table: `azn_ag_resource_perms`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of UNIQUE KEY (org_id)
access_group_id	int(11)	Part of UNIQUE KEY (access_group_id)
resource_id	int(11)	Part of UNIQUE KEY (resource_id)
api_type	enum('DATA',	Part of UNIQUE KEY (api_type)
permission	enum('NONE',	None
is_active	tinyint(1)	None
updated_by	int(11)	None
last_updated_on	timestamp	None

Table: `group_permissions`

Column Name	Data Type	Index
group_id	bigint(20)	Part of PRIMARY KEY (group_id)
permission_id	bigint(20)	Part of PRIMARY KEY (permission_id)
created	timestamp	None
is_active	tinyint(4)	None
last_updated_by	int(11)	None
last_updated_on	datetime	None

Table: `azn_resources`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
name	varchar(100)	Part of UNIQUE KEY (name)
is_active	tinyint(1)	None
is_active_for_ui	tinyint(1)	None
last_updated_on	timestamp	None

Table: `user_app_features`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of UNIQUE KEY (org_id)
feature_id	int(11)	Part of UNIQUE KEY (feature_id)
security_group_json	varchar(50)	None
is_active	tinyint(4)	None
entered_by	int(11)	None
auto_update_time	timestamp	None

Table: `modules`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
name	varchar(50)	None
code	varchar(20)	Part of UNIQUE KEY (code)
is_web_client	tinyint(1)	None
version	varchar(10)	None
namespace	varchar(100)	None
display_order	tinyint(4)	None
visible_to_customer	tinyint(4)	None
is_free_module	tinyint(4)	None
notes	mediumtext	None
created	timestamp	None

Table: `resources`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
module_id	int(11)	Part of UNIQUE KEY (module_id)
name	varchar(50)	None
code	varchar(255)	Part of UNIQUE KEY (code)
description	text	None
visibility	tinyint(4)	None

Table: `org_app_features`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of UNIQUE KEY (org_id)
feature_id	int(11)	Part of UNIQUE KEY (feature_id)
is_active	tinyint(4)	None
entered_by	int(11)	None
auto_update_time	timestamp	None

Table: `group_templates_permissions`

Column Name	Data Type	Index
group_id	int(11)	None
permission_id	int(11)	None

Table: `resources_mapping`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
module_id	int(11)	Part of UNIQUE KEY (module_id)
parent_resource_id	int(11)	Part of UNIQUE KEY (parent_resource_id)
child_resource_id	int(11)	Part of UNIQUE KEY (child_resource_id)
last_updated_by	int(11)	None
last_updated_on	datetime	None

Table: `permission_hierarchy`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
parent_permission_id	int(11)	None
child_permission_id	int(11)	Part of UNIQUE KEY (child_permission_id)
notes	varchar(40)	None

Table: `approver_logs`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
approver_id	int(11)	None
user_id	int(11)	None
groups_included	mediumtext	None
sent_on	datetime	None
approved_on	datetime	None
status	tinyint(1)	None

Table: `membership_change_log`

Column Name	Data Type	Index
user_id	int(11)	Part of KEY (user_id)
org_id	int(11)	None
group_id	int(11)	None
changed_by	int(11)	None
time	timestamp	None
action	enum('ADD','DELETE')	None

Table: `modules_help_url`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
module_id	int(11)	Part of UNIQUE KEY (module_id)
params	mediumtext	None
updated_by	int(11)	None
last_updated_on	timestamp	None
locale_id	int(11)	Part of UNIQUE KEY (locale_id)

Table: `tab_based_actions`

Column Name	Data Type	Index
action_id	int(11)	None
parent_action_id	int(11)	None
module_id	int(11)	None
action_type	varchar(50)	None
last_updated_by	int(11)	None
last_updated_on	datetime	None

Table: `workflow_hierarchy`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
permission_id	bigint(20)	None
parent_workflow_id	bigint(20)	None
parent_workflow_hierarchy_id	bigint(20)	None
type	varchar(20)	None
workflow_id	bigint(20)	None
org_id	bigint(20)	None
is_active	tinyint(4)	None
last_updated_by	int(11)	None
last_updated_on	datetime	None

Table: `groups`

Column Name	Data Type	Index
org_id	bigint(20)	Part of UNIQUE KEY (org_id)
group_id	int(11)	Part of PRIMARY KEY (group_id)
group_name	varchar(50)	Part of UNIQUE KEY (group_name)
notes	text	None
type	enum('STANDARD','CUSTOM')	None
version	tinyint(1)	None
visible_on_ui	tinyint(1)	None
created	timestamp	None
last_updated_on	datetime	None
last_updated_by	int(11)	None
is_active	tinyint(4)	None

Table: `group_templates`

Column Name	Data Type	Index
id	int(11)	Part of UNIQUE KEY (id)
ref_id	int(11)	Part of UNIQUE KEY (ref_id)

Table: `user_proxy_orgs`

Column Name	Data Type	Index
user_id	bigint(20)	Part of UNIQUE KEY (user_id)
proxy_org_id	bigint(20)	Part of UNIQUE KEY (proxy_org_id)
active	tinyint(4)	None
modified_by	bigint(20)	None
modified_on	datetime	None

Table: `app_features`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
name	varchar(30)	None
type	varchar(20)	None
tag	varchar(30)	None
auto_update_time	timestamp	None

Table: `features`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
module_id	int(11)	None
name	varchar(255)	Part of UNIQUE KEY (name)
label	varchar(255)	None
is_active	tinyint(4)	None
feature_type	enum('BASIC','ADVANCED')	None
created_by	int(11)	None
created_on	datetime	None
updated_by	int(11)	None
updated_on	datetime	None

Table: `workflows`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
name	varchar(100)	None
description	varchar(200)	None
module_id	int(11)	None
created	timestamp	None
last_updated_on	datetime	None
last_updated_by	int(11)	None
org_id	bigint(20)	None
is_active	tinyint(4)	None

Table: `actions`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
namespace	varchar(100)	Part of UNIQUE KEY (namespace)
resource_id	int(11)	Part of UNIQUE KEY (resource_id)
module_id	int(11)	Part of UNIQUE KEY (module_id)
name	varchar(50)	Part of UNIQUE KEY (name)
code	varchar(255)	Part of UNIQUE KEY (code)
is_active	tinyint(4)	None
description	text	None
permission_id	int(11)	None
visibility	tinyint(4)	None
offline_supported	tinyint(1)	None
is_dump	tinyint(4)	None
feature_id	int(11)	None
params	mediumtext	None
offline_source	enum('SMS','MISSED_CALL','ALL')	None

Table: `active_modules`

Column Name	Data Type	Index
org_id	bigint(20)	Part of PRIMARY KEY (org_id)
module_id	int(11)	Part of PRIMARY KEY (module_id)
active	tinyint(4)	None
created	datetime	None
last_updated	timestamp	None

Table: `azn_ag_assignments`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of KEY (org_id)
access_group_id	int(11)	None
assignment_level	enum('ORG_ENTITY_TYPE',	Part of KEY (assignment_level)
org_entity_type	enum('STORE','TILL','STR_SERVER','ZONE','CONCEPT','OAUTH_CLIENT')	None
org_entity_id	int(11)	Part of KEY (org_entity_id)
is_active	tinyint(1)	None
updated_by	int(11)	None
last_updated_on	timestamp	None

Table: `memberships`

Column Name	Data Type	Index
user_id	bigint(20)	Part of PRIMARY KEY (user_id)
group_id	int(11)	Part of KEY (group_id)
joined	timestamp	None
is_active	tinyint(4)	None
is_approved	tinyint(4)	None
org_id	bigint(20)	Part of PRIMARY KEY (org_id)

Table: `access_exceptions`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
user_id	bigint(20)	Part of KEY (user_id)
org_id	bigint(20)	Part of UNIQUE KEY (org_id)
action_id	bigint(20)	Part of UNIQUE KEY (action_id)
validity_date	datetime	None
assigned_by	bigint(20)	None
purpose	varchar(500)	None
expired	tinyint(4)	None

Table: `permissions`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
name	varchar(50)	None
notes	varchar(50)	None
assoc_module	int(11)	None
created	timestamp	None
visible_on_ui	tinyint(4)	None
type	varchar(20)	None
org_id	bigint(20)	None
is_active	tinyint(4)	None

Table: `vulcan_action_permissions`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
vulcan_action_id	int(11)	Part of UNIQUE KEY (vulcan_action_id)
permission_id	int(11)	Part of UNIQUE KEY (permission_id)
is_active	tinyint(4)	None
last_updated_on	datetime	None
last_updated_by	int(11)	None

Table: `azn_resource_endpoints`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
resource_id	int(11)	Part of KEY (resource_id)
api_type	enum('DATA',	None
pattern	varchar(250)	Part of UNIQUE KEY (pattern)
action	enum('INCLUDE','EXCLUDE')	None
priority	int(11)	None
is_active	tinyint(1)	None
last_updated_on	timestamp	None

Table: `org_namespaces`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
name	varchar(255)	Part of UNIQUE KEY (name)
org_id	int(11)	Part of UNIQUE KEY (org_id)
parent_namespace_id	int(11)	None
scope	ENUM('STANDARD',	None
is_active	tinyint(1)	None
created_by	int(11)	None
created_on	datetime	None
updated_by	int(11)	None
updated_on	datetime	None

Table: `org_features`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of UNIQUE KEY (org_id)
feature_id	int(11)	Part of UNIQUE KEY (feature_id)
is_active	tinyint(4)	None
expires_on	datetime	None
created_by	int(11)	None
created_on	datetime	None
updated_by	int(11)	None
updated_on	datetime	None

Table: `access_logs`

Column Name	Data Type	Index
action_id	int(11)	None
params	varchar(100)	None
user_id	int(11)	None
org_id	int(11)	None
time	datetime	None
apache_thread_id	varchar(60)	None

Table: `action_permissions`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
action_id	int(11)	Part of UNIQUE KEY (action_id)
permission_id	int(11)	Part of UNIQUE KEY (permission_id)
is_active	tinyint(4)	None
last_updated_on	datetime	None
last_updated_by	int(11)	None

Table: `azn_access_groups`

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(100)	Part of UNIQUE KEY (name)
description	varchar(500)	None
is_active	tinyint(1)	None
is_system_managed	tinyint(1)	None
created_by	int(11)	None
created_on	timestamp	None
updated_by	int(11)	None
last_updated_on	timestamp	None

Table: `import_error_logs`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
file_id	int(11)	Part of KEY (file_id)
record_id	int(11)	None
error	mediumtext	None

Table: `ftp_data_dump`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of KEY (org_id)
dump_call	varchar(30)	Part of KEY (dump_call)
dump_file	varchar(200)	None
status	enum('INIT','STARTED','TEMP_DUMP_FILE_INPROGRESS','TEMP_DUMP_FILE_COMPLETE','FTP_PUT_INPROGRESS','FTP_PUT_COMPLETE','FAILED')	None
scheduler_params	mediumtext	None
started_on	datetime	None
updated_on	timestamp	None

Table: `ftp_sources_templates_audit`

Column Name	Data Type	Index
org_id	int(11)	Part of KEY (org_id)
source_id	int(11)	Part of KEY (source_id)
source_details	text	None
template_mapping	text	None
cron_details	text	None
update_time	timestamp	None
updated_by	int(11)	None

Table: `import_templates_mappings`

Column Name	Data Type	Index
template_id	int(11)	Part of PRIMARY KEY (template_id)
org_id	int(11)	None
field_id	int(11)	Part of PRIMARY KEY (field_id)
field_name	varchar(100)	None
ref_type	enum('BASE','CUSTOM')	Part of PRIMARY KEY (ref_type)
field_index	int(11)	None
field_not_null	int(1)	None
field_transformer	varchar(100)	None
transformer_inputs	mediumtext	None
field_validation_type	varchar(100)	None
field_data_type	enum('VARCHAR','DATETIME','INT')	None
field_length	int(11)	None

Table: `import_running_status`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
import_id	int(11)	Part of UNIQUE KEY (import_id)
org_id	int(11)	Part of UNIQUE KEY (org_id)
type	varchar(50)	Part of UNIQUE KEY (type)
count	int(11)	None
current_state	varchar(200)	None
timestamp	datetime	None
notes	mediumtext	None
start_time	timestamp	None

Table: `import_conf_keys`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
profile_id	int(11)	Part of KEY (profile_id)
name	varchar(200)	None
label	varchar(200)	None
ui_type	varchar(100)	None
values	varchar(300)	None
default_value	varchar(200)	None
type	varchar(20)	None
is_mandatory	tinyint(4)	None
order_id	int(10)	Part of KEY (order_id)
parent_conf_key_name	varchar(100)	None

Table: `import_ftp_sources`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of KEY (org_id)
name	varchar(255)	None
server_url	varchar(99)	None
username	varchar(50)	None
password	varchar(50)	None
base_folder	varchar(255)	None
processed_folder	varchar(255)	None
sftp_enabled	tinyint(1)	None
is_active	tinyint(1)	None
non_stop	tinyint(1)	None
email	text	None
import_file_confs	varchar(255)	None
ref_id	int(11)	Part of KEY (ref_id)
location_hash	varchar(50)	Part of UNIQUE KEY (location_hash)
auto_update_time	timestamp	None
updated_by	int(11)	None
ftp_port	int(11)	None

Table: `ftp_background_import`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
file_id	int(11)	Part of KEY (file_id)
org_id	int(10)	None
tempdb_status	enum('TEMPDB_OPEN','TEMPDB_INPROGRESS','TEMPDB_DONE','TEMPDB_APPROVED','MAINDB_INPROGRESS','MAINDB_DONE','TEMPDB_FAILED','MAINDB_FAILED')	Part of KEY (tempdb_status)
email	varchar(200)	None
added_on	datetime	None
added_by	int(11)	None
last_picked_up	datetime	None
tempdb_done_time	datetime	None
maindb_done_time	datetime	None
nsadmin_id_temp	bigint(20)	None
nsadmin_id_main	bigint(20)	None
priority	int(5)	None
profile	int(1)	None
source_id	int(11)	None

Table: `import_point_engine_status`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
import_id	int(11)	Part of KEY (import_id)
point_engine_batch_id	int(10)	Part of KEY (point_engine_batch_id)
status	enum('SUCCESS','FAIL')	None
temp_table_start_id	int(10)	None
temp_table_end_id	int(10)	None
point_engine_status_details	mediumtext	None
last_update_on	timestamp	None

Table: `import_additional_details`

Column Name	Data Type	Index
file_id	int(11)	Part of KEY (file_id)
org_id	int(11)	Part of KEY (org_id)
configs	mediumtext	None
field_info	mediumtext	None
fs_file_handle	varchar(100)	None
additional_info	mediumtext	None

Table: `import_templates_mappings_bkp`

Column Name	Data Type	Index
template_id	int(11)	Part of PRIMARY KEY (template_id)
org_id	int(11)	None
field_id	int(11)	Part of PRIMARY KEY (field_id)
field_name	varchar(100)	None
ref_type	enum('BASE','CUSTOM')	Part of PRIMARY KEY (ref_type)
field_index	int(11)	None
field_not_null	int(1)	None
field_transformer	varchar(100)	None
transformer_inputs	mediumtext	None
field_validation_type	varchar(100)	None
field_data_type	enum('VARCHAR','DATETIME','INT')	None
field_length	int(11)	None

Table: `import_subscriptions`

Column Name	Data Type	Index
id	int(10)	Part of PRIMARY KEY (id)
org_id	int(10)	Part of KEY (org_id)
subscribed_from	date	None
subscribed_upto	date	None
added_by	int(10)	None
added_on	datetime	None
unsubscribed_on	datetime	None
status	tinyint(1)	None

Table: `import_logs`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	None
user_id	int(11)	None
import_profile_type	enum('CUSTOMER','BILL','INVENTORY')	None
db_details	mediumtext	None
status	enum('SUCCESS','FAIL','REJECT','PARTIAL')	None
records_uploaded	int(11)	None
records_updated_to_db	int(11)	None
imported_on	datetime	None

Table: `import_conf_keys_values`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
key_id	int(11)	Part of UNIQUE KEY (key_id)
template_id	int(11)	Part of UNIQUE KEY (template_id)
value	mediumtext	None

Table: `import_files_history`

Column Name	Data Type	Index
id	int(10)	Part of PRIMARY KEY (id)
org_id	int(10)	Part of KEY (org_id)
user_id	int(10)	Part of KEY (user_id)
filename	varchar(200)	None
namespace	varchar(500)	None
count	int(10)	None
template_id	int(10)	None
profile_id	int(10)	None
is_validated	int(10)	None
temp_table_name	varchar(200)	None
temp_table_count	int(10)	None
csv_properties	mediumtext	None
start_time	datetime	Part of KEY (start_time)
end_time	datetime	Part of KEY (end_time)
time_taken	datetime	None
import_status	enum('SUCCESS','FAIL','INPROGRESS','PREVIEWED','TEMP_DB_COMPLETED','POINT_ENGINE_PENDING','POINT_ENGINE_INPROGRESS','POINT_ENGINE_FAIL','CANCELED','DELETED')	Part of KEY (import_status)
memory_consumed	double	None
memory_peak	double	None
cpu_usage	double	None
task_time_breakup	mediumtext	None
query_time_breakup	mediumtext	None
additional_info	mediumtext	None

Table: `import_templates`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
name	varchar(100)	None
org_id	int(11)	None
profile_id	int(11)	Part of KEY (profile_id)
create_on	datetime	None
created_by	int(11)	None
is_valid	int(1)	None
valid_till	datetime	None

Table: `import_profiles`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
name	varchar(100)	Part of UNIQUE KEY (name)
type	varchar(20)	None
created_on	datetime	None
created_by	int(10)	None
is_valid	int(1)	None
valid_till	datetime	None
ftp_enabled	int(1)	None
ftp_folder_name	varchar(100)	Part of UNIQUE KEY (ftp_folder_name)

Table: `import_subscribed_profile_stages`

Column Name	Data Type	Index
id	int(10)	Part of PRIMARY KEY (id)
profile_id	int(10)	Part of UNIQUE KEY (profile_id)
stage_type	enum('ALL','TEMP_DB_INSERT','VALIDATIONS','MAINDB_COMPLETE','DAILY_SUMMARY','PENDING_NOTIFY','ERROR')	Part of UNIQUE KEY (stage_type)
group_subscribe_id	int(10)	Part of UNIQUE KEY (group_subscribe_id)

Table: `ftp_template_mapping`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of UNIQUE KEY (org_id)
source_id	int(11)	Part of UNIQUE KEY (source_id)
profile_id	int(11)	Part of UNIQUE KEY (profile_id)
template_id	int(11)	None
is_valid	tinyint(1)	None
auto_update_time	timestamp	None

Table: `import_points_engine_configs`

Column Name	Data Type	Index
org_id	int(11)	Part of KEY (org_id)
template_id	int(11)	Part of KEY (template_id)
pe_program_details	mediumtext	None

Table: `import_subscribed_emails`

Column Name	Data Type	Index
id	int(10)	Part of PRIMARY KEY (id)
group_subscribe_id	int(10)	Part of KEY (group_subscribe_id)
email	varchar(100)	Part of KEY (email)
status	tinyint(1)	Part of KEY (status)
unsubscribed_on	datetime	None

Table: `import_profiles_fields`

Column Name	Data Type	Index
profile_id	int(11)	Part of PRIMARY KEY (profile_id)
field_id	int(11)	Part of PRIMARY KEY (field_id)
field_name	varchar(100)	None
field_label	varchar(50)	None
field_data_type	enum('INT','VARCHAR','DATETIME','TEXT','FLOAT','VARBINARY','DOUBLE','BIGINT','DECIMAL(15,	None
field_length	int(11)	None
field_validation_type	varchar(100)	None
is_mandatory	tinyint(1)	None
info_text	mediumtext	None
possible_values	varchar(255)	None

Table: `import_subscribed_mobiles`

Column Name	Data Type	Index
id	int(10)	Part of PRIMARY KEY (id)
group_subscribe_id	int(10)	Part of KEY (group_subscribe_id)
mobile	varchar(13)	Part of KEY (mobile)
status	tinyint(1)	Part of KEY (status)
unsubscribed_on	datetime	None

Table: `import_system_configs`

Column Name	Data Type	Index
id	int(11)	Part of KEY (id)
label	varchar(50)	None
name	varchar(50)	Part of KEY (name)
value	varchar(255)	None
possible_values	varchar(200)	None
validation	varchar(50)	None
last_updatded_on	timestamp	None
config_type	varchar(20)	Part of KEY (config_type)
is_updatable	tinyint(1)	None

Table: `campaign_audience_downloads`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	None
campaign_id	int(11)	None
group_id	int(11)	None
file_path	varchar(250)	None
file_size	int(11)	None
status	enum('PROCESSING','EXECUTED','ARCHIVED')	None
uploaded_by	int(11)	None
last_updated	timestamp	None

Table: `download`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	None
status	enum('OPEN','EXECUTED','PROCESSING','ERROR','ARCHIVED')	None
module	varchar(50)	None
action	varchar(250)	None
params	mediumtext	None
scheduled_by	int(11)	Part of KEY (scheduled_by)
last_updated	timestamp	None
expiry_time	datetime	Part of KEY (expiry_time)

Table: `active_logins`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
ref_id	int(11)	Part of UNIQUE KEY (ref_id)
is_valid	tinyint(3)	None
user_agent	varchar(200)	None
sso_cookie	varchar(40)	Part of UNIQUE KEY (sso_cookie)
user_ip	varchar(20)	None
login_attempted_at	datetime	None
last_updated_on	datetime	None

Table: `user_cookies`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
ref_id	int(11)	Part of KEY (ref_id)
is_ip_session	tinyint(4)	None
user_ip	varchar(20)	None
cookie_hash	varchar(100)	Part of KEY (cookie_hash)
is_valid	tinyint(1)	None
valid_days	int(11)	None
created_on	datetime	None
expires_on	timestamp	None
status	enum('INVALID','TWO_FACTOR_PENDING','VALID','PENDING')	None

Table: `otp_history`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
otp	varchar(10)	None
ref_type	enum('LOGIN','RESET_PASSWORD','FORGOT_PASSWORD','OTP_LOGIN','VALIDATE_EMAIL','VALIDATE_MOBILE','CHANGE_MOBILE','CHANGE_EMAIL')	None
ref_id	bigint(20)	None
loggable_user_id	bigint(20)	None
created_on	timestamp	None
expires_on	timestamp	None
status	enum('VALIDATED','OPEN','EXPIRED')	None

Table: `verification_log`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
ref_id	int(11)	Part of KEY (ref_id)
user_ip	varchar(20)	None
type	enum('MOBILE','EMAIL','USERNAME')	None
identifier	varchar(100)	Part of UNIQUE KEY (identifier)
verfication_code	varchar(100)	Part of UNIQUE KEY (verfication_code)
number_of_times_reminded	tinyint(4)	None
is_valid	tinyint(4)	None
valid_till	datetime	None
last_updated_on	datetime	None

Table: `user_login_history_success_stories`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
ref_id	int(11)	Part of UNIQUE KEY (ref_id)
last_login_on	datetime	None

Table: `federated_sso_settings`

Column Name	Data Type	Index
id	bigint(20)	Part of PRIMARY KEY (id)
org_id	bigint(20)	Part of UNIQUE KEY (org_id)
is_org_attribute_enabled	tinyint(1)	None
is_enabled	tinyint(1)	None
auto_update_time	timestamp	None

Table: `username_cart`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
reserverd_for	int(11)	Part of KEY (reserverd_for)
user_ip	int(11)	None
user_cookie	int(11)	None
type	enum('USERNAME','EMAIL','MOBILE')	None
identifier	varchar(100)	None
is_valid	tinyint(4)	None
reserved_till	datetime	None

Table: `user_login_history`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
ref_id	int(11)	Part of KEY (ref_id)
identifier	varchar(255)	None
login_response	enum('SUCCESS','FAILURE')	None
failed_reason	varchar(255)	None
login_attempted_on	datetime	None

Table: `loggable_users`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of KEY (org_id)
cluster_region	enum('APAC','APAC-MORE','US','EU')	None
type	enum('TILL','ADMIN_USER','STR_SERVER','ASSOCIATE','USER')	None
ref_id	int(11)	Part of KEY (ref_id)
password_salt	varchar(100)	None
password	varchar(250)	None
is_active	tinyint(1)	None
is_deleted	tinyint(4)	None
password_validity	datetime	None
created_by	int(11)	None
last_updated_by	int(11)	None
last_updated_on	datetime	None

Table: `user_deleted_log`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
ref_id	int(11)	Part of KEY (ref_id)
cluster_region	enum('APAC','APAC-MORE','US','EU')	None
identifier_type	enum('USERNAME','MOBILE','EMAIL')	None
identifier	varchar(255)	None
deleted_by	int(11)	None
deleted_on	datetime	None

Table: `password_history`

Column Name	Data Type	Index
id	int(11)	Part of UNIQUE KEY (id)
ref_id	int(11)	None
password_salt	varchar(100)	None
password	varchar(250)	None
last_updated_by	int(11)	None
last_updated_on	datetime	None

Table: `user_activity_log`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
ref_id	int(11)	Part of KEY (ref_id)
user_ip	varchar(20)	None
activity_type	enum('VIEW','CREATE','UPDATE','DELETE')	None
action_type	enum('SINGLE','BULK')	None
reference_org_id	int(11)	None
user_ids	longtext	None
description	longtext	None
activity_date	datetime	None

Table: `user_attributes`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
ref_id	int(11)	Part of KEY (ref_id)
cluster_region	enum('APAC','APAC-MORE','US','EU')	Part of UNIQUE KEY (cluster_region)
identifier_type	enum('USERNAME','MOBILE','EMAIL')	Part of UNIQUE KEY (identifier_type)
identifier	varchar(255)	Part of UNIQUE KEY (identifier)
is_verfiied	tinyint(4)	None
last_updated_on	datetime	None

Table: `duo_factor_settings`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	int(11)	Part of UNIQUE KEY (org_id)
type	enum('TILL','ADMIN_USER','STR_SERVER','ASSOCIATE')	Part of UNIQUE KEY (type)
is_enabled	tinyint(4)	None
otp_validity_in_hours	int(11)	None
session_validity	int(11)	None
module	varchar(20)	Part of UNIQUE KEY (module)
auto_update_time	timestamp	None
otp_session_validity	int(11)	None
two_factor_validity_hours	int(11)	None

Table: `verification_body_template`

Column Name	Data Type	Index
id	int(11)	Part of PRIMARY KEY (id)
org_id	bigint(20)	Part of KEY (org_id)
identifier_type	enum('USERNAME','MOBILE','EMAIL')	Part of KEY (identifier_type)
activity_type	enum('RESET_PASSWORD','FORGOT_PASSWORD','OTP_LOGIN','VALIDATE_IDENTIFIER')	None
body	text	None

Table: `visitors`

Column Name	Data Type	Index
User__user_id	int(20)	Part of PRIMARY KEY (User__user_id)
org_id	int(15)	None
User__first_name	varchar(30)	None
User__last_name	varchar(30)	None
User__mobile	varchar(20)	None
User__email	varchar(50)	None
Last_purchased_store__store_id	int(20)	None
Last_purchased_store__Till_Id	int(20)	None
Auto_Update_Time_Cps	int(20)	None
Auto_Update_Time_Extnd	int(20)	None
is_registered	tinyint(1)	Part of KEY (is_registered)
registration_status	varchar(20)	None
imageQuality	varchar(40)	None
ReckoMsg	varchar(100)	None
code	int(10)	None
imageRegistered	int(10)	None
Date__Date	date	None
Time__Time	time	None
Last_purchased_store__till_name	varchar(50)	None

Table: `associates`

Column Name	Data Type	Index
id	int(20)	Part of PRIMARY KEY (id)
org_id	int(15)	None
first_name	varchar(30)	None
last_name	varchar(30)	None
mobile	varchar(20)	None
email	varchar(50)	None
store_id	int(15)	None
updated_on	datetime	None
added_on	datetime	None
added_by	int(15)	None
is_active	tinyint(1)	None
auto_update_time	timestamp	None
is_registered	tinyint(1)	Part of KEY (is_registered)
registration_status	varchar(20)	None
imageQuality	varchar(40)	None
ReckoMsg	varchar(100)	None
code	int(10)	None
imageRegistered	int(10)	None

Updated 1 day ago

Table: spark_org_status_mapping

Table: spark_org_voucher_status_mapping

Table: filter_queries

Table: spark_org_segment_status_mapping

Table: extended_fields_values

Table: language_support_ef_values

Table: client_credentials

Table: header_overrides

Table: prefix_service_mapping

Table: meta_test_temp_table

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: IF

Table: client_versions

Table: thin_client_version_mapping

Table: client_version_mapping

Table: device_details

Table: accessories_details

Table: installation_details

Table: post_installation_details

Table: device_registration_meta

Table: entrance_details

Table: whitelisted_network

Table: multi_language_fields

Table: multi_language_modules

Table: multi_language_entities

Table: multi_language_custom_fields

Table: scope_entities

Table: integration_client_scope_mapping

Table: integration_clients

Table: scope_entity_resource_mapping

Table: config_key_values

Table: jwk_keys

Table: config_keys

Table: org_blocks

Table: display_images

Table: org_actions

Table: button_types

Table: actions

Table: default_messages

Table: template_types

Table: custom_dimension_values

Table: date

Table: custom_dimension_insights_hierarchy

Table: custom_dimensions

Table: target_data

Table: filter

Table: filter_info

Table: field_properties

Table: form_parts

Table: filter_properties

Table: filter_execution

Table: org_configs

Table: vs_kpis_sqls

Table: `spark_org_status_mapping`

Table: `spark_org_voucher_status_mapping`

Table: `filter_queries`

Table: `spark_org_segment_status_mapping`

Table: `extended_fields_values`

Table: `language_support_ef_values`

Table: `client_credentials`

Table: `header_overrides`

Table: `prefix_service_mapping`

Table: `meta_test_temp_table`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `IF`

Table: `client_versions`

Table: `thin_client_version_mapping`

Table: `client_version_mapping`

Table: `device_details`

Table: `accessories_details`

Table: `installation_details`

Table: `post_installation_details`

Table: `device_registration_meta`

Table: `entrance_details`

Table: `whitelisted_network`

Table: `multi_language_fields`

Table: `multi_language_modules`

Table: `multi_language_entities`

Table: `multi_language_custom_fields`

Table: `scope_entities`

Table: `integration_client_scope_mapping`

Table: `integration_clients`

Table: `scope_entity_resource_mapping`

Table: `config_key_values`

Table: `jwk_keys`

Table: `config_keys`

Table: `org_blocks`

Table: `display_images`

Table: `org_actions`

Table: `button_types`

Table: `actions`

Table: `default_messages`

Table: `template_types`

Table: `custom_dimension_values`

Table: `date`

Table: `custom_dimension_insights_hierarchy`

Table: `custom_dimensions`

Table: `target_data`

Table: `filter`

Table: `filter_info`

Table: `field_properties`

Table: `form_parts`

Table: `filter_properties`

Table: `filter_execution`

Table: `org_configs`

Table: `vs_kpis_sqls`