-- MySQL dump 10.13  Distrib 8.0.45, for Linux (x86_64)
--
-- Host: localhost    Database: shukria_transactions
-- ------------------------------------------------------
-- Server version	8.0.45-0ubuntu0.24.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `risk_rules`
--

DROP TABLE IF EXISTS `risk_rules`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `risk_rules` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text,
  `category` varchar(255) NOT NULL,
  `parameters` json DEFAULT NULL,
  `enabled` tinyint(1) DEFAULT '1',
  `rule_type` varchar(255) NOT NULL,
  `execution_order` int DEFAULT '0',
  `mcc_codes` json DEFAULT NULL,
  `inserted_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `risk_rules_name_category_index` (`name`,`category`),
  KEY `risk_rules_category_index` (`category`),
  KEY `risk_rules_enabled_index` (`enabled`),
  KEY `risk_rules_rule_type_index` (`rule_type`)
) ENGINE=InnoDB AUTO_INCREMENT=415 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `risk_rules`
--

LOCK TABLES `risk_rules` WRITE;
/*!40000 ALTER TABLE `risk_rules` DISABLE KEYS */;
INSERT INTO `risk_rules` VALUES (227,'Suspicious International transactions','International card transactions with value ≥ AED 10,000','Cat A','{\"currency\": \"AED\", \"threshold\": 8000.0, \"card_types\": [\"international\"], \"multiplier\": 3.2}',1,'hold',1,'{}','2026-03-19 07:20:54','2026-03-19 07:20:54'),(228,'Multiple Int\'l card, low value','2+ international transactions, same terminal, 2,000–5,000 AED within 30 minutes','Cat A','{\"min_count\": 2, \"threshold\": 8000.0, \"card_types\": [\"international\"], \"max_amount\": 5000, \"min_amount\": 2000, \"multiplier\": 3.2, \"time_window_minutes\": 30}',1,'hold',2,'{}','2026-03-19 07:20:54','2026-03-19 07:20:54'),(229,'Abnormal Time transaction','Transactions between 12AM–7AM, except certain MCCs','Cat A','{\"end_hour\": 7, \"threshold\": 8000.0, \"multiplier\": 3.2, \"start_hour\": 0, \"excluded_mccs\": [\"8062\", \"7011\", \"5542\", \"5812\"]}',1,'hold',3,'{}','2026-03-19 07:20:54','2026-03-19 07:20:54'),(230,'Split transaction','Same card+terminal+city, ≤10 minutes, sum ≥ AED 10,000','Cat A','{\"threshold\": 8000.0, \"multiplier\": 3.2, \"sum_threshold\": 10000, \"grouping_fields\": [\"card_number\", \"terminal_id\", \"location\"], \"time_window_minutes\": 10}',1,'hold',4,'{}','2026-03-19 07:20:54','2026-03-19 07:20:54'),(231,'Duplicate transaction','Same card+terminal+amount, ≤10 minutes, sum ≥ AED 10,000','Cat A','{\"threshold\": 8000.0, \"multiplier\": 3.2, \"sum_threshold\": 10000, \"grouping_fields\": [\"card_number\", \"terminal_id\", \"amount\"], \"time_window_minutes\": 10}',1,'hold',5,'{}','2026-03-19 07:20:54','2026-03-19 07:20:54'),(232,'High Velocity transaction','Same terminal, ≤2 minutes, value ≥ AED 500','Cat A','{\"threshold\": 8000.0, \"multiplier\": 3.2, \"grouping_fields\": [\"terminal_id\"], \"amount_threshold\": 500, \"time_window_minutes\": 2}',1,'hold',6,'{}','2026-03-19 07:20:54','2026-03-19 07:20:54'),(233,'Above-average ticket size','≥4x average ticket size on specific MCCs','Cat A','{\"threshold\": 8000.0, \"multiplier\": 3.2, \"target_mccs\": [\"4812\", \"5732\", \"5733\", \"5541\"], \"rolling_days\": 30}',1,'hold',7,'{}','2026-03-19 07:20:54','2026-03-19 07:20:54'),(234,'Dormant Merchant','Transaction after 30 days of inactivity','Cat A','{\"threshold\": 8000.0, \"multiplier\": 3.2, \"inactivity_days\": 30}',1,'hold',8,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(235,'High Value Transaction','Single transaction value ≥ AED 10,000','Cat A','{\"currency\": \"AED\", \"threshold\": 8000.0, \"multiplier\": 3.2}',1,'hold',9,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(236,'Machines of High Value Fallback Transactions','Transaction amount >50 AED AND entry mode = 80 (Fallback) OR 90 (Magstripe)','Cat A','{\"threshold\": 8000.0, \"multiplier\": 3.2, \"entry_modes\": [\"80\", \"90\"], \"amount_threshold\": 50, \"entry_mode_names\": [\"Fallback\", \"Magstripe\"]}',1,'alert',10,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(237,'Decline Transaction Monitoring','More than 10 declines within 20 minutes at same merchant','Cat A','{\"threshold\": 8000.0, \"multiplier\": 3.2, \"time_window_minutes\": 20, \"decline_count_threshold\": 10}',1,'alert',11,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(238,'New Onboarded Merchant High Decline','Merchant age <90 days AND increasing declines >5 within 20 minutes','Cat A','{\"threshold\": 8000.0, \"multiplier\": 3.2, \"decline_threshold\": 5, \"merchant_age_days\": 90, \"time_window_minutes\": 20}',1,'alert',12,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(239,'MI - Local Transaction Higher than 500K','Single transaction >500,000 AED (Local Cards)','Cat A','{\"card_type\": \"local\", \"threshold\": 8000.0, \"multiplier\": 3.2, \"amount_threshold\": 500000}',1,'hold',13,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(240,'MI - Regional Transaction Higher than 1500K','Single transaction >1,500,000 AED (Regional Cards); Hold for Cat B/C/D, Alert only for Cat A','Cat A','{\"card_type\": \"regional\", \"threshold\": 8000.0, \"multiplier\": 3.2, \"amount_threshold\": 1500000, \"cat_a_alert_only\": true}',1,'hold',14,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(241,'MI - Local Transaction Higher than 400K','Single transaction >400,000 AED (Local Cards), Excluding Cat A','Cat A','{\"card_type\": \"local\", \"threshold\": 8000.0, \"multiplier\": 3.2, \"amount_threshold\": 400000, \"exclude_categories\": [\"Cat A\"]}',1,'hold',15,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(242,'MI - International Transaction Higher than 100K','Single transaction >100,000 AED (International Cards)','Cat A','{\"card_type\": \"international\", \"threshold\": 8000.0, \"multiplier\": 3.2, \"amount_threshold\": 100000}',1,'hold',16,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(243,'MI - International Transaction Higher than 25K','Single transaction >25,000 AED (International Cards)','Cat A','{\"card_type\": \"international\", \"threshold\": 8000.0, \"multiplier\": 3.2, \"amount_threshold\": 25000}',1,'alert',17,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(244,'MV - 10 Cards Same BIN','More than 10 different cards from same BIN used at same merchant within 30 minutes','Cat A','{\"grouping\": [\"bin\", \"merchant_id\"], \"threshold\": 8000.0, \"multiplier\": 3.2, \"time_window_minutes\": 30, \"card_count_threshold\": 10}',1,'alert',18,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(245,'MH - 20 Cards Same BIN','More than 20 different cards from same BIN used at same merchant within 30 minutes','Cat A','{\"grouping\": [\"bin\", \"merchant_id\"], \"threshold\": 8000.0, \"multiplier\": 3.2, \"time_window_minutes\": 30, \"card_count_threshold\": 20}',1,'alert',19,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(246,'MI - Daily Amount Limit Per Card','Accumulated daily amount per card exceeds 100K/200K AED','Cat A','{\"period\": \"daily\", \"threshold\": 8000.0, \"multiplier\": 3.2, \"alternative_threshold\": 200000, \"daily_limit_threshold\": 100000}',1,'alert',20,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(247,'High Value Transaction on New Merchant (First 90 Days)','Transaction >25,000 AED on merchant within first 90 days of account opening','Cat A','{\"threshold\": 8000.0, \"multiplier\": 3.2, \"merchant_status\": \"new\", \"amount_threshold\": 25000, \"merchant_age_days\": 90}',1,'alert',21,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(249,'MI - Suspicious International Transaction (High-Risk Countries)','Transaction from Iraq, Egypt, Libya, Mozambique exceeding 5,000 AED','Cat A','{\"threshold\": 8000.0, \"multiplier\": 3.2, \"country_names\": [\"Iraq\", \"Egypt\", \"Libya\", \"Mozambique\"], \"amount_threshold\": 5000, \"high_risk_countries\": [\"IQ\", \"EG\", \"LY\", \"MZ\"]}',1,'alert',23,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(250,'Suspicious High Value Manual Entry','Domestic/International transaction >5,000 AED (QR) OR POS with manual entry mode (Key-in)','Cat A','{\"threshold\": 8000.0, \"multiplier\": 3.2, \"entry_modes\": [\"manual\", \"keyin\"], \"amount_threshold\": 5000, \"transaction_types\": [\"QR\", \"POS\"]}',1,'alert',24,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(251,'New Merchant International Card (First 50 Days)','Merchant age <50 days AND international card transaction >20,000 AED','Cat A','{\"card_type\": \"international\", \"threshold\": 8000.0, \"multiplier\": 3.2, \"amount_threshold\": 20000, \"merchant_age_days\": 50}',1,'alert',25,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(252,'Expired Card Reuse at Same Merchant','Expired card (response code 01) used >50 times at same merchant','Cat A','{\"grouping\": [\"card_number\", \"merchant_id\"], \"threshold\": 8000.0, \"multiplier\": 3.2, \"response_code\": \"01\", \"transaction_count_threshold\": 50}',1,'alert',26,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(253,'High Amount of Aggregative Refunds','More than 10 refunds totaling >5,000 AED','Cat A','{\"threshold\": 8000.0, \"multiplier\": 3.2, \"transaction_status\": [\"refund\", \"refunded\"], \"refund_count_threshold\": 10, \"total_amount_threshold\": 5000}',1,'alert',27,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(254,'High Value Single Refund Alert','Single refund transaction >5,000 AED','Cat A','{\"threshold\": 8000.0, \"multiplier\": 3.2, \"amount_threshold\": 5000, \"transaction_status\": [\"refund\", \"refunded\"]}',1,'alert',28,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(256,'Transactions Followed by Frequent Successful Transactions','Transaction followed by SUCCESSFUL transaction using Different Card BUT same merchant (4+ declines then approvals - testing stolen cards with different BINs/PANs)','Cat A','{\"pattern\": \"declines_then_approvals\", \"threshold\": 8000.0, \"multiplier\": 3.2, \"decline_count\": 4, \"different_cards\": true, \"time_window_minutes\": 30}',1,'alert',30,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(258,'Daily Volume Above Initial Volume','Daily volume above initial volume of a Merchant','Cat A','{\"threshold\": 8000.0, \"multiplier\": 3.2, \"analysis_period\": \"daily\", \"baseline_period_days\": 30, \"initial_volume_multiplier\": 2.0}',1,'alert',32,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(259,'Multiple Transactions Same Amount','Multiple transactions with same amount','Cat A','{\"threshold\": 8000.0, \"multiplier\": 3.2, \"same_amount_count\": 5, \"time_window_minutes\": 60}',1,'alert',33,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(260,'Merchant Debit Card Transactions','Transactions Reco by debit card of the Merchants','Cat A','{\"card_type\": \"merchant_owned_debit\", \"threshold\": 8000.0, \"multiplier\": 3.2, \"self_transaction_detection\": true}',1,'alert',34,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(274,'Suspicious International transactions','International card transactions with value ≥ AED 10,000','Cat B','{\"currency\": \"AED\", \"threshold\": 10000, \"card_types\": [\"international\"]}',1,'hold',1,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(275,'Multiple Int\'l card, low value','2+ international transactions, same terminal, 2,000–5,000 AED within 30 minutes','Cat B','{\"min_count\": 2, \"card_types\": [\"international\"], \"max_amount\": 5000, \"min_amount\": 2000, \"time_window_minutes\": 30}',1,'hold',2,'{}','2026-03-19 07:20:55','2026-03-19 07:20:55'),(276,'Abnormal Time transaction','Transactions between 12AM–7AM, except certain MCCs','Cat B','{\"end_hour\": 7, \"start_hour\": 0, \"excluded_mccs\": [\"8062\", \"7011\", \"5542\", \"5812\"]}',1,'hold',3,'{}','2026-03-19 07:20:56','2026-03-19 07:20:56'),(277,'Split transaction','Same card+terminal+city, ≤10 minutes, sum ≥ AED 10,000','Cat B','{\"sum_threshold\": 10000, \"grouping_fields\": [\"card_number\", \"terminal_id\", \"location\"], \"time_window_minutes\": 10}',1,'hold',4,'{}','2026-03-19 07:20:56','2026-03-19 07:20:56'),(278,'Duplicate transaction','Same card+terminal+amount, ≤10 minutes, sum ≥ AED 10,000','Cat B','{\"sum_threshold\": 10000, \"grouping_fields\": [\"card_number\", \"terminal_id\", \"amount\"], \"time_window_minutes\": 10}',1,'hold',5,'{}','2026-03-19 07:20:56','2026-03-19 07:20:56'),(279,'High Velocity transaction','Same terminal, ≤2 minutes, value ≥ AED 500','Cat B','{\"grouping_fields\": [\"terminal_id\"], \"amount_threshold\": 500, \"time_window_minutes\": 2}',1,'hold',6,'{}','2026-03-19 07:20:56','2026-03-19 07:20:56'),(280,'Above-average ticket size','≥4x average ticket size on specific MCCs','Cat B','{\"multiplier\": 4.0, \"target_mccs\": [\"4812\", \"5732\", \"5733\", \"5541\"], \"rolling_days\": 30}',1,'hold',7,'{}','2026-03-19 07:20:56','2026-03-19 07:20:56'),(281,'Dormant Merchant','Transaction after 30 days of inactivity','Cat B','{\"inactivity_days\": 30}',1,'hold',8,'{}','2026-03-19 07:20:56','2026-03-19 07:20:56'),(282,'High Value Transaction','Single transaction value ≥ AED 10,000','Cat B','{\"currency\": \"AED\", \"threshold\": 10000}',1,'hold',9,'{}','2026-03-19 07:20:56','2026-03-19 07:20:56'),(283,'Machines of High Value Fallback Transactions','Transaction amount >50 AED AND entry mode = 80 (Fallback) OR 90 (Magstripe)','Cat B','{\"entry_modes\": [\"80\", \"90\"], \"amount_threshold\": 50, \"entry_mode_names\": [\"Fallback\", \"Magstripe\"]}',1,'alert',10,'{}','2026-03-19 07:20:56','2026-03-19 07:20:56'),(284,'Decline Transaction Monitoring','More than 10 declines within 20 minutes at same merchant','Cat B','{\"time_window_minutes\": 20, \"decline_count_threshold\": 10}',1,'alert',11,'{}','2026-03-19 07:20:56','2026-03-19 07:20:56'),(285,'New Onboarded Merchant High Decline','Merchant age <90 days AND increasing declines >5 within 20 minutes','Cat B','{\"decline_threshold\": 5, \"merchant_age_days\": 90, \"time_window_minutes\": 20}',1,'alert',12,'{}','2026-03-19 07:20:56','2026-03-19 07:20:56'),(286,'MI - Local Transaction Higher than 500K','Single transaction >500,000 AED (Local Cards)','Cat B','{\"card_type\": \"local\", \"amount_threshold\": 500000}',1,'hold',13,'{}','2026-03-19 07:20:56','2026-03-19 07:20:56'),(287,'MI - Regional Transaction Higher than 1500K','Single transaction >1,500,000 AED (Regional Cards); Hold for Cat B/C/D, Alert only for Cat A','Cat B','{\"card_type\": \"regional\", \"amount_threshold\": 1500000, \"cat_a_alert_only\": true}',1,'hold',14,'{}','2026-03-19 07:20:56','2026-03-19 07:20:56'),(288,'MI - Local Transaction Higher than 400K','Single transaction >400,000 AED (Local Cards), Excluding Cat A','Cat B','{\"card_type\": \"local\", \"amount_threshold\": 400000, \"exclude_categories\": [\"Cat A\"]}',1,'hold',15,'{}','2026-03-19 07:20:56','2026-03-19 07:20:56'),(289,'MI - International Transaction Higher than 100K','Single transaction >100,000 AED (International Cards)','Cat B','{\"card_type\": \"international\", \"amount_threshold\": 100000}',1,'hold',16,'{}','2026-03-19 07:20:56','2026-03-19 07:20:56'),(290,'MI - International Transaction Higher than 25K','Single transaction >25,000 AED (International Cards)','Cat B','{\"card_type\": \"international\", \"amount_threshold\": 25000}',1,'alert',17,'{}','2026-03-19 07:20:56','2026-03-19 07:20:56'),(291,'MV - 10 Cards Same BIN','More than 10 different cards from same BIN used at same merchant within 30 minutes','Cat B','{\"grouping\": [\"bin\", \"merchant_id\"], \"time_window_minutes\": 30, \"card_count_threshold\": 10}',1,'alert',18,'{}','2026-03-19 07:20:56','2026-03-19 07:20:56'),(292,'MH - 20 Cards Same BIN','More than 20 different cards from same BIN used at same merchant within 30 minutes','Cat B','{\"grouping\": [\"bin\", \"merchant_id\"], \"time_window_minutes\": 30, \"card_count_threshold\": 20}',1,'alert',19,'{}','2026-03-19 07:20:56','2026-03-19 07:20:56'),(293,'MI - Daily Amount Limit Per Card','Accumulated daily amount per card exceeds 100K/200K AED','Cat B','{\"period\": \"daily\", \"alternative_threshold\": 200000, \"daily_limit_threshold\": 100000}',1,'alert',20,'{}','2026-03-19 07:20:56','2026-03-19 07:20:56'),(294,'High Value Transaction on New Merchant (First 90 Days)','Transaction >25,000 AED on merchant within first 90 days of account opening','Cat B','{\"merchant_status\": \"new\", \"amount_threshold\": 25000, \"merchant_age_days\": 90}',1,'alert',21,'{}','2026-03-19 07:20:56','2026-03-19 07:20:56'),(296,'MI - Suspicious International Transaction (High-Risk Countries)','Transaction from Iraq, Egypt, Libya, Mozambique exceeding 5,000 AED','Cat B','{\"country_names\": [\"Iraq\", \"Egypt\", \"Libya\", \"Mozambique\"], \"amount_threshold\": 5000, \"high_risk_countries\": [\"IQ\", \"EG\", \"LY\", \"MZ\"]}',1,'alert',23,'{}','2026-03-19 07:20:56','2026-03-19 07:20:56'),(297,'Suspicious High Value Manual Entry','Domestic/International transaction >5,000 AED (QR) OR POS with manual entry mode (Key-in)','Cat B','{\"entry_modes\": [\"manual\", \"keyin\"], \"amount_threshold\": 5000, \"transaction_types\": [\"QR\", \"POS\"]}',1,'alert',24,'{}','2026-03-19 07:20:56','2026-03-19 07:20:56'),(298,'New Merchant International Card (First 50 Days)','Merchant age <50 days AND international card transaction >20,000 AED','Cat B','{\"card_type\": \"international\", \"amount_threshold\": 20000, \"merchant_age_days\": 50}',1,'alert',25,'{}','2026-03-19 07:20:56','2026-03-19 07:20:56'),(299,'Expired Card Reuse at Same Merchant','Expired card (response code 01) used >50 times at same merchant','Cat B','{\"grouping\": [\"card_number\", \"merchant_id\"], \"response_code\": \"01\", \"transaction_count_threshold\": 50}',1,'alert',26,'{}','2026-03-19 07:20:56','2026-03-19 07:20:56'),(300,'High Amount of Aggregative Refunds','More than 10 refunds totaling >5,000 AED','Cat B','{\"transaction_status\": [\"refund\", \"refunded\"], \"refund_count_threshold\": 10, \"total_amount_threshold\": 5000}',1,'alert',27,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(301,'High Value Single Refund Alert','Single refund transaction >5,000 AED','Cat B','{\"amount_threshold\": 5000, \"transaction_status\": [\"refund\", \"refunded\"]}',1,'alert',28,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(303,'Transactions Followed by Frequent Successful Transactions','Transaction followed by SUCCESSFUL transaction using Different Card BUT same merchant (4+ declines then approvals - testing stolen cards with different BINs/PANs)','Cat B','{\"pattern\": \"declines_then_approvals\", \"decline_count\": 4, \"different_cards\": true, \"time_window_minutes\": 30}',1,'alert',30,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(305,'Daily Volume Above Initial Volume','Daily volume above initial volume of a Merchant','Cat B','{\"analysis_period\": \"daily\", \"baseline_period_days\": 30, \"initial_volume_multiplier\": 2.0}',1,'alert',32,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(306,'Multiple Transactions Same Amount','Multiple transactions with same amount','Cat B','{\"same_amount_count\": 5, \"time_window_minutes\": 60}',1,'alert',33,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(307,'Merchant Debit Card Transactions','Transactions Reco by debit card of the Merchants','Cat B','{\"card_type\": \"merchant_owned_debit\", \"self_transaction_detection\": true}',1,'alert',34,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(321,'Suspicious International transactions','International card transactions with value ≥ AED 10,000','Cat C','{\"currency\": \"AED\", \"threshold\": 12000.0, \"card_types\": [\"international\"], \"multiplier\": 4.8}',1,'hold',1,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(322,'Multiple Int\'l card, low value','2+ international transactions, same terminal, 2,000–5,000 AED within 30 minutes','Cat C','{\"min_count\": 2, \"threshold\": 12000.0, \"card_types\": [\"international\"], \"max_amount\": 5000, \"min_amount\": 2000, \"multiplier\": 4.8, \"time_window_minutes\": 30}',1,'hold',2,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(323,'Abnormal Time transaction','Transactions between 12AM–7AM, except certain MCCs','Cat C','{\"end_hour\": 7, \"threshold\": 12000.0, \"multiplier\": 4.8, \"start_hour\": 0, \"excluded_mccs\": [\"8062\", \"7011\", \"5542\", \"5812\"]}',1,'hold',3,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(324,'Split transaction','Same card+terminal+city, ≤10 minutes, sum ≥ AED 10,000','Cat C','{\"threshold\": 12000.0, \"multiplier\": 4.8, \"sum_threshold\": 10000, \"grouping_fields\": [\"card_number\", \"terminal_id\", \"location\"], \"time_window_minutes\": 10}',1,'hold',4,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(325,'Duplicate transaction','Same card+terminal+amount, ≤10 minutes, sum ≥ AED 10,000','Cat C','{\"threshold\": 12000.0, \"multiplier\": 4.8, \"sum_threshold\": 10000, \"grouping_fields\": [\"card_number\", \"terminal_id\", \"amount\"], \"time_window_minutes\": 10}',1,'hold',5,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(326,'High Velocity transaction','Same terminal, ≤2 minutes, value ≥ AED 500','Cat C','{\"threshold\": 12000.0, \"multiplier\": 4.8, \"grouping_fields\": [\"terminal_id\"], \"amount_threshold\": 500, \"time_window_minutes\": 2}',1,'hold',6,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(327,'Above-average ticket size','≥4x average ticket size on specific MCCs','Cat C','{\"threshold\": 12000.0, \"multiplier\": 4.8, \"target_mccs\": [\"4812\", \"5732\", \"5733\", \"5541\"], \"rolling_days\": 30}',1,'hold',7,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(328,'Dormant Merchant','Transaction after 30 days of inactivity','Cat C','{\"threshold\": 12000.0, \"multiplier\": 4.8, \"inactivity_days\": 30}',1,'hold',8,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(329,'High Value Transaction','Single transaction value ≥ AED 10,000','Cat C','{\"currency\": \"AED\", \"threshold\": 12000.0, \"multiplier\": 4.8}',1,'hold',9,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(330,'Machines of High Value Fallback Transactions','Transaction amount >50 AED AND entry mode = 80 (Fallback) OR 90 (Magstripe)','Cat C','{\"threshold\": 12000.0, \"multiplier\": 4.8, \"entry_modes\": [\"80\", \"90\"], \"amount_threshold\": 50, \"entry_mode_names\": [\"Fallback\", \"Magstripe\"]}',1,'alert',10,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(331,'Decline Transaction Monitoring','More than 10 declines within 20 minutes at same merchant','Cat C','{\"threshold\": 12000.0, \"multiplier\": 4.8, \"time_window_minutes\": 20, \"decline_count_threshold\": 10}',1,'alert',11,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(332,'New Onboarded Merchant High Decline','Merchant age <90 days AND increasing declines >5 within 20 minutes','Cat C','{\"threshold\": 12000.0, \"multiplier\": 4.8, \"decline_threshold\": 5, \"merchant_age_days\": 90, \"time_window_minutes\": 20}',1,'alert',12,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(333,'MI - Local Transaction Higher than 500K','Single transaction >500,000 AED (Local Cards)','Cat C','{\"card_type\": \"local\", \"threshold\": 12000.0, \"multiplier\": 4.8, \"amount_threshold\": 500000}',1,'hold',13,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(334,'MI - Regional Transaction Higher than 1500K','Single transaction >1,500,000 AED (Regional Cards); Hold for Cat B/C/D, Alert only for Cat A','Cat C','{\"card_type\": \"regional\", \"threshold\": 12000.0, \"multiplier\": 4.8, \"amount_threshold\": 1500000, \"cat_a_alert_only\": true}',1,'hold',14,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(335,'MI - Local Transaction Higher than 400K','Single transaction >400,000 AED (Local Cards), Excluding Cat A','Cat C','{\"card_type\": \"local\", \"threshold\": 12000.0, \"multiplier\": 4.8, \"amount_threshold\": 400000, \"exclude_categories\": [\"Cat A\"]}',1,'hold',15,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(336,'MI - International Transaction Higher than 100K','Single transaction >100,000 AED (International Cards)','Cat C','{\"card_type\": \"international\", \"threshold\": 12000.0, \"multiplier\": 4.8, \"amount_threshold\": 100000}',1,'hold',16,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(337,'MI - International Transaction Higher than 25K','Single transaction >25,000 AED (International Cards)','Cat C','{\"card_type\": \"international\", \"threshold\": 12000.0, \"multiplier\": 4.8, \"amount_threshold\": 25000}',1,'alert',17,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(338,'MV - 10 Cards Same BIN','More than 10 different cards from same BIN used at same merchant within 30 minutes','Cat C','{\"grouping\": [\"bin\", \"merchant_id\"], \"threshold\": 12000.0, \"multiplier\": 4.8, \"time_window_minutes\": 30, \"card_count_threshold\": 10}',1,'alert',18,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(339,'MH - 20 Cards Same BIN','More than 20 different cards from same BIN used at same merchant within 30 minutes','Cat C','{\"grouping\": [\"bin\", \"merchant_id\"], \"threshold\": 12000.0, \"multiplier\": 4.8, \"time_window_minutes\": 30, \"card_count_threshold\": 20}',1,'alert',19,'{}','2026-03-19 07:20:57','2026-03-19 07:20:57'),(340,'MI - Daily Amount Limit Per Card','Accumulated daily amount per card exceeds 100K/200K AED','Cat C','{\"period\": \"daily\", \"threshold\": 12000.0, \"multiplier\": 4.8, \"alternative_threshold\": 200000, \"daily_limit_threshold\": 100000}',1,'alert',20,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(341,'High Value Transaction on New Merchant (First 90 Days)','Transaction >25,000 AED on merchant within first 90 days of account opening','Cat C','{\"threshold\": 12000.0, \"multiplier\": 4.8, \"merchant_status\": \"new\", \"amount_threshold\": 25000, \"merchant_age_days\": 90}',1,'alert',21,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(343,'MI - Suspicious International Transaction (High-Risk Countries)','Transaction from Iraq, Egypt, Libya, Mozambique exceeding 5,000 AED','Cat C','{\"threshold\": 12000.0, \"multiplier\": 4.8, \"country_names\": [\"Iraq\", \"Egypt\", \"Libya\", \"Mozambique\"], \"amount_threshold\": 5000, \"high_risk_countries\": [\"IQ\", \"EG\", \"LY\", \"MZ\"]}',1,'alert',23,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(344,'Suspicious High Value Manual Entry','Domestic/International transaction >5,000 AED (QR) OR POS with manual entry mode (Key-in)','Cat C','{\"threshold\": 12000.0, \"multiplier\": 4.8, \"entry_modes\": [\"manual\", \"keyin\"], \"amount_threshold\": 5000, \"transaction_types\": [\"QR\", \"POS\"]}',1,'alert',24,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(345,'New Merchant International Card (First 50 Days)','Merchant age <50 days AND international card transaction >20,000 AED','Cat C','{\"card_type\": \"international\", \"threshold\": 12000.0, \"multiplier\": 4.8, \"amount_threshold\": 20000, \"merchant_age_days\": 50}',1,'alert',25,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(346,'Expired Card Reuse at Same Merchant','Expired card (response code 01) used >50 times at same merchant','Cat C','{\"grouping\": [\"card_number\", \"merchant_id\"], \"threshold\": 12000.0, \"multiplier\": 4.8, \"response_code\": \"01\", \"transaction_count_threshold\": 50}',1,'alert',26,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(347,'High Amount of Aggregative Refunds','More than 10 refunds totaling >5,000 AED','Cat C','{\"threshold\": 12000.0, \"multiplier\": 4.8, \"transaction_status\": [\"refund\", \"refunded\"], \"refund_count_threshold\": 10, \"total_amount_threshold\": 5000}',1,'alert',27,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(348,'High Value Single Refund Alert','Single refund transaction >5,000 AED','Cat C','{\"threshold\": 12000.0, \"multiplier\": 4.8, \"amount_threshold\": 5000, \"transaction_status\": [\"refund\", \"refunded\"]}',1,'alert',28,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(350,'Transactions Followed by Frequent Successful Transactions','Transaction followed by SUCCESSFUL transaction using Different Card BUT same merchant (4+ declines then approvals - testing stolen cards with different BINs/PANs)','Cat C','{\"pattern\": \"declines_then_approvals\", \"threshold\": 12000.0, \"multiplier\": 4.8, \"decline_count\": 4, \"different_cards\": true, \"time_window_minutes\": 30}',1,'alert',30,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(352,'Daily Volume Above Initial Volume','Daily volume above initial volume of a Merchant','Cat C','{\"threshold\": 12000.0, \"multiplier\": 4.8, \"analysis_period\": \"daily\", \"baseline_period_days\": 30, \"initial_volume_multiplier\": 2.0}',1,'alert',32,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(353,'Multiple Transactions Same Amount','Multiple transactions with same amount','Cat C','{\"threshold\": 12000.0, \"multiplier\": 4.8, \"same_amount_count\": 5, \"time_window_minutes\": 60}',1,'alert',33,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(354,'Merchant Debit Card Transactions','Transactions Reco by debit card of the Merchants','Cat C','{\"card_type\": \"merchant_owned_debit\", \"threshold\": 12000.0, \"multiplier\": 4.8, \"self_transaction_detection\": true}',1,'alert',34,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(368,'Suspicious International transactions','International card transactions with value ≥ AED 10,000','Cat D','{\"currency\": \"AED\", \"threshold\": 15000.0, \"card_types\": [\"international\"], \"multiplier\": 6.0, \"time_window_minutes\": 20}',1,'hold',1,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(369,'Multiple Int\'l card, low value','2+ international transactions, same terminal, 2,000–5,000 AED within 30 minutes','Cat D','{\"min_count\": 2, \"threshold\": 15000.0, \"card_types\": [\"international\"], \"max_amount\": 5000, \"min_amount\": 2000, \"multiplier\": 6.0, \"time_window_minutes\": 60}',1,'hold',2,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(370,'Abnormal Time transaction','Transactions between 12AM–7AM, except certain MCCs','Cat D','{\"end_hour\": 7, \"threshold\": 15000.0, \"multiplier\": 6.0, \"start_hour\": 0, \"excluded_mccs\": [\"8062\", \"7011\", \"5542\", \"5812\"], \"time_window_minutes\": 20}',1,'hold',3,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(371,'Split transaction','Same card+terminal+city, ≤10 minutes, sum ≥ AED 10,000','Cat D','{\"threshold\": 15000.0, \"multiplier\": 6.0, \"sum_threshold\": 10000, \"grouping_fields\": [\"card_number\", \"terminal_id\", \"location\"], \"time_window_minutes\": 20}',1,'hold',4,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(372,'Duplicate transaction','Same card+terminal+amount, ≤10 minutes, sum ≥ AED 10,000','Cat D','{\"threshold\": 15000.0, \"multiplier\": 6.0, \"sum_threshold\": 10000, \"grouping_fields\": [\"card_number\", \"terminal_id\", \"amount\"], \"time_window_minutes\": 20}',1,'hold',5,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(373,'High Velocity transaction','Same terminal, ≤2 minutes, value ≥ AED 500','Cat D','{\"threshold\": 15000.0, \"multiplier\": 6.0, \"grouping_fields\": [\"terminal_id\"], \"amount_threshold\": 500, \"time_window_minutes\": 4}',1,'hold',6,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(374,'Above-average ticket size','≥4x average ticket size on specific MCCs','Cat D','{\"threshold\": 15000.0, \"multiplier\": 6.0, \"target_mccs\": [\"4812\", \"5732\", \"5733\", \"5541\"], \"rolling_days\": 30, \"time_window_minutes\": 20}',1,'hold',7,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(375,'Dormant Merchant','Transaction after 30 days of inactivity','Cat D','{\"threshold\": 15000.0, \"multiplier\": 6.0, \"inactivity_days\": 30, \"time_window_minutes\": 20}',1,'hold',8,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(376,'High Value Transaction','Single transaction value ≥ AED 10,000','Cat D','{\"currency\": \"AED\", \"threshold\": 15000.0, \"multiplier\": 6.0, \"time_window_minutes\": 20}',1,'hold',9,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(377,'Machines of High Value Fallback Transactions','Transaction amount >50 AED AND entry mode = 80 (Fallback) OR 90 (Magstripe)','Cat D','{\"threshold\": 15000.0, \"multiplier\": 6.0, \"entry_modes\": [\"80\", \"90\"], \"amount_threshold\": 50, \"entry_mode_names\": [\"Fallback\", \"Magstripe\"], \"time_window_minutes\": 20}',1,'alert',10,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(378,'Decline Transaction Monitoring','More than 10 declines within 20 minutes at same merchant','Cat D','{\"threshold\": 15000.0, \"multiplier\": 6.0, \"time_window_minutes\": 40, \"decline_count_threshold\": 10}',1,'alert',11,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(379,'New Onboarded Merchant High Decline','Merchant age <90 days AND increasing declines >5 within 20 minutes','Cat D','{\"threshold\": 15000.0, \"multiplier\": 6.0, \"decline_threshold\": 5, \"merchant_age_days\": 90, \"time_window_minutes\": 40}',1,'alert',12,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(380,'MI - Local Transaction Higher than 500K','Single transaction >500,000 AED (Local Cards)','Cat D','{\"card_type\": \"local\", \"threshold\": 15000.0, \"multiplier\": 6.0, \"amount_threshold\": 500000, \"time_window_minutes\": 20}',1,'hold',13,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(381,'MI - Regional Transaction Higher than 1500K','Single transaction >1,500,000 AED (Regional Cards); Hold for Cat B/C/D, Alert only for Cat A','Cat D','{\"card_type\": \"regional\", \"threshold\": 15000.0, \"multiplier\": 6.0, \"amount_threshold\": 1500000, \"cat_a_alert_only\": true, \"time_window_minutes\": 20}',1,'hold',14,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(382,'MI - Local Transaction Higher than 400K','Single transaction >400,000 AED (Local Cards), Excluding Cat A','Cat D','{\"card_type\": \"local\", \"threshold\": 15000.0, \"multiplier\": 6.0, \"amount_threshold\": 400000, \"exclude_categories\": [\"Cat A\"], \"time_window_minutes\": 20}',1,'hold',15,'{}','2026-03-19 07:20:58','2026-03-19 07:20:58'),(383,'MI - International Transaction Higher than 100K','Single transaction >100,000 AED (International Cards)','Cat D','{\"card_type\": \"international\", \"threshold\": 15000.0, \"multiplier\": 6.0, \"amount_threshold\": 100000, \"time_window_minutes\": 20}',1,'hold',16,'{}','2026-03-19 07:20:59','2026-03-19 07:20:59'),(384,'MI - International Transaction Higher than 25K','Single transaction >25,000 AED (International Cards)','Cat D','{\"card_type\": \"international\", \"threshold\": 15000.0, \"multiplier\": 6.0, \"amount_threshold\": 25000, \"time_window_minutes\": 20}',1,'alert',17,'{}','2026-03-19 07:20:59','2026-03-19 07:20:59'),(385,'MV - 10 Cards Same BIN','More than 10 different cards from same BIN used at same merchant within 30 minutes','Cat D','{\"grouping\": [\"bin\", \"merchant_id\"], \"threshold\": 15000.0, \"multiplier\": 6.0, \"time_window_minutes\": 60, \"card_count_threshold\": 10}',1,'alert',18,'{}','2026-03-19 07:20:59','2026-03-19 07:20:59'),(386,'MH - 20 Cards Same BIN','More than 20 different cards from same BIN used at same merchant within 30 minutes','Cat D','{\"grouping\": [\"bin\", \"merchant_id\"], \"threshold\": 15000.0, \"multiplier\": 6.0, \"time_window_minutes\": 60, \"card_count_threshold\": 20}',1,'alert',19,'{}','2026-03-19 07:20:59','2026-03-19 07:20:59'),(387,'MI - Daily Amount Limit Per Card','Accumulated daily amount per card exceeds 100K/200K AED','Cat D','{\"period\": \"daily\", \"threshold\": 15000.0, \"multiplier\": 6.0, \"time_window_minutes\": 20, \"alternative_threshold\": 200000, \"daily_limit_threshold\": 100000}',1,'alert',20,'{}','2026-03-19 07:20:59','2026-03-19 07:20:59'),(388,'High Value Transaction on New Merchant (First 90 Days)','Transaction >25,000 AED on merchant within first 90 days of account opening','Cat D','{\"threshold\": 15000.0, \"multiplier\": 6.0, \"merchant_status\": \"new\", \"amount_threshold\": 25000, \"merchant_age_days\": 90, \"time_window_minutes\": 20}',1,'alert',21,'{}','2026-03-19 07:20:59','2026-03-19 07:20:59'),(390,'MI - Suspicious International Transaction (High-Risk Countries)','Transaction from Iraq, Egypt, Libya, Mozambique exceeding 5,000 AED','Cat D','{\"threshold\": 15000.0, \"multiplier\": 6.0, \"country_names\": [\"Iraq\", \"Egypt\", \"Libya\", \"Mozambique\"], \"amount_threshold\": 5000, \"high_risk_countries\": [\"IQ\", \"EG\", \"LY\", \"MZ\"], \"time_window_minutes\": 20}',1,'alert',23,'{}','2026-03-19 07:20:59','2026-03-19 07:20:59'),(391,'Suspicious High Value Manual Entry','Domestic/International transaction >5,000 AED (QR) OR POS with manual entry mode (Key-in)','Cat D','{\"threshold\": 15000.0, \"multiplier\": 6.0, \"entry_modes\": [\"manual\", \"keyin\"], \"amount_threshold\": 5000, \"transaction_types\": [\"QR\", \"POS\"], \"time_window_minutes\": 20}',1,'alert',24,'{}','2026-03-19 07:20:59','2026-03-19 07:20:59'),(392,'New Merchant International Card (First 50 Days)','Merchant age <50 days AND international card transaction >20,000 AED','Cat D','{\"card_type\": \"international\", \"threshold\": 15000.0, \"multiplier\": 6.0, \"amount_threshold\": 20000, \"merchant_age_days\": 50, \"time_window_minutes\": 20}',1,'alert',25,'{}','2026-03-19 07:20:59','2026-03-19 07:20:59'),(393,'Expired Card Reuse at Same Merchant','Expired card (response code 01) used >50 times at same merchant','Cat D','{\"grouping\": [\"card_number\", \"merchant_id\"], \"threshold\": 15000.0, \"multiplier\": 6.0, \"response_code\": \"01\", \"time_window_minutes\": 20, \"transaction_count_threshold\": 50}',1,'alert',26,'{}','2026-03-19 07:20:59','2026-03-19 07:20:59'),(394,'High Amount of Aggregative Refunds','More than 10 refunds totaling >5,000 AED','Cat D','{\"threshold\": 15000.0, \"multiplier\": 6.0, \"transaction_status\": [\"refund\", \"refunded\"], \"time_window_minutes\": 20, \"refund_count_threshold\": 10, \"total_amount_threshold\": 5000}',1,'alert',27,'{}','2026-03-19 07:20:59','2026-03-19 07:20:59'),(395,'High Value Single Refund Alert','Single refund transaction >5,000 AED','Cat D','{\"threshold\": 15000.0, \"multiplier\": 6.0, \"amount_threshold\": 5000, \"transaction_status\": [\"refund\", \"refunded\"], \"time_window_minutes\": 20}',1,'alert',28,'{}','2026-03-19 07:20:59','2026-03-19 07:20:59'),(397,'Transactions Followed by Frequent Successful Transactions','Transaction followed by SUCCESSFUL transaction using Different Card BUT same merchant (4+ declines then approvals - testing stolen cards with different BINs/PANs)','Cat D','{\"pattern\": \"declines_then_approvals\", \"threshold\": 15000.0, \"multiplier\": 6.0, \"decline_count\": 4, \"different_cards\": true, \"time_window_minutes\": 60}',1,'alert',30,'{}','2026-03-19 07:20:59','2026-03-19 07:20:59'),(399,'Daily Volume Above Initial Volume','Daily volume above initial volume of a Merchant','Cat D','{\"threshold\": 15000.0, \"multiplier\": 6.0, \"analysis_period\": \"daily\", \"time_window_minutes\": 20, \"baseline_period_days\": 30, \"initial_volume_multiplier\": 2.0}',1,'alert',32,'{}','2026-03-19 07:20:59','2026-03-19 07:20:59'),(400,'Multiple Transactions Same Amount','Multiple transactions with same amount','Cat D','{\"threshold\": 15000.0, \"multiplier\": 6.0, \"same_amount_count\": 5, \"time_window_minutes\": 120}',1,'alert',33,'{}','2026-03-19 07:20:59','2026-03-19 07:20:59'),(401,'Merchant Debit Card Transactions','Transactions Reco by debit card of the Merchants','Cat D','{\"card_type\": \"merchant_owned_debit\", \"threshold\": 15000.0, \"multiplier\": 6.0, \"time_window_minutes\": 20, \"self_transaction_detection\": true}',1,'alert',34,'{}','2026-03-19 07:20:59','2026-03-19 07:20:59');
/*!40000 ALTER TABLE `risk_rules` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-03-26  9:40:09
