-- Structure of the portfolio database "nextrouge_0000635" (MySQL 8.0.44). Structure only: no data.
-- Generated by reading SHOW CREATE TABLE for every table. Row counts are the server's estimates at the time.

-- mw_currency (~168 rows)
CREATE TABLE `mw_currency` (
  `currency_id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `code` char(3) NOT NULL,
  `value` decimal(15,8) NOT NULL DEFAULT '0.00000000',
  `is_default` enum('yes','no') NOT NULL DEFAULT 'no',
  `s_currency` char(1) DEFAULT NULL,
  `status` char(15) NOT NULL DEFAULT 'active',
  `date_added` datetime NOT NULL,
  `last_updated` datetime NOT NULL,
  `priority` int DEFAULT NULL,
  `dufault_p` enum('0','1') NOT NULL,
  PRIMARY KEY (`currency_id`),
  UNIQUE KEY `code_UNIQUE` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- mw_customer (~1 rows)
CREATE TABLE `mw_customer` (
  `customer_id` int NOT NULL AUTO_INCREMENT,
  `customer_uid` char(13) NOT NULL,
  `group_id` int DEFAULT NULL,
  `language_id` int DEFAULT NULL,
  `phone` varchar(16) DEFAULT NULL,
  `first_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `email` varchar(100) NOT NULL,
  `password` char(34) NOT NULL,
  `timezone` varchar(50) NOT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `hourly_quota` int NOT NULL DEFAULT '0',
  `removable` enum('yes','no') NOT NULL DEFAULT 'yes',
  `confirmation_key` char(40) DEFAULT NULL,
  `oauth_uid` bigint DEFAULT NULL,
  `oauth_provider` char(10) DEFAULT NULL,
  `status` char(15) NOT NULL DEFAULT 'inactive',
  `date_added` datetime NOT NULL,
  `last_updated` datetime NOT NULL,
  `last_login` datetime DEFAULT NULL,
  `s_name` varchar(255) NOT NULL,
  `s_address` varchar(250) DEFAULT NULL,
  `s_country_id` int DEFAULT NULL,
  `s_state_id` int DEFAULT NULL,
  `s_area_id` int DEFAULT NULL,
  `location_latitude` varchar(150) DEFAULT NULL,
  `location_longitude` varchar(150) DEFAULT NULL,
  `icon` varchar(150) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `area_location` varchar(250) DEFAULT NULL,
  `description` text,
  `opening` time DEFAULT NULL,
  `closing` time DEFAULT NULL,
  `lunch` date DEFAULT NULL,
  `lunch_close` date DEFAULT NULL,
  `h_s` char(1) DEFAULT NULL,
  `h_m` char(1) DEFAULT NULL,
  `h_t` char(1) DEFAULT NULL,
  `h_w` char(1) DEFAULT NULL,
  `h_th` char(1) DEFAULT NULL,
  `h_f` char(1) DEFAULT NULL,
  `h_st` char(1) DEFAULT NULL,
  `f_type` enum('B','F') NOT NULL,
  `avg_rating` decimal(2,1) DEFAULT NULL,
  `total_reviews` int DEFAULT NULL,
  `gender_id` int DEFAULT NULL,
  `verification_code` varchar(150) DEFAULT NULL,
  `reset_key` varchar(150) DEFAULT NULL,
  `email_verified` enum('0','1') NOT NULL,
  `o_verified` enum('0','1') NOT NULL,
  `enable_l_f` enum('0','1') NOT NULL,
  `e_skipped` enum('0','1') NOT NULL,
  `o_send_at` datetime DEFAULT NULL,
  `otp` char(6) DEFAULT NULL,
  `u_p` enum('0','1') NOT NULL,
  `otp_login_send` datetime DEFAULT NULL,
  `otp_login` char(6) DEFAULT NULL,
  `o_skipped` enum('0','1') NOT NULL,
  `v_send_at` datetime DEFAULT NULL,
  `cookie_otp` char(4) DEFAULT NULL,
  `active_plan` int DEFAULT NULL,
  `zip` char(8) NOT NULL,
  `dob` date DEFAULT NULL,
  `vat` varchar(50) DEFAULT NULL,
  `doc` varchar(250) DEFAULT NULL,
  `company_type` int DEFAULT NULL,
  `verified` enum('0','1') NOT NULL,
  `company_name` varchar(250) DEFAULT NULL,
  `e_referal` enum('0','1') NOT NULL,
  `c_type` enum('I','B') NOT NULL,
  `parent_customer` int DEFAULT NULL,
  `plan_id` int DEFAULT NULL,
  `registered_via` char(10) DEFAULT NULL,
  `category_id` int DEFAULT NULL,
  `prefix` varchar(50) DEFAULT NULL,
  `middle_name` varchar(150) DEFAULT NULL,
  `suffix` varchar(10) DEFAULT NULL,
  `skills` varchar(250) DEFAULT NULL,
  `hobbies` varchar(250) DEFAULT NULL,
  `job_title` varchar(250) DEFAULT NULL,
  `department` varchar(250) DEFAULT NULL,
  `pcode` char(10) DEFAULT NULL,
  `city` varchar(150) DEFAULT NULL,
  `district` varchar(150) DEFAULT NULL,
  `work` varchar(20) DEFAULT NULL,
  `ext` char(10) DEFAULT NULL,
  `home` varchar(20) DEFAULT NULL,
  `email2` varchar(150) DEFAULT NULL,
  `work_email` varchar(150) DEFAULT NULL,
  `zone_id` int DEFAULT NULL,
  `maiden_name` varchar(20) DEFAULT NULL,
  `linkedin` varchar(250) DEFAULT NULL,
  `twitter` varchar(250) DEFAULT NULL,
  `insta` varchar(250) DEFAULT NULL,
  `snap` varchar(250) DEFAULT NULL,
  `facebook` varchar(250) DEFAULT NULL,
  `youtube` varchar(250) DEFAULT NULL,
  `pinterest` varchar(250) DEFAULT NULL,
  `behance` varchar(250) DEFAULT NULL,
  `messenger` varchar(250) DEFAULT NULL,
  `skype` varchar(250) DEFAULT NULL,
  `w_l` varchar(250) DEFAULT NULL,
  `g_m` varchar(250) DEFAULT NULL,
  `teams` varchar(250) DEFAULT NULL,
  `website` varchar(250) DEFAULT NULL,
  `catalogue` varchar(250) DEFAULT NULL,
  `profile` varchar(250) DEFAULT NULL,
  `body_type` varchar(250) DEFAULT NULL,
  `allergies` varchar(250) DEFAULT NULL,
  `medical_h` varchar(250) DEFAULT NULL,
  `surgical_h` varchar(250) DEFAULT NULL,
  `family_h` varchar(250) DEFAULT NULL,
  `medications` varchar(250) DEFAULT NULL,
  `vaccinations` varchar(250) DEFAULT NULL,
  `license_number` varchar(50) DEFAULT NULL,
  `country_id_3` int DEFAULT NULL,
  `zone_id_3` int DEFAULT NULL,
  `activities` varchar(250) DEFAULT NULL,
  `cname` varchar(150) DEFAULT NULL,
  `crelative` varchar(150) DEFAULT NULL,
  `cname2` varchar(150) DEFAULT NULL,
  `crelative2` varchar(150) DEFAULT NULL,
  `no_4` varchar(20) DEFAULT NULL,
  `company_landline` varchar(20) DEFAULT NULL,
  `company_email` varchar(150) DEFAULT NULL,
  `company_address` varchar(250) DEFAULT NULL,
  `brand` varchar(100) DEFAULT NULL,
  `item_id` int DEFAULT NULL,
  `a_1` varchar(60) DEFAULT NULL,
  `a_2` varchar(60) DEFAULT NULL,
  `a_3` varchar(60) DEFAULT NULL,
  `a_4` varchar(60) DEFAULT NULL,
  `a_5` varchar(60) DEFAULT NULL,
  `a_1lab` varchar(100) DEFAULT NULL,
  `a_2lab` varchar(100) DEFAULT NULL,
  `a_3lab` varchar(100) DEFAULT NULL,
  `a_4lab` varchar(100) DEFAULT NULL,
  `a_5lab` varchar(100) DEFAULT NULL,
  `w_added` decimal(10,2) DEFAULT NULL,
  `w_used` decimal(10,2) DEFAULT NULL,
  `no_users` int DEFAULT NULL,
  `price` decimal(14,2) DEFAULT NULL,
  `category_id2` int DEFAULT NULL,
  `country_id` int DEFAULT NULL,
  `priority` int DEFAULT NULL,
  `industry` int DEFAULT NULL,
  `company_address2` varchar(250) DEFAULT NULL,
  `weight` varchar(100) DEFAULT NULL,
  `zone_id2` int DEFAULT NULL,
  `district2` varchar(250) DEFAULT NULL,
  `street2` varchar(250) DEFAULT NULL,
  `flat_number2` varchar(50) DEFAULT NULL,
  `country_id2` int DEFAULT NULL,
  `pname1` varchar(150) DEFAULT NULL,
  `pname2` varchar(150) DEFAULT NULL,
  `pname_no` varchar(20) DEFAULT NULL,
  `pname2_no` varchar(20) DEFAULT NULL,
  `gender` char(1) DEFAULT NULL,
  `married` char(1) DEFAULT NULL,
  `smocking_h` varchar(250) DEFAULT NULL,
  `bus_contact` varchar(20) DEFAULT NULL,
  `e1_na` varchar(250) DEFAULT NULL,
  `e1_co` varchar(15) DEFAULT NULL,
  `e2_na` varchar(250) DEFAULT NULL,
  `e2_co` varchar(250) DEFAULT NULL,
  `aum_calc_mode` varchar(10) NOT NULL DEFAULT 'net',
  `report_bank_filter_mode` varchar(32) NOT NULL DEFAULT 'children_only',
  `default_layout` varchar(32) NOT NULL DEFAULT 'default',
  PRIMARY KEY (`customer_id`),
  UNIQUE KEY `customer_uid_UNIQUE` (`customer_uid`),
  UNIQUE KEY `email_UNIQUE` (`email`),
  UNIQUE KEY `slug` (`slug`),
  KEY `fk_customer_language1_idx` (`language_id`),
  KEY `fk_customer_customer_group1_idx` (`group_id`),
  KEY `oauth` (`oauth_uid`,`oauth_provider`),
  KEY `s_area_id` (`s_area_id`),
  KEY `gender_id` (`gender_id`),
  KEY `active_plan` (`active_plan`),
  KEY `company_type` (`company_type`),
  KEY `parent_customer` (`parent_customer`),
  KEY `plan_id` (`plan_id`),
  KEY `category_id` (`category_id`),
  KEY `zone_id` (`zone_id`),
  KEY `item_id` (`item_id`),
  KEY `country_id` (`country_id`),
  KEY `zone_id2` (`zone_id2`),
  KEY `country_id2` (`country_id2`),
  KEY `mw_customer_ibfk_11` (`industry`),
  KEY `idx_report_bank_filter_mode` (`report_bank_filter_mode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- mw_customer_auto_login_token (~0 rows)
CREATE TABLE `mw_customer_auto_login_token` (
  `token_id` int NOT NULL AUTO_INCREMENT,
  `customer_id` int NOT NULL,
  `token` char(40) NOT NULL,
  PRIMARY KEY (`token_id`),
  KEY `fk_customer_auto_login_token_customer1_idx` (`customer_id`),
  CONSTRAINT `fk_customer_auto_login_token_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- mw_customer_banks (~0 rows)
CREATE TABLE `mw_customer_banks` (
  `bank_id` bigint NOT NULL AUTO_INCREMENT,
  `parent_bank_id` int DEFAULT NULL,
  `bank_name` varchar(250) COLLATE utf8mb4_general_ci NOT NULL,
  `r_currency` int DEFAULT NULL,
  `status` enum('A','I') COLLATE utf8mb4_general_ci NOT NULL,
  `d_status` char(15) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `user_id` int NOT NULL,
  `date_added` datetime NOT NULL,
  `last_updated` datetime NOT NULL,
  `cashback_update` date DEFAULT NULL,
  `leverage_update` date DEFAULT NULL,
  `priority` int DEFAULT NULL,
  `account_number` varchar(60) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `more_details` text COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`bank_id`),
  KEY `user_id` (`user_id`),
  KEY `r_currency` (`r_currency`),
  KEY `idx_parent_bank_id` (`parent_bank_id`),
  CONSTRAINT `mw_customer_banks_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE,
  CONSTRAINT `mw_customer_banks_ibfk_2` FOREIGN KEY (`r_currency`) REFERENCES `mw_currency` (`currency_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- mw_customer_banks_balance (~0 rows)
CREATE TABLE `mw_customer_banks_balance` (
  `currency_id` int NOT NULL,
  `bank_id` bigint NOT NULL,
  `balance` decimal(32,15) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `cnt` int NOT NULL,
  `stock_id` int NOT NULL,
  `temp_id` int DEFAULT NULL,
  PRIMARY KEY (`currency_id`,`bank_id`,`stock_id`),
  KEY `bank_id` (`bank_id`),
  KEY `stock_id` (`stock_id`),
  CONSTRAINT `mw_customer_banks_balance_ibfk_1` FOREIGN KEY (`currency_id`) REFERENCES `mw_currency` (`currency_id`) ON DELETE CASCADE,
  CONSTRAINT `mw_customer_banks_balance_ibfk_2` FOREIGN KEY (`bank_id`) REFERENCES `mw_customer_banks` (`bank_id`) ON DELETE CASCADE,
  CONSTRAINT `mw_customer_banks_balance_ibfk_3` FOREIGN KEY (`stock_id`) REFERENCES `mw_stock` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- mw_customer_banks_leverage (~0 rows)
CREATE TABLE `mw_customer_banks_leverage` (
  `currency_id` int NOT NULL,
  `bank_id` bigint NOT NULL,
  `balance` decimal(10,2) NOT NULL,
  `last_updated` datetime NOT NULL,
  `cnt` int NOT NULL,
  PRIMARY KEY (`currency_id`,`bank_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- mw_divident_childs (~0 rows)
CREATE TABLE `mw_divident_childs` (
  `stock_id` int NOT NULL,
  `divident_id` int NOT NULL,
  `quantiy` decimal(25,15) DEFAULT NULL,
  `amount` decimal(25,15) DEFAULT NULL,
  PRIMARY KEY (`stock_id`,`divident_id`),
  KEY `divident_id` (`divident_id`),
  CONSTRAINT `mw_divident_childs_ibfk_1` FOREIGN KEY (`divident_id`) REFERENCES `mw_stock` (`id`) ON DELETE CASCADE,
  CONSTRAINT `mw_divident_childs_ibfk_2` FOREIGN KEY (`stock_id`) REFERENCES `mw_stock` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- mw_divident_childs_corporate (~3457 rows)
CREATE TABLE `mw_divident_childs_corporate` (
  `stock_id` int NOT NULL,
  `divident_id` int NOT NULL,
  `quantiy` decimal(25,15) DEFAULT NULL,
  `amount` decimal(25,15) DEFAULT NULL,
  `customer_id` int NOT NULL,
  KEY `idx_div_stock_cust` (`stock_id`,`customer_id`),
  KEY `idx_div_parent_cust` (`divident_id`,`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- mw_drift_settings (~0 rows)
CREATE TABLE `mw_drift_settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `customer_id` int NOT NULL,
  `parent_id` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `child_id` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_class` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_type` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `industry` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sector` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `currency` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `country` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `target_percentage` decimal(10,4) NOT NULL DEFAULT '0.0000',
  `margin` decimal(10,4) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `isin` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin_group_id` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin_group_mode` varchar(16) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin_group_input_pct` decimal(10,4) DEFAULT NULL,
  `issuer` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `issuer_percentage` decimal(10,4) DEFAULT NULL,
  `is_advance` tinyint(1) NOT NULL DEFAULT '0',
  `operator` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `rule_group` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `layout_parent_type` varchar(16) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `layout_parent_id` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `rule_group_layout` varchar(16) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_customer_id` (`customer_id`),
  KEY `idx_is_active` (`is_active`),
  KEY `idx_customer_active` (`customer_id`,`is_active`),
  KEY `idx_isin` (`isin`),
  KEY `idx_rule_group` (`customer_id`,`rule_group`),
  KEY `idx_issuer` (`issuer`),
  KEY `idx_isin_group_id` (`customer_id`,`isin_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- mw_group_name (~4 rows)
CREATE TABLE `mw_group_name` (
  `group_id` int NOT NULL AUTO_INCREMENT,
  `group_name` varchar(250) NOT NULL,
  `customer_id` int NOT NULL,
  `status` enum('A','I') NOT NULL,
  `is_trash` enum('0','1') NOT NULL,
  `last_updated` datetime NOT NULL,
  PRIMARY KEY (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- mw_group_summary (~760 rows)
CREATE TABLE `mw_group_summary` (
  `ref_id` text,
  `group_id` int DEFAULT NULL,
  `customer_id` int NOT NULL,
  `ref_id_only` int DEFAULT NULL,
  `prefix` varchar(20) DEFAULT NULL,
  KEY `group_id` (`group_id`),
  CONSTRAINT `mw_group_summary_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `mw_group_name` (`group_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- mw_master (~41 rows)
CREATE TABLE `mw_master` (
  `master_id` int NOT NULL AUTO_INCREMENT,
  `master_name` varchar(250) DEFAULT NULL,
  `f_type` char(10) DEFAULT NULL,
  `status` enum('A','I','R') NOT NULL,
  `is_trash` enum('0','1') NOT NULL,
  `last_updated` datetime NOT NULL,
  `priority` int DEFAULT NULL,
  `a` enum('0','1') NOT NULL,
  `b` enum('0','1') NOT NULL,
  `category_id` int DEFAULT NULL,
  `parent_master` int DEFAULT NULL,
  `title` varchar(150) DEFAULT NULL,
  `master_array` char(1) DEFAULT NULL,
  `master_generated` varchar(250) DEFAULT NULL,
  `slug` varchar(250) NOT NULL,
  `file_name` varchar(150) DEFAULT NULL,
  `short_description` varchar(250) DEFAULT NULL,
  `multiline_text` varchar(250) DEFAULT NULL,
  `s_sm` char(1) DEFAULT NULL,
  `s_ec` char(1) DEFAULT NULL,
  `s_hi` char(1) DEFAULT NULL,
  `u_s_sm` char(1) DEFAULT NULL,
  `u_s_ec` char(1) DEFAULT NULL,
  `u_s_hi` char(1) DEFAULT NULL,
  `s_st` char(1) DEFAULT NULL,
  `code` varchar(6) DEFAULT NULL,
  PRIMARY KEY (`master_id`),
  KEY `category_id` (`category_id`),
  KEY `parent_master` (`parent_master`),
  CONSTRAINT `mw_master_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `mw_master_category` (`category_id`) ON DELETE SET NULL,
  CONSTRAINT `mw_master_ibfk_2` FOREIGN KEY (`parent_master`) REFERENCES `mw_master` (`master_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- mw_master_category (~0 rows)
CREATE TABLE `mw_master_category` (
  `category_id` int NOT NULL AUTO_INCREMENT,
  `category_name` varchar(250) NOT NULL,
  `status` enum('A','I') NOT NULL,
  `isTrash` enum('0','1') NOT NULL,
  `date_added` datetime DEFAULT NULL,
  `last_updated` datetime DEFAULT NULL,
  PRIMARY KEY (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- mw_master_stock_new (~18994 rows)
CREATE TABLE `mw_master_stock_new` (
  `master_id` bigint DEFAULT NULL,
  `customer_id` int NOT NULL,
  `id` int NOT NULL,
  `t_date` date DEFAULT NULL,
  `o_date` date DEFAULT NULL,
  `t_o_t` int DEFAULT NULL,
  `ticker_id` int DEFAULT NULL,
  `uid` int DEFAULT NULL,
  `c_currency` int DEFAULT NULL,
  `isin` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ticker` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin_id` int DEFAULT NULL,
  `a_class` int DEFAULT NULL,
  `a_type` int DEFAULT NULL,
  `r_no` char(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `p_date` date DEFAULT NULL,
  `quantity` decimal(32,15) DEFAULT NULL,
  `price` decimal(32,15) DEFAULT NULL,
  `p_currency` int DEFAULT NULL,
  `t_price` decimal(23,15) DEFAULT NULL,
  `commission` decimal(23,15) DEFAULT NULL,
  `b_1` decimal(23,15) DEFAULT NULL,
  `b_2` decimal(23,15) DEFAULT NULL,
  `b_3` decimal(23,15) DEFAULT NULL,
  `date_added` datetime NOT NULL,
  `last_updated` datetime NOT NULL,
  `user_id` int DEFAULT NULL,
  `d_status` char(15) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_type` char(2) COLLATE utf8mb4_general_ci NOT NULL,
  `parent_id` int DEFAULT NULL,
  `premium` decimal(32,15) DEFAULT NULL,
  `m_date` date DEFAULT NULL,
  `t_o_o` int DEFAULT NULL,
  `b_s` int DEFAULT NULL,
  `c_date` date DEFAULT NULL,
  `c_date2` date DEFAULT NULL,
  `c_date3` date DEFAULT NULL,
  `duration` int DEFAULT NULL,
  `total_days` int DEFAULT NULL,
  `duration_other` int DEFAULT NULL,
  `i_rate` decimal(23,15) DEFAULT NULL,
  `maturity` decimal(34,15) DEFAULT NULL,
  `security_id` int DEFAULT NULL,
  `amount` decimal(34,15) DEFAULT NULL,
  `net` decimal(34,15) DEFAULT NULL,
  `e_t` int DEFAULT NULL,
  `o_s` int DEFAULT NULL,
  `knock` decimal(23,15) DEFAULT NULL,
  `knock_t` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `knock_ft` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `i_b` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bank_id` bigint DEFAULT NULL,
  `sl` char(12) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `accumulator_id` int DEFAULT NULL,
  `d_type` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `d_p` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `md` char(2) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `s_percentage` decimal(23,15) DEFAULT NULL,
  `asset_type_t` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `market_price_t` decimal(32,15) DEFAULT NULL,
  `structure_name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `is_sale` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` enum('A','I') COLLATE utf8mb4_general_ci NOT NULL,
  `s_isin` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `product_type` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ko_barrirer` decimal(10,4) DEFAULT NULL,
  `parent_isin` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `parent_isin_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Industry1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Sector1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `MarketPrice1` decimal(32,15) DEFAULT NULL,
  `expired` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `balance_quantity` decimal(32,15) DEFAULT NULL,
  `balance_amount` decimal(34,15) DEFAULT NULL,
  `expired_id` int DEFAULT NULL,
  `parent_structure` int DEFAULT NULL,
  `s_asset_class` char(2) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `interest_id` int DEFAULT NULL,
  `move_live` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `move_potential` tinyint(1) NOT NULL DEFAULT '0',
  `expire_no_parent` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `expired_label` char(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `portfolio_cash_synced` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`customer_id`,`id`),
  KEY `idx_mwstocknew_uid_customer_dstatus_ticker` (`uid`,`customer_id`,`d_status`,`ticker`),
  KEY `idx_mwstocknew_uid_customer_ticker_ftype` (`uid`,`customer_id`,`ticker`,`f_type`),
  KEY `idx_msn_id_cust` (`id`,`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- mw_order_blotter (~0 rows)
CREATE TABLE `mw_order_blotter` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'S/N',
  `transaction_id` int DEFAULT NULL COMMENT 'Optional link to transactions.id (Phase 2 automation)',
  `transaction_corporate_db` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Corporate DB slug (DB_NAME); empty = legacy / single-DB backend',
  `layout_version` smallint NOT NULL DEFAULT '1',
  `extended_json` longtext COLLATE utf8mb4_unicode_ci COMMENT 'All form values keyed by registry column key (JSON)',
  `index_order_number` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Mirror for list/filter',
  `index_client_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Mirror for list/filter',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_by_user_id` int DEFAULT NULL,
  `updated_by_user_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_ob_tx_corporate_id` (`transaction_corporate_db`,`transaction_id`),
  KEY `idx_mw_order_blotter_updated` (`updated_at`),
  KEY `idx_mw_order_blotter_order_no` (`index_order_number`(64)),
  KEY `idx_mw_order_blotter_client` (`index_client_name`(64))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- mw_order_blotter_change_log (~0 rows)
CREATE TABLE `mw_order_blotter_change_log` (
  `log_id` bigint NOT NULL AUTO_INCREMENT,
  `order_blotter_id` int NOT NULL,
  `action` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'update' COMMENT 'create, update, delete',
  `user_id` int DEFAULT NULL,
  `changed_at` datetime NOT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `diff_json` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'JSON array of {key, section_id, old, new}',
  `snapshot_after_json` longtext COLLATE utf8mb4_unicode_ci COMMENT 'Optional full flattened snapshot after change',
  PRIMARY KEY (`log_id`),
  KEY `idx_ob_change_blotter_time` (`order_blotter_id`,`changed_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- mw_os_asof_20251001 (~326 rows)
CREATE TABLE `mw_os_asof_20251001` (
  `summary_id` bigint NOT NULL AUTO_INCREMENT,
  `ref_id` bigint NOT NULL,
  `customer_id` int NOT NULL,
  `stock_details` blob NOT NULL,
  `value` decimal(34,15) DEFAULT NULL,
  `status` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_type` char(2) COLLATE utf8mb4_general_ci NOT NULL,
  `priority` int NOT NULL,
  `stock_id` int NOT NULL,
  `uid` int DEFAULT NULL,
  `ticker` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bank_name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asetClass` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_type_title` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Industry` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Sector` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `t_date` date DEFAULT NULL,
  `MarketPriceCurrency` char(5) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PurchaseQuantity` decimal(32,15) DEFAULT NULL,
  `price` decimal(32,15) DEFAULT NULL,
  `purchaseValueFormated1` decimal(32,15) DEFAULT NULL,
  `MarketPriceFormated` decimal(32,15) DEFAULT NULL,
  `RealPrice` decimal(32,15) DEFAULT NULL,
  `MarketValueFormated` decimal(32,15) DEFAULT NULL,
  `GainLossFormated` varchar(201) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercteageGanLosFormated` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reporting_currency` char(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FXRate` decimal(10,6) DEFAULT NULL,
  `purchaseValuesInRcFormated` decimal(32,15) DEFAULT NULL,
  `MarketValueRCFormated` decimal(32,15) DEFAULT NULL,
  `DifferenceRCFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormatedinRc` decimal(32,15) DEFAULT NULL,
  `DividendCoupon` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TargetPrice` decimal(32,15) NOT NULL,
  `TargetPricePerentageFormat` decimal(32,15) DEFAULT NULL,
  `Country` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `BondRating` decimal(10,2) DEFAULT NULL,
  `Maturity` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercentageProtFolio` decimal(16,6) DEFAULT NULL,
  `div_class_currency` char(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `currency_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sow_error_currency_convert` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Remarks` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_date` date DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `parent_bank_id` int DEFAULT NULL,
  `FXRateB` decimal(10,6) DEFAULT NULL,
  `GainLossFormatedNum` decimal(16,6) DEFAULT NULL,
  `FxRateValue` decimal(32,15) DEFAULT NULL,
  `xir_calc` decimal(16,6) DEFAULT NULL,
  `PercteageGanLosNumber` decimal(16,6) DEFAULT NULL,
  `bank_priority` int DEFAULT NULL,
  `ytm` decimal(32,15) DEFAULT NULL,
  `macaulay_duration` decimal(10,6) DEFAULT NULL,
  `modified_duration` decimal(10,6) DEFAULT NULL,
  `macaulay_duration_c` decimal(10,6) DEFAULT NULL,
  `modified_duration_c` decimal(10,6) DEFAULT NULL,
  `ytm_c` decimal(10,6) DEFAULT NULL,
  `product_type` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `has_undrly_currency_difference` char(4) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `price_api` decimal(32,15) DEFAULT NULL,
  `market_value_api` decimal(32,15) DEFAULT NULL,
  PRIMARY KEY (`summary_id`),
  KEY `idx_parent_bank_id` (`parent_bank_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='asof_built=2026-09-24 09:02:45';

-- mw_os_asof_20260104 (~1478 rows)
CREATE TABLE `mw_os_asof_20260104` (
  `summary_id` bigint NOT NULL AUTO_INCREMENT,
  `ref_id` bigint NOT NULL,
  `customer_id` int NOT NULL,
  `stock_details` blob NOT NULL,
  `value` decimal(34,15) DEFAULT NULL,
  `status` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_type` char(2) COLLATE utf8mb4_general_ci NOT NULL,
  `priority` int NOT NULL,
  `stock_id` int NOT NULL,
  `uid` int DEFAULT NULL,
  `ticker` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bank_name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asetClass` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_type_title` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Industry` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Sector` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `t_date` date DEFAULT NULL,
  `MarketPriceCurrency` char(5) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PurchaseQuantity` decimal(32,15) DEFAULT NULL,
  `price` decimal(32,15) DEFAULT NULL,
  `purchaseValueFormated1` decimal(32,15) DEFAULT NULL,
  `MarketPriceFormated` decimal(32,15) DEFAULT NULL,
  `RealPrice` decimal(32,15) DEFAULT NULL,
  `MarketValueFormated` decimal(32,15) DEFAULT NULL,
  `GainLossFormated` varchar(201) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercteageGanLosFormated` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reporting_currency` char(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FXRate` decimal(10,6) DEFAULT NULL,
  `purchaseValuesInRcFormated` decimal(32,15) DEFAULT NULL,
  `MarketValueRCFormated` decimal(32,15) DEFAULT NULL,
  `DifferenceRCFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormatedinRc` decimal(32,15) DEFAULT NULL,
  `DividendCoupon` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TargetPrice` decimal(32,15) NOT NULL,
  `TargetPricePerentageFormat` decimal(32,15) DEFAULT NULL,
  `Country` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `BondRating` decimal(10,2) DEFAULT NULL,
  `Maturity` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercentageProtFolio` decimal(16,6) DEFAULT NULL,
  `div_class_currency` char(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `currency_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sow_error_currency_convert` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Remarks` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_date` date DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `parent_bank_id` int DEFAULT NULL,
  `FXRateB` decimal(10,6) DEFAULT NULL,
  `GainLossFormatedNum` decimal(16,6) DEFAULT NULL,
  `FxRateValue` decimal(32,15) DEFAULT NULL,
  `xir_calc` decimal(16,6) DEFAULT NULL,
  `PercteageGanLosNumber` decimal(16,6) DEFAULT NULL,
  `bank_priority` int DEFAULT NULL,
  `ytm` decimal(32,15) DEFAULT NULL,
  `macaulay_duration` decimal(10,6) DEFAULT NULL,
  `modified_duration` decimal(10,6) DEFAULT NULL,
  `macaulay_duration_c` decimal(10,6) DEFAULT NULL,
  `modified_duration_c` decimal(10,6) DEFAULT NULL,
  `ytm_c` decimal(10,6) DEFAULT NULL,
  `product_type` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `has_undrly_currency_difference` char(4) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `price_api` decimal(32,15) DEFAULT NULL,
  `market_value_api` decimal(32,15) DEFAULT NULL,
  PRIMARY KEY (`summary_id`),
  KEY `idx_parent_bank_id` (`parent_bank_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='asof_built=2026-09-24 09:13:16';

-- mw_os_asof_20260401 (~2135 rows)
CREATE TABLE `mw_os_asof_20260401` (
  `summary_id` bigint NOT NULL AUTO_INCREMENT,
  `ref_id` bigint NOT NULL,
  `customer_id` int NOT NULL,
  `stock_details` blob NOT NULL,
  `value` decimal(34,15) DEFAULT NULL,
  `status` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_type` char(2) COLLATE utf8mb4_general_ci NOT NULL,
  `priority` int NOT NULL,
  `stock_id` int NOT NULL,
  `uid` int DEFAULT NULL,
  `ticker` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bank_name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asetClass` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_type_title` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Industry` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Sector` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `t_date` date DEFAULT NULL,
  `MarketPriceCurrency` char(5) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PurchaseQuantity` decimal(32,15) DEFAULT NULL,
  `price` decimal(32,15) DEFAULT NULL,
  `purchaseValueFormated1` decimal(32,15) DEFAULT NULL,
  `MarketPriceFormated` decimal(32,15) DEFAULT NULL,
  `RealPrice` decimal(32,15) DEFAULT NULL,
  `MarketValueFormated` decimal(32,15) DEFAULT NULL,
  `GainLossFormated` varchar(201) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercteageGanLosFormated` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reporting_currency` char(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FXRate` decimal(10,6) DEFAULT NULL,
  `purchaseValuesInRcFormated` decimal(32,15) DEFAULT NULL,
  `MarketValueRCFormated` decimal(32,15) DEFAULT NULL,
  `DifferenceRCFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormatedinRc` decimal(32,15) DEFAULT NULL,
  `DividendCoupon` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TargetPrice` decimal(32,15) NOT NULL,
  `TargetPricePerentageFormat` decimal(32,15) DEFAULT NULL,
  `Country` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `BondRating` decimal(10,2) DEFAULT NULL,
  `Maturity` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercentageProtFolio` decimal(16,6) DEFAULT NULL,
  `div_class_currency` char(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `currency_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sow_error_currency_convert` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Remarks` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_date` date DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `parent_bank_id` int DEFAULT NULL,
  `FXRateB` decimal(10,6) DEFAULT NULL,
  `GainLossFormatedNum` decimal(16,6) DEFAULT NULL,
  `FxRateValue` decimal(32,15) DEFAULT NULL,
  `xir_calc` decimal(16,6) DEFAULT NULL,
  `PercteageGanLosNumber` decimal(16,6) DEFAULT NULL,
  `bank_priority` int DEFAULT NULL,
  `ytm` decimal(32,15) DEFAULT NULL,
  `macaulay_duration` decimal(10,6) DEFAULT NULL,
  `modified_duration` decimal(10,6) DEFAULT NULL,
  `macaulay_duration_c` decimal(10,6) DEFAULT NULL,
  `modified_duration_c` decimal(10,6) DEFAULT NULL,
  `ytm_c` decimal(10,6) DEFAULT NULL,
  `product_type` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `has_undrly_currency_difference` char(4) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `price_api` decimal(32,15) DEFAULT NULL,
  `market_value_api` decimal(32,15) DEFAULT NULL,
  PRIMARY KEY (`summary_id`),
  KEY `idx_parent_bank_id` (`parent_bank_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='asof_built=2026-09-24 09:21:57';

-- mw_os_asof_20260601 (~3263 rows)
CREATE TABLE `mw_os_asof_20260601` (
  `summary_id` bigint NOT NULL AUTO_INCREMENT,
  `ref_id` bigint NOT NULL,
  `customer_id` int NOT NULL,
  `stock_details` blob NOT NULL,
  `value` decimal(34,15) DEFAULT NULL,
  `status` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_type` char(2) COLLATE utf8mb4_general_ci NOT NULL,
  `priority` int NOT NULL,
  `stock_id` int NOT NULL,
  `uid` int DEFAULT NULL,
  `ticker` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bank_name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asetClass` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_type_title` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Industry` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Sector` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `t_date` date DEFAULT NULL,
  `MarketPriceCurrency` char(5) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PurchaseQuantity` decimal(32,15) DEFAULT NULL,
  `price` decimal(32,15) DEFAULT NULL,
  `purchaseValueFormated1` decimal(32,15) DEFAULT NULL,
  `MarketPriceFormated` decimal(32,15) DEFAULT NULL,
  `RealPrice` decimal(32,15) DEFAULT NULL,
  `MarketValueFormated` decimal(32,15) DEFAULT NULL,
  `GainLossFormated` varchar(201) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercteageGanLosFormated` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reporting_currency` char(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FXRate` decimal(10,6) DEFAULT NULL,
  `purchaseValuesInRcFormated` decimal(32,15) DEFAULT NULL,
  `MarketValueRCFormated` decimal(32,15) DEFAULT NULL,
  `DifferenceRCFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormatedinRc` decimal(32,15) DEFAULT NULL,
  `DividendCoupon` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TargetPrice` decimal(32,15) NOT NULL,
  `TargetPricePerentageFormat` decimal(32,15) DEFAULT NULL,
  `Country` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `BondRating` decimal(10,2) DEFAULT NULL,
  `Maturity` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercentageProtFolio` decimal(16,6) DEFAULT NULL,
  `div_class_currency` char(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `currency_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sow_error_currency_convert` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Remarks` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_date` date DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `parent_bank_id` int DEFAULT NULL,
  `FXRateB` decimal(10,6) DEFAULT NULL,
  `GainLossFormatedNum` decimal(16,6) DEFAULT NULL,
  `FxRateValue` decimal(32,15) DEFAULT NULL,
  `xir_calc` decimal(16,6) DEFAULT NULL,
  `PercteageGanLosNumber` decimal(16,6) DEFAULT NULL,
  `bank_priority` int DEFAULT NULL,
  `ytm` decimal(32,15) DEFAULT NULL,
  `macaulay_duration` decimal(10,6) DEFAULT NULL,
  `modified_duration` decimal(10,6) DEFAULT NULL,
  `macaulay_duration_c` decimal(10,6) DEFAULT NULL,
  `modified_duration_c` decimal(10,6) DEFAULT NULL,
  `ytm_c` decimal(10,6) DEFAULT NULL,
  `product_type` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `has_undrly_currency_difference` char(4) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `price_api` decimal(32,15) DEFAULT NULL,
  `market_value_api` decimal(32,15) DEFAULT NULL,
  PRIMARY KEY (`summary_id`),
  KEY `idx_parent_bank_id` (`parent_bank_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='asof_built=2026-09-24 09:02:05';

-- mw_os_asof_20260623 (~3360 rows)
CREATE TABLE `mw_os_asof_20260623` (
  `summary_id` bigint NOT NULL AUTO_INCREMENT,
  `ref_id` bigint NOT NULL,
  `customer_id` int NOT NULL,
  `stock_details` blob NOT NULL,
  `value` decimal(34,15) DEFAULT NULL,
  `status` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_type` char(2) COLLATE utf8mb4_general_ci NOT NULL,
  `priority` int NOT NULL,
  `stock_id` int NOT NULL,
  `uid` int DEFAULT NULL,
  `ticker` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bank_name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asetClass` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_type_title` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Industry` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Sector` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `t_date` date DEFAULT NULL,
  `MarketPriceCurrency` char(5) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PurchaseQuantity` decimal(32,15) DEFAULT NULL,
  `price` decimal(32,15) DEFAULT NULL,
  `purchaseValueFormated1` decimal(32,15) DEFAULT NULL,
  `MarketPriceFormated` decimal(32,15) DEFAULT NULL,
  `RealPrice` decimal(32,15) DEFAULT NULL,
  `MarketValueFormated` decimal(32,15) DEFAULT NULL,
  `GainLossFormated` varchar(201) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercteageGanLosFormated` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reporting_currency` char(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FXRate` decimal(10,6) DEFAULT NULL,
  `purchaseValuesInRcFormated` decimal(32,15) DEFAULT NULL,
  `MarketValueRCFormated` decimal(32,15) DEFAULT NULL,
  `DifferenceRCFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormatedinRc` decimal(32,15) DEFAULT NULL,
  `DividendCoupon` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TargetPrice` decimal(32,15) NOT NULL,
  `TargetPricePerentageFormat` decimal(32,15) DEFAULT NULL,
  `Country` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `BondRating` decimal(10,2) DEFAULT NULL,
  `Maturity` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercentageProtFolio` decimal(16,6) DEFAULT NULL,
  `div_class_currency` char(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `currency_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sow_error_currency_convert` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Remarks` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_date` date DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `parent_bank_id` int DEFAULT NULL,
  `FXRateB` decimal(10,6) DEFAULT NULL,
  `GainLossFormatedNum` decimal(16,6) DEFAULT NULL,
  `FxRateValue` decimal(32,15) DEFAULT NULL,
  `xir_calc` decimal(16,6) DEFAULT NULL,
  `PercteageGanLosNumber` decimal(16,6) DEFAULT NULL,
  `bank_priority` int DEFAULT NULL,
  `ytm` decimal(32,15) DEFAULT NULL,
  `macaulay_duration` decimal(10,6) DEFAULT NULL,
  `modified_duration` decimal(10,6) DEFAULT NULL,
  `macaulay_duration_c` decimal(10,6) DEFAULT NULL,
  `modified_duration_c` decimal(10,6) DEFAULT NULL,
  `ytm_c` decimal(10,6) DEFAULT NULL,
  `product_type` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `has_undrly_currency_difference` char(4) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `price_api` decimal(32,15) DEFAULT NULL,
  `market_value_api` decimal(32,15) DEFAULT NULL,
  PRIMARY KEY (`summary_id`),
  KEY `idx_parent_bank_id` (`parent_bank_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='asof_built=2026-09-24 09:12:59';

-- mw_os_asof_20260701 (~3498 rows)
CREATE TABLE `mw_os_asof_20260701` (
  `summary_id` bigint NOT NULL AUTO_INCREMENT,
  `ref_id` bigint NOT NULL,
  `customer_id` int NOT NULL,
  `stock_details` blob NOT NULL,
  `value` decimal(34,15) DEFAULT NULL,
  `status` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_type` char(2) COLLATE utf8mb4_general_ci NOT NULL,
  `priority` int NOT NULL,
  `stock_id` int NOT NULL,
  `uid` int DEFAULT NULL,
  `ticker` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bank_name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asetClass` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_type_title` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Industry` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Sector` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `t_date` date DEFAULT NULL,
  `MarketPriceCurrency` char(5) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PurchaseQuantity` decimal(32,15) DEFAULT NULL,
  `price` decimal(32,15) DEFAULT NULL,
  `purchaseValueFormated1` decimal(32,15) DEFAULT NULL,
  `MarketPriceFormated` decimal(32,15) DEFAULT NULL,
  `RealPrice` decimal(32,15) DEFAULT NULL,
  `MarketValueFormated` decimal(32,15) DEFAULT NULL,
  `GainLossFormated` varchar(201) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercteageGanLosFormated` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reporting_currency` char(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FXRate` decimal(10,6) DEFAULT NULL,
  `purchaseValuesInRcFormated` decimal(32,15) DEFAULT NULL,
  `MarketValueRCFormated` decimal(32,15) DEFAULT NULL,
  `DifferenceRCFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormatedinRc` decimal(32,15) DEFAULT NULL,
  `DividendCoupon` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TargetPrice` decimal(32,15) NOT NULL,
  `TargetPricePerentageFormat` decimal(32,15) DEFAULT NULL,
  `Country` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `BondRating` decimal(10,2) DEFAULT NULL,
  `Maturity` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercentageProtFolio` decimal(16,6) DEFAULT NULL,
  `div_class_currency` char(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `currency_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sow_error_currency_convert` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Remarks` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_date` date DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `parent_bank_id` int DEFAULT NULL,
  `FXRateB` decimal(10,6) DEFAULT NULL,
  `GainLossFormatedNum` decimal(16,6) DEFAULT NULL,
  `FxRateValue` decimal(32,15) DEFAULT NULL,
  `xir_calc` decimal(16,6) DEFAULT NULL,
  `PercteageGanLosNumber` decimal(16,6) DEFAULT NULL,
  `bank_priority` int DEFAULT NULL,
  `ytm` decimal(32,15) DEFAULT NULL,
  `macaulay_duration` decimal(10,6) DEFAULT NULL,
  `modified_duration` decimal(10,6) DEFAULT NULL,
  `macaulay_duration_c` decimal(10,6) DEFAULT NULL,
  `modified_duration_c` decimal(10,6) DEFAULT NULL,
  `ytm_c` decimal(10,6) DEFAULT NULL,
  `product_type` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `has_undrly_currency_difference` char(4) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `price_api` decimal(32,15) DEFAULT NULL,
  `market_value_api` decimal(32,15) DEFAULT NULL,
  PRIMARY KEY (`summary_id`),
  KEY `idx_parent_bank_id` (`parent_bank_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='asof_built=2026-09-24 09:01:40';

-- mw_os_asof_20260706 (~3464 rows)
CREATE TABLE `mw_os_asof_20260706` (
  `summary_id` bigint NOT NULL AUTO_INCREMENT,
  `ref_id` bigint NOT NULL,
  `customer_id` int NOT NULL,
  `stock_details` blob NOT NULL,
  `value` decimal(34,15) DEFAULT NULL,
  `status` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_type` char(2) COLLATE utf8mb4_general_ci NOT NULL,
  `priority` int NOT NULL,
  `stock_id` int NOT NULL,
  `uid` int DEFAULT NULL,
  `ticker` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bank_name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asetClass` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_type_title` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Industry` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Sector` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `t_date` date DEFAULT NULL,
  `MarketPriceCurrency` char(5) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PurchaseQuantity` decimal(32,15) DEFAULT NULL,
  `price` decimal(32,15) DEFAULT NULL,
  `purchaseValueFormated1` decimal(32,15) DEFAULT NULL,
  `MarketPriceFormated` decimal(32,15) DEFAULT NULL,
  `RealPrice` decimal(32,15) DEFAULT NULL,
  `MarketValueFormated` decimal(32,15) DEFAULT NULL,
  `GainLossFormated` varchar(201) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercteageGanLosFormated` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reporting_currency` char(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FXRate` decimal(10,6) DEFAULT NULL,
  `purchaseValuesInRcFormated` decimal(32,15) DEFAULT NULL,
  `MarketValueRCFormated` decimal(32,15) DEFAULT NULL,
  `DifferenceRCFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormatedinRc` decimal(32,15) DEFAULT NULL,
  `DividendCoupon` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TargetPrice` decimal(32,15) NOT NULL,
  `TargetPricePerentageFormat` decimal(32,15) DEFAULT NULL,
  `Country` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `BondRating` decimal(10,2) DEFAULT NULL,
  `Maturity` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercentageProtFolio` decimal(16,6) DEFAULT NULL,
  `div_class_currency` char(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `currency_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sow_error_currency_convert` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Remarks` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_date` date DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `parent_bank_id` int DEFAULT NULL,
  `FXRateB` decimal(10,6) DEFAULT NULL,
  `GainLossFormatedNum` decimal(16,6) DEFAULT NULL,
  `FxRateValue` decimal(32,15) DEFAULT NULL,
  `xir_calc` decimal(16,6) DEFAULT NULL,
  `PercteageGanLosNumber` decimal(16,6) DEFAULT NULL,
  `bank_priority` int DEFAULT NULL,
  `ytm` decimal(32,15) DEFAULT NULL,
  `macaulay_duration` decimal(10,6) DEFAULT NULL,
  `modified_duration` decimal(10,6) DEFAULT NULL,
  `macaulay_duration_c` decimal(10,6) DEFAULT NULL,
  `modified_duration_c` decimal(10,6) DEFAULT NULL,
  `ytm_c` decimal(10,6) DEFAULT NULL,
  `product_type` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `has_undrly_currency_difference` char(4) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `price_api` decimal(32,15) DEFAULT NULL,
  `market_value_api` decimal(32,15) DEFAULT NULL,
  PRIMARY KEY (`summary_id`),
  KEY `idx_parent_bank_id` (`parent_bank_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='asof_built=2026-09-24 09:01:23';

-- mw_os_asof_20260713 (~3403 rows)
CREATE TABLE `mw_os_asof_20260713` (
  `summary_id` bigint NOT NULL AUTO_INCREMENT,
  `ref_id` bigint NOT NULL,
  `customer_id` int NOT NULL,
  `stock_details` blob NOT NULL,
  `value` decimal(34,15) DEFAULT NULL,
  `status` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_type` char(2) COLLATE utf8mb4_general_ci NOT NULL,
  `priority` int NOT NULL,
  `stock_id` int NOT NULL,
  `uid` int DEFAULT NULL,
  `ticker` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bank_name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asetClass` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_type_title` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Industry` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Sector` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `t_date` date DEFAULT NULL,
  `MarketPriceCurrency` char(5) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PurchaseQuantity` decimal(32,15) DEFAULT NULL,
  `price` decimal(32,15) DEFAULT NULL,
  `purchaseValueFormated1` decimal(32,15) DEFAULT NULL,
  `MarketPriceFormated` decimal(32,15) DEFAULT NULL,
  `RealPrice` decimal(32,15) DEFAULT NULL,
  `MarketValueFormated` decimal(32,15) DEFAULT NULL,
  `GainLossFormated` varchar(201) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercteageGanLosFormated` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reporting_currency` char(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FXRate` decimal(10,6) DEFAULT NULL,
  `purchaseValuesInRcFormated` decimal(32,15) DEFAULT NULL,
  `MarketValueRCFormated` decimal(32,15) DEFAULT NULL,
  `DifferenceRCFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormatedinRc` decimal(32,15) DEFAULT NULL,
  `DividendCoupon` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TargetPrice` decimal(32,15) NOT NULL,
  `TargetPricePerentageFormat` decimal(32,15) DEFAULT NULL,
  `Country` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `BondRating` decimal(10,2) DEFAULT NULL,
  `Maturity` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercentageProtFolio` decimal(16,6) DEFAULT NULL,
  `div_class_currency` char(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `currency_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sow_error_currency_convert` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Remarks` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_date` date DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `parent_bank_id` int DEFAULT NULL,
  `FXRateB` decimal(10,6) DEFAULT NULL,
  `GainLossFormatedNum` decimal(16,6) DEFAULT NULL,
  `FxRateValue` decimal(32,15) DEFAULT NULL,
  `xir_calc` decimal(16,6) DEFAULT NULL,
  `PercteageGanLosNumber` decimal(16,6) DEFAULT NULL,
  `bank_priority` int DEFAULT NULL,
  `ytm` decimal(32,15) DEFAULT NULL,
  `macaulay_duration` decimal(10,6) DEFAULT NULL,
  `modified_duration` decimal(10,6) DEFAULT NULL,
  `macaulay_duration_c` decimal(10,6) DEFAULT NULL,
  `modified_duration_c` decimal(10,6) DEFAULT NULL,
  `ytm_c` decimal(10,6) DEFAULT NULL,
  `product_type` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `has_undrly_currency_difference` char(4) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `price_api` decimal(32,15) DEFAULT NULL,
  `market_value_api` decimal(32,15) DEFAULT NULL,
  PRIMARY KEY (`summary_id`),
  KEY `idx_parent_bank_id` (`parent_bank_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='asof_built=2026-09-24 09:09:56';

-- mw_os_asof_20260721 (~3537 rows)
CREATE TABLE `mw_os_asof_20260721` (
  `summary_id` bigint NOT NULL AUTO_INCREMENT,
  `ref_id` bigint NOT NULL,
  `customer_id` int NOT NULL,
  `stock_details` blob NOT NULL,
  `value` decimal(34,15) DEFAULT NULL,
  `status` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_type` char(2) COLLATE utf8mb4_general_ci NOT NULL,
  `priority` int NOT NULL,
  `stock_id` int NOT NULL,
  `uid` int DEFAULT NULL,
  `ticker` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bank_name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asetClass` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_type_title` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Industry` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Sector` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `t_date` date DEFAULT NULL,
  `MarketPriceCurrency` char(5) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PurchaseQuantity` decimal(32,15) DEFAULT NULL,
  `price` decimal(32,15) DEFAULT NULL,
  `purchaseValueFormated1` decimal(32,15) DEFAULT NULL,
  `MarketPriceFormated` decimal(32,15) DEFAULT NULL,
  `RealPrice` decimal(32,15) DEFAULT NULL,
  `MarketValueFormated` decimal(32,15) DEFAULT NULL,
  `GainLossFormated` varchar(201) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercteageGanLosFormated` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reporting_currency` char(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FXRate` decimal(10,6) DEFAULT NULL,
  `purchaseValuesInRcFormated` decimal(32,15) DEFAULT NULL,
  `MarketValueRCFormated` decimal(32,15) DEFAULT NULL,
  `DifferenceRCFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormatedinRc` decimal(32,15) DEFAULT NULL,
  `DividendCoupon` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TargetPrice` decimal(32,15) NOT NULL,
  `TargetPricePerentageFormat` decimal(32,15) DEFAULT NULL,
  `Country` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `BondRating` decimal(10,2) DEFAULT NULL,
  `Maturity` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercentageProtFolio` decimal(16,6) DEFAULT NULL,
  `div_class_currency` char(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `currency_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sow_error_currency_convert` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Remarks` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_date` date DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `parent_bank_id` int DEFAULT NULL,
  `FXRateB` decimal(10,6) DEFAULT NULL,
  `GainLossFormatedNum` decimal(16,6) DEFAULT NULL,
  `FxRateValue` decimal(32,15) DEFAULT NULL,
  `xir_calc` decimal(16,6) DEFAULT NULL,
  `PercteageGanLosNumber` decimal(16,6) DEFAULT NULL,
  `bank_priority` int DEFAULT NULL,
  `ytm` decimal(32,15) DEFAULT NULL,
  `macaulay_duration` decimal(10,6) DEFAULT NULL,
  `modified_duration` decimal(10,6) DEFAULT NULL,
  `macaulay_duration_c` decimal(10,6) DEFAULT NULL,
  `modified_duration_c` decimal(10,6) DEFAULT NULL,
  `ytm_c` decimal(10,6) DEFAULT NULL,
  `product_type` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `has_undrly_currency_difference` char(4) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `price_api` decimal(32,15) DEFAULT NULL,
  `market_value_api` decimal(32,15) DEFAULT NULL,
  PRIMARY KEY (`summary_id`),
  KEY `idx_parent_bank_id` (`parent_bank_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='asof_built=2026-09-24 09:01:09';

-- mw_os_asof_20260910 (~3724 rows)
CREATE TABLE `mw_os_asof_20260910` (
  `summary_id` bigint NOT NULL AUTO_INCREMENT,
  `ref_id` bigint NOT NULL,
  `customer_id` int NOT NULL,
  `stock_details` blob NOT NULL,
  `value` decimal(34,15) DEFAULT NULL,
  `status` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_type` char(2) COLLATE utf8mb4_general_ci NOT NULL,
  `priority` int NOT NULL,
  `stock_id` int NOT NULL,
  `uid` int DEFAULT NULL,
  `ticker` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bank_name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asetClass` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_type_title` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Industry` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Sector` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `t_date` date DEFAULT NULL,
  `MarketPriceCurrency` char(5) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PurchaseQuantity` decimal(32,15) DEFAULT NULL,
  `price` decimal(32,15) DEFAULT NULL,
  `purchaseValueFormated1` decimal(32,15) DEFAULT NULL,
  `MarketPriceFormated` decimal(32,15) DEFAULT NULL,
  `RealPrice` decimal(32,15) DEFAULT NULL,
  `MarketValueFormated` decimal(32,15) DEFAULT NULL,
  `GainLossFormated` varchar(201) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercteageGanLosFormated` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reporting_currency` char(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FXRate` decimal(10,6) DEFAULT NULL,
  `purchaseValuesInRcFormated` decimal(32,15) DEFAULT NULL,
  `MarketValueRCFormated` decimal(32,15) DEFAULT NULL,
  `DifferenceRCFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormatedinRc` decimal(32,15) DEFAULT NULL,
  `DividendCoupon` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TargetPrice` decimal(32,15) NOT NULL,
  `TargetPricePerentageFormat` decimal(32,15) DEFAULT NULL,
  `Country` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `BondRating` decimal(10,2) DEFAULT NULL,
  `Maturity` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercentageProtFolio` decimal(16,6) DEFAULT NULL,
  `div_class_currency` char(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `currency_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sow_error_currency_convert` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Remarks` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_date` date DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `parent_bank_id` int DEFAULT NULL,
  `FXRateB` decimal(10,6) DEFAULT NULL,
  `GainLossFormatedNum` decimal(16,6) DEFAULT NULL,
  `FxRateValue` decimal(32,15) DEFAULT NULL,
  `xir_calc` decimal(16,6) DEFAULT NULL,
  `PercteageGanLosNumber` decimal(16,6) DEFAULT NULL,
  `bank_priority` int DEFAULT NULL,
  `ytm` decimal(32,15) DEFAULT NULL,
  `macaulay_duration` decimal(10,6) DEFAULT NULL,
  `modified_duration` decimal(10,6) DEFAULT NULL,
  `macaulay_duration_c` decimal(10,6) DEFAULT NULL,
  `modified_duration_c` decimal(10,6) DEFAULT NULL,
  `ytm_c` decimal(10,6) DEFAULT NULL,
  `product_type` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `has_undrly_currency_difference` char(4) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `price_api` decimal(32,15) DEFAULT NULL,
  `market_value_api` decimal(32,15) DEFAULT NULL,
  PRIMARY KEY (`summary_id`),
  KEY `idx_parent_bank_id` (`parent_bank_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='asof_built=2026-09-24 08:57:40';

-- mw_os_asof_20260922 (~3655 rows)
CREATE TABLE `mw_os_asof_20260922` (
  `summary_id` bigint NOT NULL AUTO_INCREMENT,
  `ref_id` bigint NOT NULL,
  `customer_id` int NOT NULL,
  `stock_details` blob NOT NULL,
  `value` decimal(34,15) DEFAULT NULL,
  `status` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_type` char(2) COLLATE utf8mb4_general_ci NOT NULL,
  `priority` int NOT NULL,
  `stock_id` int NOT NULL,
  `uid` int DEFAULT NULL,
  `ticker` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bank_name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asetClass` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_type_title` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Industry` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Sector` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `t_date` date DEFAULT NULL,
  `MarketPriceCurrency` char(5) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PurchaseQuantity` decimal(32,15) DEFAULT NULL,
  `price` decimal(32,15) DEFAULT NULL,
  `purchaseValueFormated1` decimal(32,15) DEFAULT NULL,
  `MarketPriceFormated` decimal(32,15) DEFAULT NULL,
  `RealPrice` decimal(32,15) DEFAULT NULL,
  `MarketValueFormated` decimal(32,15) DEFAULT NULL,
  `GainLossFormated` varchar(201) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercteageGanLosFormated` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reporting_currency` char(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FXRate` decimal(10,6) DEFAULT NULL,
  `purchaseValuesInRcFormated` decimal(32,15) DEFAULT NULL,
  `MarketValueRCFormated` decimal(32,15) DEFAULT NULL,
  `DifferenceRCFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormatedinRc` decimal(32,15) DEFAULT NULL,
  `DividendCoupon` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TargetPrice` decimal(32,15) NOT NULL,
  `TargetPricePerentageFormat` decimal(32,15) DEFAULT NULL,
  `Country` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `BondRating` decimal(10,2) DEFAULT NULL,
  `Maturity` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercentageProtFolio` decimal(16,6) DEFAULT NULL,
  `div_class_currency` char(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `currency_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sow_error_currency_convert` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Remarks` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_date` date DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `parent_bank_id` int DEFAULT NULL,
  `FXRateB` decimal(10,6) DEFAULT NULL,
  `GainLossFormatedNum` decimal(16,6) DEFAULT NULL,
  `FxRateValue` decimal(32,15) DEFAULT NULL,
  `xir_calc` decimal(16,6) DEFAULT NULL,
  `PercteageGanLosNumber` decimal(16,6) DEFAULT NULL,
  `bank_priority` int DEFAULT NULL,
  `ytm` decimal(32,15) DEFAULT NULL,
  `macaulay_duration` decimal(10,6) DEFAULT NULL,
  `modified_duration` decimal(10,6) DEFAULT NULL,
  `macaulay_duration_c` decimal(10,6) DEFAULT NULL,
  `modified_duration_c` decimal(10,6) DEFAULT NULL,
  `ytm_c` decimal(10,6) DEFAULT NULL,
  `product_type` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `has_undrly_currency_difference` char(4) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `price_api` decimal(32,15) DEFAULT NULL,
  `market_value_api` decimal(32,15) DEFAULT NULL,
  PRIMARY KEY (`summary_id`),
  KEY `idx_parent_bank_id` (`parent_bank_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='asof_built=2026-09-24 09:21:41';

-- mw_os_asof_20260923 (~3683 rows)
CREATE TABLE `mw_os_asof_20260923` (
  `summary_id` bigint NOT NULL AUTO_INCREMENT,
  `ref_id` bigint NOT NULL,
  `customer_id` int NOT NULL,
  `stock_details` blob NOT NULL,
  `value` decimal(34,15) DEFAULT NULL,
  `status` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_type` char(2) COLLATE utf8mb4_general_ci NOT NULL,
  `priority` int NOT NULL,
  `stock_id` int NOT NULL,
  `uid` int DEFAULT NULL,
  `ticker` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bank_name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asetClass` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_type_title` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Industry` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Sector` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `t_date` date DEFAULT NULL,
  `MarketPriceCurrency` char(5) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PurchaseQuantity` decimal(32,15) DEFAULT NULL,
  `price` decimal(32,15) DEFAULT NULL,
  `purchaseValueFormated1` decimal(32,15) DEFAULT NULL,
  `MarketPriceFormated` decimal(32,15) DEFAULT NULL,
  `RealPrice` decimal(32,15) DEFAULT NULL,
  `MarketValueFormated` decimal(32,15) DEFAULT NULL,
  `GainLossFormated` varchar(201) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercteageGanLosFormated` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reporting_currency` char(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FXRate` decimal(10,6) DEFAULT NULL,
  `purchaseValuesInRcFormated` decimal(32,15) DEFAULT NULL,
  `MarketValueRCFormated` decimal(32,15) DEFAULT NULL,
  `DifferenceRCFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormatedinRc` decimal(32,15) DEFAULT NULL,
  `DividendCoupon` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TargetPrice` decimal(32,15) NOT NULL,
  `TargetPricePerentageFormat` decimal(32,15) DEFAULT NULL,
  `Country` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `BondRating` decimal(10,2) DEFAULT NULL,
  `Maturity` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercentageProtFolio` decimal(16,6) DEFAULT NULL,
  `div_class_currency` char(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `currency_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sow_error_currency_convert` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Remarks` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_date` date DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `parent_bank_id` int DEFAULT NULL,
  `FXRateB` decimal(10,6) DEFAULT NULL,
  `GainLossFormatedNum` decimal(16,6) DEFAULT NULL,
  `FxRateValue` decimal(32,15) DEFAULT NULL,
  `xir_calc` decimal(16,6) DEFAULT NULL,
  `PercteageGanLosNumber` decimal(16,6) DEFAULT NULL,
  `bank_priority` int DEFAULT NULL,
  `ytm` decimal(32,15) DEFAULT NULL,
  `macaulay_duration` decimal(10,6) DEFAULT NULL,
  `modified_duration` decimal(10,6) DEFAULT NULL,
  `macaulay_duration_c` decimal(10,6) DEFAULT NULL,
  `modified_duration_c` decimal(10,6) DEFAULT NULL,
  `ytm_c` decimal(10,6) DEFAULT NULL,
  `product_type` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `has_undrly_currency_difference` char(4) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `price_api` decimal(32,15) DEFAULT NULL,
  `market_value_api` decimal(32,15) DEFAULT NULL,
  PRIMARY KEY (`summary_id`),
  KEY `idx_parent_bank_id` (`parent_bank_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='asof_built=2026-09-24 08:56:32';

-- mw_overall_sub (~62 rows)
CREATE TABLE `mw_overall_sub` (
  `key_index` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
  `value` blob NOT NULL,
  `last_updated` datetime NOT NULL,
  PRIMARY KEY (`key_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- mw_overall_summary (~0 rows)
CREATE TABLE `mw_overall_summary` (
  `ref_id` bigint NOT NULL,
  `stock_details` blob NOT NULL,
  `value` decimal(15,6) DEFAULT NULL,
  `status` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_type` char(2) COLLATE utf8mb4_general_ci NOT NULL,
  `priority` int NOT NULL,
  `stock_id` int NOT NULL,
  PRIMARY KEY (`stock_id`),
  KEY `f_type` (`f_type`),
  KEY `priority` (`priority`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- mw_overall_summary_backup (~0 rows)
CREATE TABLE `mw_overall_summary_backup` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `ref_id` bigint NOT NULL,
  `stock_details` blob NOT NULL,
  `value` decimal(34,15) DEFAULT NULL,
  `status` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_type` char(2) COLLATE utf8mb4_general_ci NOT NULL,
  `priority` int NOT NULL,
  `stock_id` int NOT NULL,
  `uid` int DEFAULT NULL,
  `ticker` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bank_name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asetClass` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_type_title` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Industry` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Sector` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `t_date` date DEFAULT NULL,
  `MarketPriceCurrency` char(5) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PurchaseQuantity` decimal(16,6) DEFAULT NULL,
  `price` decimal(32,15) DEFAULT NULL,
  `purchaseValueFormated1` decimal(32,15) DEFAULT NULL,
  `MarketPriceFormated` decimal(32,15) DEFAULT NULL,
  `RealPrice` decimal(32,15) DEFAULT NULL,
  `MarketValueFormated` decimal(32,15) DEFAULT NULL,
  `GainLossFormated` varchar(201) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercteageGanLosFormated` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reporting_currency` char(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FXRate` decimal(10,6) DEFAULT NULL,
  `purchaseValuesInRcFormated` decimal(32,15) DEFAULT NULL,
  `MarketValueRCFormated` decimal(32,15) DEFAULT NULL,
  `DifferenceRCFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormatedinRc` decimal(32,15) DEFAULT NULL,
  `DividendCoupon` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TargetPrice` decimal(32,15) NOT NULL,
  `TargetPricePerentageFormat` decimal(32,15) DEFAULT NULL,
  `Country` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `BondRating` decimal(10,2) DEFAULT NULL,
  `Maturity` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercentageProtFolio` decimal(32,15) DEFAULT NULL,
  `div_class_currency` char(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `currency_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sow_error_currency_convert` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Remarks` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_date` date DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `FXRateB` decimal(32,15) DEFAULT NULL,
  `GainLossFormatedNum` decimal(32,15) DEFAULT NULL,
  `FxRateValue` decimal(10,6) DEFAULT NULL,
  `xir_calc` decimal(16,6) DEFAULT NULL,
  `PercteageGanLosNumber` decimal(16,6) DEFAULT NULL,
  `ytm` decimal(32,15) DEFAULT NULL,
  `modified_duration` decimal(10,6) DEFAULT NULL,
  `macaulay_duration` decimal(10,6) DEFAULT NULL,
  `macaulay_duration_c` decimal(10,6) DEFAULT NULL,
  `modified_duration_c` decimal(10,6) DEFAULT NULL,
  `ytm_c` decimal(10,6) DEFAULT NULL,
  `product_type` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `price_api` decimal(32,15) DEFAULT NULL,
  `market_value_api` decimal(32,15) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_f_type` (`f_type`),
  KEY `idx_priority` (`priority`),
  KEY `idx_stock_id` (`stock_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- mw_overall_summary_corporate (~3657 rows)
CREATE TABLE `mw_overall_summary_corporate` (
  `summary_id` bigint NOT NULL AUTO_INCREMENT,
  `ref_id` bigint NOT NULL,
  `customer_id` int NOT NULL,
  `stock_details` blob NOT NULL,
  `value` decimal(34,15) DEFAULT NULL,
  `status` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_type` char(2) COLLATE utf8mb4_general_ci NOT NULL,
  `priority` int NOT NULL,
  `stock_id` int NOT NULL,
  `uid` int DEFAULT NULL,
  `ticker` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bank_name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asetClass` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_type_title` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Industry` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Sector` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `t_date` date DEFAULT NULL,
  `MarketPriceCurrency` char(5) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PurchaseQuantity` decimal(32,15) DEFAULT NULL,
  `price` decimal(32,15) DEFAULT NULL,
  `purchaseValueFormated1` decimal(32,15) DEFAULT NULL,
  `MarketPriceFormated` decimal(32,15) DEFAULT NULL,
  `RealPrice` decimal(32,15) DEFAULT NULL,
  `MarketValueFormated` decimal(32,15) DEFAULT NULL,
  `GainLossFormated` varchar(201) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercteageGanLosFormated` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reporting_currency` char(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FXRate` decimal(10,6) DEFAULT NULL,
  `purchaseValuesInRcFormated` decimal(32,15) DEFAULT NULL,
  `MarketValueRCFormated` decimal(32,15) DEFAULT NULL,
  `DifferenceRCFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormatedinRc` decimal(32,15) DEFAULT NULL,
  `DividendCoupon` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TargetPrice` decimal(32,15) NOT NULL,
  `TargetPricePerentageFormat` decimal(32,15) DEFAULT NULL,
  `Country` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `BondRating` decimal(10,2) DEFAULT NULL,
  `Maturity` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercentageProtFolio` decimal(16,6) DEFAULT NULL,
  `div_class_currency` char(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `currency_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sow_error_currency_convert` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Remarks` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_date` date DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `parent_bank_id` int DEFAULT NULL,
  `FXRateB` decimal(10,6) DEFAULT NULL,
  `GainLossFormatedNum` decimal(16,6) DEFAULT NULL,
  `FxRateValue` decimal(32,15) DEFAULT NULL,
  `xir_calc` decimal(16,6) DEFAULT NULL,
  `PercteageGanLosNumber` decimal(16,6) DEFAULT NULL,
  `bank_priority` int DEFAULT NULL,
  `ytm` decimal(32,15) DEFAULT NULL,
  `macaulay_duration` decimal(10,6) DEFAULT NULL,
  `modified_duration` decimal(10,6) DEFAULT NULL,
  `macaulay_duration_c` decimal(10,6) DEFAULT NULL,
  `modified_duration_c` decimal(10,6) DEFAULT NULL,
  `ytm_c` decimal(10,6) DEFAULT NULL,
  `product_type` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `has_undrly_currency_difference` char(4) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `price_api` decimal(32,15) DEFAULT NULL,
  `market_value_api` decimal(32,15) DEFAULT NULL,
  PRIMARY KEY (`summary_id`),
  KEY `idx_parent_bank_id` (`parent_bank_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- mw_overall_summary_corporate_backup (~463090 rows)
CREATE TABLE `mw_overall_summary_corporate_backup` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `summary_id` bigint NOT NULL,
  `ref_id` bigint NOT NULL,
  `customer_id` int NOT NULL,
  `stock_details` blob NOT NULL,
  `value` decimal(34,15) DEFAULT NULL,
  `status` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_type` char(2) COLLATE utf8mb4_general_ci NOT NULL,
  `priority` int NOT NULL,
  `stock_id` int NOT NULL,
  `uid` int DEFAULT NULL,
  `ticker` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bank_name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asetClass` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_type_title` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Industry` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Sector` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `t_date` date DEFAULT NULL,
  `MarketPriceCurrency` char(5) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PurchaseQuantity` decimal(32,15) DEFAULT NULL,
  `price` decimal(32,15) DEFAULT NULL,
  `purchaseValueFormated1` decimal(32,15) DEFAULT NULL,
  `MarketPriceFormated` decimal(32,15) DEFAULT NULL,
  `RealPrice` decimal(32,15) DEFAULT NULL,
  `MarketValueFormated` decimal(32,15) DEFAULT NULL,
  `GainLossFormated` varchar(201) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercteageGanLosFormated` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reporting_currency` char(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FXRate` decimal(10,6) DEFAULT NULL,
  `purchaseValuesInRcFormated` decimal(32,15) DEFAULT NULL,
  `MarketValueRCFormated` decimal(32,15) DEFAULT NULL,
  `DifferenceRCFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormatedinRc` decimal(32,15) DEFAULT NULL,
  `DividendCoupon` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TargetPrice` decimal(32,15) NOT NULL,
  `TargetPricePerentageFormat` decimal(32,15) DEFAULT NULL,
  `Country` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `BondRating` decimal(10,2) DEFAULT NULL,
  `Maturity` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercentageProtFolio` decimal(16,6) DEFAULT NULL,
  `div_class_currency` char(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `currency_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sow_error_currency_convert` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Remarks` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_date` date DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `FXRateB` decimal(10,6) DEFAULT NULL,
  `GainLossFormatedNum` decimal(16,6) DEFAULT NULL,
  `FxRateValue` decimal(32,15) DEFAULT NULL,
  `xir_calc` decimal(16,6) DEFAULT NULL,
  `PercteageGanLosNumber` decimal(16,6) DEFAULT NULL,
  `bank_priority` int DEFAULT NULL,
  `ytm` decimal(32,15) DEFAULT NULL,
  `macaulay_duration` decimal(10,6) DEFAULT NULL,
  `modified_duration` decimal(10,6) DEFAULT NULL,
  `macaulay_duration_c` decimal(10,6) DEFAULT NULL,
  `modified_duration_c` decimal(10,6) DEFAULT NULL,
  `ytm_c` decimal(10,6) DEFAULT NULL,
  `product_type` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `price_api` decimal(32,15) DEFAULT NULL,
  `market_value_api` decimal(32,15) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_summary_id` (`summary_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- mw_overall_summary_new (~0 rows)
CREATE TABLE `mw_overall_summary_new` (
  `ref_id` bigint NOT NULL,
  `stock_details` blob NOT NULL,
  `value` decimal(34,15) DEFAULT NULL,
  `status` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_type` char(2) COLLATE utf8mb4_general_ci NOT NULL,
  `priority` int NOT NULL,
  `stock_id` int NOT NULL,
  `uid` int DEFAULT NULL,
  `ticker` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bank_name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asetClass` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_type_title` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Industry` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Sector` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `t_date` date DEFAULT NULL,
  `MarketPriceCurrency` char(5) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PurchaseQuantity` decimal(16,6) DEFAULT NULL,
  `price` decimal(32,15) DEFAULT NULL,
  `purchaseValueFormated1` decimal(32,15) DEFAULT NULL,
  `MarketPriceFormated` decimal(32,15) DEFAULT NULL,
  `RealPrice` decimal(32,15) DEFAULT NULL,
  `MarketValueFormated` decimal(32,15) DEFAULT NULL,
  `GainLossFormated` varchar(201) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercteageGanLosFormated` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reporting_currency` char(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `FXRate` decimal(10,6) DEFAULT NULL,
  `purchaseValuesInRcFormated` decimal(32,15) DEFAULT NULL,
  `MarketValueRCFormated` decimal(32,15) DEFAULT NULL,
  `DifferenceRCFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormated` decimal(32,15) DEFAULT NULL,
  `dividenFormatedinRc` decimal(32,15) DEFAULT NULL,
  `DividendCoupon` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TargetPrice` decimal(32,15) NOT NULL,
  `TargetPricePerentageFormat` decimal(32,15) DEFAULT NULL,
  `Country` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `BondRating` decimal(10,2) DEFAULT NULL,
  `Maturity` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PercentageProtFolio` decimal(32,15) DEFAULT NULL,
  `div_class_currency` char(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `currency_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sow_error_currency_convert` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Remarks` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_date` date DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `parent_bank_id` int DEFAULT NULL,
  `FXRateB` decimal(32,15) DEFAULT NULL,
  `GainLossFormatedNum` decimal(32,15) DEFAULT NULL,
  `FxRateValue` decimal(10,6) DEFAULT NULL,
  `xir_calc` decimal(16,6) DEFAULT NULL,
  `PercteageGanLosNumber` decimal(16,6) DEFAULT NULL,
  `ytm` decimal(32,15) DEFAULT NULL,
  `modified_duration` decimal(10,6) DEFAULT NULL,
  `macaulay_duration` decimal(10,6) DEFAULT NULL,
  `macaulay_duration_c` decimal(10,6) DEFAULT NULL,
  `modified_duration_c` decimal(10,6) DEFAULT NULL,
  `ytm_c` decimal(10,6) DEFAULT NULL,
  `product_type` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `has_undrly_currency_difference` char(4) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `price_api` decimal(32,15) DEFAULT NULL,
  `market_value_api` decimal(32,15) DEFAULT NULL,
  PRIMARY KEY (`stock_id`),
  KEY `f_type` (`f_type`),
  KEY `priority` (`priority`),
  KEY `idx_parent_bank_id` (`parent_bank_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- mw_pos_overall_summary_corporate (~3312 rows)
CREATE TABLE `mw_pos_overall_summary_corporate` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `run_id` int unsigned NOT NULL,
  `upload_id` int DEFAULT NULL,
  `customer_id` int DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `parent_bank_id` int DEFAULT NULL,
  `account_number` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `account_normalized` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ref_id` varchar(40) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `stock_id` int DEFAULT NULL,
  `ticker` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin` varchar(80) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin_match` varchar(80) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asetClass` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_class` varchar(80) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_type_title` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_type_stripped` varchar(80) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_type` varchar(8) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PurchaseQuantity` varchar(40) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `MarketValueFormated` varchar(40) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `value` varchar(40) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `MarketPriceCurrency` varchar(12) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `quantity` decimal(22,8) DEFAULT '0.00000000',
  `mapped` tinyint(1) NOT NULL DEFAULT '0',
  `match_status` varchar(40) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pos_row_id` int unsigned DEFAULT NULL,
  `identity_key` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `leftover_reason` varchar(120) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_v2_os_run_mapped` (`run_id`,`mapped`),
  KEY `idx_v2_os_run_identity` (`run_id`,`identity_key`),
  KEY `idx_v2_os_run_status` (`run_id`,`match_status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- mw_pos_recon_v2_run (~11 rows)
CREATE TABLE `mw_pos_recon_v2_run` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `upload_id` int DEFAULT NULL,
  `bank_api_id` int DEFAULT NULL,
  `subdomain_id` int DEFAULT NULL,
  `as_of_date` date DEFAULT NULL,
  `source` varchar(40) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `error_message` text COLLATE utf8mb4_general_ci,
  `xml_rows` int NOT NULL DEFAULT '0',
  `tagged_rows` int NOT NULL DEFAULT '0',
  `unmapped_rows` int NOT NULL DEFAULT '0',
  `os_rows` int NOT NULL DEFAULT '0',
  `matched_items` int NOT NULL DEFAULT '0',
  `mismatch_items` int NOT NULL DEFAULT '0',
  `missing_in_xml` int NOT NULL DEFAULT '0',
  `missing_in_oxy` int NOT NULL DEFAULT '0',
  `bank_id_list` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `note` text COLLATE utf8mb4_general_ci,
  `started_at` datetime DEFAULT NULL,
  `finished_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_pos_recon_v2_run_upload_date` (`upload_id`,`as_of_date`),
  KEY `idx_pos_recon_v2_run_bank` (`bank_api_id`),
  KEY `idx_pos_recon_v2_run_status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- mw_report_table (~0 rows)
CREATE TABLE `mw_report_table` (
  `report_type` char(30) DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `bank_name` varchar(150) DEFAULT NULL,
  `currency_name` varchar(150) DEFAULT NULL,
  `code` char(5) DEFAULT NULL,
  `balance` decimal(34,15) DEFAULT NULL,
  `priority` int DEFAULT NULL,
  `bank_priority` int DEFAULT NULL,
  `type` char(10) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `i_rate` decimal(15,6) DEFAULT NULL,
  `offset_date` date DEFAULT NULL,
  `p_date` date DEFAULT NULL,
  `m_date` date DEFAULT NULL,
  `m_value` decimal(15,6) DEFAULT NULL,
  `duration` int DEFAULT NULL,
  `duration_other` int DEFAULT NULL,
  KEY `report_type` (`report_type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- mw_stock (~0 rows)
CREATE TABLE `mw_stock` (
  `id` int NOT NULL AUTO_INCREMENT,
  `t_date` date DEFAULT NULL,
  `o_date` date DEFAULT NULL,
  `t_o_t` int DEFAULT NULL,
  `t_o_t_other` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ticker_id` int DEFAULT NULL,
  `uid` int DEFAULT NULL,
  `c_currency` int DEFAULT NULL,
  `isin` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ticker` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin_id` int DEFAULT NULL,
  `a_class` int DEFAULT NULL,
  `a_type` int DEFAULT NULL,
  `r_no` char(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bank` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `remarks` text COLLATE utf8mb4_general_ci,
  `p_date` date DEFAULT NULL,
  `quantity` decimal(32,15) DEFAULT NULL,
  `price` decimal(32,15) DEFAULT NULL,
  `p_currency` int DEFAULT NULL,
  `t_price` decimal(23,15) DEFAULT NULL,
  `purpose` text COLLATE utf8mb4_general_ci,
  `commission` decimal(23,15) DEFAULT NULL,
  `b_1` decimal(23,15) DEFAULT NULL,
  `b_2` decimal(23,15) DEFAULT NULL,
  `b_3` decimal(23,15) DEFAULT NULL,
  `r_m` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `r_link` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date_added` datetime NOT NULL,
  `last_updated` datetime NOT NULL,
  `user_id` int DEFAULT NULL,
  `d_status` char(15) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_type` char(2) COLLATE utf8mb4_general_ci NOT NULL,
  `parent_id` int DEFAULT NULL,
  `premium` decimal(32,15) DEFAULT NULL,
  `m_date` date DEFAULT NULL,
  `t_o_o` int DEFAULT NULL,
  `b_s` int DEFAULT NULL,
  `c_date` date DEFAULT NULL,
  `c_date2` date DEFAULT NULL,
  `c_date3` date DEFAULT NULL,
  `duration` int DEFAULT NULL,
  `total_days` int DEFAULT NULL,
  `duration_other` int DEFAULT NULL,
  `i_rate` decimal(23,15) DEFAULT NULL,
  `maturity` decimal(34,15) DEFAULT NULL,
  `security_id` int DEFAULT NULL,
  `b_notes` text COLLATE utf8mb4_general_ci,
  `amount` decimal(34,15) DEFAULT NULL,
  `net` decimal(34,15) DEFAULT NULL,
  `e_t` int DEFAULT NULL,
  `o_s` int DEFAULT NULL,
  `knock` decimal(23,15) DEFAULT NULL,
  `knock_t` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `knock_ft` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `i_b` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bank_id` bigint DEFAULT NULL,
  `sl` char(12) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `accumulator_id` int DEFAULT NULL,
  `d_type` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `d_p` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `md` char(2) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `s_percentage` decimal(23,15) DEFAULT NULL,
  `asset_type_t` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `market_price_t` decimal(32,15) DEFAULT NULL,
  `structure_name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `is_sale` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` enum('A','I') COLLATE utf8mb4_general_ci NOT NULL,
  `s_isin` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `product_type` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ko_barrirer` decimal(10,4) DEFAULT NULL,
  `temp_id` int DEFAULT NULL,
  `parent_isin` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `parent_isin_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `MarketPrice1` decimal(32,15) DEFAULT NULL,
  `Industry1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Sector1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `expired` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `balance_quantity` decimal(32,15) DEFAULT NULL,
  `balance_amount` decimal(34,15) DEFAULT NULL,
  `expired_id` int DEFAULT NULL,
  `parent_structure` int DEFAULT NULL,
  `s_asset_class` char(2) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `interest_id` int DEFAULT NULL,
  `move_live` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `move_potential` tinyint(1) NOT NULL DEFAULT '0',
  `expire_no_parent` char(1) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `expired_label` char(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `portfolio_cash_synced` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `a_class` (`a_class`),
  KEY `a_type` (`a_type`),
  KEY `p_currency` (`p_currency`),
  KEY `user_id` (`user_id`),
  KEY `f_type` (`f_type`),
  KEY `mw_stock_ibfk_5` (`parent_id`),
  KEY `t_o_o` (`t_o_o`),
  KEY `b_s` (`b_s`),
  KEY `c_currency` (`c_currency`),
  KEY `security_id` (`security_id`),
  KEY `t_o_t` (`t_o_t`),
  KEY `e_t` (`e_t`),
  KEY `bank_id` (`bank_id`),
  KEY `accumulator_id` (`accumulator_id`),
  KEY `isin_id` (`isin_id`),
  KEY `uid` (`uid`),
  CONSTRAINT `mw_stock_ibfk_1` FOREIGN KEY (`a_class`) REFERENCES `mw_master` (`master_id`) ON DELETE SET NULL,
  CONSTRAINT `mw_stock_ibfk_10` FOREIGN KEY (`t_o_t`) REFERENCES `nextrouge_primary`.`mw_master` (`master_id`) ON DELETE SET NULL,
  CONSTRAINT `mw_stock_ibfk_11` FOREIGN KEY (`e_t`) REFERENCES `nextrouge_primary`.`mw_master` (`master_id`) ON DELETE SET NULL,
  CONSTRAINT `mw_stock_ibfk_12` FOREIGN KEY (`bank_id`) REFERENCES `mw_customer_banks` (`bank_id`) ON DELETE SET NULL,
  CONSTRAINT `mw_stock_ibfk_13` FOREIGN KEY (`accumulator_id`) REFERENCES `mw_stock` (`id`) ON DELETE SET NULL,
  CONSTRAINT `mw_stock_ibfk_14` FOREIGN KEY (`isin_id`) REFERENCES `mw_master` (`master_id`) ON DELETE SET NULL,
  CONSTRAINT `mw_stock_ibfk_2` FOREIGN KEY (`a_type`) REFERENCES `mw_master` (`master_id`) ON DELETE SET NULL,
  CONSTRAINT `mw_stock_ibfk_3` FOREIGN KEY (`p_currency`) REFERENCES `mw_currency` (`currency_id`) ON DELETE SET NULL,
  CONSTRAINT `mw_stock_ibfk_4` FOREIGN KEY (`user_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE SET NULL,
  CONSTRAINT `mw_stock_ibfk_5` FOREIGN KEY (`parent_id`) REFERENCES `mw_stock` (`id`) ON DELETE SET NULL,
  CONSTRAINT `mw_stock_ibfk_6` FOREIGN KEY (`t_o_o`) REFERENCES `nextrouge_primary`.`mw_master` (`master_id`) ON DELETE SET NULL,
  CONSTRAINT `mw_stock_ibfk_7` FOREIGN KEY (`b_s`) REFERENCES `nextrouge_primary`.`mw_master` (`master_id`) ON DELETE SET NULL,
  CONSTRAINT `mw_stock_ibfk_8` FOREIGN KEY (`c_currency`) REFERENCES `mw_currency` (`currency_id`) ON DELETE SET NULL,
  CONSTRAINT `mw_stock_ibfk_9` FOREIGN KEY (`security_id`) REFERENCES `mw_master` (`master_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- mw_stock_structure_options (~0 rows)
CREATE TABLE `mw_stock_structure_options` (
  `row_id` int NOT NULL,
  `stock_id` int NOT NULL,
  `underlying` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reference_link` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `strike_percentage` decimal(10,2) DEFAULT NULL,
  `currency` int DEFAULT NULL,
  `strike_price` decimal(14,4) DEFAULT NULL,
  `spot_price` decimal(10,2) DEFAULT NULL,
  `quantity` decimal(14,4) NOT NULL,
  `sub_title` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ticker` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`row_id`,`stock_id`),
  KEY `stock_id` (`stock_id`),
  KEY `currency` (`currency`),
  CONSTRAINT `mw_stock_structure_options_ibfk_1` FOREIGN KEY (`stock_id`) REFERENCES `mw_stock` (`id`) ON DELETE CASCADE,
  CONSTRAINT `mw_stock_structure_options_ibfk_2` FOREIGN KEY (`currency`) REFERENCES `mw_currency` (`currency_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- mw_temp_pos_transactions (~2395 rows)
CREATE TABLE `mw_temp_pos_transactions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `run_id` int unsigned NOT NULL,
  `upload_id` int DEFAULT NULL,
  `bank_api_id` int DEFAULT NULL,
  `as_of_date` date DEFAULT NULL,
  `xml_ref` varchar(120) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `account_number` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `account_normalized` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `oxy_customer_id` int DEFAULT NULL,
  `bank_id` int DEFAULT NULL,
  `parent_bank_id` int DEFAULT NULL,
  `isin` varchar(80) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `isin_match` varchar(80) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_class` varchar(80) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_type` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_type_stripped` varchar(80) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `currency` varchar(12) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_type` varchar(8) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `quantity` decimal(22,8) DEFAULT '0.00000000',
  `oxy_quantity` decimal(22,8) DEFAULT NULL,
  `delta` decimal(22,8) DEFAULT NULL,
  `used` tinyint(1) NOT NULL DEFAULT '0',
  `match_status` varchar(40) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `os_row_id` int unsigned DEFAULT NULL,
  `tag_error` varchar(80) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `identity_key` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `leftover_reason` varchar(120) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_v2_pos_run_used` (`run_id`,`used`),
  KEY `idx_v2_pos_run_identity` (`run_id`,`identity_key`),
  KEY `idx_v2_pos_run_status` (`run_id`,`match_status`),
  KEY `idx_v2_pos_account_norm` (`account_normalized`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- mw_user_offset (~0 rows)
CREATE TABLE `mw_user_offset` (
  `id` int NOT NULL AUTO_INCREMENT,
  `offset1` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `default_currency` int DEFAULT NULL,
  `currency_total` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `default_currency` (`default_currency`),
  CONSTRAINT `mw_user_offset_ibfk_1` FOREIGN KEY (`default_currency`) REFERENCES `mw_currency` (`currency_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- mw_widgets_selected (~0 rows)
CREATE TABLE `mw_widgets_selected` (
  `customer_id` int NOT NULL,
  `widget_id` int NOT NULL,
  `priority` int DEFAULT NULL,
  `status` enum('A','I') COLLATE utf8mb4_general_ci NOT NULL,
  `isin_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  PRIMARY KEY (`customer_id`,`widget_id`),
  KEY `widget_id` (`widget_id`),
  CONSTRAINT `mw_widgets_selected_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE,
  CONSTRAINT `mw_widgets_selected_ibfk_2` FOREIGN KEY (`widget_id`) REFERENCES `nextrouge_primary`.`mw_widget` (`widget_id`) ON DELETE CASCADE,
  CONSTRAINT `mw_widgets_selected_chk_1` CHECK (json_valid(`isin_list`))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- stock_history (~0 rows)
CREATE TABLE `stock_history` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `bank_id` int NOT NULL,
  `f_type` char(2) COLLATE utf8mb4_general_ci NOT NULL,
  `value` decimal(16,6) NOT NULL,
  `asetClass` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_type_title` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `date` datetime NOT NULL,
  `currency` char(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `MarketPriceCurrency` char(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Country` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Industry` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Sector` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `purchaseValuesInRcFormated` decimal(16,6) DEFAULT NULL,
  `DifferenceRCFormated` decimal(16,6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- stock_history_corporate (~136893 rows)
CREATE TABLE `stock_history_corporate` (
  `id` bigint NOT NULL,
  `customer_id` int NOT NULL,
  `bank_id` int NOT NULL,
  `f_type` char(2) COLLATE utf8mb4_general_ci NOT NULL,
  `value` decimal(16,6) NOT NULL,
  `asetClass` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `asset_type_title` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `date` date NOT NULL,
  `currency` char(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `MarketPriceCurrency` char(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Country` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Industry` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Sector` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `purchaseValuesInRcFormated` decimal(16,6) DEFAULT NULL,
  `DifferenceRCFormated` decimal(16,6) DEFAULT NULL,
  PRIMARY KEY (`id`,`customer_id`,`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- stock_history_old (~0 rows)
CREATE TABLE `stock_history_old` (
  `bank_id` int NOT NULL,
  `f_type` char(2) COLLATE utf8mb4_general_ci NOT NULL,
  `value` decimal(16,6) NOT NULL,
  `asetClass` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `asset_type_title` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `date` datetime NOT NULL,
  `currency` char(3) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`bank_id`,`f_type`,`asetClass`,`asset_type_title`,`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;