-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jun 09, 2025 at 03:37 AM
-- Server version: 10.6.21-MariaDB-cll-lve-log
-- PHP Version: 8.3.21

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `thiqljmz_banksfinders`
--

-- --------------------------------------------------------

--
-- Table structure for table `BankLatest`
--

CREATE TABLE `BankLatest` (
  `Bank` varchar(24) DEFAULT NULL,
  `CARD_name` varchar(50) DEFAULT NULL,
  `Minimum_Salary` varchar(3) DEFAULT NULL,
  `Annual_Fee` varchar(28) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `BankLatest`
--

INSERT INTO `BankLatest` (`Bank`, `CARD_name`, `Minimum_Salary`, `Annual_Fee`) VALUES
('Deem Finance', 'Deem Titanium card', '5K', 'Free for first year'),
('Deem Finance', 'Deem Platinum Card', '10K', 'Free for life'),
('Deem Finance', 'Deem World Card', '25K', 'Free for life'),
('Dubai First', 'Dubai First Cashback card', '5K', 'Free for first year'),
('Dubai First', 'Dubai First Slice pay card', '5K', 'Free for first year'),
('Mashreq Bank', 'Mashreq Cashback Credit Card', '5K', 'Free for life'),
('Mashreq Bank', 'Mashreq Noon Credit Card', '5K', 'Free for life'),
('Mashreq Bank', 'Mashreq Platinum Elite Credit Card', '7K', 'AED 650 + VAT'),
('Mashreq Bank', 'Mashreq Solitaire Credit card', '25K', 'AED 1500 + VAT'),
('Emirates NBD Bank', 'Emirates NBD Duo Credit Card', '10K', 'Free For Life'),
('Emirates NBD Bank', 'Emirates NBD Lulu 247 Platinum Credit Card', '15K', 'AED 250'),
('Emirates NBD Bank', 'Emirates NBD Lulu 247 Titanium Credit Card', '5K', 'Free For Life'),
('Emirates NBD Bank', 'Emirates NBD Skywards Signature Credit Card', '12k', 'AED 735'),
('Emirates NBD Bank', 'Emirates NBD Skywards Infinite Credit Card', '30K', 'AED 1575'),
('Emirates NBD Bank', 'Emirates NBD VISA Infinite Credit Card', '30K', 'AED 1575'),
('Emirates NBD Bank', 'Emirates NBD Dnata World Credit Card', '20K', 'AED 1049'),
('Emirates NBD Bank', 'Emirates NBD Dnata Platinum Credit Card', '5K', 'AED 525'),
('Emirates NBD Bank', 'Emirates NBD Etihad Guest Visa Elevate', '30K', 'AED 1575'),
('Emirates NBD Bank', 'Emirates NBD Etihad Guest Visa Inspire', '12k', 'AED 735'),
('Emirates NBD Bank', 'Emirates NBD Mastercard Platinum Credit Card', '12k', ' No annual fee '),
('Emirates NBD Bank', 'Emirates NBD Visa Platinum Credit Card', '12k', 'No Annual Fees'),
('Emirates NBD Bank', 'Emirates NBD Mastercard Titanium Credit Card', '5k', 'No Annual Fees'),
('Emirates NBD Bank', 'Emirates NBD Go4it Platinum Credit Card', '12k', 'No Annual Fees'),
('Emirates NBD Bank', 'Emirates NBD Go4it Gold Credit Card', '5k', 'No Annual Fees'),
('Emirates NBD Bank', 'Emirates NBD U By Emaar Visa Family Card', '5K', 'Free for Life'),
('Emirates NBD Bank', 'Emirates NBD U By Emaar Visa Infinite', '30k', 'AED 1575'),
('Emirates NBD Bank', 'Emirates NBD U By Emaar Signature Credit Card', '12K', 'AED 262.50'),
('Emirates NBD Bank', 'ENBD noon One Visa Credit card', '5K', 'Free for Life'),
('Ajman Bank', 'Ajman Bank ULTRACASH Mastercard Touch Card', '10K', 'AED 300'),
('Ajman Bank', 'Ajman Bank BRight World Credit Card', '20K', 'AED 1500'),
('Ajman Bank', 'Ajman Bank BRight Platinum Credit Card', '10K', 'AED 1000'),
('Ajman Bank', 'Ajman Bank BRight Titanium Credit Card', '5K', 'Free for Life'),
('First Abu Dhabi Bank', 'FAB Etihad Guest Infinite Credit Card', '30K', '2500'),
('First Abu Dhabi Bank', 'FAB Etihad Guest Infinite Credit Card', '30K', '2500'),
('First Abu Dhabi Bank', 'FAB Etihad Guest Signature Credit Card', '15K', '1500'),
('First Abu Dhabi Bank', 'FAB Etihad Guest Platinum Credit Card', '8k', '500'),
('First Abu Dhabi Bank', 'FAB Travel Card world Elite', '25K', '1500'),
('First Abu Dhabi Bank', 'FAB Cashback Credit Card', '5k', '300'),
('First Abu Dhabi Bank', 'FAB du Titanium Credit Card', '5K', 'No Annual fee'),
('First Abu Dhabi Bank', 'FAB GEMS World Credit Card', '8K', 'AED 399'),
('First Abu Dhabi Bank', 'BLUE FAB Infinite Credit Card by Al-Futtaim', '40K', 'No Annual Fees'),
('First Abu Dhabi Bank', 'BLUE FAB Signature Credit Card by Al-Futtaim', '15K', 'Free For Life'),
('First Abu Dhabi Bank', 'BLUE FAB Platinum Credit Card by Al-Futtaim', '8K', 'Free For Life'),
('First Abu Dhabi Bank', 'FAB SHARE Signature Credit Card', '30K', '1500'),
('First Abu Dhabi Bank', 'FAB SHARE Platinum Credit Card', '10K', '1000'),
('First Abu Dhabi Bank', 'FAB SHARE Standard Credit Card', '5K', 'No Annual Fees'),
('First Abu Dhabi Bank', 'FAB Elite Credit Card', '50K', 'Free for First year- 1200'),
('First Abu Dhabi Bank', 'FAB Rewards Indulge Card', '5K', 'No Annual Fee'),
('Commercial Bank of Dubai', 'CBD Visa Infinite Credit Card', '15K', 'Free for first year'),
('Commercial Bank of Dubai', 'CBD Super Saver Credit Card', '5K', 'Free for first year'),
('Commercial Bank of Dubai', 'CBD One Credit Card', '5K', 'Free for Life'),
('Commercial Bank of Dubai', 'CBD Yes Rewards Credit Card', '5K', 'Free For First year'),
('Commercial Bank of Dubai', 'CBD Visa Smiles Signature Credit Card', '5k', 'F Y F then AED 199'),
('RAK BANK', 'RAK Bank World Credit Card', '20K', 'FYF then 950'),
('RAK BANK', 'RAK Bank Titanium Credit Card', '8k', 'Free for Life'),
('RAK BANK', 'RAK Bank Air Arabia Platinum Credit Card', '5K', 'AED 420*'),
('RAK Bank', 'RAK Bank RED Credit Card', '5k', 'Free for Life'),
('RAK Bank', 'RAK Bank Elevate credit card ', '35K', 'Spend base'),
('Emirates Islamic Bank', 'Emirates Islamic Emarati Credit Card', '12K', 'No Annual fee'),
('Emirates Islamic Bank', 'Emirates Islamic Flex Elite Credit Card', '15K', '735'),
('Emirates Islamic Bank', 'Emirates Islamic RTA Credit Card', '5K', 'No Annual Fee'),
('Emirates Islamic Bank', 'Emirates Islamic Cashback Credit Card', '5k', 'No AMF for first year*'),
('Emirates Islamic Bank', 'Emirates Islamic Cashback Plus Credit Card', '12K', 'No AMF for first year*'),
('Emirates Islamic Bank', 'Emirates Islamic Switch Cashback Credit Card', '5K', 'Free for First Year'),
('Emirates Islamic Bank', 'Emirates Islamic Etihad Guest Premium Credit Card', '20K', 'No AMF for first year*'),
('Emirates Islamic Bank', 'Emirates Islamic Etihad Guest Saqer Credit Card', '12k', 'No AMF for first year*'),
('Emirates Islamic Bank', 'Emirates Islamic Etihad Guest Ameera Credit Card', NULL, 'No AMF for first year*'),
('Emirates Islamic Bank', 'Emirates Islamic Etihad Guest Platinum Credit Card', '5k', 'No AMF for first year* '),
('Emirates Islamic Bank', 'Emirates Islamic Skywards Black Credit Card', '35K', 'AED 2k or AED 3.5K'),
('Emirates Islamic Bank', 'Emirates Islamic Skywards Infinite Credit Card', '20K', 'AED 2K'),
('Emirates Islamic Bank', 'Emirates Islamic Skywards Signature Credit Card', '12k', 'AED 700'),
('HSBC', 'HSBC Cash+ Credit Card', '30K', 'Free for 1st  Year-then 1000'),
('HSBC', 'HSBC Live+ Credit Card', '5K', 'Free for 1st  Year*'),
('HSBC', 'HSBC Max Rewards Credit Card', '10K', 'Free for 1st  Year'),
('HSBC', 'HSBC Emirates Skywards Infinite Credit Card', '30K', 'AED 2,500'),
('HSBC', 'HSBC Emirates Skywards Signature Credit Card', '10K', 'AED 1,000'),
('Liv Bank', 'Liv Bank Cashback Credit Card', '5K', 'Free for life'),
('Liv Bank', 'Liv Bank Cashback Plus Credit Card', '10k', 'AED 700'),
('NBQ', 'NBQ Infinite Credit Card', '30k', 'AED 1000'),
('NBQ', 'NBQ Platinum Credit Card', '15k', 'AED 500'),
('NBQ', 'NBQ Gold Credit Card', '8k', 'Free for life'),
('Dubai Islamic Bank', 'DIB SHAMS Infinite Covered Card', '50K', 'Free for 1st year'),
('Dubai Islamic Bank', 'DIB SHAMS Signature Covered Card', NULL, 'Free for 1st year'),
('Dubai Islamic Bank', 'DIB SHAMS Platinum Covered Card', 'K', 'Free for 1st year'),
('Dubai Islamic Bank', 'The Emirates Skywards DIB Infinite Covered Card', NULL, NULL),
('Dubai Islamic Bank', 'The Emirates Skywards DIB Signature Covered Card', NULL, NULL),
('Dubai Islamic Bank', 'The Emirates Skywards DIB Platinum Covered Card', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `banks`
--

CREATE TABLE `banks` (
  `idbanks` int(11) NOT NULL,
  `bankcode` varchar(20) DEFAULT NULL,
  `bankname` varchar(100) DEFAULT NULL,
  `bankDetails` varchar(500) DEFAULT NULL,
  `bankslocation` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `banks`
--

INSERT INTO `banks` (`idbanks`, `bankcode`, `bankname`, `bankDetails`, `bankslocation`) VALUES
(2, 'ADCB', 'Abu Dhabi Commercial Bank', '', 'Abu Dhabi'),
(3, 'ADIB', 'Abu Dhabi Islamic Bank', '', 'Ajman'),
(4, 'AJMANBANK', 'Ajman Bank', '', 'Abu Dhabi'),
(5, 'AlHilal', 'Al Hilal Bank', '', 'Abu Dhabi'),
(6, 'BOS', 'Bank of Sharjah', '', 'Ras Al Khaimah'),
(7, 'CBI', 'Commercial Bank International', '', 'Dubai'),
(8, 'CBD', 'Commercial Bank of Dubai', '', 'Dubai'),
(9, 'DIB', 'Dubai Islamic Bank', '', 'Dubai'),
(10, 'EIBANK', 'Emirates Investment Bank', '', 'Dubai'),
(11, 'EIB', 'Emirates Islamic Bank', '', 'Dubai'),
(12, 'EMIRATESNBD', 'Emirates NBD Bank', '', 'Abu Dhabi'),
(13, 'FAB', 'First Abu Dhabi Bank', '', 'Abu Dhabi'),
(14, 'INVESTB', 'Invest Bank', '', 'Dubai'),
(15, 'MASQ', 'Mashreq Bank', '', 'Fujairah'),
(16, 'NBF', 'National Bank of Fujairah', '', 'Ras Al Khaimah'),
(17, 'RAKBANK', 'RAK BANK', '', 'Umm Al Quwain'),
(18, 'NBQ', 'NBQ', '', 'Ajman'),
(19, 'SIB', 'Sharjah Islamic Bank', '', 'Sharjah'),
(20, 'UAB', 'United Arab Bank', '', 'Abu Dhabi'),
(21, 'DEEM', 'Deem Finance', '', 'Dubai'),
(22, 'DubaiFirst', 'Dubai First', '', 'Dubai'),
(23, 'HSBC', 'HSBC', NULL, 'Dubai'),
(24, 'LivBank', 'Liv Bank', NULL, 'Dubai'),
(25, 'CityBank', 'City Bank', NULL, NULL),
(26, 'STB', 'Standard Chartered', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `carddetailsdummy`
--

CREATE TABLE `carddetailsdummy` (
  `id` int(11) NOT NULL,
  `code` int(11) DEFAULT NULL,
  `Bank` varchar(255) DEFAULT NULL,
  `CARD_IMAGE` int(11) DEFAULT NULL,
  `CARD_name` varchar(255) DEFAULT NULL,
  `Column_6` varchar(255) DEFAULT NULL,
  `Minimum_Salary` varchar(50) DEFAULT NULL,
  `Annual_Fee` varchar(255) DEFAULT NULL,
  `Column_9` text DEFAULT NULL,
  `VIEW_Features` text DEFAULT NULL,
  `OFFERS` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `carddetailsrought`
--

CREATE TABLE `carddetailsrought` (
  `id` int(11) NOT NULL,
  `code` int(11) DEFAULT NULL,
  `bank` varchar(24) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `card_image` int(11) DEFAULT NULL,
  `card_name` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `card_type` varchar(17) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `minimum_salary` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `annual_fee` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `view_features` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `offers` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `carddetailsrought`
--

INSERT INTO `carddetailsrought` (`id`, `code`, `bank`, `card_image`, `card_name`, `card_type`, `minimum_salary`, `annual_fee`, `description`, `view_features`, `offers`) VALUES
(1, NULL, 'Deem Finance', NULL, 'Deem Titanium card', NULL, '5K', 'Free for first year', NULL, 'Free for first year. 10+ lounges in the Middle East and the Levant. Up to 10% discount on hotel bookings at booking.com. Up to 20% on Avis car rentals worldwide. 10% off your car rental with rentalcars.com.', '500 AED Welcome bonus on spend of 12K in 3 months, 300 AED Welcome bonus on spend of 8K in 3 months valid until 31st March 2025, weekly draw of AED 100,000'),
(2, NULL, 'Deem Finance', NULL, 'Deem Platinum Card', NULL, '10K', 'Free for life', NULL, 'Free for life. 25+ lounges in the Middle East and the Levant. Up to 30% on ClearTrip. Up to 10% discount on hotel bookings at booking.com. Up to 20% on Avis car rentals worldwide. 10% off your car rental with rentalcars.com. 10% off on selected luxury fashion with Farfetch. Complimentary valet parking service.', '500 AED Welcome bonus on spend of 12K in 3 months, 300 AED Welcome bonus on spend of 8K in 3 months valid until 31st March 2025, weekly draw of AED 100,000');

-- --------------------------------------------------------

--
-- Table structure for table `cardfeatures`
--

CREATE TABLE `cardfeatures` (
  `idcardfeature` int(11) NOT NULL,
  `cardfeaturedesc` varchar(500) DEFAULT NULL,
  `cardfeaturedetails` varchar(1000) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cardfeatures`
--

INSERT INTO `cardfeatures` (`idcardfeature`, `cardfeaturedesc`, `cardfeaturedetails`) VALUES
(1, 'Fee for life', NULL),
(2, 'Airport lounge', NULL),
(3, 'Earn Reward Points', NULL),
(4, 'Fuel Discounts', NULL),
(5, 'Dining Offers', NULL),
(6, 'Exclusive Travel Benefits', NULL),
(7, 'Hotel Discounts', NULL),
(8, 'Priority Customer Support', NULL),
(9, '1% Cashback on All Purchases', NULL),
(10, 'Low Interest Rate', NULL),
(11, 'Free Movie Tickets', NULL),
(12, '0% Balance Transfer', NULL),
(13, 'No Foreign Transaction Fee', NULL),
(14, 'Bonus Points on Signup', NULL),
(59, 'Cash Back', NULL),
(60, 'Welcome Bonus on signup', NULL),
(61, 'Free for Life', NULL),
(62, 'Movie Discount', NULL),
(65, 'High Credit limit', NULL),
(66, 'Skywards Miles', NULL),
(67, 'Etihad Miles', NULL),
(69, 'Exclusive for UAE National', NULL),
(72, '0% Smart Cash', NULL),
(74, 'Travel Benefits', NULL),
(75, 'Entertainment Benefits', NULL),
(76, 'Valet Parking', NULL),
(77, 'Golf Benefits', NULL),
(78, 'Concierge Service', NULL),
(79, 'Health Club Memberships', NULL),
(80, 'Fitness First Privileges', NULL),
(81, 'Free Travel Insurance', NULL),
(82, 'Airport Meet & Greet', NULL),
(83, 'Airport Pick-Up / Drop', NULL),
(84, 'Fitness & Wellness Memberships', NULL),
(85, 'Purchase Protection & Extended Warranty', NULL),
(86, 'Roadside Assistance', NULL),
(87, 'Airport Spa', NULL),
(88, 'Insurance', NULL),
(89, 'Flexible Payments', NULL),
(90, 'Financial Benefit', NULL),
(91, 'Amazon Prime Membership', NULL),
(92, 'Agoda Offer', NULL),
(93, 'Avis Car Rental', NULL),
(94, 'Salik Top Up', NULL),
(95, 'Accident Insurance', NULL),
(96, 'Education Cover', NULL),
(97, 'Lifestyle Benefits', NULL),
(98, 'Emergency Assistance', NULL),
(99, 'Loyalty Benefits', NULL),
(100, 'Amazon Gift Card', NULL),
(101, 'Nol Card', NULL),
(102, 'RTA Transport Payments', NULL),
(103, 'Metal Card', NULL),
(104, 'Salaam Points', NULL),
(105, 'Touch Points', NULL),
(106, 'Free Supplementary Cards', NULL),
(107, 'Zomato Pro Membership', NULL),
(108, 'Carrefour & Amazon Vouchers', NULL),
(109, 'Spa', NULL),
(110, 'Welcome Miles', NULL),
(111, 'Complimentary Class upgrades', NULL),
(112, 'SHARE points', NULL),
(113, 'Protection Benefits', NULL),
(114, 'Lowest interest rates on spending', NULL),
(115, '30% discount on Emaar Attraction', NULL),
(116, 'Payment plans', NULL),
(117, 'Noon Gift voucher of AED 500*', NULL),
(118, 'Noon Gift voucher of AED 200*', NULL),
(119, 'Get up to 100,000 Skywards Miles', NULL),
(120, 'AED 500 Welcome Bonus', NULL),
(121, 'Talabat credit on spends', NULL),
(122, 'Unlimited free delivery on talabat', NULL),
(123, 'Personalized card design', NULL),
(124, 'Air Miles', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `CardFilters`
--

CREATE TABLE `CardFilters` (
  `cardname` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Cash_Back` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Welcome_Bonus` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Free_for_Life` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Travel_Card` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Airport_Lounge` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `First_Year_Free` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Fuel_Discounts` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Movies_Discount` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Easy_Cash` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Balance_Transfer` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Column_0_Balance_Transfer` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Dining_Offers` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Health_Club_Memberships` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Column_0_Foreign_Transaction_Fee` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Valet_Parking` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Premium_Card` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Etihad_Miles` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Emirate_Skywards` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Life_style` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Fixed_Deposit` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Islamic_Card` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Emirati_Card` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Golf_Benefits` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Concierge_Service` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Free_Travel_Insurance` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Airport_Meet_Greet` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Airport_Pick_Up_Drop` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Roadside_Assistance` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Flexible_Payments` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Amazon_Prime_Membership` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Agoda_Offer` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Avis_Car_Rental` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Accident_Insurance` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `salam_points` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Protection_Benefits` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Column_30_discount_on_Emaar_Attraction` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Talabat_Benefits` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `CardFilters`
--

INSERT INTO `CardFilters` (`cardname`, `Cash_Back`, `Welcome_Bonus`, `Free_for_Life`, `Travel_Card`, `Airport_Lounge`, `First_Year_Free`, `Fuel_Discounts`, `Movies_Discount`, `Easy_Cash`, `Balance_Transfer`, `Column_0_Balance_Transfer`, `Dining_Offers`, `Health_Club_Memberships`, `Column_0_Foreign_Transaction_Fee`, `Valet_Parking`, `Premium_Card`, `Etihad_Miles`, `Emirate_Skywards`, `Life_style`, `Fixed_Deposit`, `Islamic_Card`, `Emirati_Card`, `Golf_Benefits`, `Concierge_Service`, `Free_Travel_Insurance`, `Airport_Meet_Greet`, `Airport_Pick_Up_Drop`, `Roadside_Assistance`, `Flexible_Payments`, `Amazon_Prime_Membership`, `Agoda_Offer`, `Avis_Car_Rental`, `Accident_Insurance`, `salam_points`, `Protection_Benefits`, `Column_30_discount_on_Emaar_Attraction`, `Talabat_Benefits`) VALUES
('Deem Mastercard Titanium Cash Up Credit Card', 'Y', NULL, NULL, 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, NULL, 'Y'),
('Deem Mastercard Platinum Cash Up Credit Card', 'Y', NULL, 'Y', 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, NULL),
('Deem Mastercard World Miles Up Credit Card', 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, 'Y', 'Y', 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, 'Y'),
('Dubai First Cashback credit card', 'Y', NULL, NULL, 'Y', 'Y', NULL, 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, NULL),
('Dubai First Slice pay credit card', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('Mashreq Cashback Credit Card', 'Y', 'Y', 'Y', 'Y', NULL, NULL, 'Y', NULL, 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('Mashreq Noon Credit Card', 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('Mashreq Platinum Elite Credit Card', NULL, 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, 'Y', NULL, 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL),
('Mashreq Solitaire Credit card', NULL, 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', 'Y', 'Y', NULL, 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL),
('Emirates NBD Duo Credit Card', 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, 'Y', 'Y', NULL, 'Y'),
('Emirates NBD Lulu 247 Platinum Credit Card', 'Y', 'Y', NULL, 'Y', 'Y', NULL, 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, NULL),
('Emirates NBD Lulu 247 Titanium Credit Card', 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, 'Y', NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, NULL),
('Emirates NBD Skywards Signature Credit Card', NULL, 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL),
('Emirates NBD Skywards Infinite Credit Card', NULL, 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, NULL),
('Emirates NBD VISA Infinite Credit Card', 'Y', NULL, NULL, 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL),
('Emirates NBD Dnata World Credit Card', NULL, 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL),
('Emirates NBD Dnata Platinum Credit Card', NULL, 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, NULL),
('Emirates NBD Etihad Guest Visa Elevate', NULL, 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, 'Y', NULL, NULL),
('Emirates NBD Etihad Guest Visa Inspire', NULL, 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL),
('Emirates NBD Mastercard Platinum Credit Card', 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, NULL),
('Emirates NBD Visa Platinum Credit Card', 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, NULL),
('Emirates NBD Mastercard Titanium Credit Card', 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL),
('Emirates NBD SHARE Visa Infinite Credit Card', 'Y', 'Y', NULL, 'Y', NULL, 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, NULL),
('Emirates NBD SHARE Visa Signature Credit Card', 'Y', 'Y', 'Y', 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, NULL),
('Emirates NBD SHARE Visa Platinum Credit Card', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL),
('Emirates NBD Darna Visa Infinite Credit Card', 'Y', 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL),
('Emirates NBD Darna Visa Signature Credit Card', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL),
('Emirates NBD Darna Select Visa Credit Card', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL),
('Emirates NBD U By Emaar Infinite Credit Card', 'Y', 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, 'Y', NULL),
('Emirates NBD U By Emaar Signature Credit Card', 'Y', 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, 'Y', NULL),
('Emirates NBD U By Emaar Family Credit Card', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL),
('Emirates NBD noon One Visa Credit card\n', 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('Ajman Bank ULTRACASH Mastercard Touch Card', 'Y', 'Y', NULL, 'Y', 'Y', NULL, 'Y', 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL),
('Ajman Bank BRight World Credit Card', NULL, 'Y', NULL, 'Y', 'Y', NULL, NULL, NULL, 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('Ajman Bank BRight Platinum Credit Card', NULL, 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('Ajman Bank BRight Titanium Credit Card', NULL, NULL, 'Y', 'Y', 'Y', NULL, NULL, NULL, 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('FAB Etihad Guest Infinite Credit Card', NULL, 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', 'Y', 'Y', NULL, NULL, NULL, 'Y', 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', 'Y', 'Y', NULL, 'Y', NULL, 'Y', NULL, 'Y', NULL, 'Y', NULL, NULL),
('FAB Etihad Guest Signature Credit Card', NULL, 'Y', NULL, 'Y', 'Y', NULL, NULL, NULL, 'Y', 'Y', 'Y', 'Y', NULL, NULL, NULL, 'Y', 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL, 'Y', NULL, 'Y', NULL, 'Y', NULL, 'Y', NULL, NULL),
('FAB Etihad Guest Platinum Credit Card', NULL, 'Y', NULL, 'Y', NULL, NULL, NULL, 'Y', 'Y', 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', NULL, 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL),
('FAB Travel Card world Elite', 'Y', 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', 'Y', 'Y', NULL, 'Y', NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('FAB Cashback Credit Card', 'Y', NULL, NULL, 'Y', 'Y', NULL, 'Y', 'Y', 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('FAB du Titanium Credit Card', 'Y', NULL, 'Y', 'Y', 'Y', NULL, NULL, NULL, 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('FAB GEMS World Credit Card', 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('BLUE FAB Infinite Credit Card by Al-Futtaim', 'Y', NULL, 'Y', 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', 'Y', 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('BLUE FAB Signature Credit Card by Al-Futtaim', 'Y', NULL, 'Y', 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', 'Y', 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('BLUE FAB Platinum Credit Card by Al-Futtaim', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, 'Y', 'Y', 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('FAB Elite Credit Card', NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('FAB Rewards Indulge Card', NULL, NULL, 'Y', 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL),
('CBD Visa Infinite Credit Card', NULL, NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL),
('CBD Super Saver Credit Card', 'Y', NULL, NULL, 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL),
('CBD One Credit Card', 'Y', NULL, 'Y', 'Y', NULL, NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL),
('CBD Yes Rewards Credit Card', NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, NULL, 'Y', 'Y', 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL),
('CBD Visa Smiles Signature Credit Card', NULL, NULL, NULL, NULL, 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('RAK Bank World Credit Card', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('RAK Bank Titanium Credit Card', 'Y', NULL, 'Y', 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL, 'Y', NULL, NULL),
('RAK Bank Air Arabia Platinum Credit Card', NULL, 'Y', NULL, 'Y', NULL, NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('RAK Bank RED Credit Card', 'Y', NULL, 'Y', 'Y', 'Y', NULL, NULL, NULL, 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y'),
('RAK Bank Elevate credit card ', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, 'Y', NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y'),
('Emirates Islamic Emarati Credit Card', NULL, 'Y', 'Y', 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, 'Y', 'Y', NULL, 'Y', 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y'),
('Emirates Islamic Flex Elite Credit Card', NULL, 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y'),
('Emirates Islamic RTA Credit Card', 'Y', NULL, 'Y', NULL, NULL, NULL, 'Y', 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL),
('Emirates Islamic Cashback Credit Card', 'Y', NULL, NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL),
('Emirates Islamic Cashback Plus Credit Card', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL),
('Emirates Islamic Switch Cashback Credit Card', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, 'Y', 'Y', 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL),
('Emirates Islamic Etihad Guest Premium Credit Card', NULL, 'Y', NULL, 'Y', 'Y', NULL, NULL, NULL, 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL),
('Emirates Islamic Etihad Guest Saqer Credit Card', NULL, 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL),
('Emirates Islamic Etihad Guest Ameera Credit Card', NULL, 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, 'Y', NULL, 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL),
('Emirates Islamic Etihad Guest Platinum Credit Card', NULL, 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, 'Y', NULL, 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('Emirates Islamic Skywards Black Credit Card', NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, 'Y', 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y'),
('Emirates Islamic Skywards Infinite Credit Card', NULL, NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL, 'Y', 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, 'Y'),
('Emirates Islamic Skywards Signature Credit Card', NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL, 'Y', 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('HSBC Cash+ Credit Card', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, 'Y', 'Y', 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('HSBC Live+ Credit Card', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, 'Y', NULL, 'Y'),
('HSBC Max Rewards Credit Card', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', 'Y', 'Y', NULL, NULL, NULL, 'Y', 'Y', NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('HSBC Emirates Skywards Infinite Credit Card', NULL, 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, NULL, 'Y', NULL, 'Y', 'Y', 'Y', NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL),
('HSBC Emirates Skywards Signature Credit Card', NULL, 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', 'Y', 'Y', NULL, NULL, NULL, 'Y', 'Y', 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, 'Y'),
('Liv Bank Cashback Credit Card', 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y'),
('Liv Bank Cashback Plus Credit Card', 'Y', NULL, NULL, 'Y', 'Y', NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, 'Y', NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y'),
('NBQ Infinite Credit Card', NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('NBQ Platinum Credit Card', NULL, NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('NBQ Gold Credit Card', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('DIB SHAMS Infinite Covered Card', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', 'Y', NULL, 'Y', 'Y', NULL, 'Y', 'Y', NULL, 'Y', 'Y', NULL, NULL, 'Y', NULL, 'Y', NULL, 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, NULL, NULL, 'Y', NULL, 'Y', NULL, 'Y'),
('DIB SHAMS Signature Covered Card', NULL, 'Y', NULL, 'Y', 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL, 'Y', 'Y', 'Y', 'Y', NULL, NULL, 'Y', NULL, 'Y', NULL, 'Y'),
('DIB SHAMS Platinum Covered Card', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, 'Y'),
('The Emirates Skywards DIB Infinite Covered Card', NULL, 'Y', NULL, 'Y', 'Y', NULL, NULL, NULL, 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, 'Y', NULL, 'Y', NULL, 'Y'),
('The Emirates Skywards DIB Signature Covered Card', NULL, 'Y', NULL, 'Y', 'Y', NULL, NULL, NULL, 'Y', 'Y', NULL, 'Y', NULL, NULL, NULL, 'Y', NULL, 'Y', 'Y', NULL, 'Y', NULL, NULL, 'Y', NULL, NULL, NULL, NULL, 'Y', NULL, NULL, NULL, NULL, NULL, 'Y', NULL, 'Y');

-- --------------------------------------------------------

--
-- Table structure for table `cardoffer_transformed`
--

CREATE TABLE `cardoffer_transformed` (
  `CARD_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Offers` varchar(111) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cardoffer_transformed`
--

INSERT INTO `cardoffer_transformed` (`CARD_name`, `Offers`) VALUES
('Deem Mastercard Titanium Cash Up Credit Card', 'Up to 3% Cash Up at supermarkets, fuel and utilities'),
('Deem Mastercard Titanium Cash Up Credit Card', 'Complimentary Airport lounge access'),
('Deem Mastercard Titanium Cash Up Credit Card', '20% discount on 3 Careem rides every month'),
('Deem Mastercard Titanium Cash Up Credit Card', 'First year free'),
('Deem Mastercard Platinum Cash Up Credit Card', 'Free for life credit card'),
('Deem Mastercard Platinum Cash Up Credit Card', 'Earn up to 10% cash up on specific categories'),
('Deem Mastercard Platinum Cash Up Credit Card', 'Complimentary Valtrans valet parking service'),
('Deem Mastercard World Miles Up Credit Card', 'First for Life'),
('Deem Mastercard World Miles Up Credit Card', '50% off on VOX cinema'),
('Deem Mastercard World Miles Up Credit Card', 'Golf Privileges'),
('Deem Mastercard World Miles Up Credit Card', 'Travel medical insurance'),
('Deem Mastercard World Miles Up Credit Card', 'Airport lounge benefits'),
('Deem Mastercard World Miles Up Credit Card', 'Miles Up benefit'),
('Dubai First Cashback card', 'Return flights to the Maldives or Greece'),
('Dubai First Cashback card', 'Maldives -2 nights / 3 days in a 5-star resort with breakfast'),
('Dubai First Cashback card', 'Greece - 2 nights/ 3 days in a 4-star hotel in Athens'),
('Dubai First Cashback card', '5% cashback on supermarket spending, dining and fuel.'),
('Dubai First Slice pay card', 'Slice your purchases into 4 interest-free instalments'),
('Dubai First Slice pay card', 'Get an instant digital card'),
('Dubai First Slice pay card', 'No processing fees'),
('Mashreq Cashback Credit Card', 'Welcome bonus of AED 500'),
('Mashreq Cashback Credit Card', 'Up to 5% Cashback'),
('Mashreq Cashback Credit Card', '20% Cashback at your favourite ecom merchants'),
('Mashreq Cashback Credit Card', 'Free for Life'),
('Mashreq Noon Credit Card', 'AED 500 Welcome Bonus'),
('Mashreq Noon Credit Card', 'No annual fees ever'),
('Mashreq Noon Credit Card', '5% cashback on noon, NowNow, Sivvi, noon Food'),
('Mashreq Noon Credit Card', '5% cashback on noon Minutes, noon supermall and Namshi'),
('Mashreq Platinum Elite Credit Card', 'Welcome bonus of AED 1500'),
('Mashreq Platinum Elite Credit Card', 'Access to Fitness First'),
('Mashreq Platinum Elite Credit Card', 'Free Airport transfer'),
('Mashreq Platinum Elite Credit Card', '50% discount on movie'),
('Mashreq Solitaire Credit card', 'Welcome Bonus of AED 2,500'),
('Mashreq Solitaire Credit card', 'Unlimited visits to Fitness First'),
('Mashreq Solitaire Credit card', 'Travel insurance'),
('Mashreq Solitaire Credit card', 'Airport lounge access'),
('Emirates NBD Duo Credit Card', '5% rewards on grocery, electronics, utilities, education and fuel'),
('Emirates NBD Duo Credit Card', 'Unlimited complimentary airport lounge access'),
('Emirates NBD Duo Credit Card', 'Exclusive for Abu Dhabi residents'),
('Emirates NBD Duo Credit Card', 'Movie Discount'),
('Emirates NBD Lulu 247 Platinum Credit Card', 'Up to 500 Lulu Points'),
('Emirates NBD Lulu 247 Platinum Credit Card', 'Up to 7% back as Lulu Points'),
('Emirates NBD Lulu 247 Platinum Credit Card', 'Buy 1 Get 1 Free on Movie Tickets'),
('Emirates NBD Lulu 247 Platinum Credit Card', 'Airport lounge Access'),
('Emirates NBD Lulu 247 Titanium Credit Card', 'Free for life card'),
('Emirates NBD Lulu 247 Titanium Credit Card', 'Airport lounge Access'),
('Emirates NBD Lulu 247 Titanium Credit Card', '0% balance transfer with no processing fees'),
('Emirates NBD Lulu 247 Titanium Credit Card', 'Up to 3.5 % back as Lulu Points on daily spends'),
('Emirates NBD Skywards Signature Credit Card', 'Bonus Skywards Miles up to 40,000'),
('Emirates NBD Skywards Signature Credit Card', 'Up to 1.5 Skywards Miles/USD'),
('Emirates NBD Skywards Signature Credit Card', 'Unlimited access to premium Airport lounges'),
('Emirates NBD Skywards Signature Credit Card', 'Buy 1 get 1 free on movies'),
('Emirates NBD Skywards Infinite Credit Card', 'Up to 100,000 bonus Skywards Miles'),
('Emirates NBD Skywards Infinite Credit Card', 'Emirates Skywards Silver membership upgrade'),
('Emirates NBD Skywards Infinite Credit Card', 'Business Class Lounge access with Silver membership.'),
('Emirates NBD Skywards Infinite Credit Card', 'Earn up to 2 Skywards Miles per USD equivalent spend'),
('Emirates NBD VISA Infinite Credit Card', 'Complimentary golf access'),
('Emirates NBD VISA Infinite Credit Card', 'Up to 2 points for every AED 100 spent'),
('Emirates NBD VISA Infinite Credit Card', 'Unlimited access to over 1,000 premium lounges in over 300 cities'),
('Emirates NBD Dnata World Credit Card', 'Welcome bonus up to 2,500 dnata points'),
('Emirates NBD Dnata World Credit Card', '0% back on Dubai Duty Free;'),
('Emirates NBD Dnata World Credit Card', '0% forex fee'),
('Emirates NBD Dnata World Credit Card', 'Access to over 900 VIP Airport lounges'),
('Emirates NBD Dnata Platinum Credit Card', 'Welcome bonus up to 1,000 dnata points'),
('Emirates NBD Dnata Platinum Credit Card', 'Complimentary lounge access with Mastercard Travel Pass'),
('Emirates NBD Dnata Platinum Credit Card', 'Up to 15% dnata Points on all spends'),
('Emirates NBD Dnata Platinum Credit Card', 'Access to over 900 VIP Airport lounges'),
('Emirates NBD Etihad Guest Visa Elevate', 'Welcome offer of up to 200,000 Etihad Guest miles'),
('Emirates NBD Etihad Guest Visa Elevate', 'Earn up to 10 etihad Guest Miles/10 AED spend'),
('Emirates NBD Etihad Guest Visa Elevate', 'Fast Track to gold Tier'),
('Emirates NBD Etihad Guest Visa Elevate', '50% Etihad guest miles discount voucher'),
('Emirates NBD Etihad Guest Visa Inspire', 'Welcome offer of up to 60,000 Etihad Guest miles'),
('Emirates NBD Etihad Guest Visa Inspire', 'Earn up to 7 etihad Guest Miles/10 AED spend'),
('Emirates NBD Etihad Guest Visa Inspire', 'Fast Track to silver Tier'),
('Emirates NBD Mastercard Platinum Credit Card', 'No Annual Fees'),
('Emirates NBD Mastercard Platinum Credit Card', 'Earn up to 1.5 Plus Points for every AED 100 spent'),
('Emirates NBD Visa Platinum Credit Card', 'No Annual Fees'),
('Emirates NBD Visa Platinum Credit Card', 'Earn up to 1.5 Plus Points for every AED 100 spent'),
('Emirates NBD Mastercard Titanium Credit Card', 'No Annual Fees'),
('Emirates NBD Mastercard Titanium Credit Card', 'Earn Plus Points on your spends'),
('Emirates NBD SHARE Visa Infinite Credit Card', 'Free for first year'),
('Emirates NBD SHARE Visa Infinite Credit Card', 'Earn 8% back as SHARE Points'),
('Emirates NBD SHARE Visa Infinite Credit Card', 'Welcome bonus of 10,000 SHARE Points equal to AED 1,000'),
('Emirates NBD SHARE Visa Signature Credit Card', 'Free for Life'),
('Emirates NBD SHARE Visa Signature Credit Card', 'Earn 6% back as SHARE Points'),
('Emirates NBD SHARE Visa Signature Credit Card', 'Welcome bonus of 5,000 SHARE Points equal to AED 500'),
('Emirates NBD SHARE Visa Platinum Credit Card', 'Free for Life'),
('Emirates NBD SHARE Visa Platinum Credit Card', 'Earn 4% back as SHARE Points'),
('Emirates NBD Darna Visa Infinite Credit Card', 'Welcome Bonus up to 15,000 Darna Points'),
('Emirates NBD Darna Visa Infinite Credit Card', 'Earn 10% back as Darna Points'),
('Emirates NBD Darna Visa Signature Credit Card', 'Welcome Bonus up to 3000 Darna Points'),
('Emirates NBD Darna Visa Signature Credit Card', 'Earn 7.5% back as Darna Points'),
('Emirates NBD Darna Visa Signature Credit Card', 'First year free for a limited time offer'),
('Emirates NBD Darna Select Visa Credit Card', 'Free for Life'),
('Emirates NBD Darna Select Visa Credit Card', 'Earn 6.25% back as Darna Points'),
('Emirates NBD U By Emaar Infinite Credit Card', 'Welcome offer: Up to 25,000 U Points.'),
('Emirates NBD U By Emaar Infinite Credit Card', '7.5% U points on all Emaar spends'),
('Emirates NBD U By Emaar Signature Credit Card', 'Welcome offer: Up to 2,500 U Points.'),
('Emirates NBD U By Emaar Signature Credit Card', '6.25% U points on all Emaar spends'),
('Emirates NBD U By Emaar Signature Credit Card', 'Travel Insurance'),
('Emirates NBD U By Emaar Family Credit Card', 'Free for life'),
('Emirates NBD U By Emaar Family Credit Card', '30% discount on Emaar Attraction'),
('Emirates NBD noon One Visa Credit card', 'Get a welcome bonus of AED 500'),
('Emirates NBD noon One Visa Credit card', 'Earn up to 20% back as noon credits'),
('Emirates NBD noon One Visa Credit card', 'Earn up to 1% on all other spends'),
('Emirates NBD noon One Visa Credit card', '1-year free noon One membership & 50% off thereafter'),
('Ajman Bank ULTRACASH Mastercard Touch Card', 'Bonus cashback for UAE Nationals AED 500 & Expatriates AED 300'),
('Ajman Bank ULTRACASH Mastercard Touch Card', 'Balance Transfer with 0% for 3 or 6 months.'),
('Ajman Bank ULTRACASH Mastercard Touch Card', 'Airport lounge access'),
('Ajman Bank ULTRACASH Mastercard Touch Card', 'Up to 10% on fuel spending'),
('Ajman Bank BRight World Credit Card', 'Welcome bonus of 15,000 BRight Rewards'),
('Ajman Bank BRight World Credit Card', 'O% foreign transaction fees'),
('Ajman Bank BRight World Credit Card', 'Airport lounge access'),
('Ajman Bank BRight World Credit Card', 'Enjoy valet parking services.'),
('Ajman Bank BRight World Credit Card', 'Earn up to 3 BRight rewards for every AED 10 spend'),
('Ajman Bank BRight Platinum Credit Card', 'Welcome bonus of 10,000 BRight Rewards'),
('Ajman Bank BRight Platinum Credit Card', 'O% foreign transaction fees'),
('Ajman Bank BRight Platinum Credit Card', 'Airport lounge access'),
('Ajman Bank BRight Platinum Credit Card', 'Enjoy valet parking services'),
('Ajman Bank BRight Platinum Credit Card', 'Earn up to 2 BRight rewards for every AED 10 spend'),
('Ajman Bank BRight Titanium Credit Card', 'Free for Life'),
('Ajman Bank BRight Titanium Credit Card', 'Airport lounge access'),
('Ajman Bank BRight Titanium Credit Card', 'Enjoy valet parking services'),
('Ajman Bank BRight Titanium Credit Card', 'Earn up to 1 BRight rewards for every AED 10 spend'),
('FAB Etihad Guest Infinite Credit Card', 'Welcome bonus of 55,000 Etihad Guest Miles'),
('FAB Etihad Guest Infinite Credit Card', 'Earn up to 7.5 Etihad Guest Miles/AED 10 spends'),
('FAB Etihad Guest Signature Credit Card', 'Welcome bonus of 35,000 Etihad Guest Miles'),
('FAB Etihad Guest Signature Credit Card', 'Earn up to 6.5 Etihad Guest Miles/AED 10 spends'),
('FAB Etihad Guest Platinum Credit Card', 'Welcome bonus of 10,000 Etihad Guest Miles'),
('FAB Etihad Guest Platinum Credit Card', 'Earn up to 4 Etihad Guest Miles/AED 10 spends'),
('FAB Travel Card world Elite', 'A free return flight every year'),
('FAB Travel Card world Elite', 'Movie ticket at AED 20'),
('FAB Travel Card world Elite', 'Free Airport Lounge'),
('FAB Cashback Credit Card', 'FREE HOLIDAY - Return flights to the Maldives or Greece'),
('FAB Cashback Credit Card', 'Maldives -2 nights / 3 days in a 5-star resort with breakfast'),
('FAB Cashback Credit Card', 'Greece - 2 nights/ 3 days in a 4-star hotel in Athens'),
('FAB Cashback Credit Card', '5% cashback on supermarket spending, dining and fuel.'),
('FAB du Titanium Credit Card', 'Exclusive 10% cashback'),
('FAB du Titanium Credit Card', 'Airport lounge access'),
('FAB GEMS World Credit Card', 'Get 10% cashback'),
('FAB GEMS World Credit Card', '20% off at Emaar entertainment'),
('BLUE FAB Infinite Credit Card by Al-Futtaim', 'No annual Fees'),
('BLUE FAB Infinite Credit Card by Al-Futtaim', 'Cinema ticket @ AED 20'),
('BLUE FAB Infinite Credit Card by Al-Futtaim', '9% cashback on Al-Futtaim retail brands'),
('BLUE FAB Signature Credit Card by Al-Futtaim', 'No Annual fees'),
('BLUE FAB Signature Credit Card by Al-Futtaim', '7% cashback on Al-Futtaim retail brands'),
('BLUE FAB Platinum Credit Card by Al-Futtaim', 'No Annual Fees'),
('BLUE FAB Platinum Credit Card by Al-Futtaim', '6% cashback on Al-Futtaim retail brands'),
('FAB Elite Credit Card', 'Movie tickets from only AED 20'),
('FAB Rewards Indulge Card', 'Free for Life'),
('FAB Rewards Indulge Card', 'Movie tickets at only AED 20'),
('CBD Visa Infinite Credit Card', 'No Annual Fees'),
('CBD Visa Infinite Credit Card', 'Golf privilege'),
('CBD Super Saver Credit Card', 'Up t Up to 10% cashback on bills, education, supermarkets and fuel'),
('CBD Super Saver Credit Card', 'Free for first Year'),
('CBD Super Saver Credit Card', 'Multi-trip travel insurance'),
('CBD Super Saver Credit Card', 'Airport lounge access with Lounge Key'),
('CBD One Credit Card', 'Free for life'),
('CBD One Credit Card', '50% off on cinema tickets'),
('CBD Yes Rewards Credit Card', 'Welcome bonus of 20,000 Yes Rewards'),
('CBD Yes Rewards Credit Card', 'First year free'),
('CBD Visa Smiles Signature Credit Card', 'Free for first year'),
('CBD Visa Smiles Signature Credit Card', '90-day complimentary subscription to Smiles Unlimited'),
('RAK Bank World Credit Card', 'Welcome bonus of AED 1500'),
('RAK Bank World Credit Card', 'Free for First year'),
('RAK Bank Titanium Credit Card', 'Free for life'),
('RAK Bank Titanium Credit Card', 'Cashback of up to 5% on supermarket'),
('RAK Bank Air Arabia Platinum Credit Card', 'Welcome bonus of 20,000 Air Rewards'),
('RAK Bank Air Arabia Platinum Credit Card', 'Complimentary annual return ticket'),
('RAK Bank RED Credit Card', 'Free for Life'),
('RAK Bank RED Credit Card', 'Access to airport Lounges'),
('RAK Bank Elevate credit card ', 'Free trial for Founder Members until 31st July 2025 - Privilege'),
('Emirates Islamic Emarati Credit Card', 'Welcome Bonus: Get AED 1,000 in the form of EI SmartMiles.'),
('Emirates Islamic Flex Elite Credit Card', '175,000 EI Smart Miles Welcome Bonus'),
('Emirates Islamic RTA Credit Card', 'Get 10% Cashback on Fuel Spends'),
('Emirates Islamic RTA Credit Card', 'Get 10% Cashback on RTA Transport Payment'),
('Emirates Islamic Cashback Credit Card', '5% cash back on telecom expenses.'),
('Emirates Islamic Cashback Credit Card', '5% cash back on electronic store purchases'),
('Emirates Islamic Cashback Plus Credit Card', 'No annual Fees'),
('Emirates Islamic Cashback Plus Credit Card', 'Up to 10% cash back on groceries'),
('Emirates Islamic Switch Cashback Credit Card', 'Welcome Bonus of AED 500 Cashback points'),
('Emirates Islamic Etihad Guest Premium Credit Card', 'Welcome Bonus: Earn up to 55,000 Etihad Guest Miles  Etihad Guest Gold Tier'),
('Emirates Islamic Etihad Guest Saqer Credit Card', 'Welcome bonus of 30,000 Etihad Guest Miles'),
('Emirates Islamic Etihad Guest Ameera Credit Card', 'Welcome bonus of 20,000 Etihad Guest Miles'),
('Emirates Islamic Etihad Guest Platinum Credit Card', 'Welcome bonus of 5,000 Etihad Guest Miles'),
('Emirates Islamic Skywards Black Credit Card', 'Up to 3.5 Skywards Miles per USD spent.'),
('Emirates Islamic Skywards Infinite Credit Card', 'No AMF for first year'),
('Emirates Islamic Skywards Infinite Credit Card', 'Up to 2 Etihad Guest Miles per USD spent.'),
('Emirates Islamic Skywards Infinite Credit Card', 'Complimentary Valet Parking & golf 7 days a week'),
('Emirates Islamic Skywards Infinite Credit Card', 'Automatic upgrade to Emirates Skywards silver membership'),
('Emirates Islamic Skywards Signature Credit Card', 'Up to 1.5 Skywards Miles/USD spent'),
('Emirates Islamic Skywards Signature Credit Card', 'Complimentary Golf'),
('HSBC Cash+ Credit Card', 'Get AED 500 cashback when you apply for this card by 30 June 2025 & spend AED 6K within the first 60 days.'),
('HSBC Cash+ Credit Card', 'Buy 1 Get 1 Free movie tickets every month at Vox, Reel and Roxy Cinemas'),
('HSBC Live+ Credit Card', 'Get AED 500 cashback when you apply for this card by 30 June 2025 and spend AED 6,000 within the first 60 days.'),
('HSBC Live+ Credit Card', '6% cashback on dining and food and 5% cashback on fuel - all upto AED 200'),
('HSBC Max Rewards Credit Card', 'Get AED 500 cashback when you apply for this card by 30 June 2025 and spend AED 6K within the first 60 days.'),
('HSBC Max Rewards Credit Card', 'Enjoy 8 Fitness First visits a month for AED 1'),
('HSBC Max Rewards Credit Card', 'Get a complimentary 12-month Careem Plus subscription.'),
('HSBC Max Rewards Credit Card', 'Buy 1 Get 1 Free movie tickets every month at Vox, Reel and Roxy Cinemas'),
('HSBC Emirates Skywards Infinite Credit Card', 'Get welcome bonus up to 50,000 Skywards Miles'),
('HSBC Emirates Skywards Infinite Credit Card', 'Complimentary Emirates Skywards Silver Tier membership'),
('HSBC Emirates Skywards Infinite Credit Card', 'No Miles Expiry'),
('HSBC Emirates Skywards Infinite Credit Card', '3 complimentary visits per month to premium beach clubs'),
('HSBC Emirates Skywards Infinite Credit Card', 'Earn up to 2.75 Skywards Miles for every USD spent'),
('HSBC Emirates Skywards Signature Credit Card', 'Get welcome bonus up to 20,000 Skywards Miles'),
('HSBC Emirates Skywards Signature Credit Card', 'Complimentary Emirates Skywards Silver Tier membership'),
('HSBC Emirates Skywards Signature Credit Card', 'No Miles Expiry'),
('HSBC Emirates Skywards Signature Credit Card', 'Earn up to 1.75 Skywards Miles for every USD spent'),
('HSBC Emirates Skywards Signature Credit Card', '12 complimentary visits for you and additional cardholders'),
('Liv Bank Cashback Credit Card', 'Free for life'),
('Liv Bank Cashback Credit Card', '2% cashback on ALL YOUR SPENDS - no categories, no fuss!'),
('Liv Bank Cashback Credit Card', 'Up to 750 cashback every month'),
('Liv Bank Cashback Credit Card', 'Up to 5000 Skywards miles every month'),
('Liv Bank Cashback Credit Card', 'Access to 25+ Airport Lounges'),
('Liv Bank Cashback Plus Credit Card', '4% cashback on ALL YOUR SPENDS - no categories, no fuss!'),
('Liv Bank Cashback Plus Credit Card', 'Access to 850+ airport lounges world wide'),
('Liv Bank Cashback Plus Credit Card', 'VOX Cinemas 3 Free Tickets (B1G1 x 3 times) + 25% off on F&B'),
('Liv Bank Cashback Plus Credit Card', 'Up to 1500 cashback every month'),
('NBQ Infinite Credit Card', 'Priority Pass Lounge access at over 1300 lounges in Various airports around the world'),
('NBQ Platinum Credit Card', 'Priority Pass Lounge access at over 1300 lounges in Various airports around the world'),
('NBQ Platinum Credit Card', 'Free Worldwide Travel Insurance'),
('NBQ Gold Credit Card', 'Free Worldwide Travel Insurance'),
('NBQ Gold Credit Card', 'Balance transfer Facility'),
('DIB SHAMS Infinite Covered Card', 'Access to Fitness First across the UAE'),
('DIB SHAMS Infinite Covered Card', 'Welcome Bonus up to 200,000 rewards'),
('DIB SHAMS Infinite Covered Card', 'Up to 20% cashback on selected merchant'),
('DIB SHAMS Infinite Covered Card', 'Enjoy 5% back on travel & Dining'),
('DIB SHAMS Signature Covered Card', 'Access to Fitness First across the UAE'),
('DIB SHAMS Signature Covered Card', 'Welcome Bonus up to 100,000 rewards'),
('DIB SHAMS Signature Covered Card', 'Up to 20% cashback on selected merchant'),
('DIB SHAMS Signature Covered Card', 'Enjoy 5% back on travel & Dining'),
('DIB SHAMS Platinum Covered Card', 'Welcome Bonus up to 50,000 rewards'),
('DIB SHAMS Platinum Covered Card', 'Up to 20% cashback on selected merchant'),
('DIB SHAMS Platinum Covered Card', 'Enjoy 5% back on Travel & Dining'),
('The Emirates Skywards DIB Infinite Covered Card', 'Earn up to 120,000 bonus Skywards Miles'),
('The Emirates Skywards DIB Infinite Covered Card', 'Complimentary Emirates Skywards Silver membership'),
('The Emirates Skywards DIB Infinite Covered Card', 'Earn Skywards Miles on all spends'),
('The Emirates Skywards DIB Signature Covered Card', 'Earn up to 50,000 bonus Skywards Miles'),
('The Emirates Skywards DIB Signature Covered Card', 'Premium lifestyle benefits'),
('The Emirates Skywards DIB Signature Covered Card', 'Earn Skywards Miles on all spends');

-- --------------------------------------------------------

--
-- Table structure for table `cardtypes`
--

CREATE TABLE `cardtypes` (
  `idcardtype` int(11) NOT NULL,
  `cardtypecode` varchar(10) NOT NULL,
  `cardtypedesc` varchar(45) NOT NULL,
  `cardtypeDetails` varchar(45) DEFAULT NULL,
  `useascategory` tinyint(1) DEFAULT NULL,
  `menuitem` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cardtypes`
--

INSERT INTO `cardtypes` (`idcardtype`, `cardtypecode`, `cardtypedesc`, `cardtypeDetails`, `useascategory`, `menuitem`) VALUES
(1, 'CB', 'Cash Back', '0', 0, 'cash-back'),
(2, 'WB', 'Welcome Bonus', '0', 0, 'welcome-bonus'),
(3, 'FFL', 'Free For Life', '0', 0, 'free-for-life'),
(4, 'TC', 'Travel Card ', '0', 0, 'travel-card'),
(5, 'PRC', 'Premium Card', '0', 0, 'premium-card'),
(6, 'ETM', 'Etihad Miles', '0', 0, 'etihad-miles'),
(7, 'EMSKY', 'Emirate SkyWord', '0', 0, 'emirate-skywords'),
(8, 'BLT', 'Balance Transfer', '0', 0, 'balance-transfer'),
(9, 'FD', 'Fixed Deposit', '0', 0, 'fixed-deposit'),
(10, 'ISC', 'Islamic Card', '0', 0, 'islamic-card'),
(11, 'BSC', 'Business Card', '0', 0, 'business-card'),
(12, 'BCC', 'Best Credit Card', '0', 0, NULL),
(13, 'BCCB', 'Best CashBack Card', '0', 1, NULL),
(14, 'BSKC', 'Best Skywords Card', '0', 1, NULL),
(15, 'BMOC', 'Best Movieoffer Card', '0', 1, NULL),
(16, 'BAMC', 'Best Air-Miles Card', '0', 0, NULL),
(17, 'BDOC', 'Best Dining Offer Card', '0', 1, NULL),
(18, 'BLSC', 'Best LifeStyle Card', '0', 0, NULL),
(19, 'BDINOF', 'Best Travel Card', '0', 1, NULL),
(20, 'EIC', 'Emarati Cards', '0', 0, 'business-card'),
(21, 'LS', 'Life Style', '0', 0, ''),
(22, 'FS', 'First Year Free', '0', 0, '');

-- --------------------------------------------------------

--
-- Table structure for table `creditcardnew`
--

CREATE TABLE `creditcardnew` (
  `Bank` varchar(24) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `CARD_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `Minimum_Salary` int(11) DEFAULT NULL,
  `Annual_Fee` varchar(28) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `creditcardnew`
--

INSERT INTO `creditcardnew` (`Bank`, `CARD_name`, `Minimum_Salary`, `Annual_Fee`) VALUES
('Deem Finance', 'Deem Mastercard Titanium Cash Up Credit Card', 5, 'Free for first year'),
('Deem Finance', 'Deem Mastercard Platinum Cash Up Credit Card', 10, 'Free for life'),
('Deem Finance', 'Deem Mastercard World Miles Up Credit Card', 25, 'Free for life'),
('Dubai First', 'Dubai First Cashback card', 5, 'AED 399'),
('Dubai First', 'Dubai First Slice pay card', 5, 'AED 99'),
('Mashreq Bank', 'Mashreq Cashback Credit Card', 5, 'Free for life'),
('Mashreq Bank', 'Mashreq Noon Credit Card', 5, 'Free for life'),
('Mashreq Bank', 'Mashreq Platinum Elite Credit Card', 7, 'AED 650 + VAT'),
('Mashreq Bank', 'Mashreq Solitaire Credit card', 25, 'AED 1500 '),
('Emirates NBD Bank', 'Emirates NBD Duo Credit Card', 12, 'Free For Life'),
('Emirates NBD Bank', 'Emirates NBD Lulu 247 Platinum Credit Card', 15, 'AED 250'),
('Emirates NBD Bank', 'Emirates NBD Lulu 247 Titanium Credit Card', 5, 'Free For Life'),
('Emirates NBD Bank', 'Emirates NBD Skywards Signature Credit Card', 12, 'AED 700'),
('Emirates NBD Bank', 'Emirates NBD Skywards Infinite Credit Card', 30, 'AED 1500'),
('Emirates NBD Bank', 'Emirates NBD VISA Infinite Credit Card', 30, 'AED 1500'),
('Emirates NBD Bank', 'Emirates NBD Dnata World Credit Card', 20, 'AED 1049'),
('Emirates NBD Bank', 'Emirates NBD Dnata Platinum Credit Card', 5, 'AED 525'),
('Emirates NBD Bank', 'Emirates NBD Etihad Guest Visa Elevate', 30, 'AED 1575'),
('Emirates NBD Bank', 'Emirates NBD Etihad Guest Visa Inspire', 12, 'AED 735'),
('Emirates NBD Bank', 'Emirates NBD Mastercard Platinum Credit Card', 12, ' No annual fee '),
('Emirates NBD Bank', 'Emirates NBD Visa Platinum Credit Card', 12, '\nNo Annual Fees'),
('Emirates NBD Bank', 'Emirates NBD Mastercard Titanium Credit Card', 5, 'No Annual Fees'),
('Emirates NBD Bank', 'Emirates NBD SHARE Visa Infinite Credit Card', 30, 'Free for first year'),
('Emirates NBD Bank', 'Emirates NBD SHARE Visa Signature Credit Card', 12, 'Free for life'),
('Emirates NBD Bank', 'Emirates NBD SHARE Visa Platinum Credit Card', 5, 'Free for Life'),
('Emirates NBD Bank', 'Emirates NBD Darna Visa Infinite Credit Card', 30, 'AED 1500'),
('Emirates NBD Bank', 'Emirates NBD Darna Visa Signature Credit Card', 12, 'First year Free'),
('Emirates NBD Bank', 'Emirates NBD Darna Select Visa Credit Card', 5, 'Free for Life'),
('Emirates NBD Bank', 'Emirates NBD U By Emaar Infinite Credit Card', 30, 'AED 1500'),
('Emirates NBD Bank', 'Emirates NBD U By Emaar Signature Credit Card', 12, 'AED 250'),
('Emirates NBD Bank', 'Emirates NBD U By Emaar Family Credit Card', 5, 'Free for Life'),
('Emirates NBD Bank', 'Emirates NBD noon One Visa Credit card\n', 5, 'Free for Life'),
('Ajman Bank', 'Ajman Bank ULTRACASH Mastercard Touch Card', 10, 'AED 500'),
('Ajman Bank', 'Ajman Bank BRight World Credit Card', 10, 'AED 1500'),
('Ajman Bank', 'Ajman Bank BRight Platinum Credit Card', 10, 'AED 1000'),
('Ajman Bank', 'Ajman Bank BRight Titanium Credit Card', 5, 'Free for Life'),
('First Abu Dhabi Bank', 'FAB Etihad Guest Infinite Credit Card', 30, 'AED 2500'),
('First Abu Dhabi Bank', 'FAB Etihad Guest Signature Credit Card', 15, 'AED 1500'),
('First Abu Dhabi Bank', 'FAB Etihad Guest Platinum Credit Card', 8, 'AED 500'),
('First Abu Dhabi Bank', 'FAB Travel Card world Elite', 25, 'AED 1500'),
('First Abu Dhabi Bank', 'FAB Cashback Credit Card', 5, 'AED 300'),
('First Abu Dhabi Bank', 'FAB du Titanium Credit Card', 5, 'No Annual fee'),
('First Abu Dhabi Bank', 'FAB GEMS World Credit Card', 8, 'AED 399'),
('First Abu Dhabi Bank', 'BLUE FAB Infinite Credit Card by Al-Futtaim', 40, 'No Annual Fees'),
('First Abu Dhabi Bank', 'BLUE FAB Signature Credit Card by Al-Futtaim', 15, 'Free For Life'),
('First Abu Dhabi Bank', 'BLUE FAB Platinum Credit Card by Al-Futtaim', 8, 'Free For Life'),
('First Abu Dhabi Bank', 'FAB Elite Credit Card', 50, 'AED 1'),
('First Abu Dhabi Bank', 'FAB Rewards Indulge Card', 5, 'No Annual Fee'),
('Commercial Bank of Dubai', 'CBD Visa Infinite Credit Card', 15, 'Free for first year'),
('Commercial Bank of Dubai', 'CBD Super Saver Credit Card', 8, 'Free for first year'),
('Commercial Bank of Dubai', 'CBD One Credit Card', 5, 'Free for Life'),
('Commercial Bank of Dubai', 'CBD Yes Rewards Credit Card', 5, 'Free For First year'),
('Commercial Bank of Dubai', 'CBD Visa Smiles Signature Credit Card', 5, 'F Y F then AED 199'),
('RAK BANK ', 'RAK Bank World Credit Card', 20, 'FYF then 950'),
('RAK BANK ', 'RAK Bank Titanium Credit Card', 8, 'Free for Life'),
('RAK BANK ', 'RAK Bank Air Arabia Platinum Credit Card', 5, 'AED 420*'),
('RAK Bank', 'RAK Bank RED Credit Card', 5, 'Free for Life'),
('RAK Bank', 'RAK Bank Elevate credit card ', 35, 'Spend base'),
('Emirates Islamic Bank', 'Emirates Islamic Emarati Credit Card', 12, 'No Annual fee'),
('Emirates Islamic Bank', 'Emirates Islamic Flex Elite Credit Card', 15, '735'),
('Emirates Islamic Bank', 'Emirates Islamic RTA Credit Card', 5, 'No Annual Fee'),
('Emirates Islamic Bank', 'Emirates Islamic Cashback Credit Card', 5, 'No AMF for first year*'),
('Emirates Islamic Bank', 'Emirates Islamic Cashback Plus Credit Card', 12, 'No AMF for first year*'),
('Emirates Islamic Bank', 'Emirates Islamic Switch Cashback Credit Card', 5, 'Free for First Year'),
('Emirates Islamic Bank', 'Emirates Islamic Etihad Guest Premium Credit Card', 20, 'No AMF for first year*'),
('Emirates Islamic Bank', 'Emirates Islamic Etihad Guest Saqer Credit Card', 12, 'No AMF for first year*'),
('Emirates Islamic Bank', 'Emirates Islamic Etihad Guest Ameera Credit Card', 5, 'No AMF for first year*'),
('Emirates Islamic Bank', 'Emirates Islamic Etihad Guest Platinum Credit Card', 5, 'No AMF for first year* '),
('Emirates Islamic Bank', 'Emirates Islamic Skywards Black Credit Card', 35, 'AED 2k or AED 3.5K'),
('Emirates Islamic Bank', 'Emirates Islamic Skywards Infinite Credit Card', 20, 'AED 2K'),
('Emirates Islamic Bank', 'Emirates Islamic Skywards Signature Credit Card', 12, 'AED 700'),
('HSBC', 'HSBC Cash+ Credit Card', 30, 'Free for 1st  Year-then 1000'),
('HSBC', 'HSBC Live+ Credit Card', 5, 'Free for 1st  Year*'),
('HSBC', 'HSBC Max Rewards Credit Card', 10, 'Free for 1st  Year'),
('HSBC', 'HSBC Emirates Skywards Infinite Credit Card', 30, 'AED 2'),
('HSBC', 'HSBC Emirates Skywards Signature Credit Card', 10, 'AED 1'),
('Liv Bank', 'Liv Bank Cashback Credit Card', 5, 'Free for life'),
('Liv Bank', 'Liv Bank Cashback Plus Credit Card', 10, 'AED 700'),
('NBQ', 'NBQ Infinite Credit Card', 30, 'AED 1000'),
('NBQ', 'NBQ Platinum Credit Card', 15, 'AED 500'),
('NBQ', 'NBQ Gold Credit Card', 8, 'Free for life'),
('Dubai Islamic Bank', 'DIB SHAMS Infinite Covered Card', 50, 'Free for 1st year'),
('Dubai Islamic Bank', 'DIB SHAMS Signature Covered Card', 5, 'Free for 1st year'),
('Dubai Islamic Bank', 'DIB SHAMS Platinum Covered Card', 5, 'Free for 1st year'),
('Dubai Islamic Bank', 'The Emirates Skywards DIB Infinite Covered Card', 20, 'AED 2500'),
('Dubai Islamic Bank', 'The Emirates Skywards DIB Signature Covered Card', 15, 'AED 1500');

-- --------------------------------------------------------

--
-- Table structure for table `creditcards`
--

CREATE TABLE `creditcards` (
  `idcreditcards` int(11) NOT NULL,
  `creditcardscode` varchar(45) NOT NULL,
  `creditcardsname` varchar(100) NOT NULL,
  `creditcardsDetails` varchar(1000) DEFAULT NULL,
  `idcardtypes` int(11) NOT NULL,
  `idbanks` int(11) NOT NULL,
  `creditcardsimageid` varchar(45) DEFAULT NULL,
  `creditcardsimagelocation` varchar(45) DEFAULT NULL,
  `creditcardsimagename` varchar(150) DEFAULT NULL,
  `MinimumSalary` decimal(10,0) DEFAULT NULL,
  `AnnualFee` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `creditcards`
--

INSERT INTO `creditcards` (`idcreditcards`, `creditcardscode`, `creditcardsname`, `creditcardsDetails`, `idcardtypes`, `idbanks`, `creditcardsimageid`, `creditcardsimagelocation`, `creditcardsimagename`, `MinimumSalary`, `AnnualFee`) VALUES
(255, 'AA', 'Ajman Bank ULTRACASH Mastercard Touch Card', 'Ajman Bank ULTRACASH Mastercard Touch Card', 1, 4, NULL, NULL, 'Ajman_Bank_ULTRACASH_Mastercard_Touch_Card.webp', 10000, 'AED 500'),
(256, 'AA', 'Ajman Bank BRight World Credit Card', 'Ajman Bank BRight World Credit Card', 1, 4, NULL, NULL, 'Ajman_Bank_BRight_World_Credit_Card.webp', 10000, 'AED 1500'),
(257, 'AA', 'Ajman Bank BRight Platinum Credit Card', 'Ajman Bank BRight Platinum Credit Card', 1, 4, NULL, NULL, 'Ajman_Bank_BRight_Platinum_Credit_Card.webp', 10000, 'AED 1000'),
(258, 'AA', 'Ajman Bank BRight Titanium Credit Card', 'Ajman Bank BRight Titanium Credit Card', 1, 4, NULL, NULL, 'Ajman_Bank_BRight_Titanium_Credit_Card.webp', 5000, 'Free for Life'),
(259, 'AA', 'CBD Visa Infinite Credit Card', 'CBD Visa Infinite Credit Card', 1, 8, NULL, NULL, 'CBD_Visa_Infinite_Credit_Card.webp', 15000, 'Free for first year'),
(260, 'AA', 'CBD Super Saver Credit Card', 'CBD Super Saver Credit Card', 1, 8, NULL, NULL, 'CBD_Super_Saver_Credit_Card.webp', 8000, 'Free for first year'),
(261, 'AA', 'CBD One Credit Card', 'CBD One Credit Card', 1, 8, NULL, NULL, 'CBD_One_Credit_Card.webp', 5000, 'Free for Life'),
(262, 'AA', 'CBD Yes Rewards Credit Card', 'CBD Yes Rewards Credit Card', 1, 8, NULL, NULL, 'CBD_Yes_Rewards_Credit_Card.webp', 5000, 'Free For First year'),
(263, 'AA', 'CBD Visa Smiles Signature Credit Card', 'CBD Visa Smiles Signature Credit Card', 1, 8, NULL, NULL, 'CBD_Visa_Smiles_Signature_Credit_Card.webp', 5000, 'F Y F then AED 199'),
(264, 'AA', 'DIB SHAMS Infinite Covered Card', 'DIB SHAMS Infinite Covered Card', 1, 9, NULL, NULL, 'DIB_SHAMS_Infinite_Covered_Card.webp', 50000, 'Free for 1st year'),
(265, 'AA', 'DIB SHAMS Signature Covered Card', 'DIB SHAMS Signature Covered Card', 1, 9, NULL, NULL, 'DIB_SHAMS_Signature_Covered_Card.webp', 5000, 'Free for 1st year'),
(266, 'AA', 'DIB SHAMS Platinum Covered Card', 'DIB SHAMS Platinum Covered Card', 1, 9, NULL, NULL, 'DIB_SHAMS_Platinum_Covered_Card.webp', 5000, 'Free for 1st year'),
(267, 'AA', 'The Emirates Skywards DIB Infinite Covered Card', 'The Emirates Skywards DIB Infinite Covered Card', 1, 9, NULL, NULL, 'The_Emirates_Skywards_DIB_Infinite_Covered_Card.webp', 20000, 'AED 2500'),
(268, 'AA', 'The Emirates Skywards DIB Signature Covered Card', 'The Emirates Skywards DIB Signature Covered Card', 1, 9, NULL, NULL, 'The_Emirates_Skywards_DIB_Signature_Covered_Card.webp', 15000, 'AED 1500'),
(269, 'AA', 'Emirates Islamic Emarati Credit Card', 'Emirates Islamic Emarati Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_Emarati_Credit_Card.webp', 12000, 'No Annual fee'),
(270, 'AA', 'Emirates Islamic Flex Elite Credit Card', 'Emirates Islamic Flex Elite Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_Flex_Elite_Credit_Card.webp', 15000, '735'),
(271, 'AA', 'Emirates Islamic RTA Credit Card', 'Emirates Islamic RTA Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_RTA_Credit_Card.webp', 5000, 'No Annual Fee'),
(272, 'AA', 'Emirates Islamic Cashback Credit Card', 'Emirates Islamic Cashback Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_Cashback_Credit_Card.webp', 5000, 'No AMF for first year*'),
(273, 'AA', 'Emirates Islamic Cashback Plus Credit Card', 'Emirates Islamic Cashback Plus Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_Cashback_Plus_Credit_Card.webp', 12000, 'No AMF for first year*'),
(274, 'AA', 'Emirates Islamic Switch Cashback Credit Card', 'Emirates Islamic Switch Cashback Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_Switch_Cashback_Credit_Card.webp', 5000, 'Free for First Year'),
(275, 'AA', 'Emirates Islamic Etihad Guest Premium Credit Card', 'Emirates Islamic Etihad Guest Premium Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_Etihad_Guest_Premium_Credit_Card.webp', 20000, 'No AMF for first year*'),
(276, 'AA', 'Emirates Islamic Etihad Guest Saqer Credit Card', 'Emirates Islamic Etihad Guest Saqer Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_Etihad_Guest_Saqer_Credit_Card.webp', 12000, 'No AMF for first year*'),
(277, 'AA', 'Emirates Islamic Etihad Guest Ameera Credit Card', 'Emirates Islamic Etihad Guest Ameera Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_Etihad_Guest_Ameera_Credit_Card.webp', 5000, 'No AMF for first year*'),
(278, 'AA', 'Emirates Islamic Etihad Guest Platinum Credit Card', 'Emirates Islamic Etihad Guest Platinum Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_Etihad_Guest_Platinum_Credit_Card.webp', 5000, 'No AMF for first year* '),
(279, 'AA', 'Emirates Islamic Skywards Black Credit Card', 'Emirates Islamic Skywards Black Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_Skywards_Black_Credit_Card.webp', 35000, 'AED 2k or AED 3.5K'),
(280, 'AA', 'Emirates Islamic Skywards Infinite Credit Card', 'Emirates Islamic Skywards Infinite Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_Skywards_Infinite_Credit_Card.webp', 20000, 'AED 2K'),
(281, 'AA', 'Emirates Islamic Skywards Signature Credit Card', 'Emirates Islamic Skywards Signature Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_Skywards_Signature_Credit_Card.webp', 12000, 'AED 700'),
(282, 'AA', 'Emirates NBD Duo Credit Card', 'Emirates NBD Duo Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Duo_Credit_Card.webp', 12000, 'Free For Life'),
(283, 'AA', 'Emirates NBD Lulu 247 Platinum Credit Card', 'Emirates NBD Lulu 247 Platinum Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Lulu_247_Platinum_Credit_Card.webp', 15000, 'AED 250'),
(284, 'AA', 'Emirates NBD Lulu 247 Titanium Credit Card', 'Emirates NBD Lulu 247 Titanium Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Lulu_247_Titanium_Credit_Card.webp', 5000, 'Free For Life'),
(285, 'AA', 'Emirates NBD Skywards Signature Credit Card', 'Emirates NBD Skywards Signature Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Skywards_Signature_Credit_Card.webp', 12000, 'AED 700'),
(286, 'AA', 'Emirates NBD Skywards Infinite Credit Card', 'Emirates NBD Skywards Infinite Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Skywards_Infinite_Credit_Card.webp', 30000, 'AED 1500'),
(287, 'AA', 'Emirates NBD VISA Infinite Credit Card', 'Emirates NBD VISA Infinite Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_VISA_Infinite_Credit_Card.webp', 30000, 'AED 1500'),
(288, 'AA', 'Emirates NBD Dnata World Credit Card', 'Emirates NBD Dnata World Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Dnata_World_Credit_Card.webp', 20000, 'AED 1049'),
(289, 'AA', 'Emirates NBD Dnata Platinum Credit Card', 'Emirates NBD Dnata Platinum Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Dnata_Platinum_Credit_Card.webp', 5000, 'AED 525'),
(290, 'AA', 'Emirates NBD Etihad Guest Visa Elevate', 'Emirates NBD Etihad Guest Visa Elevate', 1, 12, NULL, NULL, 'Emirates_NBD_Etihad_Guest_Visa_Elevate.webp', 30000, 'AED 1575'),
(291, 'AA', 'Emirates NBD Etihad Guest Visa Inspire', 'Emirates NBD Etihad Guest Visa Inspire', 1, 12, NULL, NULL, 'Emirates_NBD_Etihad_Guest_Visa_Inspire.webp', 12000, 'AED 735'),
(292, 'AA', 'Emirates NBD Mastercard Platinum Credit Card', 'Emirates NBD Mastercard Platinum Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Mastercard_Platinum_Credit_Card.webp', 12000, ' No annual fee '),
(293, 'AA', 'Emirates NBD Visa Platinum Credit Card', 'Emirates NBD Visa Platinum Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Visa_Platinum_Credit_Card.webp', 12000, '\nNo Annual Fees'),
(294, 'AA', 'Emirates NBD Mastercard Titanium Credit Card', 'Emirates NBD Mastercard Titanium Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Mastercard_Titanium_Credit_Card.webp', 5000, 'No Annual Fees'),
(295, 'AA', 'Emirates NBD SHARE Visa Infinite Credit Card', 'Emirates NBD SHARE Visa Infinite Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_SHARE_Visa_Infinite_Credit_Card.webp', 30000, 'Free for first year'),
(296, 'AA', 'Emirates NBD SHARE Visa Signature Credit Card', 'Emirates NBD SHARE Visa Signature Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_SHARE_Visa_Signature_Credit_Card.webp', 12000, 'Free for life'),
(297, 'AA', 'Emirates NBD SHARE Visa Platinum Credit Card', 'Emirates NBD SHARE Visa Platinum Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_SHARE_Visa_Platinum_Credit_Card.webp', 5000, 'Free for Life'),
(298, 'AA', 'Emirates NBD Darna Visa Infinite Credit Card', 'Emirates NBD Darna Visa Infinite Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Darna_Visa_Infinite_Credit_Card.webp', 30000, 'AED 1500'),
(299, 'AA', 'Emirates NBD Darna Visa Signature Credit Card', 'Emirates NBD Darna Visa Signature Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Darna_Visa_Signature_Credit_Card.webp', 12000, 'First year Free'),
(300, 'AA', 'Emirates NBD Darna Select Visa Credit Card', 'Emirates NBD Darna Select Visa Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Darna_Select_Visa_Credit_Card.webp', 5000, 'Free for Life'),
(301, 'AA', 'Emirates NBD U By Emaar Infinite Credit Card', 'Emirates NBD U By Emaar Infinite Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_U_By_Emaar_Infinite_Credit_Card.webp', 30000, 'AED 1500'),
(302, 'AA', 'Emirates NBD U By Emaar Signature Credit Card', 'Emirates NBD U By Emaar Signature Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_U_By_Emaar_Signature_Credit_Card.webp', 12000, 'AED 250'),
(303, 'AA', 'Emirates NBD U By Emaar Family Credit Card', 'Emirates NBD U By Emaar Family Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_U_By_Emaar_Family_Credit_Card.webp', 5000, 'Free for Life'),
(304, 'AA', 'Emirates NBD noon One Visa Credit card', 'Emirates NBD noon One Visa Credit card\n', 1, 12, NULL, NULL, 'Emirates_NBD_noon_One_Visa_Credit_card.webp', 5000, 'Free for Life'),
(305, 'AA', 'FAB Etihad Guest Infinite Credit Card', 'FAB Etihad Guest Infinite Credit Card', 1, 13, NULL, NULL, 'FAB_Etihad_Guest_Infinite_Credit_Card.webp', 30000, 'AED 2500'),
(306, 'AA', 'FAB Etihad Guest Signature Credit Card', 'FAB Etihad Guest Signature Credit Card', 1, 13, NULL, NULL, 'FAB_Etihad_Guest_Signature_Credit_Card.webp', 15000, 'AED 1500'),
(307, 'AA', 'FAB Etihad Guest Platinum Credit Card', 'FAB Etihad Guest Platinum Credit Card', 1, 13, NULL, NULL, 'FAB_Etihad_Guest_Platinum_Credit_Card.webp', 8000, 'AED 500'),
(308, 'AA', 'FAB Travel Card world Elite', 'FAB Travel Card world Elite', 1, 13, NULL, NULL, 'FAB_Travel_Card_world_Elite.webp', 25000, 'AED 1500'),
(309, 'AA', 'FAB Cashback Credit Card', 'FAB Cashback Credit Card', 1, 13, NULL, NULL, 'FAB_Cashback_Credit_Card.webp', 5000, 'AED 300'),
(310, 'AA', 'FAB du Titanium Credit Card', 'FAB du Titanium Credit Card', 1, 13, NULL, NULL, 'FAB_du_Titanium_Credit_Card.webp', 5000, 'No Annual fee'),
(311, 'AA', 'FAB GEMS World Credit Card', 'FAB GEMS World Credit Card', 1, 13, NULL, NULL, 'FAB_GEMS_World_Credit_Card.webp', 8000, 'AED 399'),
(312, 'AA', 'BLUE FAB Infinite Credit Card by Al-Futtaim', 'BLUE FAB Infinite Credit Card by Al-Futtaim', 1, 13, NULL, NULL, 'BLUE_FAB_Infinite_Credit_Card_by_Al-Futtaim.webp', 40000, 'No Annual Fees'),
(313, 'AA', 'BLUE FAB Signature Credit Card by Al-Futtaim', 'BLUE FAB Signature Credit Card by Al-Futtaim', 1, 13, NULL, NULL, 'BLUE_FAB_Signature_Credit_Card_by_Al-Futtaim.webp', 15000, 'Free For Life'),
(314, 'AA', 'BLUE FAB Platinum Credit Card by Al-Futtaim', 'BLUE FAB Platinum Credit Card by Al-Futtaim', 1, 13, NULL, NULL, 'BLUE_FAB_Platinum_Credit_Card_by_Al-Futtaim.webp', 8000, 'Free For Life'),
(315, 'AA', 'FAB Elite Credit Card', 'FAB Elite Credit Card', 1, 13, NULL, NULL, 'FAB_Elite_Credit_Card.webp', 50000, 'AED 1'),
(316, 'AA', 'FAB Rewards Indulge Card', 'FAB Rewards Indulge Card', 1, 13, NULL, NULL, 'FAB_Rewards_Indulge_Card.webp', 5000, 'No Annual Fee'),
(317, 'AA', 'Mashreq Cashback Credit Card', 'Mashreq Cashback Credit Card', 1, 15, NULL, NULL, 'Mashreq_Cashback_Credit_Card.webp', 5000, 'Free for life'),
(318, 'AA', 'Mashreq Noon Credit Card', 'Mashreq Noon Credit Card', 1, 15, NULL, NULL, 'Mashreq_Noon_Credit_Card.webp', 5000, 'Free for life'),
(319, 'AA', 'Mashreq Platinum Elite Credit Card', 'Mashreq Platinum Elite Credit Card', 1, 15, NULL, NULL, 'Mashreq_Platinum_Elite_Credit_Card.webp', 7000, 'AED 650 + VAT'),
(320, 'AA', 'Mashreq Solitaire Credit card', 'Mashreq Solitaire Credit card', 1, 15, NULL, NULL, 'Mashreq_Solitaire_Credit_card.webp', 25000, 'AED 1500 '),
(321, 'AA', 'RAK Bank World Credit Card', 'RAK Bank World Credit Card', 1, 17, NULL, NULL, 'RAK_Bank_World_Credit_Card.webp', 20000, 'FYF then 950'),
(322, 'AA', 'RAK Bank Titanium Credit Card', 'RAK Bank Titanium Credit Card', 1, 17, NULL, NULL, 'RAK_Bank_Titanium_Credit_Card.webp', 8000, 'Free for Life'),
(323, 'AA', 'RAK Bank Air Arabia Platinum Credit Card', 'RAK Bank Air Arabia Platinum Credit Card', 1, 17, NULL, NULL, 'RAK_Bank_Air_Arabia_Platinum_Credit_Card.webp', 5000, 'AED 420*'),
(324, 'AA', 'RAK Bank RED Credit Card', 'RAK Bank RED Credit Card', 1, 17, NULL, NULL, 'RAK_Bank_RED_Credit_Card.webp', 5000, 'Free for Life'),
(325, 'AA', 'RAK Bank Elevate credit card ', 'RAK Bank Elevate credit card ', 1, 17, NULL, NULL, 'RAK_Bank_Elevate_credit_card.webp', 35000, 'Spend base'),
(326, 'AA', 'NBQ Infinite Credit Card', 'NBQ Infinite Credit Card', 1, 18, NULL, NULL, 'NBQ_Infinite_Credit_Card.webp', 30000, 'AED 1000'),
(327, 'AA', 'NBQ Platinum Credit Card', 'NBQ Platinum Credit Card', 1, 18, NULL, NULL, 'NBQ_Platinum_Credit_Card.webp', 15000, 'AED 500'),
(328, 'AA', 'NBQ Gold Credit Card', 'NBQ Gold Credit Card', 1, 18, NULL, NULL, 'NBQ_Gold_Credit_Card.webp', 8000, 'Free for life'),
(329, 'AA', 'Deem Mastercard Titanium Cash Up Credit Card', 'Deem Mastercard Titanium Cash Up Credit Card', 1, 21, NULL, NULL, 'Deem_Mastercard_Titanium_Cash_Up_Credit_Card.webp', 5000, 'Free for first year'),
(330, 'AA', 'Deem Mastercard Platinum Cash Up Credit Card', 'Deem Mastercard Platinum Cash Up Credit Card', 1, 21, NULL, NULL, 'Deem_Mastercard_Platinum_Cash_Up_Credit_Card.webp', 10000, 'Free for life'),
(331, 'AA', 'Deem Mastercard World Miles Up Credit Card', 'Deem Mastercard World Miles Up Credit Card', 1, 21, NULL, NULL, 'Deem_Mastercard_World_Miles_Up_Credit_Card.webp', 25000, 'Free for life'),
(332, 'AA', 'Dubai First Cashback card', 'Dubai First Cashback card', 1, 22, NULL, NULL, 'Dubai_First_Cashback_card.webp', 5000, 'AED 399'),
(333, 'AA', 'Dubai First Slice pay card', 'Dubai First Slice pay card', 1, 22, NULL, NULL, 'Dubai_First_Slice_pay_card.webp', 5000, 'AED 99'),
(334, 'AA', 'HSBC Cash+ Credit Card', 'HSBC Cash+ Credit Card', 1, 23, NULL, NULL, 'HSBC_Cash+_Credit_Card.webp', 30000, 'Free for 1st  Year-then 1000'),
(335, 'AA', 'HSBC Live+ Credit Card', 'HSBC Live+ Credit Card', 1, 23, NULL, NULL, 'HSBC_Live+_Credit_Card.webp', 5000, 'Free for 1st  Year*'),
(336, 'AA', 'HSBC Max Rewards Credit Card', 'HSBC Max Rewards Credit Card', 1, 23, NULL, NULL, 'HSBC_Max_Rewards_Credit_Card.webp', 10000, 'Free for 1st  Year'),
(337, 'AA', 'HSBC Emirates Skywards Infinite Credit Card', 'HSBC Emirates Skywards Infinite Credit Card', 1, 23, NULL, NULL, 'HSBC_Emirates_Skywards_Infinite_Credit_Card.webp', 30000, 'AED 2'),
(338, 'AA', 'HSBC Emirates Skywards Signature Credit Card', 'HSBC Emirates Skywards Signature Credit Card', 1, 23, NULL, NULL, 'HSBC_Emirates_Skywards_Signature_Credit_Card.webp', 10000, 'AED 1'),
(339, 'AA', 'Liv Bank Cashback Credit Card', 'Liv Bank Cashback Credit Card', 1, 24, NULL, NULL, 'Liv_Bank_Cashback_Credit_Card.webp', 5000, 'Free for life'),
(340, 'AA', 'Liv Bank Cashback Plus Credit Card', 'Liv Bank Cashback Plus Credit Card', 1, 24, NULL, NULL, 'Liv_Bank_Cashback_Plus_Credit_Card.webp', 10000, 'AED 700');

-- --------------------------------------------------------

--
-- Table structure for table `creditcardsbenefits`
--

CREATE TABLE `creditcardsbenefits` (
  `idcreditcardsbenefits` int(11) NOT NULL,
  `creditcardsbenefitsDetails` varchar(45) DEFAULT NULL,
  `idcreditcards` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `creditcardsfeatures`
--

CREATE TABLE `creditcardsfeatures` (
  `idcreditcardsfeatures` int(11) NOT NULL,
  `idcreditcards` int(11) NOT NULL,
  `idcardfeatures` int(11) NOT NULL,
  `creditcardsfeaturesvalues` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `creditcardsfetures`
--

CREATE TABLE `creditcardsfetures` (
  `idcreditcardsbenefits` int(11) NOT NULL,
  `creditcardsfeturesDetails` varchar(500) DEFAULT NULL,
  `idcreditcards` int(11) DEFAULT NULL,
  `creditcardshortfeature` varchar(500) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `creditcardsfetures`
--

INSERT INTO `creditcardsfetures` (`idcreditcardsbenefits`, `creditcardsfeturesDetails`, `idcreditcards`, `creditcardshortfeature`) VALUES
(1, '5% on school fees, supermarkets, and online shopping', 255, 'Shopping Discount'),
(2, 'Bonus Cashback', 255, 'Cashback'),
(3, 'Airport lounge access', 255, 'Lounge Access'),
(4, 'Up to 10% on fuel spending', 255, 'Fuel Discount'),
(5, 'FLY for FREE with Upfront 15,000 Complimentary BRight Rewards', 256, 'Rewards'),
(6, '0% Foreign Transaction Fees', 256, 'No Foreign Transaction Fees'),
(7, 'Complimentary Lounge Access', 256, 'Lounge Access'),
(8, 'Earn up to 2.5 BRight Rewards for every AED 10 spend', 256, 'Rewards'),
(9, 'Valet Parking 4 times a month at over 35 locations', 256, 'Valet Parking'),
(10, 'FLY for FREE with Upfront 10,000 Complimentary BRight Rewards', 257, 'Rewards'),
(11, '0% Foreign Transaction Fees', 257, 'No Foreign Transaction Fees'),
(12, 'Complimentary Lounge Access', 257, 'Lounge Access'),
(13, 'Earn up to 2 BRight Rewards for every AED 10 spend', 257, 'Rewards'),
(14, 'Valet Parking 3 times a month at over 35 locations', 257, 'Valet Parking'),
(15, 'Complimentary Lounge Access', 258, 'Lounge Access'),
(16, 'Earn up to 1 BRight Rewards for every AED 10 spend', 258, 'Rewards'),
(17, 'Valet Parking  at over 35 locations', 258, 'Valet Parking'),
(18, '0% off on Cleartrip', 258, 'Cleartrip Discount'),
(19, '4 tickets across VOX, Reel or Novo at 50% off', 260, '4 Movies tickets '),
(20, 'Complimentary golf access', 260, 'Golf Access'),
(21, 'Valet Parking', 260, 'Valet Parking'),
(22, 'Movies discount', 260, 'Movie Discount'),
(23, 'Free for life', 261, 'Free for Life'),
(24, 'Earn up to AED 135 cashback every month', 261, 'Cashback'),
(25, '50% off on cinema tickets', 261, '50% off on cinema tickets'),
(26, 'Complimentary valet parking', 261, 'Valet Parking'),
(27, 'First year free', 262, 'first year free'),
(28, 'Welcome bonus of 20,000 Yes Rewards worth AED 200', 262, 'Welcome Bonus'),
(29, 'Save up to 15% on fuel & more', 262, 'Fuel Discount'),
(30, 'Complimentary valet parking, cinema discounts and more', 262, 'Valet Parking'),
(31, 'A chance to win 1,000,000 Smiles Points', 263, 'Smiles Points'),
(32, 'Complimentary global Airport Visa Companion', 263, 'Airport Visa'),
(33, '10 Smiles points on all Etisalat channels, Smiles app and elGrocer spends', 263, 'Smiles Points'),
(34, '90-day complimentary subscription to Smiles Unlimited', 263, 'Subscription Offer'),
(35, 'Travel Insurance', 264, 'Travel Insurance'),
(36, 'Airport lounge access', 264, 'Lounge Access'),
(37, 'Buy 1 Get 1’ offer on Costa Coffee', 264, 'costa coffee Offer'),
(38, '4 Airport transfers', 264, 'Airport Transfer'),
(39, 'Travel Insurance', 265, 'Travel Insurance'),
(40, 'Airport lounge access', 265, 'Lounge Access'),
(41, 'Free Roadside assistance', 265, 'Roadside Assistance'),
(42, '2 Airport transfers', 265, 'Airport Transfer'),
(43, 'Travel Insurance', 266, 'Travel Insurance'),
(44, 'Free Roadside assistance', 266, 'Roadside Assistance'),
(45, 'Enjoy 5% back on Travel & Dining', 266, 'Dining Offer'),
(46, 'Roadside assistance', 267, 'Roadside Assistance'),
(47, 'Dining Offer', 267, 'Dining Offer'),
(48, 'Travel Insurance', 267, 'Travel Insurance'),
(49, 'Airport Lounge access', 267, 'Lounge Access'),
(50, 'Roadside assistance', 268, 'Roadside Assistance'),
(51, 'Dining Offer', 268, 'Dining Offer'),
(52, 'Airport Lounge access', 268, 'Lounge Access'),
(53, 'Balance Transfer', 268, 'balance transfer'),
(54, 'Welcome Bonus: Get AED 1,000 in the form of EI SmartMiles.', 269, 'Welcome Bonus'),
(55, 'Exclusive for UAE nationals.', 269, 'exclusive for uae nationals.'),
(56, 'No Annual Membership Fee.', 269, 'no annual membership fee.'),
(57, 'Complimentary airport lounge access.', 269, 'Lounge Access'),
(58, '175,000 EI SmartMiles Welcome Bonus', 270, 'Welcome Bonus'),
(59, '3.75% cashback on international spend', 270, 'Cashback'),
(60, 'Unlimited airport lounge access for you + guest.', 270, 'Lounge Access'),
(61, 'Unlimited rounds of golf.', 270, 'Golf Access'),
(62, 'No Annual Fee', 271, 'no annual fee'),
(63, '10% Cashback on RTA Transport', 271, 'Cashback'),
(64, '10% Cashback on Fuel', 271, 'Cashback'),
(65, '2.25% Cashback on Other Spends', 271, 'Cashback'),
(66, '5% cash back on telecom expenses.', 272, '5% cash back on telecom.'),
(67, '5% cash back on electronic store purchases.', 272, '5% cash back on electronic.'),
(68, 'No AMF for first year subject to retail spend of AED 3,000 within 90 days.', 272, 'no amf for first year'),
(69, 'Up to 1% guaranteed cash back on all local and international transactions.', 272, 'up to 1% guaranteed cash back'),
(70, 'Up to 10% cash back on groceries, education, dining and telecom.', 273, 'Dining Offer'),
(71, 'No Annual Membership Fee for first year subject to retail spend of AED 5,000 within 90 days.', 273, 'no amf for first year'),
(72, 'Unlimited complimentary access to over 1,000 airport lounges worldwide.', 273, 'Airport lounges worldwide.'),
(73, 'Complimentary Access to Dubai Ladies Club & Sharjah Ladies Club.', 273, 'access to ladies club.'),
(74, 'Welcome Bonus of AED 500 Cashback points on spends of AED 15,000 within 60 days of Card approval.', 274, 'Cashback'),
(75, 'Lifestyle - 4% cashback on Supermarkets, Dining & Education with 8% cashback on Fuel.', 274, 'Cashback'),
(76, 'Travel - 4% cashback on Airlines, Hotels & Dining.', 274, 'Cashback'),
(77, '2 \"Buy 1 Get 1\" complimentary movie tickets every month.', 274, 'Movie Discount'),
(78, 'No AMF for first year', 275, 'no amf for first year'),
(79, 'Fast-Track Etihad Guest Gold Tier Status', 275, 'fast-track etihad guest gold tier status'),
(80, 'Up to 3.5 Etihad Guest Miles per USD spent', 275, 'up to 3.5 etihad guest miles per usd spent'),
(81, 'Complimentary airport transfers, airport lounge access, golf & valet parking.', 275, 'Lounge Access'),
(82, 'Complimentary Access to Dubai Ladies Club.', 275, 'complimentary access to dubai ladies club.'),
(83, 'No AMF for first year', 276, 'no amf for first year'),
(84, 'Fast-Track Etihad Guest Silver Tier Status.', 276, 'Silver Tier Benefits'),
(85, 'Up to 3 Etihad Guest Miles per USD spent.', 276, 'up to 3 etihad guest miles per usd spent.'),
(86, 'Complimentary Access to Dubai Ladies Club.', 276, 'complimentary access to dubai ladies club.'),
(87, 'Complimentary airport transfers, airport lounge access, golf & valet parking.', 276, 'Lounge Access'),
(88, 'No AMF for first year', 277, 'no amf for first year'),
(89, 'Fast-Track Etihad Guest Silver Tier Status.', 277, 'Silver Tier Benefits'),
(90, 'Up to 3 Etihad Guest Miles per USD spent.', 277, 'up to 3 etihad guest miles per usd spent.'),
(91, 'Complimentary Access to Dubai Ladies Club.', 277, 'complimentary access to dubai ladies club.'),
(92, 'Complimentary airport transfers, airport lounge access, golf & valet parking.', 277, 'Lounge Access'),
(93, 'No AMF for first year', 278, 'no amf for first year'),
(94, 'Up to 2 Etihad Guest Miles per USD spent.', 278, 'up to 2 etihad guest miles per usd spent.'),
(95, 'Unlock 10% Etihad Guest Miles Discount Voucher', 278, 'unlock 10% etihad guest miles discount voucher'),
(96, 'Discounts on dining, travel, hotels and shopping.', 278, 'Dining Offer'),
(97, 'Up to 3.5 Skywards Miles per USD spent.', 279, 'Skywards Miles'),
(98, 'Automatic upgrade to Emirates Skywards Silver membership.', 279, 'automatic upgrade skywards membership.'),
(99, 'Fast Track to Emirates Skywards Gold Tier Membership', 279, ''),
(100, 'Unlimited Complimentary golf any day of the week.', 279, 'Golf Access'),
(101, 'Unlimited complimentary access to over 1000+ airport lounges with a guest.', 279, 'airport lounges.'),
(102, 'AMF waiver for First Year subject to retail spends of AED 30K within 90 days from approval', 280, 'no amf for first year'),
(103, 'Up to 2 Skywards Miles per USD spent', 280, 'Skywards Miles'),
(104, 'Automatic upgrade to Emirates Skywards Silver membership', 280, 'automatic upgrade to emirates skywards silver membership'),
(105, 'Unlimited Complimentary golf any day of the week', 280, 'Golf Access'),
(106, 'Unlimited complimentary access to over 1000+ airport lounges with a guest', 280, 'unlimited  airport lounges'),
(107, 'Up to 1.5 Skywards Miles per USD spent.', 281, 'Skywards Miles'),
(108, 'Two rounds of Complimentary golf any day of the week.', 281, 'Golf Access'),
(109, '1 complimentary valet parking service per month.', 281, 'Valet Parking'),
(110, 'Unlimited complimentary access to over 1000+ airport lounges.', 281, 'unlimited  airport lounges'),
(111, 'Complimentary Access to Dubai Ladies Club.', 281, 'complimentary access to dubai ladies club.'),
(112, 'Free for Life', 282, 'Free for Life'),
(113, 'Concierge services', 282, 'concierge services'),
(114, 'Access to golf courses across the UAE', 282, 'Golf Access'),
(115, 'Buy 1 Get 1’ offers on movie tickets with Royal Cinemas', 282, 'Movie Discount'),
(116, 'Earn Plus Points on spend - 5% rewards on grocery, electronics, utilities, education and fuel', 282, 'Fuel Discount'),
(117, '0% Balance Transfer', 283, '0% balance transfer'),
(118, '4% on fuel spends', 283, 'Fuel Discount'),
(119, 'Free concierge services', 283, 'free concierge services'),
(120, 'Exclusive benefits & offers at Lulu stores & online', 283, 'exclusive benefits & offers at lulu stores & online'),
(121, 'Priority checkout', 284, 'priority checkout'),
(122, 'Early access to major sales and promotions', 284, 'early access to major sales and promotions'),
(123, 'Monthly discount and exclusive offers', 284, 'monthly discount and exclusive offers'),
(124, 'Free shipping on Lulu online', 284, 'free shipping on lulu online'),
(125, 'Access to top golfing courses', 285, 'Golf Access'),
(126, 'Buy 1 get 1 free on movies', 285, 'Movie Discount'),
(127, 'Valet parking in Abu Dhabi', 285, 'Valet Parking'),
(128, 'Get up to 1.5 Skywards Miles/USD', 285, 'Skywards Miles'),
(129, 'Welcome bonus of 100,000 skywards miles', 286, 'Welcome Bonus'),
(130, 'Access to golf courses', 286, 'Golf Access'),
(131, 'Valet Parking', 286, 'Valet Parking'),
(132, 'Movies offer', 286, 'Movie Discount'),
(133, 'Multi-trip travel insurance', 286, 'Travel Insurance'),
(134, 'Valet Parking', 287, 'Valet Parking'),
(135, 'Airport Transfer', 287, 'Airport Transfer'),
(136, 'Travel Insurance', 287, 'Travel Insurance'),
(137, 'Airport Lounge access', 287, 'Lounge Access'),
(138, 'Exclusive Movie Offers', 287, 'Movie Discount'),
(139, '15% rewards for spends at dnata Travel and Emirates Leisure', 288, 'Rewards'),
(140, '10% rewards for spends at MMI / Al Hamra Cellar and Le Clos', 288, 'Rewards'),
(141, '10% rewards for Duty Free Shopping worldwide', 288, 'Shopping Discount'),
(142, '0% bank fee for foreign transactions', 288, '0% bank fee for foreign transactions'),
(143, 'Complimentary Airport lounge access to over 1000 lounges', 288, 'Lounge Access'),
(144, '10% rewards for spends at dnata Travel and Emirates Leisure', 289, 'Rewards'),
(145, '10% rewards for spends at MMI / Al Hamra Cellar and Le Clos', 289, 'Rewards'),
(146, '10% rewards for Duty Free Shopping worldwide', 289, 'Shopping Discount'),
(147, 'Complimentary Airport lounge access to over 1000 lounges', 289, 'Lounge Access'),
(148, 'Welcome offer of up to 200,000 Etihad Guest Miles', 290, 'welcome offer up  200,000 EGM**.'),
(149, 'Premium lifestyle benefits - valet parking, cinema offers', 290, 'Valet Parking'),
(150, 'Premium travel offers - airport lounge, airport transfers', 290, 'Airport Transfer'),
(151, 'Complimentary airport lounge access to over 1000 lounges', 290, 'Lounge Access'),
(152, 'Concierge services for your time-consuming errands', 290, 'concierge services for your time-consuming errands'),
(153, 'Welcome offer of up to 60,000 Etihad Guest Miles', 291, 'welcome offer 60,000 EGM**.'),
(154, 'High Etihad Miles earning rate on hotels, dining & Etihad', 291, 'Dining Offer'),
(155, 'Complimentary cinema tickets, golf access, valet parking', 291, 'Valet Parking'),
(156, 'Complimentary Airport lounge access', 291, 'Lounge Access'),
(157, 'Up to 1.5 points for every AED 100 spent', 292, 'up to 1.5 points for every aed 100 spent'),
(158, 'Complimentary Airport Lounge Access', 292, 'Lounge Access'),
(159, 'Golf Privileges', 292, 'Golf Access'),
(160, 'Up to 30% discount on Restaurants across the UAE', 292, 'up to 30% discount on restaurants across the uae'),
(161, 'Earn rewards on all domestic & international spends', 292, 'Rewards'),
(162, 'Up to 1.5 points for every AED 100 spent', 293, 'up to 1.5 points for every aed 100 spent'),
(163, 'Free insurance for big purchases', 293, 'free insurance for big purchases'),
(164, 'Valet Parking Service', 293, 'Valet Parking'),
(165, 'Up to 50% discount on health & fitness', 293, 'up to 50% discount on health & fitness'),
(166, 'Golf Privileges', 293, 'Golf Access'),
(167, 'Complimentary access to over 10 VIP Airport lounges', 294, 'complimentary access to over 10 vip airport lounges'),
(168, 'Enjoy Master Card Buy 1 Get 1 offers', 294, 'enjoy master card buy 1 get 1 offers'),
(169, 'Earn rewards on all domestic & international spends', 294, 'Rewards'),
(170, 'Exclusive offers and deals on travel, lifestyle & shopping', 294, 'Shopping Discount'),
(171, 'Get up to 40% discount at over 100 golf courses worldwide', 294, 'Golf Access'),
(172, 'Complimentary access to over 10 VIP Airport lounges', 295, 'complimentary access to over 10 vip airport lounges'),
(173, 'Complimentary Travel Insurance', 295, 'Travel Insurance'),
(174, 'Golf Privileges', 295, 'Golf Access'),
(175, 'Valet parking', 295, 'Valet Parking'),
(176, 'Buy 1 get 1 free’ at VOX Cinemas', 295, 'buy 1 get 1 free’ at vox cinemas'),
(177, 'Complimentary access to over 10 VIP Airport lounges', 296, 'complimentary access to over 10 vip airport lounges'),
(178, 'Concierge Services', 296, 'concierge services'),
(179, 'Free for Life', 296, 'Free for Life'),
(180, 'Buy 1 get 1 free’ at VOX Cinemas', 296, 'buy 1 get 1 free’ at vox cinemas'),
(181, 'Free for Life', 297, 'Free for Life'),
(182, 'Buy 1 get 1 free’ at VOX Cinemas', 297, 'buy 1 get 1 free’ at vox cinemas'),
(183, '0% Easy Installment Plan', 297, '0% easy installment plan'),
(184, 'Buy 1 get 1 free’ at VOX Cinemas', 298, 'buy 1 get 1 free’ at vox cinemas'),
(185, 'Airport Lounge Access', 298, 'Lounge Access'),
(186, 'Golf Privileges', 298, 'Golf Access'),
(187, 'Valet Parking', 298, 'Valet Parking'),
(188, 'Complimentary Darna Platinum tier status', 298, 'complimentary darna platinum tier status'),
(189, 'Buy 1 get 1 free’ at VOX Cinemas', 299, 'buy 1 get 1 free’ at vox cinemas'),
(190, 'Airport Lounge Access', 299, 'Lounge Access'),
(191, 'Free for first year', 299, 'free for first year'),
(192, 'Complimentary Darna Gold tier status', 299, 'complimentary darna gold tier status'),
(193, 'Buy 1 get 1 free’ at VOX Cinemas', 300, 'buy 1 get 1 free’ at vox cinemas'),
(194, 'Free for Life', 300, 'Free for Life'),
(195, 'Complimentary Darna Silver tier status', 300, 'Silver Tier Benefits'),
(196, 'Airport Lounge Access', 301, 'Lounge Access'),
(197, 'Buy 1 get 1 free at Reel Cinemas', 301, 'buy 1 get 1 free at reel cinemas'),
(198, 'Complimentary valet parking', 301, 'Valet Parking'),
(199, 'Excellent discounts & offers at Emaar establishments', 301, 'excellent discounts & offers at emaar establishments'),
(200, '7.5% U points on all Emaar spends', 301, '7.5% u points on all emaar spends'),
(201, 'Airport Lounge Access', 302, 'Lounge Access'),
(202, 'Buy 1 get 1 free’ at Reel Cinemas', 302, 'buy 1 get 1 free’ at reel cinemas'),
(203, 'Excellent discounts & offers at Emaar establishments', 302, 'excellent discounts & offers at emaar establishments'),
(204, '6.25% U points on all Emaar spends', 302, '6.25% u points on all emaar spends'),
(205, 'Golf Privilege', 302, 'Golf Access'),
(206, 'Buy 1 get 1 free offer at Reel Cinemas', 303, 'buy 1 get 1 free offer at reel cinemas'),
(207, 'Excellent discounts & offers at Emaar establishments', 303, 'excellent discounts & offers at emaar establishments'),
(208, '5% U points on all Emaar spends', 303, '5% u points on all emaar spends'),
(209, 'Free for life', 303, 'Free for Life'),
(210, 'Life time free Credit card', 304, 'life time free credit card'),
(211, 'AED 500 Welcome bonus', 304, 'Welcome Bonus'),
(212, 'Movies discount at VOX Cinemas', 304, 'Movie Discount'),
(213, 'Get 5% back as noon credits and flat 15% discount', 304, 'get 5% back as noon credits and flat 15% discount'),
(214, 'Get up to 20% back as noon credits when you order food', 304, 'get up to 20% back as noon credits when you order food'),
(215, 'Earn 10% back as noon credits on purchases.', 304, 'earn 10% back as noon credits on purchases.'),
(216, 'Airport lounge access', 305, 'Lounge Access'),
(217, 'Fast track your Etihad Guest Gold membership', 305, 'fast track your etihad guest gold membership'),
(218, 'Free inflight Wi-Fi voucher', 305, 'free inflight wi-fi voucher'),
(219, '75% Miles Discount Voucher', 305, '75% miles discount voucher'),
(220, 'A 55,000 Etihad Guest Miles bonus', 305, 'a 55,000 etihad guest miles bonus'),
(221, 'Airport lounge access', 306, 'Lounge Access'),
(222, 'Fast track your Etihad Guest Silver membership', 306, 'fast track your etihad guest silver membership'),
(223, 'Free inflight Wi-Fi voucher', 306, 'free inflight wi-fi voucher'),
(224, '50% Miles Discount Voucher', 306, '50% miles discount voucher'),
(225, 'A 35,000 Etihad Guest Miles bonus', 306, 'a 35,000 etihad guest miles bonus'),
(226, 'Cinema Discount', 307, 'cinema discount'),
(227, 'Free Airport transfers', 307, 'Airport Transfer'),
(228, '25% Miles Discount Voucher', 307, '25% miles discount voucher'),
(229, 'A 10,000 Etihad Guest Miles bonus', 307, 'a 10,000 etihad guest miles bonus'),
(230, 'A free return flight every year', 308, 'a free return flight every year'),
(231, '12% cashback on all flight and hotel bookings', 308, 'Cashback'),
(232, '0% foreign currency conversion fees', 308, '0% foreign currency conversion fees'),
(233, 'Free lounge access along with 2 guests', 308, 'Lounge Access'),
(234, 'Save up to AED 1,000 each month', 309, 'save up to aed 1,000 each month'),
(235, 'Get up to 5% cashback on fashion, dining out and grocery shopping', 309, 'Cashback'),
(236, 'Get up to 3% cashback on international spending', 309, 'Cashback'),
(237, 'Get up to 40% off MakeMyTrip bookings,', 309, 'get up to 40% off makemytrip bookings,'),
(238, 'Free worldwide Airport lounge access', 309, 'Lounge Access'),
(239, 'No annual fee', 310, 'no annual fee'),
(240, 'Airport lounge access', 310, 'Lounge Access'),
(241, 'Get Up to 12 Months 0% EPP', 310, 'get up to 12 months 0% epp'),
(242, '10% cashback on your du postpaid line bills', 310, 'Cashback'),
(243, '10% cashback on du home services bills', 310, 'Cashback'),
(244, '10% cashback on prepaid line recharges', 310, 'Cashback'),
(245, '10% cashback on your du smartphone Privilege Plan', 310, 'Cashback'),
(246, 'Save big on school and family expenses.', 311, 'save big on school and family expenses.'),
(247, 'Save up to 4.25% on school fees', 311, 'save up to 4.25% on school fees'),
(248, 'Get 10% cashback on school bus, canteen, and uniform purchases, plus non-school activities', 311, 'Cashback'),
(249, 'Receive a 20% discount at Emaar attractions and more', 311, 'receive a 20% discount at emaar attractions and more'),
(250, '2% cashback on spending', 311, 'Cashback'),
(251, '9% cashback on Al-Futtaim retail brands', 312, 'Cashback'),
(252, '4% cashback at Al-Futtaim school, car and real estate brands', 312, 'Cashback'),
(253, '0% interest buy now pay later plans on your Al-Futtaim shopping', 312, 'Shopping Discount'),
(254, '7% cashback on Al-Futtaim retail brands', 313, 'Cashback'),
(255, '3% cashback at Al-Futtaim school, car and real estate brands', 313, 'Cashback'),
(256, 'Free airport lounge access', 313, 'Lounge Access'),
(257, '6% cashback on Al-Futtaim retail brands', 314, 'Cashback'),
(258, '2% cashback at Al-Futtaim school, car and real estate brands', 314, 'Cashback'),
(259, '0% interest buy now pay later plans on your Al-Futtaim shopping', 314, 'Shopping Discount'),
(260, 'First year free with a new card', 315, 'first year free with a new card'),
(261, 'Exclusive access to luxury beach clubs, gyms, premium dining experiences and more', 315, 'Dining Offer'),
(262, 'More convenience with 24/7 global concierge and free valet parking', 315, 'Valet Parking'),
(263, 'Guaranteed gift of gold bars and tree planting with each card', 315, ''),
(264, 'Earn up to 500,000 FAB Rewards on all your spending', 315, 'Rewards'),
(265, 'Travel Insurance', 317, 'Travel Insurance'),
(266, 'Free for Life', 317, 'Free for Life'),
(267, 'Extended Warranty', 317, 'extended warranty'),
(268, '5% cashback on dining', 317, 'Cashback'),
(269, 'Free for Life credit card', 318, 'Free for Life'),
(270, 'AED 500 Welcome bonus', 318, 'Welcome Bonus'),
(271, 'Instant Digital Card', 318, 'Digital Card'),
(272, 'Free noon delivery', 318, 'free noon delivery'),
(273, 'Travel Insurance', 319, 'Travel Insurance'),
(274, 'Free Airport transfer', 319, 'Airport Transfer'),
(275, 'Up to 5 Vantage points per 1 AED', 319, 'up to 5 vantage points per 1 aed'),
(276, 'Get 50% off at selected Restaurants, Spa, Entertainment', 319, '50% off restaurants, spa, entertainment**'),
(277, '50% discount on movie tickets', 320, 'Movie Discount'),
(278, 'Golf Benefits', 320, 'Golf Access'),
(279, 'Travel Insurance', 320, 'Travel Insurance'),
(280, 'Earn 1 Salaam Point on local spends.', 320, 'earn 1 salaam point on local spends.'),
(281, 'Earn 6 Salaam points on International spends.', 320, 'earn 6 salaam points on international spends.'),
(282, 'Get AED 1,000 welcome bonus Free for First year', 321, 'Welcome Bonus'),
(283, 'Up to 10% cashback on supermarket', 321, 'Cashback'),
(284, '50% discount on VOX Cinemas', 321, '50% discount on vox cinemas'),
(285, '10% cashback on travel, flight and hotel bookings', 321, 'Cashback'),
(286, 'Get AED 500 welcome bonus  Cashback of up to 5% on supermarket & dining spends and up to 50% for entertainment spends', 322, 'Cashback'),
(287, 'Get up to AED 600 cashback per month', 322, 'Cashback'),
(288, 'Free for life', 322, 'Free for Life'),
(289, 'Earn 1.75 Air rewards per AED 5 for spends', 323, 'Rewards'),
(290, 'Get a joining bonus of 20,000 AirRewards', 323, 'Rewards'),
(291, 'Enjoy benefits with no maximum caps', 323, 'enjoy benefits with no maximum caps'),
(292, 'Enjoy a free-for-life card and great rewards', 324, 'Rewards'),
(293, 'Cashback of up to 1.5% on local & international spends', 324, 'Cashback'),
(294, 'Get up to AED 300 cashback', 324, 'Cashback'),
(295, 'Tier-based Monthly Fee', 325, 'tier-based monthly fee'),
(296, 'Up to 4% cashback on all your spends', 325, 'Cashback'),
(297, 'Up to 3% value back on airline and hotel reward redemption', 325, 'up to 3% value back on airline and hotel reward redemption'),
(298, 'No Foreign Currency Fee', 325, 'no foreign currency fee'),
(299, 'Airport Lounge Access', 326, 'Lounge Access'),
(300, 'Free supplementary card', 326, 'free supplementary card'),
(301, 'Balance Transfer', 326, 'balance transfer'),
(302, 'Easy Payment Plan', 326, 'easy payment plan'),
(303, 'Airport Lounge Access', 327, 'Lounge Access'),
(304, 'Travel Insurance', 327, 'Travel Insurance'),
(305, 'Balance Transfer', 327, 'balance transfer'),
(306, 'Easy Payment Plan', 327, 'easy payment plan'),
(307, 'Free for Life', 328, 'Free for Life'),
(308, 'Travel Insurance', 328, 'Travel Insurance'),
(309, 'Balance Transfer', 328, 'balance transfer'),
(310, 'Easy Payment Plan', 328, 'easy payment plan'),
(311, '50% off on VOX cinema', 329, '50% off on vox cinema'),
(312, '20% off grocery or food order on the Talabat', 329, '20% off grocery or food order on the talabat'),
(313, '3% unlimited Cash Up on fuel', 329, 'Fuel Discount'),
(314, '3% unlimited Cash Up on online shopping', 329, 'Shopping Discount'),
(315, 'Cinema offers on VOX and REEL and much more', 330, 'cinema offers on vox and reel and much more'),
(316, 'Valet Parking', 330, 'Valet Parking'),
(317, 'Dining Offers', 330, 'Dining Offer'),
(318, 'Balance Transfer', 330, 'balance transfer'),
(319, 'Airport Lounge Access', 330, 'Lounge Access'),
(320, '50% off on VOX cinema', 331, '50% off on vox cinema'),
(321, 'Miles Up benefit', 331, 'miles up benefit'),
(322, 'Free Valet parking', 331, 'Valet Parking'),
(323, 'Earn up to 10% cash up on specific categories', 331, 'earn up to 10% cash up on specific categories'),
(324, '20% off grocery or food order on the Talabat', 331, '20% off grocery or food order on the talabat'),
(325, '5% cashback on supermarket spending, dining and fuel, 3% on international spends and 1% on other purchases.', 332, 'Cashback'),
(326, '5% cashback on online purchases, utility bills, school fees', 332, 'Cashback'),
(327, 'Get 20% off talabat delivery', 332, 'get 20% off talabat delivery'),
(328, 'Unlimited Airport Lounge access', 332, 'Lounge Access'),
(329, '20% off on Careem rides', 332, 'Careem Discount'),
(330, '0% interest rate at quick cash & Balance transfer', 332, '0% interest rate at quick cash & balance transfer'),
(331, 'Enjoy Movies at AED 20 only', 332, 'Movie Discount'),
(332, 'Interest Free installment', 333, 'Interest Free'),
(333, 'Digital Card', 333, 'Digital Card'),
(334, 'No processing fees on installment', 333, 'No Processing Fees'),
(335, 'Welcome Bonus AED 500', 334, 'Welcome Bonus'),
(336, 'Free for First Year', 334, 'free for first year'),
(337, 'Travel Insurance', 334, 'Travel Insurance'),
(338, 'Cashback', 334, 'Cashback'),
(339, 'Careem Plus & Zomato Gold subscription', 334, 'Subscription Offer'),
(340, 'Welcome Bonus AED 500', 335, 'Welcome Bonus'),
(341, 'Free for First Year', 335, 'free for first year'),
(342, '5% cashback on fuel', 335, 'Cashback'),
(343, 'Earn 6% cashback on dining', 335, 'Cashback'),
(344, 'Travel Insurance', 335, 'Travel Insurance'),
(345, 'Zomato Gold subscription', 335, 'Subscription Offer'),
(346, 'Welcome Bonus AED 500', 336, 'Welcome Bonus'),
(347, 'Free for 1st year', 336, 'free for 1st year'),
(348, 'Travel Insurance', 336, 'Travel Insurance'),
(349, '1 Air Mile for every AED 1', 336, '1 air mile for every aed 1'),
(350, 'Dining Discounts', 336, 'Dining Offer'),
(351, 'Welcome Bonus up to 50K Skywards Miles', 337, 'Welcome Bonus'),
(352, 'Airport Lounge Access', 337, 'Lounge Access'),
(353, 'Silver Tier Benefits', 337, 'Silver Tier Benefits'),
(354, 'Multi-trip travel insurance', 337, 'Travel Insurance'),
(355, 'Get a complimentary Zomato Gold Dining membership', 337, 'Dining Offer'),
(356, 'Get a complimentary Careem Plus subscription', 337, 'Subscription Offer'),
(357, 'Welcome Bonus up to 20K Skywards Miles', 338, 'Welcome Bonus'),
(358, 'Airport Lounge Access', 338, 'Lounge Access'),
(359, 'Silver Tier Benefits', 338, 'Silver Tier Benefits'),
(360, 'Multi-trip travel insurance', 338, 'Travel Insurance'),
(361, 'Get a complimentary Zomato Gold Dining membership', 338, 'Dining Offer'),
(362, 'Get a complimentary Careem Plus subscription', 338, 'Subscription Offer'),
(363, 'Free for Life', 339, 'Free for Life'),
(364, 'Cashback', 339, 'Cashback'),
(365, 'Airport Lounge Access', 339, 'Lounge Access'),
(366, 'Movie Discounts', 339, 'Movie Discount'),
(367, 'Skywards Miles', 339, 'Skywards Miles'),
(368, 'Cashback', 340, 'Cashback'),
(369, 'Airport Lounge Access', 340, 'Lounge Access'),
(370, 'Movie Discounts', 340, 'Movie Discount'),
(371, 'Airport Transfer', 340, 'Airport Transfer'),
(372, 'Travel Insurance', 340, 'Travel Insurance');

-- --------------------------------------------------------

--
-- Table structure for table `creditcardsoffers`
--

CREATE TABLE `creditcardsoffers` (
  `idcreditcardsoffers` int(11) NOT NULL,
  `creditcardsoffersDetails` varchar(500) DEFAULT NULL,
  `idcreditcards` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `creditcardsoffers`
--

INSERT INTO `creditcardsoffers` (`idcreditcardsoffers`, `creditcardsoffersDetails`, `idcreditcards`) VALUES
(1, 'Up to 3% Cash Up at supermarkets, fuel and utilities', 329),
(2, 'Complimentary Airport lounge access', 329),
(3, '20% discount on 3 Careem rides every month', 329),
(4, 'First year free', 329),
(5, 'Free for life credit card', 330),
(6, 'Earn up to 10% cash up on specific categories', 330),
(7, 'Complimentary Valtrans valet parking service', 330),
(8, 'First for Life', 331),
(9, '50% off on VOX cinema', 331),
(10, 'Golf Privileges', 331),
(11, 'Travel medical insurance', 331),
(12, 'Airport lounge benefits', 331),
(13, 'Miles Up benefit', 331),
(14, 'Return flights to the Maldives or Greece', 332),
(15, 'Maldives -2 nights / 3 days in a 5-star resort with breakfast', 332),
(16, 'Greece - 2 nights/ 3 days in a 4-star hotel in Athens', 332),
(17, '5% cashback on supermarket spending, dining and fuel.', 332),
(18, 'Slice your purchases into 4 interest-free instalments', 333),
(19, 'Get an instant digital card', 333),
(20, 'No processing fees', 333),
(21, 'Welcome bonus of AED 500', 317),
(22, 'Up to 5% Cashback', 317),
(23, '20% Cashback at your favourite ecom merchants', 317),
(24, 'Free for Life', 317),
(25, 'AED 500 Welcome Bonus', 318),
(26, 'No annual fees ever', 318),
(27, '5% cashback on noon, NowNow, Sivvi, noon Food', 318),
(28, '5% cashback on noon Minutes, noon supermall and Namshi', 318),
(29, 'Welcome bonus of AED 1500', 319),
(30, 'Access to Fitness First', 319),
(31, 'Free Airport transfer', 319),
(32, '50% discount on movie', 319),
(33, 'Welcome Bonus of AED 2,500', 320),
(34, 'Unlimited visits to Fitness First', 320),
(35, 'Travel insurance', 320),
(36, 'Airport lounge access', 320),
(37, '5% rewards on grocery, electronics, utilities, education and fuel', 282),
(38, 'Unlimited complimentary airport lounge access', 282),
(39, 'Exclusive for Abu Dhabi residents', 282),
(40, 'Movie Discount', 282),
(41, 'Up to 500 Lulu Points', 283),
(42, 'Up to 7% back as Lulu Points', 283),
(43, 'Buy 1 Get 1 Free on Movie Tickets', 283),
(44, 'Airport lounge Access', 283),
(45, 'Free for life card', 284),
(46, 'Airport lounge Access', 284),
(47, '0% balance transfer with no processing fees', 284),
(48, 'Up to 3.5 % back as Lulu Points on daily spends', 284),
(49, 'Bonus Skywards Miles up to 40,000', 285),
(50, 'Up to 1.5 Skywards Miles/USD', 285),
(51, 'Unlimited access to premium Airport lounges', 285),
(52, 'Buy 1 get 1 free on movies', 285),
(53, 'Up to 100,000 bonus Skywards Miles', 286),
(54, 'Emirates Skywards Silver membership upgrade', 286),
(55, 'Business Class Lounge access with Silver membership.', 286),
(56, 'Earn up to 2 Skywards Miles per USD equivalent spend', 286),
(57, 'Complimentary golf access', 287),
(58, 'Up to 2 points for every AED 100 spent', 287),
(59, 'Unlimited access to over 1,000 premium lounges in over 300 cities', 287),
(60, 'Welcome bonus up to 2,500 dnata points', 288),
(61, '0% back on Dubai Duty Free;', 288),
(62, '0% forex fee', 288),
(63, 'Access to over 900 VIP Airport lounges', 288),
(64, 'Welcome bonus up to 1,000 dnata points', 289),
(65, 'Complimentary lounge access with Mastercard Travel Pass', 289),
(66, 'Up to 15% dnata Points on all spends', 289),
(67, 'Access to over 900 VIP Airport lounges', 289),
(68, 'Welcome offer of up to 200,000 Etihad Guest miles', 290),
(69, 'Earn up to 10 etihad Guest Miles/10 AED spend', 290),
(70, 'Fast Track to gold Tier', 290),
(71, '50% Etihad guest miles discount voucher', 290),
(72, 'Welcome offer of up to 60,000 Etihad Guest miles', 291),
(73, 'Earn up to 7 etihad Guest Miles/10 AED spend', 291),
(74, 'Fast Track to silver Tier', 291),
(75, 'No Annual Fees', 292),
(76, 'Earn up to 1.5 Plus Points for every AED 100 spent', 292),
(77, 'No Annual Fees', 293),
(78, 'Earn up to 1.5 Plus Points for every AED 100 spent', 293),
(79, 'No Annual Fees', 294),
(80, 'Earn Plus Points on your spends', 294),
(81, 'Free for first year', 295),
(82, 'Earn 8% back as SHARE Points', 295),
(83, 'Welcome bonus of 10,000 SHARE Points equal to AED 1,000', 295),
(84, 'Free for Life', 296),
(85, 'Earn 6% back as SHARE Points', 296),
(86, 'Welcome bonus of 5,000 SHARE Points equal to AED 500', 296),
(87, 'Free for Life', 297),
(88, 'Earn 4% back as SHARE Points', 297),
(89, 'Welcome Bonus up to 15,000 Darna Points', 298),
(90, 'Earn 10% back as Darna Points', 298),
(91, 'Welcome Bonus up to 3000 Darna Points', 299),
(92, 'Earn 7.5% back as Darna Points', 299),
(93, 'First year free for a limited time offer', 299),
(94, 'Free for Life', 300),
(95, 'Earn 6.25% back as Darna Points', 300),
(96, 'Welcome offer: Up to 25,000 U Points.', 301),
(97, '7.5% U points on all Emaar spends', 301),
(98, 'Welcome offer: Up to 2,500 U Points.', 302),
(99, '6.25% U points on all Emaar spends', 302),
(100, 'Travel Insurance', 302),
(101, 'Free for life', 303),
(102, '30% discount on Emaar Attraction', 303),
(103, 'Get a welcome bonus of AED 500', 304),
(104, 'Earn up to 20% back as noon credits', 304),
(105, 'Earn up to 1% on all other spends', 304),
(106, '1-year free noon One membership & 50% off thereafter', 304),
(107, 'Bonus cashback for UAE Nationals AED 500 & Expatriates AED 300', 255),
(108, 'Balance Transfer with 0% for 3 or 6 months.', 255),
(109, 'Airport lounge access', 255),
(110, 'Up to 10% on fuel spending', 255),
(111, 'Welcome bonus of 15,000 BRight Rewards', 256),
(112, 'O% foreign transaction fees', 256),
(113, 'Airport lounge access', 256),
(114, 'Enjoy valet parking services.', 256),
(115, 'Earn up to 3 BRight rewards for every AED 10 spend', 256),
(116, 'Welcome bonus of 10,000 BRight Rewards', 257),
(117, 'O% foreign transaction fees', 257),
(118, 'Airport lounge access', 257),
(119, 'Enjoy valet parking services', 257),
(120, 'Earn up to 2 BRight rewards for every AED 10 spend', 257),
(121, 'Free for Life', 258),
(122, 'Airport lounge access', 258),
(123, 'Enjoy valet parking services', 258),
(124, 'Earn up to 1 BRight rewards for every AED 10 spend', 258),
(125, 'Welcome bonus of 55,000 Etihad Guest Miles', 305),
(126, 'Earn up to 7.5 Etihad Guest Miles/AED 10 spends', 305),
(127, 'Welcome bonus of 35,000 Etihad Guest Miles', 306),
(128, 'Earn up to 6.5 Etihad Guest Miles/AED 10 spends', 306),
(129, 'Welcome bonus of 10,000 Etihad Guest Miles', 307),
(130, 'Earn up to 4 Etihad Guest Miles/AED 10 spends', 307),
(131, 'A free return flight every year', 308),
(132, 'Movie ticket at AED 20', 308),
(133, 'Free Airport Lounge', 308),
(134, 'FREE HOLIDAY - Return flights to the Maldives or Greece', 309),
(135, 'Maldives -2 nights / 3 days in a 5-star resort with breakfast', 309),
(136, 'Greece - 2 nights/ 3 days in a 4-star hotel in Athens', 309),
(137, '5% cashback on supermarket spending, dining and fuel.', 309),
(138, 'Exclusive 10% cashback', 310),
(139, 'Airport lounge access', 310),
(140, 'Get 10% cashback', 311),
(141, '20% off at Emaar entertainment', 311),
(142, 'No annual Fees', 312),
(143, 'Cinema ticket @ AED 20', 312),
(144, '9% cashback on Al-Futtaim retail brands', 312),
(145, 'No Annual fees', 313),
(146, '7% cashback on Al-Futtaim retail brands', 313),
(147, 'No Annual Fees', 314),
(148, '6% cashback on Al-Futtaim retail brands', 314),
(149, 'Movie tickets from only AED 20', 315),
(150, 'Free for Life', 316),
(151, 'Movie tickets at only AED 20', 316),
(152, 'No Annual Fees', 259),
(153, 'Golf privilege', 259),
(154, 'Up t Up to 10% cashback on bills, education, supermarkets and fuel', 260),
(155, 'Free for first Year', 260),
(156, 'Multi-trip travel insurance', 260),
(157, 'Airport lounge access with Lounge Key', 260),
(158, 'Free for life', 261),
(159, '50% off on cinema tickets', 261),
(160, 'Welcome bonus of 20,000 Yes Rewards', 262),
(161, 'First year free', 262),
(162, 'Free for first year', 263),
(163, '90-day complimentary subscription to Smiles Unlimited', 263),
(164, 'Welcome bonus of AED 1500', 321),
(165, 'Free for First year', 321),
(166, 'Free for life', 322),
(167, 'Cashback of up to 5% on supermarket', 322),
(168, 'Welcome bonus of 20,000 Air Rewards', 323),
(169, 'Complimentary annual return ticket', 323),
(170, 'Free for Life', 324),
(171, 'Access to airport Lounges', 324),
(172, 'Free trial for Founder Members until 31st July 2025 - Privilege', 325),
(173, 'Welcome Bonus: Get AED 1,000 in the form of EI SmartMiles.', 269),
(174, '175,000 EI Smart Miles Welcome Bonus', 270),
(175, 'Get 10% Cashback on Fuel Spends', 271),
(176, 'Get 10% Cashback on RTA Transport Payment', 271),
(177, '5% cash back on telecom expenses.', 272),
(178, '5% cash back on electronic store purchases', 272),
(179, 'No annual Fees', 273),
(180, 'Up to 10% cash back on groceries', 273),
(181, 'Welcome Bonus of AED 500 Cashback points', 274),
(182, 'Welcome Bonus: Earn up to 55,000 Etihad Guest Miles  Etihad Guest Gold Tier', 275),
(183, 'Welcome bonus of 30,000 Etihad Guest Miles', 276),
(184, 'Welcome bonus of 20,000 Etihad Guest Miles', 277),
(185, 'Welcome bonus of 5,000 Etihad Guest Miles', 278),
(186, 'Up to 3.5 Skywards Miles per USD spent.', 279),
(187, 'No AMF for first year', 280),
(188, 'Up to 2 Etihad Guest Miles per USD spent.', 280),
(189, 'Complimentary Valet Parking & golf 7 days a week', 280),
(190, 'Automatic upgrade to Emirates Skywards silver membership', 280),
(191, 'Up to 1.5 Skywards Miles/USD spent', 281),
(192, 'Complimentary Golf', 281),
(193, 'Get AED 500 cashback when you apply for this card by 30 June 2025 & spend AED 6K within the first 60 days.', 334),
(194, 'Buy 1 Get 1 Free movie tickets every month at Vox, Reel and Roxy Cinemas', 334),
(195, 'Get AED 500 cashback when you apply for this card by 30 June 2025 and spend AED 6,000 within the first 60 days.', 335),
(196, '6% cashback on dining and food and 5% cashback on fuel - all upto AED 200', 335),
(197, 'Get AED 500 cashback when you apply for this card by 30 June 2025 and spend AED 6K within the first 60 days.', 336),
(198, 'Enjoy 8 Fitness First visits a month for AED 1', 336),
(199, 'Get a complimentary 12-month Careem Plus subscription.', 336),
(200, 'Buy 1 Get 1 Free movie tickets every month at Vox, Reel and Roxy Cinemas', 336),
(201, 'Get welcome bonus up to 50,000 Skywards Miles', 337),
(202, 'Complimentary Emirates Skywards Silver Tier membership', 337),
(203, 'No Miles Expiry', 337),
(204, '3 complimentary visits per month to premium beach clubs', 337),
(205, 'Earn up to 2.75 Skywards Miles for every USD spent', 337),
(206, 'Get welcome bonus up to 20,000 Skywards Miles', 338),
(207, 'Complimentary Emirates Skywards Silver Tier membership', 338),
(208, 'No Miles Expiry', 338),
(209, 'Earn up to 1.75 Skywards Miles for every USD spent', 338),
(210, '12 complimentary visits for you and additional cardholders', 338),
(211, 'Free for life', 339),
(212, '2% cashback on ALL YOUR SPENDS - no categories, no fuss!', 339),
(213, 'Up to 750 cashback every month', 339),
(214, 'Up to 5000 Skywards miles every month', 339),
(215, 'Access to 25+ Airport Lounges', 339),
(216, '4% cashback on ALL YOUR SPENDS - no categories, no fuss!', 340),
(217, 'Access to 850+ airport lounges world wide', 340),
(218, 'VOX Cinemas 3 Free Tickets (B1G1 x 3 times) + 25% off on F&B', 340),
(219, 'Up to 1500 cashback every month', 340),
(220, 'Priority Pass Lounge access at over 1300 lounges in Various airports around the world', 326),
(221, 'Priority Pass Lounge access at over 1300 lounges in Various airports around the world', 327),
(222, 'Free Worldwide Travel Insurance', 327),
(223, 'Free Worldwide Travel Insurance', 328),
(224, 'Balance transfer Facility', 328),
(225, 'Access to Fitness First across the UAE', 264),
(226, 'Welcome Bonus up to 200,000 rewards', 264),
(227, 'Up to 20% cashback on selected merchant', 264),
(228, 'Enjoy 5% back on travel & Dining', 264),
(229, 'Access to Fitness First across the UAE', 265),
(230, 'Welcome Bonus up to 100,000 rewards', 265),
(231, 'Up to 20% cashback on selected merchant', 265),
(232, 'Enjoy 5% back on travel & Dining', 265),
(233, 'Welcome Bonus up to 50,000 rewards', 266),
(234, 'Up to 20% cashback on selected merchant', 266),
(235, 'Enjoy 5% back on Travel & Dining', 266),
(236, 'Earn up to 120,000 bonus Skywards Miles', 267),
(237, 'Complimentary Emirates Skywards Silver membership', 267),
(238, 'Earn Skywards Miles on all spends', 267),
(239, 'Earn up to 50,000 bonus Skywards Miles', 268),
(240, 'Premium lifestyle benefits', 268),
(241, 'Earn Skywards Miles on all spends', 268);

-- --------------------------------------------------------

--
-- Table structure for table `creditcardstypes`
--

CREATE TABLE `creditcardstypes` (
  `idcreditcardstypes` int(11) NOT NULL,
  `idcreditcards` int(11) NOT NULL,
  `idcardtype` int(11) NOT NULL,
  `showonfrontscreen` tinyint(4) DEFAULT NULL,
  `showfrontscreenseqno` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `creditcardstypes`
--

INSERT INTO `creditcardstypes` (`idcreditcardstypes`, `idcreditcards`, `idcardtype`, `showonfrontscreen`, `showfrontscreenseqno`) VALUES
(1, 309, 13, 1, 1),
(2, 282, 13, 1, 2),
(3, 260, 13, 1, 3),
(4, 332, 13, 1, 4),
(5, 255, 13, 1, 5),
(6, 282, 15, 1, 1),
(7, 263, 15, 1, 2),
(8, 320, 15, 1, 3),
(9, 309, 15, 1, 4),
(10, 318, 17, 1, 1),
(11, 316, 17, 1, 3),
(12, 259, 17, 1, 4),
(13, 286, 14, 1, 1),
(14, 280, 14, 1, 2),
(15, 337, 14, 1, 3),
(16, 259, 14, 1, 4),
(17, 286, 19, 1, 1),
(18, 308, 19, 1, 2),
(19, 321, 19, 1, 3),
(20, 286, 19, 1, 4),
(21, 329, 1, NULL, NULL),
(22, 330, 1, NULL, NULL),
(23, 331, 1, NULL, NULL),
(24, 317, 1, NULL, NULL),
(25, 318, 1, NULL, NULL),
(26, 282, 1, NULL, NULL),
(27, 283, 1, NULL, NULL),
(28, 284, 1, NULL, NULL),
(29, 287, 1, NULL, NULL),
(30, 292, 1, NULL, NULL),
(31, 293, 1, NULL, NULL),
(32, 294, 1, NULL, NULL),
(33, 295, 1, NULL, NULL),
(34, 296, 1, NULL, NULL),
(35, 297, 1, NULL, NULL),
(36, 298, 1, NULL, NULL),
(37, 299, 1, NULL, NULL),
(38, 300, 1, NULL, NULL),
(39, 301, 1, NULL, NULL),
(40, 302, 1, NULL, NULL),
(41, 303, 1, NULL, NULL),
(42, 255, 1, NULL, NULL),
(43, 308, 1, NULL, NULL),
(44, 309, 1, NULL, NULL),
(45, 310, 1, NULL, NULL),
(46, 311, 1, NULL, NULL),
(47, 312, 1, NULL, NULL),
(48, 313, 1, NULL, NULL),
(49, 314, 1, NULL, NULL),
(50, 260, 1, NULL, NULL),
(51, 261, 1, NULL, NULL),
(52, 321, 1, NULL, NULL),
(53, 322, 1, NULL, NULL),
(54, 324, 1, NULL, NULL),
(55, 325, 1, NULL, NULL),
(56, 271, 1, NULL, NULL),
(57, 272, 1, NULL, NULL),
(58, 273, 1, NULL, NULL),
(59, 274, 1, NULL, NULL),
(60, 334, 1, NULL, NULL),
(61, 335, 1, NULL, NULL),
(62, 336, 1, NULL, NULL),
(63, 339, 1, NULL, NULL),
(64, 340, 1, NULL, NULL),
(65, 264, 1, NULL, NULL),
(66, 266, 1, NULL, NULL),
(84, 317, 2, NULL, NULL),
(85, 318, 2, NULL, NULL),
(86, 319, 2, NULL, NULL),
(87, 320, 2, NULL, NULL),
(88, 283, 2, NULL, NULL),
(89, 285, 2, NULL, NULL),
(90, 286, 2, NULL, NULL),
(91, 288, 2, NULL, NULL),
(92, 289, 2, NULL, NULL),
(93, 290, 2, NULL, NULL),
(94, 291, 2, NULL, NULL),
(95, 295, 2, NULL, NULL),
(96, 296, 2, NULL, NULL),
(97, 298, 2, NULL, NULL),
(98, 299, 2, NULL, NULL),
(99, 301, 2, NULL, NULL),
(100, 302, 2, NULL, NULL),
(101, 255, 2, NULL, NULL),
(102, 256, 2, NULL, NULL),
(103, 257, 2, NULL, NULL),
(104, 305, 2, NULL, NULL),
(105, 306, 2, NULL, NULL),
(106, 307, 2, NULL, NULL),
(107, 308, 2, NULL, NULL),
(108, 262, 2, NULL, NULL),
(109, 321, 2, NULL, NULL),
(110, 323, 2, NULL, NULL),
(111, 269, 2, NULL, NULL),
(112, 270, 2, NULL, NULL),
(113, 274, 2, NULL, NULL),
(114, 275, 2, NULL, NULL),
(115, 276, 2, NULL, NULL),
(116, 277, 2, NULL, NULL),
(117, 278, 2, NULL, NULL),
(118, 334, 2, NULL, NULL),
(119, 335, 2, NULL, NULL),
(120, 336, 2, NULL, NULL),
(121, 337, 2, NULL, NULL),
(122, 338, 2, NULL, NULL),
(123, 264, 2, NULL, NULL),
(124, 265, 2, NULL, NULL),
(125, 266, 2, NULL, NULL),
(126, 267, 2, NULL, NULL),
(127, 268, 2, NULL, NULL),
(147, 330, 3, NULL, NULL),
(148, 331, 3, NULL, NULL),
(149, 317, 3, NULL, NULL),
(150, 318, 3, NULL, NULL),
(151, 282, 3, NULL, NULL),
(152, 284, 3, NULL, NULL),
(153, 292, 3, NULL, NULL),
(154, 293, 3, NULL, NULL),
(155, 294, 3, NULL, NULL),
(156, 296, 3, NULL, NULL),
(157, 297, 3, NULL, NULL),
(158, 300, 3, NULL, NULL),
(159, 303, 3, NULL, NULL),
(160, 258, 3, NULL, NULL),
(161, 310, 3, NULL, NULL),
(162, 312, 3, NULL, NULL),
(163, 313, 3, NULL, NULL),
(164, 314, 3, NULL, NULL),
(165, 316, 3, NULL, NULL),
(166, 261, 3, NULL, NULL),
(167, 322, 3, NULL, NULL),
(168, 324, 3, NULL, NULL),
(169, 269, 3, NULL, NULL),
(170, 271, 3, NULL, NULL),
(171, 339, 3, NULL, NULL),
(172, 328, 3, NULL, NULL),
(178, 329, 4, NULL, NULL),
(179, 330, 4, NULL, NULL),
(180, 331, 4, NULL, NULL),
(181, 317, 4, NULL, NULL),
(182, 319, 4, NULL, NULL),
(183, 320, 4, NULL, NULL),
(184, 282, 4, NULL, NULL),
(185, 283, 4, NULL, NULL),
(186, 284, 4, NULL, NULL),
(187, 285, 4, NULL, NULL),
(188, 286, 4, NULL, NULL),
(189, 287, 4, NULL, NULL),
(190, 288, 4, NULL, NULL),
(191, 289, 4, NULL, NULL),
(192, 290, 4, NULL, NULL),
(193, 291, 4, NULL, NULL),
(194, 292, 4, NULL, NULL),
(195, 293, 4, NULL, NULL),
(196, 294, 4, NULL, NULL),
(197, 295, 4, NULL, NULL),
(198, 296, 4, NULL, NULL),
(199, 298, 4, NULL, NULL),
(200, 299, 4, NULL, NULL),
(201, 301, 4, NULL, NULL),
(202, 302, 4, NULL, NULL),
(203, 255, 4, NULL, NULL),
(204, 256, 4, NULL, NULL),
(205, 257, 4, NULL, NULL),
(206, 258, 4, NULL, NULL),
(207, 305, 4, NULL, NULL),
(208, 306, 4, NULL, NULL),
(209, 307, 4, NULL, NULL),
(210, 308, 4, NULL, NULL),
(211, 309, 4, NULL, NULL),
(212, 310, 4, NULL, NULL),
(213, 311, 4, NULL, NULL),
(214, 312, 4, NULL, NULL),
(215, 313, 4, NULL, NULL),
(216, 315, 4, NULL, NULL),
(217, 316, 4, NULL, NULL),
(218, 259, 4, NULL, NULL),
(219, 260, 4, NULL, NULL),
(220, 261, 4, NULL, NULL),
(221, 321, 4, NULL, NULL),
(222, 322, 4, NULL, NULL),
(223, 323, 4, NULL, NULL),
(224, 324, 4, NULL, NULL),
(225, 325, 4, NULL, NULL),
(226, 269, 4, NULL, NULL),
(227, 270, 4, NULL, NULL),
(228, 273, 4, NULL, NULL),
(229, 274, 4, NULL, NULL),
(230, 275, 4, NULL, NULL),
(231, 276, 4, NULL, NULL),
(232, 277, 4, NULL, NULL),
(233, 278, 4, NULL, NULL),
(234, 279, 4, NULL, NULL),
(235, 280, 4, NULL, NULL),
(236, 281, 4, NULL, NULL),
(237, 334, 4, NULL, NULL),
(238, 335, 4, NULL, NULL),
(239, 336, 4, NULL, NULL),
(240, 337, 4, NULL, NULL),
(241, 338, 4, NULL, NULL),
(242, 339, 4, NULL, NULL),
(243, 340, 4, NULL, NULL),
(244, 326, 4, NULL, NULL),
(245, 327, 4, NULL, NULL),
(246, 328, 4, NULL, NULL),
(247, 264, 4, NULL, NULL),
(248, 265, 4, NULL, NULL),
(249, 266, 4, NULL, NULL),
(250, 267, 4, NULL, NULL),
(251, 268, 4, NULL, NULL),
(305, 331, 5, NULL, NULL),
(306, 320, 5, NULL, NULL),
(307, 282, 5, NULL, NULL),
(308, 283, 5, NULL, NULL),
(309, 285, 5, NULL, NULL),
(310, 286, 5, NULL, NULL),
(311, 287, 5, NULL, NULL),
(312, 288, 5, NULL, NULL),
(313, 290, 5, NULL, NULL),
(314, 291, 5, NULL, NULL),
(315, 292, 5, NULL, NULL),
(316, 293, 5, NULL, NULL),
(317, 295, 5, NULL, NULL),
(318, 296, 5, NULL, NULL),
(319, 298, 5, NULL, NULL),
(320, 299, 5, NULL, NULL),
(321, 301, 5, NULL, NULL),
(322, 302, 5, NULL, NULL),
(323, 256, 5, NULL, NULL),
(324, 305, 5, NULL, NULL),
(325, 306, 5, NULL, NULL),
(326, 308, 5, NULL, NULL),
(327, 312, 5, NULL, NULL),
(328, 313, 5, NULL, NULL),
(329, 315, 5, NULL, NULL),
(330, 259, 5, NULL, NULL),
(331, 321, 5, NULL, NULL),
(332, 325, 5, NULL, NULL),
(333, 270, 5, NULL, NULL),
(334, 273, 5, NULL, NULL),
(335, 275, 5, NULL, NULL),
(336, 276, 5, NULL, NULL),
(337, 277, 5, NULL, NULL),
(338, 279, 5, NULL, NULL),
(339, 280, 5, NULL, NULL),
(340, 281, 5, NULL, NULL),
(341, 334, 5, NULL, NULL),
(342, 336, 5, NULL, NULL),
(343, 337, 5, NULL, NULL),
(344, 326, 5, NULL, NULL),
(345, 327, 5, NULL, NULL),
(346, 264, 5, NULL, NULL),
(347, 267, 5, NULL, NULL),
(348, 268, 5, NULL, NULL),
(368, 290, 6, NULL, NULL),
(369, 291, 6, NULL, NULL),
(370, 305, 6, NULL, NULL),
(371, 306, 6, NULL, NULL),
(372, 307, 6, NULL, NULL),
(373, 270, 6, NULL, NULL),
(374, 275, 6, NULL, NULL),
(375, 276, 6, NULL, NULL),
(376, 277, 6, NULL, NULL),
(377, 278, 6, NULL, NULL),
(378, 336, 6, NULL, NULL),
(383, 285, 7, NULL, NULL),
(384, 286, 7, NULL, NULL),
(385, 288, 7, NULL, NULL),
(386, 289, 7, NULL, NULL),
(387, 279, 7, NULL, NULL),
(388, 280, 7, NULL, NULL),
(389, 281, 7, NULL, NULL),
(390, 337, 7, NULL, NULL),
(391, 338, 7, NULL, NULL),
(392, 339, 7, NULL, NULL),
(393, 267, 7, NULL, NULL),
(394, 268, 7, NULL, NULL),
(398, 329, 8, NULL, NULL),
(399, 330, 8, NULL, NULL),
(400, 331, 8, NULL, NULL),
(401, 317, 8, NULL, NULL),
(402, 318, 8, NULL, NULL),
(403, 319, 8, NULL, NULL),
(404, 320, 8, NULL, NULL),
(405, 282, 8, NULL, NULL),
(406, 283, 8, NULL, NULL),
(407, 286, 8, NULL, NULL),
(408, 290, 8, NULL, NULL),
(409, 291, 8, NULL, NULL),
(410, 292, 8, NULL, NULL),
(411, 293, 8, NULL, NULL),
(412, 294, 8, NULL, NULL),
(413, 295, 8, NULL, NULL),
(414, 296, 8, NULL, NULL),
(415, 297, 8, NULL, NULL),
(416, 298, 8, NULL, NULL),
(417, 299, 8, NULL, NULL),
(418, 300, 8, NULL, NULL),
(419, 301, 8, NULL, NULL),
(420, 302, 8, NULL, NULL),
(421, 303, 8, NULL, NULL),
(422, 255, 8, NULL, NULL),
(423, 256, 8, NULL, NULL),
(424, 257, 8, NULL, NULL),
(425, 258, 8, NULL, NULL),
(426, 305, 8, NULL, NULL),
(427, 306, 8, NULL, NULL),
(428, 307, 8, NULL, NULL),
(429, 308, 8, NULL, NULL),
(430, 309, 8, NULL, NULL),
(431, 310, 8, NULL, NULL),
(432, 311, 8, NULL, NULL),
(433, 312, 8, NULL, NULL),
(434, 313, 8, NULL, NULL),
(435, 314, 8, NULL, NULL),
(436, 315, 8, NULL, NULL),
(437, 316, 8, NULL, NULL),
(438, 259, 8, NULL, NULL),
(439, 260, 8, NULL, NULL),
(440, 261, 8, NULL, NULL),
(441, 262, 8, NULL, NULL),
(442, 263, 8, NULL, NULL),
(443, 321, 8, NULL, NULL),
(444, 322, 8, NULL, NULL),
(445, 323, 8, NULL, NULL),
(446, 324, 8, NULL, NULL),
(447, 325, 8, NULL, NULL),
(448, 269, 8, NULL, NULL),
(449, 270, 8, NULL, NULL),
(450, 271, 8, NULL, NULL),
(451, 272, 8, NULL, NULL),
(452, 273, 8, NULL, NULL),
(453, 274, 8, NULL, NULL),
(454, 275, 8, NULL, NULL),
(455, 276, 8, NULL, NULL),
(456, 277, 8, NULL, NULL),
(457, 278, 8, NULL, NULL),
(458, 279, 8, NULL, NULL),
(459, 280, 8, NULL, NULL),
(460, 281, 8, NULL, NULL),
(461, 334, 8, NULL, NULL),
(462, 335, 8, NULL, NULL),
(463, 336, 8, NULL, NULL),
(464, 338, 8, NULL, NULL),
(465, 339, 8, NULL, NULL),
(466, 264, 8, NULL, NULL),
(467, 265, 8, NULL, NULL),
(468, 266, 8, NULL, NULL),
(469, 267, 8, NULL, NULL),
(470, 268, 8, NULL, NULL),
(525, 317, 9, NULL, NULL),
(526, 318, 9, NULL, NULL),
(527, 319, 9, NULL, NULL),
(528, 320, 9, NULL, NULL),
(529, 282, 9, NULL, NULL),
(530, 283, 9, NULL, NULL),
(531, 284, 9, NULL, NULL),
(532, 285, 9, NULL, NULL),
(533, 286, 9, NULL, NULL),
(534, 287, 9, NULL, NULL),
(535, 288, 9, NULL, NULL),
(536, 289, 9, NULL, NULL),
(537, 290, 9, NULL, NULL),
(538, 291, 9, NULL, NULL),
(539, 292, 9, NULL, NULL),
(540, 293, 9, NULL, NULL),
(541, 294, 9, NULL, NULL),
(542, 295, 9, NULL, NULL),
(543, 296, 9, NULL, NULL),
(544, 297, 9, NULL, NULL),
(545, 298, 9, NULL, NULL),
(546, 299, 9, NULL, NULL),
(547, 300, 9, NULL, NULL),
(548, 301, 9, NULL, NULL),
(549, 302, 9, NULL, NULL),
(550, 303, 9, NULL, NULL),
(551, 255, 9, NULL, NULL),
(552, 256, 9, NULL, NULL),
(553, 257, 9, NULL, NULL),
(554, 258, 9, NULL, NULL),
(555, 305, 9, NULL, NULL),
(556, 306, 9, NULL, NULL),
(557, 307, 9, NULL, NULL),
(558, 308, 9, NULL, NULL),
(559, 309, 9, NULL, NULL),
(560, 310, 9, NULL, NULL),
(561, 311, 9, NULL, NULL),
(562, 312, 9, NULL, NULL),
(563, 313, 9, NULL, NULL),
(564, 314, 9, NULL, NULL),
(565, 315, 9, NULL, NULL),
(566, 259, 9, NULL, NULL),
(567, 260, 9, NULL, NULL),
(568, 270, 9, NULL, NULL),
(569, 271, 9, NULL, NULL),
(570, 272, 9, NULL, NULL),
(571, 273, 9, NULL, NULL),
(572, 274, 9, NULL, NULL),
(573, 275, 9, NULL, NULL),
(574, 276, 9, NULL, NULL),
(575, 277, 9, NULL, NULL),
(576, 278, 9, NULL, NULL),
(577, 279, 9, NULL, NULL),
(578, 280, 9, NULL, NULL),
(579, 281, 9, NULL, NULL),
(580, 334, 9, NULL, NULL),
(581, 335, 9, NULL, NULL),
(582, 336, 9, NULL, NULL),
(583, 337, 9, NULL, NULL),
(584, 338, 9, NULL, NULL),
(585, 339, 9, NULL, NULL),
(586, 340, 9, NULL, NULL),
(588, 269, 10, NULL, NULL),
(589, 270, 10, NULL, NULL),
(590, 271, 10, NULL, NULL),
(591, 272, 10, NULL, NULL),
(592, 273, 10, NULL, NULL),
(593, 274, 10, NULL, NULL),
(594, 275, 10, NULL, NULL),
(595, 276, 10, NULL, NULL),
(596, 277, 10, NULL, NULL),
(597, 278, 10, NULL, NULL),
(598, 279, 10, NULL, NULL),
(599, 280, 10, NULL, NULL),
(600, 281, 10, NULL, NULL),
(601, 264, 10, NULL, NULL),
(602, 265, 10, NULL, NULL),
(603, 266, 10, NULL, NULL),
(604, 267, 10, NULL, NULL),
(605, 268, 10, NULL, NULL),
(619, 269, 11, NULL, NULL),
(621, 329, 21, NULL, NULL),
(622, 330, 21, NULL, NULL),
(623, 331, 21, NULL, NULL),
(624, 317, 21, NULL, NULL),
(625, 318, 21, NULL, NULL),
(626, 319, 21, NULL, NULL),
(627, 320, 21, NULL, NULL),
(628, 282, 21, NULL, NULL),
(629, 283, 21, NULL, NULL),
(630, 284, 21, NULL, NULL),
(631, 285, 21, NULL, NULL),
(632, 286, 21, NULL, NULL),
(633, 287, 21, NULL, NULL),
(634, 288, 21, NULL, NULL),
(635, 289, 21, NULL, NULL),
(636, 290, 21, NULL, NULL),
(637, 291, 21, NULL, NULL),
(638, 292, 21, NULL, NULL),
(639, 293, 21, NULL, NULL),
(640, 294, 21, NULL, NULL),
(641, 295, 21, NULL, NULL),
(642, 296, 21, NULL, NULL),
(643, 297, 21, NULL, NULL),
(644, 298, 21, NULL, NULL),
(645, 299, 21, NULL, NULL),
(646, 300, 21, NULL, NULL),
(647, 301, 21, NULL, NULL),
(648, 302, 21, NULL, NULL),
(649, 303, 21, NULL, NULL),
(650, 255, 21, NULL, NULL),
(651, 256, 21, NULL, NULL),
(652, 257, 21, NULL, NULL),
(653, 258, 21, NULL, NULL),
(654, 305, 21, NULL, NULL),
(655, 306, 21, NULL, NULL),
(656, 307, 21, NULL, NULL),
(657, 308, 21, NULL, NULL),
(658, 309, 21, NULL, NULL),
(659, 310, 21, NULL, NULL),
(660, 311, 21, NULL, NULL),
(661, 312, 21, NULL, NULL),
(662, 313, 21, NULL, NULL),
(663, 314, 21, NULL, NULL),
(664, 315, 21, NULL, NULL),
(665, 316, 21, NULL, NULL),
(666, 259, 21, NULL, NULL),
(667, 260, 21, NULL, NULL),
(668, 261, 21, NULL, NULL),
(669, 262, 21, NULL, NULL),
(670, 263, 21, NULL, NULL),
(671, 321, 21, NULL, NULL),
(672, 322, 21, NULL, NULL),
(673, 323, 21, NULL, NULL),
(674, 324, 21, NULL, NULL),
(675, 325, 21, NULL, NULL),
(676, 269, 21, NULL, NULL),
(677, 270, 21, NULL, NULL),
(678, 271, 21, NULL, NULL),
(679, 272, 21, NULL, NULL),
(680, 273, 21, NULL, NULL),
(681, 274, 21, NULL, NULL),
(682, 275, 21, NULL, NULL),
(683, 276, 21, NULL, NULL),
(684, 277, 21, NULL, NULL),
(685, 278, 21, NULL, NULL),
(686, 279, 21, NULL, NULL),
(687, 280, 21, NULL, NULL),
(688, 281, 21, NULL, NULL),
(689, 334, 21, NULL, NULL),
(690, 335, 21, NULL, NULL),
(691, 336, 21, NULL, NULL),
(692, 337, 21, NULL, NULL),
(693, 338, 21, NULL, NULL),
(694, 339, 21, NULL, NULL),
(695, 340, 21, NULL, NULL),
(696, 326, 21, NULL, NULL),
(697, 327, 21, NULL, NULL),
(698, 264, 21, NULL, NULL),
(699, 265, 21, NULL, NULL),
(700, 267, 21, NULL, NULL),
(701, 268, 21, NULL, NULL),
(748, 329, 22, NULL, NULL),
(749, 295, 22, NULL, NULL),
(750, 299, 22, NULL, NULL),
(751, 259, 22, NULL, NULL),
(752, 260, 22, NULL, NULL),
(753, 262, 22, NULL, NULL),
(754, 263, 22, NULL, NULL),
(755, 321, 22, NULL, NULL),
(756, 325, 22, NULL, NULL),
(757, 272, 22, NULL, NULL),
(758, 273, 22, NULL, NULL),
(759, 274, 22, NULL, NULL),
(760, 280, 22, NULL, NULL),
(761, 334, 22, NULL, NULL),
(762, 335, 22, NULL, NULL),
(763, 336, 22, NULL, NULL),
(764, 264, 22, NULL, NULL),
(765, 265, 22, NULL, NULL),
(766, 266, 22, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `creditcards_02062025`
--

CREATE TABLE `creditcards_02062025` (
  `idcreditcards` int(11) NOT NULL DEFAULT 0,
  `creditcardscode` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `creditcardsname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `creditcardsDetails` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `idcardtypes` int(11) NOT NULL,
  `idbanks` int(11) NOT NULL,
  `creditcardsimageid` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `creditcardsimagelocation` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `creditcardsimagename` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `MinimumSalary` decimal(10,0) DEFAULT NULL,
  `AnnualFee` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `creditcards_02062025`
--

INSERT INTO `creditcards_02062025` (`idcreditcards`, `creditcardscode`, `creditcardsname`, `creditcardsDetails`, `idcardtypes`, `idbanks`, `creditcardsimageid`, `creditcardsimagelocation`, `creditcardsimagename`, `MinimumSalary`, `AnnualFee`) VALUES
(2, 'AAD', 'Ajman Bank ULTRACASH Mastercard Touch Card', 'Ajman Bank ULTRACASH Mastercard Touch Card', 1, 4, NULL, NULL, 'Ajman_Bank_ULTRACASH_Mastercard_Touch_Card.webp', 10, 'AED 300'),
(3, 'AAD', 'Ajman Bank BRight World Credit Card', 'Ajman Bank BRight World Credit Card', 1, 4, NULL, NULL, 'Ajman_Bank_BRight_World_Credit_Card.webp', 20, 'AED 1500'),
(4, 'AAD', 'Ajman Bank BRight Platinum Credit Card', 'Ajman Bank BRight Platinum Credit Card', 1, 4, NULL, NULL, 'Ajman_Bank_BRight_Platinum_Credit_Card.webp', 10, 'AED 1000'),
(5, 'AAD', 'Ajman Bank BRight Titanium Credit Card', 'Ajman Bank BRight Titanium Credit Card', 1, 4, NULL, NULL, 'Ajman_Bank_BRight_Titanium_Credit_Card.webp', 5, 'Free for Life'),
(6, 'AAD', 'CBD Visa Infinite Credit Card', 'CBD Visa Infinite Credit Card', 1, 8, NULL, NULL, 'CBD_Visa_Infinite_Credit_Card.webp', 15, 'Free for first year'),
(7, 'AAD', 'CBD Super Saver Credit Card', 'CBD Super Saver Credit Card', 1, 8, NULL, NULL, 'CBD_Super_Saver_Credit_Card.webp', 5, 'Free for first year'),
(8, 'AAD', 'CBD One Credit Card', 'CBD One Credit Card', 1, 8, NULL, NULL, 'CBD_One_Credit_Card.webp', 5, 'Free for Life'),
(9, 'AAD', 'CBD Yes Rewards Credit Card', 'CBD Yes Rewards Credit Card', 1, 8, NULL, NULL, 'CBD_Yes_Rewards_Credit_Card.webp', 5, 'Free For First year'),
(10, 'AAD', 'CBD Visa Smiles Signature Credit Card', 'CBD Visa Smiles Signature Credit Card', 1, 8, NULL, NULL, 'CBD_Visa_Smiles_Signature_Credit_Card.webp', 5, 'F Y F then AED 199'),
(11, 'AAD', 'DIB SHAMS Infinite Covered Card', 'DIB SHAMS Infinite Covered Card', 1, 9, NULL, NULL, 'DIB_SHAMS_Infinite_Covered_Card.webp', 50, 'Free for 1st year'),
(12, 'AAD', 'DIB SHAMS Signature Covered Card', 'DIB SHAMS Signature Covered Card', 1, 9, NULL, NULL, 'DIB_SHAMS_Signature_Covered_Card.webp', NULL, 'Free for 1st year'),
(13, 'AAD', 'DIB SHAMS Platinum Covered Card', 'DIB SHAMS Platinum Covered Card', 1, 9, NULL, NULL, 'DIB_SHAMS_Platinum_Covered_Card.webp', 0, 'Free for 1st year'),
(14, 'AAD', 'The Emirates Skywards DIB Infinite Covered Card', 'The Emirates Skywards DIB Infinite Covered Card', 1, 9, NULL, NULL, 'The_Emirates_Skywards_DIB_Infinite_Covered_Card.webp', NULL, NULL),
(15, 'AAD', 'The Emirates Skywards DIB Signature Covered Card', 'The Emirates Skywards DIB Signature Covered Card', 1, 9, NULL, NULL, 'The_Emirates_Skywards_DIB_Signature_Covered_Card.webp', NULL, NULL),
(16, 'AAD', 'The Emirates Skywards DIB Platinum Covered Card', 'The Emirates Skywards DIB Platinum Covered Card', 1, 9, NULL, NULL, 'The_Emirates_Skywards_DIB_Platinum_Covered_Card.webp', NULL, NULL),
(17, 'AAD', 'Emirates Islamic Emarati Credit Card', 'Emirates Islamic Emarati Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_Emarati_Credit_Card.webp', 12, 'No Annual fee'),
(18, 'AAD', 'Emirates Islamic Flex Elite Credit Card', 'Emirates Islamic Flex Elite Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_Flex_Elite_Credit_Card.webp', 15, '735'),
(19, 'AAD', 'Emirates Islamic RTA Credit Card', 'Emirates Islamic RTA Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_RTA_Credit_Card.webp', 5, 'No Annual Fee'),
(20, 'AAD', 'Emirates Islamic Cashback Credit Card', 'Emirates Islamic Cashback Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_Cashback_Credit_Card.webp', 5, 'No AMF for first year*'),
(21, 'AAD', 'Emirates Islamic Cashback Plus Credit Card', 'Emirates Islamic Cashback Plus Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_Cashback_Plus_Credit_Card.webp', 12, 'No AMF for first year*'),
(22, 'AAD', 'Emirates Islamic Switch Cashback Credit Card', 'Emirates Islamic Switch Cashback Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_Switch_Cashback_Credit_Card.webp', 5, 'Free for First Year'),
(23, 'AAD', 'Emirates Islamic Etihad Guest Premium Credit Card', 'Emirates Islamic Etihad Guest Premium Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_Etihad_Guest_Premium_Credit_Card.webp', 20, 'No AMF for first year*'),
(24, 'AAD', 'Emirates Islamic Etihad Guest Saqer Credit Card', 'Emirates Islamic Etihad Guest Saqer Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_Etihad_Guest_Saqer_Credit_Card.webp', 12, 'No AMF for first year*'),
(25, 'AAD', 'Emirates Islamic Etihad Guest Ameera Credit Card', 'Emirates Islamic Etihad Guest Ameera Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_Etihad_Guest_Ameera_Credit_Card.webp', NULL, 'No AMF for first year*'),
(26, 'AAD', 'Emirates Islamic Etihad Guest Platinum Credit Card', 'Emirates Islamic Etihad Guest Platinum Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_Etihad_Guest_Platinum_Credit_Card.webp', 5, 'No AMF for first year* '),
(27, 'AAD', 'Emirates Islamic Skywards Black Credit Card', 'Emirates Islamic Skywards Black Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_Skywards_Black_Credit_Card.webp', 35, 'AED 2k or AED 3.5K'),
(28, 'AAD', 'Emirates Islamic Skywards Infinite Credit Card', 'Emirates Islamic Skywards Infinite Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_Skywards_Infinite_Credit_Card.webp', 20, 'AED 2K'),
(29, 'AAD', 'Emirates Islamic Skywards Signature Credit Card', 'Emirates Islamic Skywards Signature Credit Card', 1, 11, NULL, NULL, 'Emirates_Islamic_Skywards_Signature_Credit_Card.webp', 12, 'AED 700'),
(30, 'AAD', 'Emirates NBD Duo Credit Card', 'Emirates NBD Duo Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Duo_Credit_Card.webp', 10, 'Free For Life'),
(31, 'AAD', 'Emirates NBD Lulu 247 Platinum Credit Card', 'Emirates NBD Lulu 247 Platinum Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Lulu_247_Platinum_Credit_Card.webp', 15, 'AED 250'),
(32, 'AAD', 'Emirates NBD Lulu 247 Titanium Credit Card', 'Emirates NBD Lulu 247 Titanium Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Lulu_247_Titanium_Credit_Card.webp', 5, 'Free For Life'),
(33, 'AAD', 'Emirates NBD Skywards Signature Credit Card', 'Emirates NBD Skywards Signature Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Skywards_Signature_Credit_Card.webp', 12, 'AED 735'),
(34, 'AAD', 'Emirates NBD Skywards Infinite Credit Card', 'Emirates NBD Skywards Infinite Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Skywards_Infinite_Credit_Card.webp', 30, 'AED 1575'),
(35, 'AAD', 'Emirates NBD VISA Infinite Credit Card', 'Emirates NBD VISA Infinite Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_VISA_Infinite_Credit_Card.webp', 30, 'AED 1575'),
(36, 'AAD', 'Emirates NBD Dnata World Credit Card', 'Emirates NBD Dnata World Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Dnata_World_Credit_Card.webp', 20, 'AED 1049'),
(37, 'AAD', 'Emirates NBD Dnata Platinum Credit Card', 'Emirates NBD Dnata Platinum Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Dnata_Platinum_Credit_Card.webp', 5, 'AED 525'),
(38, 'AAD', 'Emirates NBD Etihad Guest Visa Elevate', 'Emirates NBD Etihad Guest Visa Elevate', 1, 12, NULL, NULL, 'Emirates_NBD_Etihad_Guest_Visa_Elevate.webp', 30, 'AED 1575'),
(39, 'AAD', 'Emirates NBD Etihad Guest Visa Inspire', 'Emirates NBD Etihad Guest Visa Inspire', 1, 12, NULL, NULL, 'Emirates_NBD_Etihad_Guest_Visa_Inspire.webp', 12, 'AED 735'),
(40, 'AAD', 'Emirates NBD Mastercard Platinum Credit Card', 'Emirates NBD Mastercard Platinum Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Mastercard_Platinum_Credit_Card.webp', 12, ' No annual fee '),
(41, 'AAD', 'Emirates NBD Visa Platinum Credit Card', 'Emirates NBD Visa Platinum Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Visa_Platinum_Credit_Card.webp', 12, 'No Annual Fees'),
(42, 'AAD', 'Emirates NBD Mastercard Titanium Credit Card', 'Emirates NBD Mastercard Titanium Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Mastercard_Titanium_Credit_Card.webp', 5, 'No Annual Fees'),
(43, 'AAD', 'Emirates NBD Go4it Platinum Credit Card', 'Emirates NBD Go4it Platinum Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Go4it_Platinum_Credit_Card.webp', 12, 'No Annual Fees'),
(44, 'AAD', 'Emirates NBD Go4it Gold Credit Card', 'Emirates NBD Go4it Gold Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_Go4it_Gold_Credit_Card.webp', 5, 'No Annual Fees'),
(45, 'AAD', 'Emirates NBD U By Emaar Visa Family Card', 'Emirates NBD U By Emaar Visa Family Card', 1, 12, NULL, NULL, 'Emirates_NBD_U_By_Emaar_Visa_Family_Card.webp', 5, 'Free for Life'),
(46, 'AAD', 'Emirates NBD U By Emaar Visa Infinite', 'Emirates NBD U By Emaar Visa Infinite', 1, 12, NULL, NULL, 'Emirates_NBD_U_By_Emaar_Visa_Infinite.webp', 30, 'AED 1575'),
(47, 'AAD', 'Emirates NBD U By Emaar Signature Credit Card', 'Emirates NBD U By Emaar Signature Credit Card', 1, 12, NULL, NULL, 'Emirates_NBD_U_By_Emaar_Signature_Credit_Card.webp', 12, 'AED 262.50'),
(48, 'AAD', 'ENBD noon One Visa Credit card', 'ENBD noon One Visa Credit card', 1, 12, NULL, NULL, 'ENBD_noon_One_Visa_Credit_card.webp', 5, 'Free for Life'),
(49, 'AAD', 'FAB Etihad Guest Infinite Credit Card', 'FAB Etihad Guest Infinite Credit Card', 1, 13, NULL, NULL, 'FAB_Etihad_Guest_Infinite_Credit_Card.webp', 30, '2500'),
(50, 'AAD', 'FAB Etihad Guest Infinite Credit Card', 'FAB Etihad Guest Infinite Credit Card', 1, 13, NULL, NULL, 'FAB_Etihad_Guest_Infinite_Credit_Card.webp', 30, '2500'),
(51, 'AAD', 'FAB Etihad Guest Signature Credit Card', 'FAB Etihad Guest Signature Credit Card', 1, 13, NULL, NULL, 'FAB_Etihad_Guest_Signature_Credit_Card.webp', 15, '1500'),
(52, 'AAD', 'FAB Etihad Guest Platinum Credit Card', 'FAB Etihad Guest Platinum Credit Card', 1, 13, NULL, NULL, 'FAB_Etihad_Guest_Platinum_Credit_Card.webp', 8, '500'),
(53, 'AAD', 'FAB Travel Card world Elite', 'FAB Travel Card world Elite', 1, 13, NULL, NULL, 'FAB_Travel_Card_world_Elite.webp', 25, '1500'),
(54, 'AAD', 'FAB Cashback Credit Card', 'FAB Cashback Credit Card', 1, 13, NULL, NULL, 'FAB_Cashback_Credit_Card.webp', 5, '300'),
(55, 'AAD', 'FAB du Titanium Credit Card', 'FAB du Titanium Credit Card', 1, 13, NULL, NULL, 'FAB_du_Titanium_Credit_Card.webp', 5, 'No Annual fee'),
(56, 'AAD', 'FAB GEMS World Credit Card', 'FAB GEMS World Credit Card', 1, 13, NULL, NULL, 'FAB_GEMS_World_Credit_Card.webp', 8, 'AED 399'),
(57, 'AAD', 'BLUE FAB Infinite Credit Card by Al-Futtaim', 'BLUE FAB Infinite Credit Card by Al-Futtaim', 1, 13, NULL, NULL, 'BLUE_FAB_Infinite_Credit_Card_by_Al-Futtaim.webp', 40, 'No Annual Fees'),
(58, 'AAD', 'BLUE FAB Signature Credit Card by Al-Futtaim', 'BLUE FAB Signature Credit Card by Al-Futtaim', 1, 13, NULL, NULL, 'BLUE_FAB_Signature_Credit_Card_by_Al-Futtaim.webp', 15, 'Free For Life'),
(59, 'AAD', 'BLUE FAB Platinum Credit Card by Al-Futtaim', 'BLUE FAB Platinum Credit Card by Al-Futtaim', 1, 13, NULL, NULL, 'BLUE_FAB_Platinum_Credit_Card_by_Al-Futtaim.webp', 8, 'Free For Life'),
(60, 'AAD', 'FAB SHARE Signature Credit Card', 'FAB SHARE Signature Credit Card', 1, 13, NULL, NULL, 'FAB_SHARE_Signature_Credit_Card.webp', 30, '1500'),
(61, 'AAD', 'FAB SHARE Platinum Credit Card', 'FAB SHARE Platinum Credit Card', 1, 13, NULL, NULL, 'FAB_SHARE_Platinum_Credit_Card.webp', 10, '1000'),
(62, 'AAD', 'FAB SHARE Standard Credit Card', 'FAB SHARE Standard Credit Card', 1, 13, NULL, NULL, 'FAB_SHARE_Standard_Credit_Card.webp', 5, 'No Annual Fees'),
(63, 'AAD', 'FAB Elite Credit Card', 'FAB Elite Credit Card', 1, 13, NULL, NULL, 'FAB_Elite_Credit_Card.webp', 50, 'Free for First year- 1200'),
(64, 'AAD', 'FAB Rewards Indulge Card', 'FAB Rewards Indulge Card', 1, 13, NULL, NULL, 'FAB_Rewards_Indulge_Card.webp', 5, 'No Annual Fee'),
(65, 'AAD', 'Mashreq Cashback Credit Card', 'Mashreq Cashback Credit Card', 1, 15, NULL, NULL, 'Mashreq_Cashback_Credit_Card.webp', 5, 'Free for life'),
(66, 'AAD', 'Mashreq Noon Credit Card', 'Mashreq Noon Credit Card', 1, 15, NULL, NULL, 'Mashreq_Noon_Credit_Card.webp', 5, 'Free for life'),
(67, 'AAD', 'Mashreq Platinum Elite Credit Card', 'Mashreq Platinum Elite Credit Card', 1, 15, NULL, NULL, 'Mashreq_Platinum_Elite_Credit_Card.webp', 7, 'AED 650 + VAT'),
(68, 'AAD', 'Mashreq Solitaire Credit card', 'Mashreq Solitaire Credit card', 1, 15, NULL, NULL, 'Mashreq_Solitaire_Credit_card.webp', 25, 'AED 1500 + VAT'),
(69, 'AAD', 'RAK Bank World Credit Card', 'RAK Bank World Credit Card', 1, 17, NULL, NULL, 'RAK_Bank_World_Credit_Card.webp', 20, 'FYF then 950'),
(70, 'AAD', 'RAK Bank Titanium Credit Card', 'RAK Bank Titanium Credit Card', 1, 17, NULL, NULL, 'RAK_Bank_Titanium_Credit_Card.webp', 8, 'Free for Life'),
(71, 'AAD', 'RAK Bank Air Arabia Platinum Credit Card', 'RAK Bank Air Arabia Platinum Credit Card', 1, 17, NULL, NULL, 'RAK_Bank_Air_Arabia_Platinum_Credit_Card.webp', 5, 'AED 420*'),
(72, 'AAD', 'RAK Bank RED Credit Card', 'RAK Bank RED Credit Card', 1, 17, NULL, NULL, 'RAK_Bank_RED_Credit_Card.webp', 5, 'Free for Life'),
(73, 'AAD', 'RAK Bank Elevate credit card ', 'RAK Bank Elevate credit card ', 1, 17, NULL, NULL, 'RAK_Bank_Elevate_credit_card_.webp', 35, 'Spend base'),
(74, 'AAD', 'NBQ Infinite Credit Card', 'NBQ Infinite Credit Card', 1, 18, NULL, NULL, 'NBQ_Infinite_Credit_Card.webp', 30, 'AED 1000'),
(75, 'AAD', 'NBQ Platinum Credit Card', 'NBQ Platinum Credit Card', 1, 18, NULL, NULL, 'NBQ_Platinum_Credit_Card.webp', 15, 'AED 500'),
(76, 'AAD', 'NBQ Gold Credit Card', 'NBQ Gold Credit Card', 1, 18, NULL, NULL, 'NBQ_Gold_Credit_Card.webp', 8, 'Free for life'),
(77, 'AAD', 'Deem Titanium card', 'Deem Titanium card', 1, 21, NULL, NULL, 'Deem_Titanium_card.webp', 5, 'Free for first year'),
(78, 'AAD', 'Deem Platinum Card', 'Deem Platinum Card', 1, 21, NULL, NULL, 'Deem_Platinum_Card.webp', 10, 'Free for life'),
(79, 'AAD', 'Deem World Card', 'Deem World Card', 1, 21, NULL, NULL, 'Deem_World_Card.webp', 25, 'Free for life'),
(80, 'AAD', 'Dubai First Cashback card', 'Dubai First Cashback card', 1, 22, NULL, NULL, 'Dubai_First_Cashback_card.webp', 5, 'Free for first year'),
(81, 'AAD', 'Dubai First Slice pay card', 'Dubai First Slice pay card', 1, 22, NULL, NULL, 'Dubai_First_Slice_pay_card.webp', 5, 'Free for first year'),
(82, 'AAD', 'HSBC Cash+ Credit Card', 'HSBC Cash+ Credit Card', 1, 23, NULL, NULL, 'HSBC_Cash+_Credit_Card.webp', 30, 'Free for 1st  Year-then 1000'),
(83, 'AAD', 'HSBC Live+ Credit Card', 'HSBC Live+ Credit Card', 1, 23, NULL, NULL, 'HSBC_Live+_Credit_Card.webp', 5, 'Free for 1st  Year*'),
(84, 'AAD', 'HSBC Max Rewards Credit Card', 'HSBC Max Rewards Credit Card', 1, 23, NULL, NULL, 'HSBC_Max_Rewards_Credit_Card.webp', 10, 'Free for 1st  Year'),
(85, 'AAD', 'HSBC Emirates Skywards Infinite Credit Card', 'HSBC Emirates Skywards Infinite Credit Card', 1, 23, NULL, NULL, 'HSBC_Emirates_Skywards_Infinite_Credit_Card.webp', 30, 'AED 2,500'),
(86, 'AAD', 'HSBC Emirates Skywards Signature Credit Card', 'HSBC Emirates Skywards Signature Credit Card', 1, 23, NULL, NULL, 'HSBC_Emirates_Skywards_Signature_Credit_Card.webp', 10, 'AED 1,000'),
(87, 'AAD', 'Liv Bank Cashback Credit Card', 'Liv Bank Cashback Credit Card', 1, 24, NULL, NULL, 'Liv_Bank_Cashback_Credit_Card.webp', 5, 'Free for life'),
(88, 'AAD', 'Liv Bank Cashback Plus Credit Card', 'Liv Bank Cashback Plus Credit Card', 1, 24, NULL, NULL, 'Liv_Bank_Cashback_Plus_Credit_Card.webp', 10, 'AED 700');

-- --------------------------------------------------------

--
-- Table structure for table `feturenew_transformed`
--

CREATE TABLE `feturenew_transformed` (
  `CARD_name` varchar(50) DEFAULT NULL,
  `Short_Features` varchar(117) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `feturenew_transformed`
--

INSERT INTO `feturenew_transformed` (`CARD_name`, `Short_Features`) VALUES
('Deem Mastercard Titanium Cash Up Credit Card', '50% off on VOX cinema'),
('Deem Mastercard Titanium Cash Up Credit Card', '20% off grocery or food order on the Talabat'),
('Deem Mastercard Titanium Cash Up Credit Card', '3% unlimited Cash Up on fuel'),
('Deem Mastercard Titanium Cash Up Credit Card', '3% unlimited Cash Up on online shopping'),
('Deem Mastercard Platinum Cash Up Credit Card', 'Cinema offers on VOX and REEL and much more'),
('Deem Mastercard Platinum Cash Up Credit Card', 'Valet Parking'),
('Deem Mastercard Platinum Cash Up Credit Card', 'Dining Offers'),
('Deem Mastercard Platinum Cash Up Credit Card', 'Balance Transfer'),
('Deem Mastercard Platinum Cash Up Credit Card', 'Airport Lounge Access'),
('Deem Mastercard World Miles Up Credit Card', '50% off on VOX cinema'),
('Deem Mastercard World Miles Up Credit Card', 'Miles Up benefit'),
('Deem Mastercard World Miles Up Credit Card', 'Free Valet parking'),
('Deem Mastercard World Miles Up Credit Card', 'Earn up to 10% cash up on specific categories'),
('Deem Mastercard World Miles Up Credit Card', '20% off grocery or food order on the Talabat'),
('Dubai First Cashback card', '5% cashback on supermarket spending, dining and fuel, 3% on international spends and 1% on other purchases.'),
('Dubai First Cashback card', '5% cashback on online purchases, utility bills, school fees'),
('Dubai First Cashback card', 'Get 20% off talabat delivery'),
('Dubai First Cashback card', 'Unlimited Airport Lounge access'),
('Dubai First Cashback card', '20% off on Careem rides'),
('Dubai First Cashback card', '0% interest rate at quick cash & Balance transfer'),
('Dubai First Cashback card', 'Enjoy Movies at AED 20 only'),
('Dubai First Slice pay card', 'Interest Free installment'),
('Dubai First Slice pay card', 'Digital Card'),
('Dubai First Slice pay card', 'No processing fees on installment'),
('Mashreq Cashback Credit Card', 'Travel Insurance'),
('Mashreq Cashback Credit Card', 'Free for Life'),
('Mashreq Cashback Credit Card', 'Extended Warranty'),
('Mashreq Cashback Credit Card', '5% cashback on dining'),
('Mashreq Noon Credit Card', 'Free for Life credit card'),
('Mashreq Noon Credit Card', 'AED 500 Welcome bonus'),
('Mashreq Noon Credit Card', 'Instant Digital Card'),
('Mashreq Noon Credit Card', 'Free noon delivery'),
('Mashreq Platinum Elite Credit Card', 'Travel Insurance'),
('Mashreq Platinum Elite Credit Card', 'Free Airport transfer'),
('Mashreq Platinum Elite Credit Card', 'Up to 5 Vantage points per 1 AED'),
('Mashreq Platinum Elite Credit Card', 'Get 50% off at selected Restaurants, Spa, Entertainment'),
('Mashreq Solitaire Credit card', '50% discount on movie tickets'),
('Mashreq Solitaire Credit card', 'Golf Benefits'),
('Mashreq Solitaire Credit card', 'Travel Insurance'),
('Mashreq Solitaire Credit card', 'Earn 1 Salaam Point on local spends.'),
('Mashreq Solitaire Credit card', 'Earn 6 Salaam points on International spends.'),
('Emirates NBD Duo Credit Card', 'Free for Life'),
('Emirates NBD Duo Credit Card', 'Concierge services'),
('Emirates NBD Duo Credit Card', 'Access to golf courses across the UAE'),
('Emirates NBD Duo Credit Card', 'Buy 1 Get 1’ offers on movie tickets with Royal Cinemas'),
('Emirates NBD Duo Credit Card', 'Earn Plus Points on spend - 5% rewards on grocery, electronics, utilities, education and fuel'),
('Emirates NBD Lulu 247 Platinum Credit Card', '0% Balance Transfer'),
('Emirates NBD Lulu 247 Platinum Credit Card', '4% on fuel spends'),
('Emirates NBD Lulu 247 Platinum Credit Card', 'Free concierge services'),
('Emirates NBD Lulu 247 Platinum Credit Card', 'Exclusive benefits & offers at Lulu stores & online'),
('Emirates NBD Lulu 247 Titanium Credit Card', 'Priority checkout'),
('Emirates NBD Lulu 247 Titanium Credit Card', 'Early access to major sales and promotions'),
('Emirates NBD Lulu 247 Titanium Credit Card', 'Monthly discount and exclusive offers'),
('Emirates NBD Lulu 247 Titanium Credit Card', 'Free shipping on Lulu online'),
('Emirates NBD Skywards Signature Credit Card', 'Access to top golfing courses'),
('Emirates NBD Skywards Signature Credit Card', 'Buy 1 get 1 free on movies'),
('Emirates NBD Skywards Signature Credit Card', 'Valet parking in Abu Dhabi'),
('Emirates NBD Skywards Signature Credit Card', 'Get up to 1.5 Skywards Miles/USD'),
('Emirates NBD Skywards Infinite Credit Card', 'Welcome bonus of 100,000 skywards miles'),
('Emirates NBD Skywards Infinite Credit Card', 'Access to golf courses'),
('Emirates NBD Skywards Infinite Credit Card', 'Valet Parking'),
('Emirates NBD Skywards Infinite Credit Card', 'Movies offer'),
('Emirates NBD Skywards Infinite Credit Card', 'Multi-trip travel insurance'),
('Emirates NBD VISA Infinite Credit Card', 'Valet Parking'),
('Emirates NBD VISA Infinite Credit Card', 'Airport Transfer'),
('Emirates NBD VISA Infinite Credit Card', 'Travel Insurance'),
('Emirates NBD VISA Infinite Credit Card', 'Airport Lounge access'),
('Emirates NBD VISA Infinite Credit Card', 'Exclusive Movie Offers'),
('Emirates NBD Dnata World Credit Card', '15% rewards for spends at dnata Travel and Emirates Leisure'),
('Emirates NBD Dnata World Credit Card', '10% rewards for spends at MMI / Al Hamra Cellar and Le Clos'),
('Emirates NBD Dnata World Credit Card', '10% rewards for Duty Free Shopping worldwide'),
('Emirates NBD Dnata World Credit Card', '0% bank fee for foreign transactions'),
('Emirates NBD Dnata World Credit Card', 'Complimentary Airport lounge access to over 1000 lounges'),
('Emirates NBD Dnata Platinum Credit Card', '10% rewards for spends at dnata Travel and Emirates Leisure'),
('Emirates NBD Dnata Platinum Credit Card', '10% rewards for spends at MMI / Al Hamra Cellar and Le Clos'),
('Emirates NBD Dnata Platinum Credit Card', '10% rewards for Duty Free Shopping worldwide'),
('Emirates NBD Dnata Platinum Credit Card', 'Complimentary Airport lounge access to over 1000 lounges'),
('Emirates NBD Etihad Guest Visa Elevate', 'Welcome offer of up to 200,000 Etihad Guest Miles'),
('Emirates NBD Etihad Guest Visa Elevate', 'Premium lifestyle benefits - valet parking, cinema offers'),
('Emirates NBD Etihad Guest Visa Elevate', 'Premium travel offers - airport lounge, airport transfers'),
('Emirates NBD Etihad Guest Visa Elevate', 'Complimentary airport lounge access to over 1000 lounges'),
('Emirates NBD Etihad Guest Visa Elevate', 'Concierge services for your time-consuming errands'),
('Emirates NBD Etihad Guest Visa Inspire', 'Welcome offer of up to 60,000 Etihad Guest Miles'),
('Emirates NBD Etihad Guest Visa Inspire', 'High Etihad Miles earning rate on hotels, dining & Etihad'),
('Emirates NBD Etihad Guest Visa Inspire', 'Complimentary cinema tickets, golf access, valet parking'),
('Emirates NBD Etihad Guest Visa Inspire', 'Complimentary Airport lounge access'),
('Emirates NBD Mastercard Platinum Credit Card', 'Up to 1.5 points for every AED 100 spent'),
('Emirates NBD Mastercard Platinum Credit Card', 'Complimentary Airport Lounge Access'),
('Emirates NBD Mastercard Platinum Credit Card', 'Golf Privileges'),
('Emirates NBD Mastercard Platinum Credit Card', 'Up to 30% discount on Restaurants across the UAE'),
('Emirates NBD Mastercard Platinum Credit Card', 'Earn rewards on all domestic & international spends'),
('Emirates NBD Visa Platinum Credit Card', 'Up to 1.5 points for every AED 100 spent'),
('Emirates NBD Visa Platinum Credit Card', 'Free insurance for big purchases'),
('Emirates NBD Visa Platinum Credit Card', 'Valet Parking Service'),
('Emirates NBD Visa Platinum Credit Card', 'Up to 50% discount on health & fitness'),
('Emirates NBD Visa Platinum Credit Card', 'Golf Privileges'),
('Emirates NBD Mastercard Titanium Credit Card', 'Complimentary access to over 10 VIP Airport lounges'),
('Emirates NBD Mastercard Titanium Credit Card', 'Enjoy Master Card Buy 1 Get 1 offers'),
('Emirates NBD Mastercard Titanium Credit Card', 'Earn rewards on all domestic & international spends'),
('Emirates NBD Mastercard Titanium Credit Card', 'Exclusive offers and deals on travel, lifestyle & shopping'),
('Emirates NBD Mastercard Titanium Credit Card', 'Get up to 40% discount at over 100 golf courses worldwide'),
('Emirates NBD SHARE Visa Infinite Credit Card', 'Complimentary access to over 10 VIP Airport lounges'),
('Emirates NBD SHARE Visa Infinite Credit Card', 'Complimentary Travel Insurance'),
('Emirates NBD SHARE Visa Infinite Credit Card', 'Golf Privileges'),
('Emirates NBD SHARE Visa Infinite Credit Card', 'Valet parking'),
('Emirates NBD SHARE Visa Infinite Credit Card', 'Buy 1 get 1 free’ at VOX Cinemas'),
('Emirates NBD SHARE Visa Signature Credit Card', 'Complimentary access to over 10 VIP Airport lounges'),
('Emirates NBD SHARE Visa Signature Credit Card', 'Concierge Services'),
('Emirates NBD SHARE Visa Signature Credit Card', 'Free for Life'),
('Emirates NBD SHARE Visa Signature Credit Card', 'Buy 1 get 1 free’ at VOX Cinemas'),
('Emirates NBD SHARE Visa Platinum Credit Card', 'Free for Life'),
('Emirates NBD SHARE Visa Platinum Credit Card', 'Buy 1 get 1 free’ at VOX Cinemas'),
('Emirates NBD SHARE Visa Platinum Credit Card', '0% Easy Installment Plan'),
('Emirates NBD Darna Visa Infinite Credit Card', 'Buy 1 get 1 free’ at VOX Cinemas'),
('Emirates NBD Darna Visa Infinite Credit Card', 'Airport Lounge Access'),
('Emirates NBD Darna Visa Infinite Credit Card', 'Golf Privileges'),
('Emirates NBD Darna Visa Infinite Credit Card', 'Valet Parking'),
('Emirates NBD Darna Visa Infinite Credit Card', 'Complimentary Darna Platinum tier status'),
('Emirates NBD Darna Visa Signature Credit Card', 'Buy 1 get 1 free’ at VOX Cinemas'),
('Emirates NBD Darna Visa Signature Credit Card', 'Airport Lounge Access'),
('Emirates NBD Darna Visa Signature Credit Card', 'Free for first year'),
('Emirates NBD Darna Visa Signature Credit Card', 'Complimentary Darna Gold tier status'),
('Emirates NBD Darna Select Visa Credit Card', 'Buy 1 get 1 free’ at VOX Cinemas'),
('Emirates NBD Darna Select Visa Credit Card', 'Free for Life'),
('Emirates NBD Darna Select Visa Credit Card', 'Complimentary Darna Silver tier status'),
('Emirates NBD U By Emaar Infinite Credit Card', 'Airport Lounge Access'),
('Emirates NBD U By Emaar Infinite Credit Card', 'Buy 1 get 1 free at Reel Cinemas'),
('Emirates NBD U By Emaar Infinite Credit Card', 'Complimentary valet parking'),
('Emirates NBD U By Emaar Infinite Credit Card', 'Excellent discounts & offers at Emaar establishments'),
('Emirates NBD U By Emaar Infinite Credit Card', '7.5% U points on all Emaar spends'),
('Emirates NBD U By Emaar Signature Credit Card', 'Airport Lounge Access'),
('Emirates NBD U By Emaar Signature Credit Card', 'Buy 1 get 1 free’ at Reel Cinemas'),
('Emirates NBD U By Emaar Signature Credit Card', 'Excellent discounts & offers at Emaar establishments'),
('Emirates NBD U By Emaar Signature Credit Card', '6.25% U points on all Emaar spends'),
('Emirates NBD U By Emaar Signature Credit Card', 'Golf Privilege'),
('Emirates NBD U By Emaar Family Credit Card', 'Buy 1 get 1 free offer at Reel Cinemas'),
('Emirates NBD U By Emaar Family Credit Card', 'Excellent discounts & offers at Emaar establishments'),
('Emirates NBD U By Emaar Family Credit Card', '5% U points on all Emaar spends'),
('Emirates NBD U By Emaar Family Credit Card', 'Free for life'),
('Emirates NBD noon One Visa Credit card', 'Life time free Credit card'),
('Emirates NBD noon One Visa Credit card', 'AED 500 Welcome bonus'),
('Emirates NBD noon One Visa Credit card', 'Movies discount at VOX Cinemas'),
('Emirates NBD noon One Visa Credit card', 'Get 5% back as noon credits and flat 15% discount'),
('Emirates NBD noon One Visa Credit card', 'Get up to 20% back as noon credits when you order food'),
('Emirates NBD noon One Visa Credit card', 'Earn 10% back as noon credits on purchases.'),
('Ajman Bank ULTRACASH Mastercard Touch Card', '5% on school fees, supermarkets, and online shopping'),
('Ajman Bank ULTRACASH Mastercard Touch Card', 'Bonus Cashback'),
('Ajman Bank ULTRACASH Mastercard Touch Card', 'Airport lounge access'),
('Ajman Bank ULTRACASH Mastercard Touch Card', 'Up to 10% on fuel spending'),
('Ajman Bank BRight World Credit Card', 'FLY for FREE with Upfront 15,000 Complimentary BRight Rewards'),
('Ajman Bank BRight World Credit Card', '0% Foreign Transaction Fees'),
('Ajman Bank BRight World Credit Card', 'Complimentary Lounge Access'),
('Ajman Bank BRight World Credit Card', 'Earn up to 2.5 BRight Rewards for every AED 10 spend'),
('Ajman Bank BRight World Credit Card', 'Valet Parking 4 times a month at over 35 locations'),
('Ajman Bank BRight Platinum Credit Card', 'FLY for FREE with Upfront 10,000 Complimentary BRight Rewards'),
('Ajman Bank BRight Platinum Credit Card', '0% Foreign Transaction Fees'),
('Ajman Bank BRight Platinum Credit Card', 'Complimentary Lounge Access'),
('Ajman Bank BRight Platinum Credit Card', 'Earn up to 2 BRight Rewards for every AED 10 spend'),
('Ajman Bank BRight Platinum Credit Card', 'Valet Parking 3 times a month at over 35 locations'),
('Ajman Bank BRight Titanium Credit Card', 'Complimentary Lounge Access'),
('Ajman Bank BRight Titanium Credit Card', 'Earn up to 1 BRight Rewards for every AED 10 spend'),
('Ajman Bank BRight Titanium Credit Card', 'Valet Parking  at over 35 locations'),
('Ajman Bank BRight Titanium Credit Card', '0% off on Cleartrip'),
('FAB Etihad Guest Infinite Credit Card', 'Airport lounge access'),
('FAB Etihad Guest Infinite Credit Card', 'Fast track your Etihad Guest Gold membership'),
('FAB Etihad Guest Infinite Credit Card', 'Free inflight Wi-Fi voucher'),
('FAB Etihad Guest Infinite Credit Card', '75% Miles Discount Voucher'),
('FAB Etihad Guest Infinite Credit Card', 'A 55,000 Etihad Guest Miles bonus'),
('FAB Etihad Guest Signature Credit Card', 'Airport lounge access'),
('FAB Etihad Guest Signature Credit Card', 'Fast track your Etihad Guest Silver membership'),
('FAB Etihad Guest Signature Credit Card', 'Free inflight Wi-Fi voucher'),
('FAB Etihad Guest Signature Credit Card', '50% Miles Discount Voucher'),
('FAB Etihad Guest Signature Credit Card', 'A 35,000 Etihad Guest Miles bonus'),
('FAB Etihad Guest Platinum Credit Card', 'Cinema Discount'),
('FAB Etihad Guest Platinum Credit Card', 'Free Airport transfers'),
('FAB Etihad Guest Platinum Credit Card', '25% Miles Discount Voucher'),
('FAB Etihad Guest Platinum Credit Card', 'A 10,000 Etihad Guest Miles bonus'),
('FAB Travel Card world Elite', 'A free return flight every year'),
('FAB Travel Card world Elite', '12% cashback on all flight and hotel bookings'),
('FAB Travel Card world Elite', '0% foreign currency conversion fees'),
('FAB Travel Card world Elite', 'Free lounge access along with 2 guests'),
('FAB Cashback Credit Card', 'Save up to AED 1,000 each month'),
('FAB Cashback Credit Card', 'Get up to 5% cashback on fashion, dining out and grocery shopping'),
('FAB Cashback Credit Card', 'Get up to 3% cashback on international spending'),
('FAB Cashback Credit Card', 'Get up to 40% off MakeMyTrip bookings,'),
('FAB Cashback Credit Card', 'Free worldwide Airport lounge access'),
('FAB du Titanium Credit Card', 'No annual fee'),
('FAB du Titanium Credit Card', 'Airport lounge access'),
('FAB du Titanium Credit Card', 'Get Up to 12 Months 0% EPP'),
('FAB du Titanium Credit Card', '10% cashback on your du postpaid line bills'),
('FAB du Titanium Credit Card', '10% cashback on du home services bills'),
('FAB du Titanium Credit Card', '10% cashback on prepaid line recharges'),
('FAB du Titanium Credit Card', '10% cashback on your du smartphone Privilege Plan'),
('FAB GEMS World Credit Card', 'Save big on school and family expenses.'),
('FAB GEMS World Credit Card', 'Save up to 4.25% on school fees'),
('FAB GEMS World Credit Card', 'Get 10% cashback on school bus, canteen, and uniform purchases, plus non-school activities'),
('FAB GEMS World Credit Card', 'Receive a 20% discount at Emaar attractions and more'),
('FAB GEMS World Credit Card', '2% cashback on spending'),
('BLUE FAB Infinite Credit Card by Al-Futtaim', '9% cashback on Al-Futtaim retail brands'),
('BLUE FAB Infinite Credit Card by Al-Futtaim', '4% cashback at Al-Futtaim school, car and real estate brands'),
('BLUE FAB Infinite Credit Card by Al-Futtaim', '0% interest buy now pay later plans on your Al-Futtaim shopping'),
('BLUE FAB Signature Credit Card by Al-Futtaim', '7% cashback on Al-Futtaim retail brands'),
('BLUE FAB Signature Credit Card by Al-Futtaim', '3% cashback at Al-Futtaim school, car and real estate brands'),
('BLUE FAB Signature Credit Card by Al-Futtaim', 'Free airport lounge access'),
('BLUE FAB Platinum Credit Card by Al-Futtaim', '6% cashback on Al-Futtaim retail brands'),
('BLUE FAB Platinum Credit Card by Al-Futtaim', '2% cashback at Al-Futtaim school, car and real estate brands'),
('BLUE FAB Platinum Credit Card by Al-Futtaim', '0% interest buy now pay later plans on your Al-Futtaim shopping'),
('FAB Elite Credit Card', 'First year free with a new card'),
('FAB Elite Credit Card', 'Exclusive access to luxury beach clubs, gyms, premium dining experiences and more'),
('FAB Elite Credit Card', 'More convenience with 24/7 global concierge and free valet parking'),
('FAB Elite Credit Card', 'Guaranteed gift of gold bars and tree planting with each card'),
('FAB Elite Credit Card', 'Earn up to 500,000 FAB Rewards on all your spending'),
('CBD Super Saver Credit Card', '4 tickets across VOX, Reel or Novo at 50% off'),
('CBD Super Saver Credit Card', 'Complimentary golf access'),
('CBD Super Saver Credit Card', 'Valet Parking'),
('CBD Super Saver Credit Card', 'Movies discount'),
('CBD One Credit Card', 'Free for life'),
('CBD One Credit Card', 'Earn up to AED 135 cashback every month'),
('CBD One Credit Card', '50% off on cinema tickets'),
('CBD One Credit Card', 'Complimentary valet parking'),
('CBD Yes Rewards Credit Card', 'First year free'),
('CBD Yes Rewards Credit Card', 'Welcome bonus of 20,000 Yes Rewards worth AED 200'),
('CBD Yes Rewards Credit Card', 'Save up to 15% on fuel & more'),
('CBD Yes Rewards Credit Card', 'Complimentary valet parking, cinema discounts and more'),
('CBD Visa Smiles Signature Credit Card', 'A chance to win 1,000,000 Smiles Points'),
('CBD Visa Smiles Signature Credit Card', 'Complimentary global Airport Visa Companion'),
('CBD Visa Smiles Signature Credit Card', '10 Smiles points on all Etisalat channels, Smiles app and elGrocer spends'),
('CBD Visa Smiles Signature Credit Card', '90-day complimentary subscription to Smiles Unlimited'),
('RAK Bank World Credit Card', 'Get AED 1,000 welcome bonus Free for First year'),
('RAK Bank World Credit Card', 'Up to 10% cashback on supermarket'),
('RAK Bank World Credit Card', '50% discount on VOX Cinemas'),
('RAK Bank World Credit Card', '10% cashback on travel, flight and hotel bookings'),
('RAK Bank Titanium Credit Card', 'Get AED 500 welcome bonus  Cashback of up to 5% on supermarket & dining spends and up to 50% for entertainment spends'),
('RAK Bank Titanium Credit Card', 'Get up to AED 600 cashback per month'),
('RAK Bank Titanium Credit Card', 'Free for life'),
('RAK Bank Air Arabia Platinum Credit Card', 'Earn 1.75 Air rewards per AED 5 for spends'),
('RAK Bank Air Arabia Platinum Credit Card', 'Get a joining bonus of 20,000 AirRewards'),
('RAK Bank Air Arabia Platinum Credit Card', 'Enjoy benefits with no maximum caps'),
('RAK Bank RED Credit Card', 'Enjoy a free-for-life card and great rewards'),
('RAK Bank RED Credit Card', 'Cashback of up to 1.5% on local & international spends'),
('RAK Bank RED Credit Card', 'Get up to AED 300 cashback'),
('RAK Bank Elevate credit card ', 'Tier-based Monthly Fee'),
('RAK Bank Elevate credit card ', 'Up to 4% cashback on all your spends'),
('RAK Bank Elevate credit card ', 'Up to 3% value back on airline and hotel reward redemption'),
('RAK Bank Elevate credit card ', 'No Foreign Currency Fee'),
('Emirates Islamic Emarati Credit Card', 'Welcome Bonus: Get AED 1,000 in the form of EI SmartMiles.'),
('Emirates Islamic Emarati Credit Card', 'Exclusive for UAE nationals.'),
('Emirates Islamic Emarati Credit Card', 'No Annual Membership Fee.'),
('Emirates Islamic Emarati Credit Card', 'Complimentary airport lounge access.'),
('Emirates Islamic Flex Elite Credit Card', '175,000 EI SmartMiles Welcome Bonus'),
('Emirates Islamic Flex Elite Credit Card', '3.75% cashback on international spend'),
('Emirates Islamic Flex Elite Credit Card', 'Unlimited airport lounge access for you + guest.'),
('Emirates Islamic Flex Elite Credit Card', 'Unlimited rounds of golf.'),
('Emirates Islamic RTA Credit Card', 'No Annual Fee'),
('Emirates Islamic RTA Credit Card', '10% Cashback on RTA Transport'),
('Emirates Islamic RTA Credit Card', '10% Cashback on Fuel'),
('Emirates Islamic RTA Credit Card', '2.25% Cashback on Other Spends'),
('Emirates Islamic Cashback Credit Card', '5% cash back on telecom expenses.'),
('Emirates Islamic Cashback Credit Card', '5% cash back on electronic store purchases.'),
('Emirates Islamic Cashback Credit Card', 'No AMF for first year subject to retail spend of AED 3,000 within 90 days.'),
('Emirates Islamic Cashback Credit Card', 'Up to 1% guaranteed cash back on all local and international transactions.'),
('Emirates Islamic Cashback Plus Credit Card', 'Up to 10% cash back on groceries, education, dining and telecom.'),
('Emirates Islamic Cashback Plus Credit Card', 'No Annual Membership Fee for first year subject to retail spend of AED 5,000 within 90 days.'),
('Emirates Islamic Cashback Plus Credit Card', 'Unlimited complimentary access to over 1,000 airport lounges worldwide.'),
('Emirates Islamic Cashback Plus Credit Card', 'Complimentary Access to Dubai Ladies Club & Sharjah Ladies Club.'),
('Emirates Islamic Switch Cashback Credit Card', 'Welcome Bonus of AED 500 Cashback points on spends of AED 15,000 within 60 days of Card approval.'),
('Emirates Islamic Switch Cashback Credit Card', 'Lifestyle - 4% cashback on Supermarkets, Dining & Education with 8% cashback on Fuel.'),
('Emirates Islamic Switch Cashback Credit Card', 'Travel - 4% cashback on Airlines, Hotels & Dining.'),
('Emirates Islamic Switch Cashback Credit Card', '2 \"Buy 1 Get 1\" complimentary movie tickets every month.'),
('Emirates Islamic Etihad Guest Premium Credit Card', 'No AMF for first year'),
('Emirates Islamic Etihad Guest Premium Credit Card', 'Fast-Track Etihad Guest Gold Tier Status'),
('Emirates Islamic Etihad Guest Premium Credit Card', 'Up to 3.5 Etihad Guest Miles per USD spent'),
('Emirates Islamic Etihad Guest Premium Credit Card', 'Complimentary airport transfers, airport lounge access, golf & valet parking.'),
('Emirates Islamic Etihad Guest Premium Credit Card', 'Complimentary Access to Dubai Ladies Club.'),
('Emirates Islamic Etihad Guest Saqer Credit Card', 'No AMF for first year'),
('Emirates Islamic Etihad Guest Saqer Credit Card', 'Fast-Track Etihad Guest Silver Tier Status.'),
('Emirates Islamic Etihad Guest Saqer Credit Card', 'Up to 3 Etihad Guest Miles per USD spent.'),
('Emirates Islamic Etihad Guest Saqer Credit Card', 'Complimentary Access to Dubai Ladies Club.'),
('Emirates Islamic Etihad Guest Saqer Credit Card', 'Complimentary airport transfers, airport lounge access, golf & valet parking.'),
('Emirates Islamic Etihad Guest Ameera Credit Card', 'No AMF for first year'),
('Emirates Islamic Etihad Guest Ameera Credit Card', 'Fast-Track Etihad Guest Silver Tier Status.'),
('Emirates Islamic Etihad Guest Ameera Credit Card', 'Up to 3 Etihad Guest Miles per USD spent.'),
('Emirates Islamic Etihad Guest Ameera Credit Card', 'Complimentary Access to Dubai Ladies Club.'),
('Emirates Islamic Etihad Guest Ameera Credit Card', 'Complimentary airport transfers, airport lounge access, golf & valet parking.'),
('Emirates Islamic Etihad Guest Platinum Credit Card', 'No AMF for first year'),
('Emirates Islamic Etihad Guest Platinum Credit Card', 'Up to 2 Etihad Guest Miles per USD spent.'),
('Emirates Islamic Etihad Guest Platinum Credit Card', 'Unlock 10% Etihad Guest Miles Discount Voucher'),
('Emirates Islamic Etihad Guest Platinum Credit Card', 'Discounts on dining, travel, hotels and shopping.'),
('Emirates Islamic Skywards Black Credit Card', 'Up to 3.5 Skywards Miles per USD spent.'),
('Emirates Islamic Skywards Black Credit Card', 'Automatic upgrade to Emirates Skywards Silver membership.'),
('Emirates Islamic Skywards Black Credit Card', 'Fast Track to Emirates Skywards Gold Tier Membership'),
('Emirates Islamic Skywards Black Credit Card', 'Unlimited Complimentary golf any day of the week.'),
('Emirates Islamic Skywards Black Credit Card', 'Unlimited complimentary access to over 1000+ airport lounges with a guest.'),
('Emirates Islamic Skywards Infinite Credit Card', 'AMF waiver for First Year subject to retail spends of AED 30K within 90 days from approval'),
('Emirates Islamic Skywards Infinite Credit Card', 'Up to 2 Skywards Miles per USD spent'),
('Emirates Islamic Skywards Infinite Credit Card', 'Automatic upgrade to Emirates Skywards Silver membership'),
('Emirates Islamic Skywards Infinite Credit Card', 'Unlimited Complimentary golf any day of the week'),
('Emirates Islamic Skywards Infinite Credit Card', 'Unlimited complimentary access to over 1000+ airport lounges with a guest'),
('Emirates Islamic Skywards Signature Credit Card', 'Up to 1.5 Skywards Miles per USD spent.'),
('Emirates Islamic Skywards Signature Credit Card', 'Two rounds of Complimentary golf any day of the week.'),
('Emirates Islamic Skywards Signature Credit Card', '1 complimentary valet parking service per month.'),
('Emirates Islamic Skywards Signature Credit Card', 'Unlimited complimentary access to over 1000+ airport lounges.'),
('Emirates Islamic Skywards Signature Credit Card', 'Complimentary Access to Dubai Ladies Club.'),
('HSBC Cash+ Credit Card', 'Welcome Bonus AED 500'),
('HSBC Cash+ Credit Card', 'Free for First Year'),
('HSBC Cash+ Credit Card', 'Travel Insurance'),
('HSBC Cash+ Credit Card', 'Cashback'),
('HSBC Cash+ Credit Card', 'Careem Plus & Zomato Gold subscription'),
('HSBC Live+ Credit Card', 'Welcome Bonus AED 500'),
('HSBC Live+ Credit Card', 'Free for First Year'),
('HSBC Live+ Credit Card', '5% cashback on fuel'),
('HSBC Live+ Credit Card', 'Earn 6% cashback on dining'),
('HSBC Live+ Credit Card', 'Travel Insurance'),
('HSBC Live+ Credit Card', 'Zomato Gold subscription'),
('HSBC Max Rewards Credit Card', 'Welcome Bonus AED 500'),
('HSBC Max Rewards Credit Card', 'Free for 1st year'),
('HSBC Max Rewards Credit Card', 'Travel Insurance'),
('HSBC Max Rewards Credit Card', '1 Air Mile for every AED 1'),
('HSBC Max Rewards Credit Card', 'Dining Discounts'),
('HSBC Emirates Skywards Infinite Credit Card', 'Welcome Bonus up to 50K Skywards Miles'),
('HSBC Emirates Skywards Infinite Credit Card', 'Airport Lounge Access'),
('HSBC Emirates Skywards Infinite Credit Card', 'Silver Tier Benefits'),
('HSBC Emirates Skywards Infinite Credit Card', 'Multi-trip travel insurance'),
('HSBC Emirates Skywards Infinite Credit Card', 'Get a complimentary Zomato Gold Dining membership'),
('HSBC Emirates Skywards Infinite Credit Card', 'Get a complimentary Careem Plus subscription'),
('HSBC Emirates Skywards Signature Credit Card', 'Welcome Bonus up to 20K Skywards Miles'),
('HSBC Emirates Skywards Signature Credit Card', 'Airport Lounge Access'),
('HSBC Emirates Skywards Signature Credit Card', 'Silver Tier Benefits'),
('HSBC Emirates Skywards Signature Credit Card', 'Multi-trip travel insurance'),
('HSBC Emirates Skywards Signature Credit Card', 'Get a complimentary Zomato Gold Dining membership'),
('HSBC Emirates Skywards Signature Credit Card', 'Get a complimentary Careem Plus subscription'),
('Liv Bank Cashback Credit Card', 'Free for Life'),
('Liv Bank Cashback Credit Card', 'Cashback'),
('Liv Bank Cashback Credit Card', 'Airport Lounge Access'),
('Liv Bank Cashback Credit Card', 'Movie Discounts'),
('Liv Bank Cashback Credit Card', 'Skywards Miles'),
('Liv Bank Cashback Plus Credit Card', 'Cashback'),
('Liv Bank Cashback Plus Credit Card', 'Airport Lounge Access'),
('Liv Bank Cashback Plus Credit Card', 'Movie Discounts'),
('Liv Bank Cashback Plus Credit Card', 'Airport Transfer'),
('Liv Bank Cashback Plus Credit Card', 'Travel Insurance'),
('NBQ Infinite Credit Card', 'Airport Lounge Access'),
('NBQ Infinite Credit Card', 'Free supplementary card'),
('NBQ Infinite Credit Card', 'Balance Transfer'),
('NBQ Infinite Credit Card', 'Easy Payment Plan'),
('NBQ Platinum Credit Card', 'Airport Lounge Access'),
('NBQ Platinum Credit Card', 'Travel Insurance'),
('NBQ Platinum Credit Card', 'Balance Transfer'),
('NBQ Platinum Credit Card', 'Easy Payment Plan'),
('NBQ Gold Credit Card', 'Free for Life'),
('NBQ Gold Credit Card', 'Travel Insurance'),
('NBQ Gold Credit Card', 'Balance Transfer'),
('NBQ Gold Credit Card', 'Easy Payment Plan'),
('DIB SHAMS Infinite Covered Card', 'Travel Insurance'),
('DIB SHAMS Infinite Covered Card', 'Airport lounge access'),
('DIB SHAMS Infinite Covered Card', 'Buy 1 Get 1’ offer on Costa Coffee'),
('DIB SHAMS Infinite Covered Card', '4 Airport transfers'),
('DIB SHAMS Signature Covered Card', 'Travel Insurance'),
('DIB SHAMS Signature Covered Card', 'Airport lounge access'),
('DIB SHAMS Signature Covered Card', 'Free Roadside assistance'),
('DIB SHAMS Signature Covered Card', '2 Airport transfers'),
('DIB SHAMS Platinum Covered Card', 'Travel Insurance'),
('DIB SHAMS Platinum Covered Card', 'Free Roadside assistance'),
('DIB SHAMS Platinum Covered Card', 'Enjoy 5% back on Travel & Dining'),
('The Emirates Skywards DIB Infinite Covered Card', 'Roadside assistance'),
('The Emirates Skywards DIB Infinite Covered Card', 'Dining Offer'),
('The Emirates Skywards DIB Infinite Covered Card', 'Travel Insurance'),
('The Emirates Skywards DIB Infinite Covered Card', 'Airport Lounge access'),
('The Emirates Skywards DIB Signature Covered Card', 'Roadside assistance'),
('The Emirates Skywards DIB Signature Covered Card', 'Dining Offer'),
('The Emirates Skywards DIB Signature Covered Card', 'Airport Lounge access'),
('The Emirates Skywards DIB Signature Covered Card', 'Balance Transfer');

-- --------------------------------------------------------

--
-- Table structure for table `Fetures_transformed`
--

CREATE TABLE `Fetures_transformed` (
  `CARD_name` varchar(50) DEFAULT NULL,
  `Minimum_Salary` varchar(3) DEFAULT NULL,
  `Annual_Fee` varchar(28) DEFAULT NULL,
  `Shrt_Features` varchar(500) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `Fetures_transformed`
--

INSERT INTO `Fetures_transformed` (`CARD_name`, `Minimum_Salary`, `Annual_Fee`, `Shrt_Features`) VALUES
('FAB Etihad Guest Infinite Credit Card', '30K', '2500', 'Get up t 110,000 welcme miles with a new card'),
('FAB Etihad Guest Infinite Credit Card', '30K', '2500', 'Earn up t 7.5 Etihad Guest Miles fr every AED 10 yu spend'),
('FAB Etihad Guest Infinite Credit Card', '30K', '2500', 'Free wrldwide airprt lunge access'),
('FAB Etihad Guest Signature Credit Card', '15K', '1500', 'Get up t 70,000 welcme miles with a new card'),
('FAB Etihad Guest Signature Credit Card', '15K', '1500', 'Earn up t 5.5 Etihad Guest Miles fr every AED 10 yu spend'),
('FAB Etihad Guest Signature Credit Card', '15K', '1500', 'Free airprt lunge access'),
('FAB Etihad Guest Platinum Credit Card', '8k', '500', 'Get up t 20,000 welcme miles with a new card'),
('FAB Etihad Guest Platinum Credit Card', '8k', '500', 'Earn up t 4 Etihad Guest Miles fr every AED 10 yu spend'),
('FAB Etihad Guest Platinum Credit Card', '8k', '500', 'Discunts n airprt transfers'),
('FAB Travel Card world Elite', '25K', '1500', 'A free return flight every year t ver 15 destinatins'),
('FAB Travel Card world Elite', '25K', '1500', '12% cashback n all flight and htel bkings'),
('FAB Travel Card world Elite', '25K', '1500', '0% freign currency cnversin fees with n hidden charges'),
('FAB Travel Card world Elite', '25K', '1500', 'Free lunge access fr yu and tw guests'),
('FAB Cashback Credit Card', '5k', '300', 'Save up t AED 1,000 each mnth!'),
('FAB Cashback Credit Card', '5k', '300', 'Get up t  5% cashback n fashin, dining ut and grcery shpping'),
('FAB Cashback Credit Card', '5k', '300', 'Get up t 3% cashback n internatinal spending'),
('FAB Cashback Credit Card', '5k', '300', 'Get up t 40% ff MakeMyTrip bkings,'),
('FAB Cashback Credit Card', '5k', '300', 'free wrldwide airprt lunge access and mre'),
('FAB du Titanium Credit Card', '5K', 'No Annual fee', '10% cashback n yur du pstpaid line bills'),
('FAB du Titanium Credit Card', '5K', 'No Annual fee', '10% cashback n du hme services bills'),
('FAB du Titanium Credit Card', '5K', 'No Annual fee', '10% cashback n prepaid line recharges'),
('FAB du Titanium Credit Card', '5K', 'No Annual fee', '10% cashback n yur du smartphne Privilege Plan mnthly data charges'),
('FAB GEMS World Credit Card', '8K', 'AED 399', 'Save big n schl and family expenses.'),
('FAB GEMS World Credit Card', '8K', 'AED 399', 'Save up t 4.25% n schl fees'),
('FAB GEMS World Credit Card', '8K', 'AED 399', 'Get 10% cashback n schl bus, canteen, and unifrm purchases, plus nn-schl activities'),
('FAB GEMS World Credit Card', '8K', 'AED 399', 'Receive a 20% discunt at Emaar attractins and mre'),
('FAB GEMS World Credit Card', '8K', 'AED 399', '2% cashback n spending'),
('BLUE FAB Infinite Credit Card by Al-Futtaim', '40K', 'No Annual Fees', '9% cashback n Al-Futtaim retail brands'),
('BLUE FAB Infinite Credit Card by Al-Futtaim', '40K', 'No Annual Fees', '4% cashback at Al-Futtaim schl, car and real estate brands'),
('BLUE FAB Infinite Credit Card by Al-Futtaim', '40K', 'No Annual Fees', '0% interest buy nw pay later plans n yur Al-Futtaim shpping'),
('BLUE FAB Signature Credit Card by Al-Futtaim', '15K', 'Free For Life', '7% cashback n Al-Futtaim retail brands'),
('BLUE FAB Signature Credit Card by Al-Futtaim', '15K', 'Free For Life', '3% cashback at Al-Futtaim schl, car and real estate brands'),
('BLUE FAB Signature Credit Card by Al-Futtaim', '15K', 'Free For Life', 'Free airprt lunge access'),
('BLUE FAB Platinum Credit Card by Al-Futtaim', '8K', 'Free For Life', '6% cashback n Al-Futtaim retail brands'),
('BLUE FAB Platinum Credit Card by Al-Futtaim', '8K', 'Free For Life', '2% cashback at Al-Futtaim schl, car and real estate brands'),
('BLUE FAB Platinum Credit Card by Al-Futtaim', '8K', 'Free For Life', '0% interest buy nw pay later plans n yur Al-Futtaim shpping'),
('FAB SHARE Signature Credit Card', '30K', '1500', '8% cashback n yur mall experiences'),
('FAB SHARE Signature Credit Card', '30K', '1500', '6% cashback when yu shp at the mall'),
('FAB SHARE Signature Credit Card', '30K', '1500', '15,000 bnus SHARE pints'),
('FAB SHARE Signature Credit Card', '30K', '1500', 'Get 2 fr 1 VX cinema tickets'),
('FAB SHARE Platinum Credit Card', '10K', '1000', '6% cashback n mall experiences'),
('FAB SHARE Platinum Credit Card', '10K', '1000', '4% cashback n mall spending'),
('FAB SHARE Platinum Credit Card', '10K', '1000', '10,000 bnus SHARE pints'),
('FAB SHARE Platinum Credit Card', '10K', '1000', 'Get 2 fr 1 VX cinema tickets'),
('FAB SHARE Standard Credit Card', '5K', 'No Annual Fees', '7% cashback at Carrefur'),
('FAB SHARE Standard Credit Card', '5K', 'No Annual Fees', '5% cashback n mall experiences'),
('FAB SHARE Standard Credit Card', '5K', 'No Annual Fees', '3% cashback n mall spending'),
('FAB SHARE Standard Credit Card', '5K', 'No Annual Fees', 'Get 2 fr 1 VX cinema tickets'),
('FAB Elite Credit Card', '50K', 'Free for First year- 1200', 'First year free with a new card'),
('FAB Elite Credit Card', '50K', 'Free for First year- 1200', 'Exclusive access t luxury beach clubs, gyms, premium dining experiences and mre'),
('FAB Elite Credit Card', '50K', 'Free for First year- 1200', 'Mre cnvenience with 24/7 glbal cncierge and free valet parking'),
('FAB Elite Credit Card', '50K', 'Free for First year- 1200', 'Guaranteed gift f gld bars and tree planting with each card'),
('FAB Elite Credit Card', '50K', 'Free for First year- 1200', 'Earn up t 500,000 FAB Rewards n all yur spending'),
('CBD One Credit Card', '5K', 'Free for Life', 'Free fr life'),
('CBD One Credit Card', '5K', 'Free for Life', 'Earn up t AED 135 cashback every mnth'),
('CBD One Credit Card', '5K', 'Free for Life', '50% ff n cinema tickets'),
('CBD One Credit Card', '5K', 'Free for Life', 'Cmplimentary valet parking'),
('CBD Yes Rewards Credit Card', '5K', 'Free For First year', 'First year free'),
('CBD Yes Rewards Credit Card', '5K', 'Free For First year', 'Welcme bnus f 20,000 Yes Rewards wrth AED 200'),
('CBD Yes Rewards Credit Card', '5K', 'Free For First year', 'Save up t 15% n fuel & mre'),
('CBD Yes Rewards Credit Card', '5K', 'Free For First year', 'Cmplimentary valet parking, cinema discunts and mre'),
('CBD Visa Smiles Signature Credit Card', '5k', 'F Y F then AED 199', 'A chance t win 1,000,000 Smiles Pints'),
('CBD Visa Smiles Signature Credit Card', '5k', 'F Y F then AED 199', 'Cmplimentary glbal Airprt Visa Cmpanin'),
('CBD Visa Smiles Signature Credit Card', '5k', 'F Y F then AED 199', '10 Smiles pints n all Etisalat channels, Smiles app and elGrcer spends'),
('CBD Visa Smiles Signature Credit Card', '5k', 'F Y F then AED 199', '90-day cmplimentary subscriptin t Smiles Unlimited'),
('RAK Bank World Credit Card', '20K', 'FYF then 950', 'Free fr First year'),
('RAK Bank World Credit Card', '20K', 'FYF then 950', 'Get AED 1,000 welcme bnus '),
('RAK Bank World Credit Card', '20K', 'FYF then 950', 'Up t 10% cashback n supermarket'),
('RAK Bank World Credit Card', '20K', 'FYF then 950', '50% discunt n VX Cinemas'),
('RAK Bank World Credit Card', '20K', 'FYF then 950', '10% cashback n travel, flight and htel bkings'),
('RAK Bank Titanium Credit Card', '8k', 'Free for Life', 'Cashback f up t 5% n supermarket & dining spends and up t 50% fr entertainment spends'),
('RAK Bank Titanium Credit Card', '8k', 'Free for Life', 'Get AED 500 welcme bnus'),
('RAK Bank Titanium Credit Card', '8k', 'Free for Life', '	Get up t AED 600 cashback per mnth'),
('RAK Bank Titanium Credit Card', '8k', 'Free for Life', '	Free fr life'),
('RAK Bank Air Arabia Platinum Credit Card', '5K', 'AED 420*', 'Earn 1.75 Air rewards per AED 5 fr spends'),
('RAK Bank Air Arabia Platinum Credit Card', '5K', 'AED 420*', 'Get a jining bnus f 20,000 AirRewards'),
('RAK Bank Air Arabia Platinum Credit Card', '5K', 'AED 420*', 'Enjy benefits with n maximum caps'),
('RAK Bank RED Credit Card', '5k', 'Free for Life', 'Enjy a free-fr-life card and great rewards'),
('RAK Bank RED Credit Card', '5k', 'Free for Life', 'Cashback f up t 1.5% n lcal & internatinal spends'),
('RAK Bank RED Credit Card', '5k', 'Free for Life', 'Get up t AED 300 cashback'),
('RAK Bank Elevate credit card ', '35K', 'Spend base', NULL),
('RAK Bank Elevate credit card ', '35K', 'Spend base', NULL),
('RAK Bank Elevate credit card ', '35K', 'Spend base', 'Tier-based Mnthly Fee'),
('RAK Bank Elevate credit card ', '35K', 'Spend base', NULL),
('RAK Bank Elevate credit card ', '35K', 'Spend base', 'Up t 4% cashback n all yur spends'),
('RAK Bank Elevate credit card ', '35K', 'Spend base', NULL),
('RAK Bank Elevate credit card ', '35K', 'Spend base', 'Up t 3% value back n airline and htel reward redemptin'),
('RAK Bank Elevate credit card ', '35K', 'Spend base', NULL),
('RAK Bank Elevate credit card ', '35K', 'Spend base', 'N Freign Currency Fee'),
('Emirates Islamic Emarati Credit Card', '12K', 'No Annual fee', 'Welcme Bnus: Get AED 1,000 in the frm f EI SmartMiles. *'),
('Emirates Islamic Emarati Credit Card', '12K', 'No Annual fee', 'Exclusive fr UAE natinals.'),
('Emirates Islamic Emarati Credit Card', '12K', 'No Annual fee', 'N Annual Membership Fee.'),
('Emirates Islamic Emarati Credit Card', '12K', 'No Annual fee', 'Cmplimentary airprt lunge access.'),
('Emirates Islamic Flex Elite Credit Card', '15K', '735', '175,000 EI SmartMiles Welcme Bnus'),
('Emirates Islamic Flex Elite Credit Card', '15K', '735', '3.75% cashback n internatinal spend'),
('Emirates Islamic Flex Elite Credit Card', '15K', '735', 'Unlimited airprt lunge access fr yu + guest.'),
('Emirates Islamic Flex Elite Credit Card', '15K', '735', 'Unlimited runds f glf.'),
('Emirates Islamic RTA Credit Card', '5K', 'No Annual Fee', 'N Annual Fee'),
('Emirates Islamic RTA Credit Card', '5K', 'No Annual Fee', '10% Cashback n RTA Transprt'),
('Emirates Islamic RTA Credit Card', '5K', 'No Annual Fee', '10% Cashback n Fuel'),
('Emirates Islamic RTA Credit Card', '5K', 'No Annual Fee', '2.25% Cashback n ther Spends'),
('Emirates Islamic Cashback Credit Card', '5k', 'No AMF for first year*', '5% cash back n telecm expenses.'),
('Emirates Islamic Cashback Credit Card', '5k', 'No AMF for first year*', '5% cash back n electrnic stre purchases.'),
('Emirates Islamic Cashback Credit Card', '5k', 'No AMF for first year*', 'N AMF fr first year* subject t retail spend f AED 3,000 within 90 days.'),
('Emirates Islamic Cashback Credit Card', '5k', 'No AMF for first year*', 'Up t 1% guaranteed cash back n all lcal and internatinal transactins.'),
('Emirates Islamic Cashback Plus Credit Card', '12K', 'No AMF for first year*', 'Up t 10% cash back n grceries, educatin, dining and telecm.'),
('Emirates Islamic Cashback Plus Credit Card', '12K', 'No AMF for first year*', 'N Annual Membership Fee fr first year* subject t retail spend f AED 5,000 within 90 days.'),
('Emirates Islamic Cashback Plus Credit Card', '12K', 'No AMF for first year*', 'Unlimited cmplimentary access t ver 1,000 airprt lunges wrldwide.'),
('Emirates Islamic Cashback Plus Credit Card', '12K', 'No AMF for first year*', 'Cmplimentary Access t Dubai Ladies Club & Sharjah Ladies Club.'),
('Emirates Islamic Switch Cashback Credit Card', '5K', 'Free for First Year', 'Welcme Bnus f AED 500 Cashback pints n spends f AED 15,000 within 60 days f Card apprval.'),
('Emirates Islamic Switch Cashback Credit Card', '5K', 'Free for First Year', 'Lifestyle - 4% cashback n Supermarkets, Dining & Educatin with 8% cashback n Fuel.'),
('Emirates Islamic Switch Cashback Credit Card', '5K', 'Free for First Year', 'Travel - 4% cashback n Airlines, Htels & Dining.'),
('Emirates Islamic Switch Cashback Credit Card', '5K', 'Free for First Year', '2 \"Buy 1 Get 1\" cmplimentary mvie tickets every mnth.'),
('Emirates Islamic Etihad Guest Premium Credit Card', '20K', 'No AMF for first year*', 'N AMF fr first year*'),
('Emirates Islamic Etihad Guest Premium Credit Card', '20K', 'No AMF for first year*', 'Fast-Track Etihad Guest Gld Tier Status'),
('Emirates Islamic Etihad Guest Premium Credit Card', '20K', 'No AMF for first year*', 'Up t 3.5 Etihad Guest Miles per USD spent'),
('Emirates Islamic Etihad Guest Premium Credit Card', '20K', 'No AMF for first year*', 'Cmplimentary airprt transfers, airprt lunge access, glf & valet parking.'),
('Emirates Islamic Etihad Guest Premium Credit Card', '20K', 'No AMF for first year*', 'Cmplimentary Access t Dubai Ladies Club.'),
('Emirates Islamic Etihad Guest Saqer Credit Card', '12k', 'No AMF for first year*', 'N AMF fr first year*'),
('Emirates Islamic Etihad Guest Saqer Credit Card', '12k', 'No AMF for first year*', 'Fast-Track Etihad Guest Silver Tier Status.'),
('Emirates Islamic Etihad Guest Saqer Credit Card', '12k', 'No AMF for first year*', 'Up t 3 Etihad Guest Miles per USD spent.'),
('Emirates Islamic Etihad Guest Saqer Credit Card', '12k', 'No AMF for first year*', 'Cmplimentary Access t Dubai Ladies Club.'),
('Emirates Islamic Etihad Guest Saqer Credit Card', '12k', 'No AMF for first year*', 'Cmplimentary airprt transfers, airprt lunge access, glf & valet parking.'),
('Emirates Islamic Etihad Guest Ameera Credit Card', NULL, 'No AMF for first year*', 'N AMF fr first year*'),
('Emirates Islamic Etihad Guest Ameera Credit Card', NULL, 'No AMF for first year*', 'Fast-Track Etihad Guest Silver Tier Status.'),
('Emirates Islamic Etihad Guest Ameera Credit Card', NULL, 'No AMF for first year*', 'Up t 3 Etihad Guest Miles per USD spent.'),
('Emirates Islamic Etihad Guest Ameera Credit Card', NULL, 'No AMF for first year*', 'Cmplimentary Access t Dubai Ladies Club.'),
('Emirates Islamic Etihad Guest Ameera Credit Card', NULL, 'No AMF for first year*', 'Cmplimentary airprt transfers, airprt lunge access, glf & valet parking.'),
('Emirates Islamic Etihad Guest Platinum Credit Card', '5k', 'No AMF for first year* ', 'N AMF fr first year*'),
('Emirates Islamic Etihad Guest Platinum Credit Card', '5k', 'No AMF for first year* ', 'Up t 2 Etihad Guest Miles per USD spent.'),
('Emirates Islamic Etihad Guest Platinum Credit Card', '5k', 'No AMF for first year* ', 'Unlck 10% Etihad Guest Miles Discunt Vucher'),
('Emirates Islamic Etihad Guest Platinum Credit Card', '5k', 'No AMF for first year* ', 'Discunts n dining, travel, htels and shpping.'),
('Emirates Islamic Skywards Black Credit Card', '35K', 'AED 2k or AED 3.5K', 'Up t 3.5 Skywards Miles per USD spent.'),
('Emirates Islamic Skywards Black Credit Card', '35K', 'AED 2k or AED 3.5K', 'Autmatic upgrade t Emirates Skywards Silver membership.'),
('Emirates Islamic Skywards Black Credit Card', '35K', 'AED 2k or AED 3.5K', 'Fast Track t Emirates Skywards Gld Tier Membership'),
('Emirates Islamic Skywards Black Credit Card', '35K', 'AED 2k or AED 3.5K', 'Unlimited Cmplimentary glf any day f the week.'),
('Emirates Islamic Skywards Black Credit Card', '35K', 'AED 2k or AED 3.5K', 'Unlimited cmplimentary access t ver 1000+ airprt lunges with a guest.'),
('Emirates Islamic Skywards Infinite Credit Card', '20K', 'AED 2K', 'AMF waiver fr First Year subject t retail spends f AED 30K within 90 days frm apprval'),
('Emirates Islamic Skywards Infinite Credit Card', '20K', 'AED 2K', 'Up t 2 Skywards Miles per USD spent'),
('Emirates Islamic Skywards Infinite Credit Card', '20K', 'AED 2K', 'Autmatic upgrade t Emirates Skywards Silver membership'),
('Emirates Islamic Skywards Infinite Credit Card', '20K', 'AED 2K', 'Unlimited Cmplimentary glf any day f the week'),
('Emirates Islamic Skywards Infinite Credit Card', '20K', 'AED 2K', 'Unlimited cmplimentary access t ver 1000+ airprt lunges with a guest'),
('Emirates Islamic Skywards Signature Credit Card', '12k', 'AED 700', 'Up t 1.5 Skywards Miles per USD spent.'),
('Emirates Islamic Skywards Signature Credit Card', '12k', 'AED 700', 'Tw runds f Cmplimentary glf any day f the week.'),
('Emirates Islamic Skywards Signature Credit Card', '12k', 'AED 700', '1 cmplimentary valet parking service per mnth.'),
('Emirates Islamic Skywards Signature Credit Card', '12k', 'AED 700', 'Unlimited cmplimentary access t ver 1000+ airprt lunges.'),
('Emirates Islamic Skywards Signature Credit Card', '12k', 'AED 700', 'Cmplimentary Access t Dubai Ladies Club.'),
('HSBC Cash+ Credit Card', '30K', 'Free for 1st  Year-then 1000', 'Welcme Bnus AED 500'),
('HSBC Cash+ Credit Card', '30K', 'Free for 1st  Year-then 1000', 'Free fr First Year'),
('HSBC Cash+ Credit Card', '30K', 'Free for 1st  Year-then 1000', 'Travel Insurance'),
('HSBC Cash+ Credit Card', '30K', 'Free for 1st  Year-then 1000', 'Cashback'),
('HSBC Cash+ Credit Card', '30K', 'Free for 1st  Year-then 1000', 'Careem Plus & Zmat Gld subscriptin'),
('HSBC Live+ Credit Card', '5K', 'Free for 1st  Year*', 'Welcme Bnus AED 500'),
('HSBC Live+ Credit Card', '5K', 'Free for 1st  Year*', 'Free fr First Year'),
('HSBC Live+ Credit Card', '5K', 'Free for 1st  Year*', '5% cashback n fuel'),
('HSBC Live+ Credit Card', '5K', 'Free for 1st  Year*', 'Earn 6% cashback n dining'),
('HSBC Live+ Credit Card', '5K', 'Free for 1st  Year*', 'Travel Insurance'),
('HSBC Live+ Credit Card', '5K', 'Free for 1st  Year*', 'Zmat Gld subscriptin'),
('HSBC Max Rewards Credit Card', '10K', 'Free for 1st  Year', 'Welcme Bnus AED 500'),
('HSBC Max Rewards Credit Card', '10K', 'Free for 1st  Year', 'Free fr 1st year'),
('HSBC Max Rewards Credit Card', '10K', 'Free for 1st  Year', 'Travel Insurance'),
('HSBC Max Rewards Credit Card', '10K', 'Free for 1st  Year', '1 Air Mile fr every AED 1'),
('HSBC Max Rewards Credit Card', '10K', 'Free for 1st  Year', 'Dining Discunts'),
('HSBC Emirates Skywards Infinite Credit Card', '30K', 'AED 2,500', 'Welcme Bnus up t 50K Skywards Miles'),
('HSBC Emirates Skywards Infinite Credit Card', '30K', 'AED 2,500', 'Airprt Lunge Access'),
('HSBC Emirates Skywards Infinite Credit Card', '30K', 'AED 2,500', 'Silver Tier Benefits'),
('HSBC Emirates Skywards Infinite Credit Card', '30K', 'AED 2,500', 'Multi-trip travel insurance'),
('HSBC Emirates Skywards Infinite Credit Card', '30K', 'AED 2,500', 'Get a cmplimentary Zmat Gld Dining membership'),
('HSBC Emirates Skywards Infinite Credit Card', '30K', 'AED 2,500', 'Get a cmplimentary Careem Plus subscriptin'),
('HSBC Emirates Skywards Signature Credit Card', '10K', 'AED 1,000', 'Welcme Bnus up t 20K Skywards Miles'),
('HSBC Emirates Skywards Signature Credit Card', '10K', 'AED 1,000', 'Airprt Lunge Access'),
('HSBC Emirates Skywards Signature Credit Card', '10K', 'AED 1,000', 'Silver Tier Benefits'),
('HSBC Emirates Skywards Signature Credit Card', '10K', 'AED 1,000', 'Multi-trip travel insurance'),
('HSBC Emirates Skywards Signature Credit Card', '10K', 'AED 1,000', 'Get a cmplimentary Zmat Gld Dining membership'),
('HSBC Emirates Skywards Signature Credit Card', '10K', 'AED 1,000', 'Get a cmplimentary Careem Plus subscriptin'),
('Liv Bank Cashback Credit Card', '5K', 'Free for life', 'Free fr Life'),
('Liv Bank Cashback Credit Card', '5K', 'Free for life', 'Cashback'),
('Liv Bank Cashback Credit Card', '5K', 'Free for life', 'Airprt Lunge Access'),
('Liv Bank Cashback Credit Card', '5K', 'Free for life', 'Mvie Discunts'),
('Liv Bank Cashback Credit Card', '5K', 'Free for life', 'Skywards Miles'),
('Liv Bank Cashback Plus Credit Card', '10k', 'AED 700', 'Cashback'),
('Liv Bank Cashback Plus Credit Card', '10k', 'AED 700', 'Airprt Lunge Access'),
('Liv Bank Cashback Plus Credit Card', '10k', 'AED 700', 'Mvie Discunts'),
('Liv Bank Cashback Plus Credit Card', '10k', 'AED 700', 'Airprt Transfer'),
('Liv Bank Cashback Plus Credit Card', '10k', 'AED 700', 'Travel Insurance'),
('NBQ Infinite Credit Card', '30k', 'AED 1000', 'Airprt Lunge Access'),
('NBQ Infinite Credit Card', '30k', 'AED 1000', 'Free supplementary card'),
('NBQ Infinite Credit Card', '30k', 'AED 1000', 'Balance Transfer'),
('NBQ Infinite Credit Card', '30k', 'AED 1000', 'Easy Payment Plan'),
('NBQ Platinum Credit Card', '15k', 'AED 500', 'Airprt Lunge Access'),
('NBQ Platinum Credit Card', '15k', 'AED 500', 'Travel Insurance'),
('NBQ Platinum Credit Card', '15k', 'AED 500', 'Balance Transfer'),
('NBQ Platinum Credit Card', '15k', 'AED 500', 'Easy Payment Plan'),
('NBQ Gold Credit Card', '8k', 'Free for life', 'Free fr Life'),
('NBQ Gold Credit Card', '8k', 'Free for life', 'Travel Insurance'),
('NBQ Gold Credit Card', '8k', 'Free for life', 'Balance Transfer'),
('NBQ Gold Credit Card', '8k', 'Free for life', 'Easy Payment Plan'),
('DIB SHAMS Infinite Covered Card', '50K', 'Free for 1st year', 'Travel Insurance'),
('DIB SHAMS Infinite Covered Card', '50K', 'Free for 1st year', 'Airprt lunge access'),
('DIB SHAMS Infinite Covered Card', '50K', 'Free for 1st year', 'Buy 1 Get 1’ ffer n Csta Cffee'),
('DIB SHAMS Infinite Covered Card', '50K', 'Free for 1st year', '4 Airprt transfers'),
('DIB SHAMS Signature Covered Card', NULL, 'Free for 1st year', 'Travel Insurance'),
('DIB SHAMS Signature Covered Card', NULL, 'Free for 1st year', 'Airprt lunge access'),
('DIB SHAMS Signature Covered Card', NULL, 'Free for 1st year', 'Free Radside assistance'),
('DIB SHAMS Signature Covered Card', NULL, 'Free for 1st year', '2 Airprt transfers');

-- --------------------------------------------------------

--
-- Table structure for table `updated_excelgtp_1`
--

CREATE TABLE `updated_excelgtp_1` (
  `idcreditcardsbenefits` int(11) DEFAULT NULL,
  `creditcardsfeturesDetails` varchar(117) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `idcreditcards` int(11) DEFAULT NULL,
  `shortfeature` varchar(58) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `updated_excelgtp_1`
--

INSERT INTO `updated_excelgtp_1` (`idcreditcardsbenefits`, `creditcardsfeturesDetails`, `idcreditcards`, `shortfeature`) VALUES
(1, '5% on school fees, supermarkets, and online shopping', 255, 'Shopping Discount'),
(2, 'Bonus Cashback', 255, 'Cashback'),
(3, 'Airport lounge access', 255, 'Lounge Access'),
(4, 'Up to 10% on fuel spending', 255, 'Fuel Discount'),
(5, 'FLY for FREE with Upfront 15,000 Complimentary BRight Rewards', 256, 'Rewards'),
(6, '0% Foreign Transaction Fees', 256, 'No Foreign Transaction Fees'),
(7, 'Complimentary Lounge Access', 256, 'Lounge Access'),
(8, 'Earn up to 2.5 BRight Rewards for every AED 10 spend', 256, 'Rewards'),
(9, 'Valet Parking 4 times a month at over 35 locations', 256, 'Valet Parking'),
(10, 'FLY for FREE with Upfront 10,000 Complimentary BRight Rewards', 257, 'Rewards'),
(11, '0% Foreign Transaction Fees', 257, 'No Foreign Transaction Fees'),
(12, 'Complimentary Lounge Access', 257, 'Lounge Access'),
(13, 'Earn up to 2 BRight Rewards for every AED 10 spend', 257, 'Rewards'),
(14, 'Valet Parking 3 times a month at over 35 locations', 257, 'Valet Parking'),
(15, 'Complimentary Lounge Access', 258, 'Lounge Access'),
(16, 'Earn up to 1 BRight Rewards for every AED 10 spend', 258, 'Rewards'),
(17, 'Valet Parking  at over 35 locations', 258, 'Valet Parking'),
(18, '0% off on Cleartrip', 258, 'Cleartrip Discount'),
(19, '4 tickets across VOX, Reel or Novo at 50% off', 260, '4 Movies tickets '),
(20, 'Complimentary golf access', 260, 'Golf Access'),
(21, 'Valet Parking', 260, 'Valet Parking'),
(22, 'Movies discount', 260, 'Movie Discount'),
(23, 'Free for life', 261, 'Free for Life'),
(24, 'Earn up to AED 135 cashback every month', 261, 'Cashback'),
(25, '50% off on cinema tickets', 261, '50% off on cinema tickets'),
(26, 'Complimentary valet parking', 261, 'Valet Parking'),
(27, 'First year free', 262, 'first year free'),
(28, 'Welcome bonus of 20,000 Yes Rewards worth AED 200', 262, 'Welcome Bonus'),
(29, 'Save up to 15% on fuel & more', 262, 'Fuel Discount'),
(30, 'Complimentary valet parking, cinema discounts and more', 262, 'Valet Parking'),
(31, 'A chance to win 1,000,000 Smiles Points', 263, 'Smiles Points'),
(32, 'Complimentary global Airport Visa Companion', 263, 'Airport Visa'),
(33, '10 Smiles points on all Etisalat channels, Smiles app and elGrocer spends', 263, 'Smiles Points'),
(34, '90-day complimentary subscription to Smiles Unlimited', 263, 'Subscription Offer'),
(35, 'Travel Insurance', 264, 'Travel Insurance'),
(36, 'Airport lounge access', 264, 'Lounge Access'),
(37, 'Buy 1 Get 1’ offer on Costa Coffee', 264, 'costa coffee Offer'),
(38, '4 Airport transfers', 264, 'Airport Transfer'),
(39, 'Travel Insurance', 265, 'Travel Insurance'),
(40, 'Airport lounge access', 265, 'Lounge Access'),
(41, 'Free Roadside assistance', 265, 'Roadside Assistance'),
(42, '2 Airport transfers', 265, 'Airport Transfer'),
(43, 'Travel Insurance', 266, 'Travel Insurance'),
(44, 'Free Roadside assistance', 266, 'Roadside Assistance'),
(45, 'Enjoy 5% back on Travel & Dining', 266, 'Dining Offer'),
(46, 'Roadside assistance', 267, 'Roadside Assistance'),
(47, 'Dining Offer', 267, 'Dining Offer'),
(48, 'Travel Insurance', 267, 'Travel Insurance'),
(49, 'Airport Lounge access', 267, 'Lounge Access'),
(50, 'Roadside assistance', 268, 'Roadside Assistance'),
(51, 'Dining Offer', 268, 'Dining Offer'),
(52, 'Airport Lounge access', 268, 'Lounge Access'),
(53, 'Balance Transfer', 268, 'balance transfer'),
(54, 'Welcome Bonus: Get AED 1,000 in the form of EI SmartMiles.', 269, 'Welcome Bonus'),
(55, 'Exclusive for UAE nationals.', 269, 'exclusive for uae nationals.'),
(56, 'No Annual Membership Fee.', 269, 'no annual membership fee.'),
(57, 'Complimentary airport lounge access.', 269, 'Lounge Access'),
(58, '175,000 EI SmartMiles Welcome Bonus', 270, 'Welcome Bonus'),
(59, '3.75% cashback on international spend', 270, 'Cashback'),
(60, 'Unlimited airport lounge access for you + guest.', 270, 'Lounge Access'),
(61, 'Unlimited rounds of golf.', 270, 'Golf Access'),
(62, 'No Annual Fee', 271, 'no annual fee'),
(63, '10% Cashback on RTA Transport', 271, 'Cashback'),
(64, '10% Cashback on Fuel', 271, 'Cashback'),
(65, '2.25% Cashback on Other Spends', 271, 'Cashback'),
(66, '5% cash back on telecom expenses.', 272, '5% cash back on telecom.'),
(67, '5% cash back on electronic store purchases.', 272, '5% cash back on electronic.'),
(68, 'No AMF for first year subject to retail spend of AED 3,000 within 90 days.', 272, 'no amf for first year'),
(69, 'Up to 1% guaranteed cash back on all local and international transactions.', 272, 'up to 1% guaranteed cash back'),
(70, 'Up to 10% cash back on groceries, education, dining and telecom.', 273, 'Dining Offer'),
(71, 'No Annual Membership Fee for first year subject to retail spend of AED 5,000 within 90 days.', 273, 'no amf for first year'),
(72, 'Unlimited complimentary access to over 1,000 airport lounges worldwide.', 273, 'Airport lounges worldwide.'),
(73, 'Complimentary Access to Dubai Ladies Club & Sharjah Ladies Club.', 273, 'access to ladies club.'),
(74, 'Welcome Bonus of AED 500 Cashback points on spends of AED 15,000 within 60 days of Card approval.', 274, 'Cashback'),
(75, 'Lifestyle - 4% cashback on Supermarkets, Dining & Education with 8% cashback on Fuel.', 274, 'Cashback'),
(76, 'Travel - 4% cashback on Airlines, Hotels & Dining.', 274, 'Cashback'),
(77, '2 \"Buy 1 Get 1\" complimentary movie tickets every month.', 274, 'Movie Discount'),
(78, 'No AMF for first year', 275, 'no amf for first year'),
(79, 'Fast-Track Etihad Guest Gold Tier Status', 275, 'fast-track etihad guest gold tier status'),
(80, 'Up to 3.5 Etihad Guest Miles per USD spent', 275, 'up to 3.5 etihad guest miles per usd spent'),
(81, 'Complimentary airport transfers, airport lounge access, golf & valet parking.', 275, 'Lounge Access'),
(82, 'Complimentary Access to Dubai Ladies Club.', 275, 'complimentary access to dubai ladies club.'),
(83, 'No AMF for first year', 276, 'no amf for first year'),
(84, 'Fast-Track Etihad Guest Silver Tier Status.', 276, 'Silver Tier Benefits'),
(85, 'Up to 3 Etihad Guest Miles per USD spent.', 276, 'up to 3 etihad guest miles per usd spent.'),
(86, 'Complimentary Access to Dubai Ladies Club.', 276, 'complimentary access to dubai ladies club.'),
(87, 'Complimentary airport transfers, airport lounge access, golf & valet parking.', 276, 'Lounge Access'),
(88, 'No AMF for first year', 277, 'no amf for first year'),
(89, 'Fast-Track Etihad Guest Silver Tier Status.', 277, 'Silver Tier Benefits'),
(90, 'Up to 3 Etihad Guest Miles per USD spent.', 277, 'up to 3 etihad guest miles per usd spent.'),
(91, 'Complimentary Access to Dubai Ladies Club.', 277, 'complimentary access to dubai ladies club.'),
(92, 'Complimentary airport transfers, airport lounge access, golf & valet parking.', 277, 'Lounge Access'),
(93, 'No AMF for first year', 278, 'no amf for first year'),
(94, 'Up to 2 Etihad Guest Miles per USD spent.', 278, 'up to 2 etihad guest miles per usd spent.'),
(95, 'Unlock 10% Etihad Guest Miles Discount Voucher', 278, 'unlock 10% etihad guest miles discount voucher'),
(96, 'Discounts on dining, travel, hotels and shopping.', 278, 'Dining Offer'),
(97, 'Up to 3.5 Skywards Miles per USD spent.', 279, 'Skywards Miles'),
(98, 'Automatic upgrade to Emirates Skywards Silver membership.', 279, 'automatic upgrade skywards membership.'),
(99, 'Fast Track to Emirates Skywards Gold Tier Membership', 279, NULL),
(100, 'Unlimited Complimentary golf any day of the week.', 279, 'Golf Access'),
(101, 'Unlimited complimentary access to over 1000+ airport lounges with a guest.', 279, 'airport lounges.'),
(102, 'AMF waiver for First Year subject to retail spends of AED 30K within 90 days from approval', 280, 'no amf for first year'),
(103, 'Up to 2 Skywards Miles per USD spent', 280, 'Skywards Miles'),
(104, 'Automatic upgrade to Emirates Skywards Silver membership', 280, 'automatic upgrade to emirates skywards silver membership'),
(105, 'Unlimited Complimentary golf any day of the week', 280, 'Golf Access'),
(106, 'Unlimited complimentary access to over 1000+ airport lounges with a guest', 280, 'unlimited  airport lounges'),
(107, 'Up to 1.5 Skywards Miles per USD spent.', 281, 'Skywards Miles'),
(108, 'Two rounds of Complimentary golf any day of the week.', 281, 'Golf Access'),
(109, '1 complimentary valet parking service per month.', 281, 'Valet Parking'),
(110, 'Unlimited complimentary access to over 1000+ airport lounges.', 281, 'unlimited  airport lounges'),
(111, 'Complimentary Access to Dubai Ladies Club.', 281, 'complimentary access to dubai ladies club.'),
(112, 'Free for Life', 282, 'Free for Life'),
(113, 'Concierge services', 282, 'concierge services'),
(114, 'Access to golf courses across the UAE', 282, 'Golf Access'),
(115, 'Buy 1 Get 1’ offers on movie tickets with Royal Cinemas', 282, 'Movie Discount'),
(116, 'Earn Plus Points on spend - 5% rewards on grocery, electronics, utilities, education and fuel', 282, 'Fuel Discount'),
(117, '0% Balance Transfer', 283, '0% balance transfer'),
(118, '4% on fuel spends', 283, 'Fuel Discount'),
(119, 'Free concierge services', 283, 'free concierge services'),
(120, 'Exclusive benefits & offers at Lulu stores & online', 283, 'exclusive benefits & offers at lulu stores & online'),
(121, 'Priority checkout', 284, 'priority checkout'),
(122, 'Early access to major sales and promotions', 284, 'early access to major sales and promotions'),
(123, 'Monthly discount and exclusive offers', 284, 'monthly discount and exclusive offers'),
(124, 'Free shipping on Lulu online', 284, 'free shipping on lulu online'),
(125, 'Access to top golfing courses', 285, 'Golf Access'),
(126, 'Buy 1 get 1 free on movies', 285, 'Movie Discount'),
(127, 'Valet parking in Abu Dhabi', 285, 'Valet Parking'),
(128, 'Get up to 1.5 Skywards Miles/USD', 285, 'Skywards Miles'),
(129, 'Welcome bonus of 100,000 skywards miles', 286, 'Welcome Bonus'),
(130, 'Access to golf courses', 286, 'Golf Access'),
(131, 'Valet Parking', 286, 'Valet Parking'),
(132, 'Movies offer', 286, 'Movie Discount'),
(133, 'Multi-trip travel insurance', 286, 'Travel Insurance'),
(134, 'Valet Parking', 287, 'Valet Parking'),
(135, 'Airport Transfer', 287, 'Airport Transfer'),
(136, 'Travel Insurance', 287, 'Travel Insurance'),
(137, 'Airport Lounge access', 287, 'Lounge Access'),
(138, 'Exclusive Movie Offers', 287, 'Movie Discount'),
(139, '15% rewards for spends at dnata Travel and Emirates Leisure', 288, 'Rewards'),
(140, '10% rewards for spends at MMI / Al Hamra Cellar and Le Clos', 288, 'Rewards'),
(141, '10% rewards for Duty Free Shopping worldwide', 288, 'Shopping Discount'),
(142, '0% bank fee for foreign transactions', 288, '0% bank fee for foreign transactions'),
(143, 'Complimentary Airport lounge access to over 1000 lounges', 288, 'Lounge Access'),
(144, '10% rewards for spends at dnata Travel and Emirates Leisure', 289, 'Rewards'),
(145, '10% rewards for spends at MMI / Al Hamra Cellar and Le Clos', 289, 'Rewards'),
(146, '10% rewards for Duty Free Shopping worldwide', 289, 'Shopping Discount'),
(147, 'Complimentary Airport lounge access to over 1000 lounges', 289, 'Lounge Access'),
(148, 'Welcome offer of up to 200,000 Etihad Guest Miles', 290, 'welcome offer up  200,000 EGM**.'),
(149, 'Premium lifestyle benefits - valet parking, cinema offers', 290, 'Valet Parking'),
(150, 'Premium travel offers - airport lounge, airport transfers', 290, 'Airport Transfer'),
(151, 'Complimentary airport lounge access to over 1000 lounges', 290, 'Lounge Access'),
(152, 'Concierge services for your time-consuming errands', 290, 'concierge services for your time-consuming errands'),
(153, 'Welcome offer of up to 60,000 Etihad Guest Miles', 291, 'welcome offer 60,000 EGM**.'),
(154, 'High Etihad Miles earning rate on hotels, dining & Etihad', 291, 'Dining Offer'),
(155, 'Complimentary cinema tickets, golf access, valet parking', 291, 'Valet Parking'),
(156, 'Complimentary Airport lounge access', 291, 'Lounge Access'),
(157, 'Up to 1.5 points for every AED 100 spent', 292, 'up to 1.5 points for every aed 100 spent'),
(158, 'Complimentary Airport Lounge Access', 292, 'Lounge Access'),
(159, 'Golf Privileges', 292, 'Golf Access'),
(160, 'Up to 30% discount on Restaurants across the UAE', 292, 'up to 30% discount on restaurants across the uae'),
(161, 'Earn rewards on all domestic & international spends', 292, 'Rewards'),
(162, 'Up to 1.5 points for every AED 100 spent', 293, 'up to 1.5 points for every aed 100 spent'),
(163, 'Free insurance for big purchases', 293, 'free insurance for big purchases'),
(164, 'Valet Parking Service', 293, 'Valet Parking'),
(165, 'Up to 50% discount on health & fitness', 293, 'up to 50% discount on health & fitness'),
(166, 'Golf Privileges', 293, 'Golf Access'),
(167, 'Complimentary access to over 10 VIP Airport lounges', 294, 'complimentary access to over 10 vip airport lounges'),
(168, 'Enjoy Master Card Buy 1 Get 1 offers', 294, 'enjoy master card buy 1 get 1 offers'),
(169, 'Earn rewards on all domestic & international spends', 294, 'Rewards'),
(170, 'Exclusive offers and deals on travel, lifestyle & shopping', 294, 'Shopping Discount'),
(171, 'Get up to 40% discount at over 100 golf courses worldwide', 294, 'Golf Access'),
(172, 'Complimentary access to over 10 VIP Airport lounges', 295, 'complimentary access to over 10 vip airport lounges'),
(173, 'Complimentary Travel Insurance', 295, 'Travel Insurance'),
(174, 'Golf Privileges', 295, 'Golf Access'),
(175, 'Valet parking', 295, 'Valet Parking'),
(176, 'Buy 1 get 1 free’ at VOX Cinemas', 295, 'buy 1 get 1 free’ at vox cinemas'),
(177, 'Complimentary access to over 10 VIP Airport lounges', 296, 'complimentary access to over 10 vip airport lounges'),
(178, 'Concierge Services', 296, 'concierge services'),
(179, 'Free for Life', 296, 'Free for Life'),
(180, 'Buy 1 get 1 free’ at VOX Cinemas', 296, 'buy 1 get 1 free’ at vox cinemas'),
(181, 'Free for Life', 297, 'Free for Life'),
(182, 'Buy 1 get 1 free’ at VOX Cinemas', 297, 'buy 1 get 1 free’ at vox cinemas'),
(183, '0% Easy Installment Plan', 297, '0% easy installment plan'),
(184, 'Buy 1 get 1 free’ at VOX Cinemas', 298, 'buy 1 get 1 free’ at vox cinemas'),
(185, 'Airport Lounge Access', 298, 'Lounge Access'),
(186, 'Golf Privileges', 298, 'Golf Access'),
(187, 'Valet Parking', 298, 'Valet Parking'),
(188, 'Complimentary Darna Platinum tier status', 298, 'complimentary darna platinum tier status'),
(189, 'Buy 1 get 1 free’ at VOX Cinemas', 299, 'buy 1 get 1 free’ at vox cinemas'),
(190, 'Airport Lounge Access', 299, 'Lounge Access'),
(191, 'Free for first year', 299, 'free for first year'),
(192, 'Complimentary Darna Gold tier status', 299, 'complimentary darna gold tier status'),
(193, 'Buy 1 get 1 free’ at VOX Cinemas', 300, 'buy 1 get 1 free’ at vox cinemas'),
(194, 'Free for Life', 300, 'Free for Life'),
(195, 'Complimentary Darna Silver tier status', 300, 'Silver Tier Benefits'),
(196, 'Airport Lounge Access', 301, 'Lounge Access'),
(197, 'Buy 1 get 1 free at Reel Cinemas', 301, 'buy 1 get 1 free at reel cinemas'),
(198, 'Complimentary valet parking', 301, 'Valet Parking'),
(199, 'Excellent discounts & offers at Emaar establishments', 301, 'excellent discounts & offers at emaar establishments'),
(200, '7.5% U points on all Emaar spends', 301, '7.5% u points on all emaar spends'),
(201, 'Airport Lounge Access', 302, 'Lounge Access'),
(202, 'Buy 1 get 1 free’ at Reel Cinemas', 302, 'buy 1 get 1 free’ at reel cinemas'),
(203, 'Excellent discounts & offers at Emaar establishments', 302, 'excellent discounts & offers at emaar establishments'),
(204, '6.25% U points on all Emaar spends', 302, '6.25% u points on all emaar spends'),
(205, 'Golf Privilege', 302, 'Golf Access'),
(206, 'Buy 1 get 1 free offer at Reel Cinemas', 303, 'buy 1 get 1 free offer at reel cinemas'),
(207, 'Excellent discounts & offers at Emaar establishments', 303, 'excellent discounts & offers at emaar establishments'),
(208, '5% U points on all Emaar spends', 303, '5% u points on all emaar spends'),
(209, 'Free for life', 303, 'Free for Life'),
(210, 'Life time free Credit card', 304, 'life time free credit card'),
(211, 'AED 500 Welcome bonus', 304, 'Welcome Bonus'),
(212, 'Movies discount at VOX Cinemas', 304, 'Movie Discount'),
(213, 'Get 5% back as noon credits and flat 15% discount', 304, 'get 5% back as noon credits and flat 15% discount'),
(214, 'Get up to 20% back as noon credits when you order food', 304, 'get up to 20% back as noon credits when you order food'),
(215, 'Earn 10% back as noon credits on purchases.', 304, 'earn 10% back as noon credits on purchases.'),
(216, 'Airport lounge access', 305, 'Lounge Access'),
(217, 'Fast track your Etihad Guest Gold membership', 305, 'fast track your etihad guest gold membership'),
(218, 'Free inflight Wi-Fi voucher', 305, 'free inflight wi-fi voucher'),
(219, '75% Miles Discount Voucher', 305, '75% miles discount voucher'),
(220, 'A 55,000 Etihad Guest Miles bonus', 305, 'a 55,000 etihad guest miles bonus'),
(221, 'Airport lounge access', 306, 'Lounge Access'),
(222, 'Fast track your Etihad Guest Silver membership', 306, 'fast track your etihad guest silver membership'),
(223, 'Free inflight Wi-Fi voucher', 306, 'free inflight wi-fi voucher'),
(224, '50% Miles Discount Voucher', 306, '50% miles discount voucher'),
(225, 'A 35,000 Etihad Guest Miles bonus', 306, 'a 35,000 etihad guest miles bonus'),
(226, 'Cinema Discount', 307, 'cinema discount'),
(227, 'Free Airport transfers', 307, 'Airport Transfer'),
(228, '25% Miles Discount Voucher', 307, '25% miles discount voucher'),
(229, 'A 10,000 Etihad Guest Miles bonus', 307, 'a 10,000 etihad guest miles bonus'),
(230, 'A free return flight every year', 308, 'a free return flight every year'),
(231, '12% cashback on all flight and hotel bookings', 308, 'Cashback'),
(232, '0% foreign currency conversion fees', 308, '0% foreign currency conversion fees'),
(233, 'Free lounge access along with 2 guests', 308, 'Lounge Access'),
(234, 'Save up to AED 1,000 each month', 309, 'save up to aed 1,000 each month'),
(235, 'Get up to 5% cashback on fashion, dining out and grocery shopping', 309, 'Cashback'),
(236, 'Get up to 3% cashback on international spending', 309, 'Cashback'),
(237, 'Get up to 40% off MakeMyTrip bookings,', 309, 'get up to 40% off makemytrip bookings,'),
(238, 'Free worldwide Airport lounge access', 309, 'Lounge Access'),
(239, 'No annual fee', 310, 'no annual fee'),
(240, 'Airport lounge access', 310, 'Lounge Access'),
(241, 'Get Up to 12 Months 0% EPP', 310, 'get up to 12 months 0% epp'),
(242, '10% cashback on your du postpaid line bills', 310, 'Cashback'),
(243, '10% cashback on du home services bills', 310, 'Cashback'),
(244, '10% cashback on prepaid line recharges', 310, 'Cashback'),
(245, '10% cashback on your du smartphone Privilege Plan', 310, 'Cashback'),
(246, 'Save big on school and family expenses.', 311, 'save big on school and family expenses.'),
(247, 'Save up to 4.25% on school fees', 311, 'save up to 4.25% on school fees'),
(248, 'Get 10% cashback on school bus, canteen, and uniform purchases, plus non-school activities', 311, 'Cashback'),
(249, 'Receive a 20% discount at Emaar attractions and more', 311, 'receive a 20% discount at emaar attractions and more'),
(250, '2% cashback on spending', 311, 'Cashback'),
(251, '9% cashback on Al-Futtaim retail brands', 312, 'Cashback'),
(252, '4% cashback at Al-Futtaim school, car and real estate brands', 312, 'Cashback'),
(253, '0% interest buy now pay later plans on your Al-Futtaim shopping', 312, 'Shopping Discount'),
(254, '7% cashback on Al-Futtaim retail brands', 313, 'Cashback'),
(255, '3% cashback at Al-Futtaim school, car and real estate brands', 313, 'Cashback'),
(256, 'Free airport lounge access', 313, 'Lounge Access'),
(257, '6% cashback on Al-Futtaim retail brands', 314, 'Cashback'),
(258, '2% cashback at Al-Futtaim school, car and real estate brands', 314, 'Cashback'),
(259, '0% interest buy now pay later plans on your Al-Futtaim shopping', 314, 'Shopping Discount'),
(260, 'First year free with a new card', 315, 'first year free with a new card'),
(261, 'Exclusive access to luxury beach clubs, gyms, premium dining experiences and more', 315, 'Dining Offer'),
(262, 'More convenience with 24/7 global concierge and free valet parking', 315, 'Valet Parking'),
(263, 'Guaranteed gift of gold bars and tree planting with each card', 315, NULL),
(264, 'Earn up to 500,000 FAB Rewards on all your spending', 315, 'Rewards'),
(265, 'Travel Insurance', 317, 'Travel Insurance'),
(266, 'Free for Life', 317, 'Free for Life'),
(267, 'Extended Warranty', 317, 'extended warranty'),
(268, '5% cashback on dining', 317, 'Cashback'),
(269, 'Free for Life credit card', 318, 'Free for Life'),
(270, 'AED 500 Welcome bonus', 318, 'Welcome Bonus'),
(271, 'Instant Digital Card', 318, 'Digital Card'),
(272, 'Free noon delivery', 318, 'free noon delivery'),
(273, 'Travel Insurance', 319, 'Travel Insurance'),
(274, 'Free Airport transfer', 319, 'Airport Transfer'),
(275, 'Up to 5 Vantage points per 1 AED', 319, 'up to 5 vantage points per 1 aed'),
(276, 'Get 50% off at selected Restaurants, Spa, Entertainment', 319, '50% off restaurants, spa, entertainment**'),
(277, '50% discount on movie tickets', 320, 'Movie Discount'),
(278, 'Golf Benefits', 320, 'Golf Access'),
(279, 'Travel Insurance', 320, 'Travel Insurance'),
(280, 'Earn 1 Salaam Point on local spends.', 320, 'earn 1 salaam point on local spends.'),
(281, 'Earn 6 Salaam points on International spends.', 320, 'earn 6 salaam points on international spends.'),
(282, 'Get AED 1,000 welcome bonus Free for First year', 321, 'Welcome Bonus'),
(283, 'Up to 10% cashback on supermarket', 321, 'Cashback'),
(284, '50% discount on VOX Cinemas', 321, '50% discount on vox cinemas'),
(285, '10% cashback on travel, flight and hotel bookings', 321, 'Cashback'),
(286, 'Get AED 500 welcome bonus  Cashback of up to 5% on supermarket & dining spends and up to 50% for entertainment spends', 322, 'Cashback'),
(287, 'Get up to AED 600 cashback per month', 322, 'Cashback'),
(288, 'Free for life', 322, 'Free for Life'),
(289, 'Earn 1.75 Air rewards per AED 5 for spends', 323, 'Rewards'),
(290, 'Get a joining bonus of 20,000 AirRewards', 323, 'Rewards'),
(291, 'Enjoy benefits with no maximum caps', 323, 'enjoy benefits with no maximum caps'),
(292, 'Enjoy a free-for-life card and great rewards', 324, 'Rewards'),
(293, 'Cashback of up to 1.5% on local & international spends', 324, 'Cashback'),
(294, 'Get up to AED 300 cashback', 324, 'Cashback'),
(295, 'Tier-based Monthly Fee', 325, 'tier-based monthly fee'),
(296, 'Up to 4% cashback on all your spends', 325, 'Cashback'),
(297, 'Up to 3% value back on airline and hotel reward redemption', 325, 'up to 3% value back on airline and hotel reward redemption'),
(298, 'No Foreign Currency Fee', 325, 'no foreign currency fee'),
(299, 'Airport Lounge Access', 326, 'Lounge Access'),
(300, 'Free supplementary card', 326, 'free supplementary card'),
(301, 'Balance Transfer', 326, 'balance transfer'),
(302, 'Easy Payment Plan', 326, 'easy payment plan'),
(303, 'Airport Lounge Access', 327, 'Lounge Access'),
(304, 'Travel Insurance', 327, 'Travel Insurance'),
(305, 'Balance Transfer', 327, 'balance transfer'),
(306, 'Easy Payment Plan', 327, 'easy payment plan'),
(307, 'Free for Life', 328, 'Free for Life'),
(308, 'Travel Insurance', 328, 'Travel Insurance'),
(309, 'Balance Transfer', 328, 'balance transfer'),
(310, 'Easy Payment Plan', 328, 'easy payment plan'),
(311, '50% off on VOX cinema', 329, '50% off on vox cinema'),
(312, '20% off grocery or food order on the Talabat', 329, '20% off grocery or food order on the talabat'),
(313, '3% unlimited Cash Up on fuel', 329, 'Fuel Discount'),
(314, '3% unlimited Cash Up on online shopping', 329, 'Shopping Discount'),
(315, 'Cinema offers on VOX and REEL and much more', 330, 'cinema offers on vox and reel and much more'),
(316, 'Valet Parking', 330, 'Valet Parking'),
(317, 'Dining Offers', 330, 'Dining Offer'),
(318, 'Balance Transfer', 330, 'balance transfer'),
(319, 'Airport Lounge Access', 330, 'Lounge Access'),
(320, '50% off on VOX cinema', 331, '50% off on vox cinema'),
(321, 'Miles Up benefit', 331, 'miles up benefit'),
(322, 'Free Valet parking', 331, 'Valet Parking'),
(323, 'Earn up to 10% cash up on specific categories', 331, 'earn up to 10% cash up on specific categories'),
(324, '20% off grocery or food order on the Talabat', 331, '20% off grocery or food order on the talabat'),
(325, '5% cashback on supermarket spending, dining and fuel, 3% on international spends and 1% on other purchases.', 332, 'Cashback'),
(326, '5% cashback on online purchases, utility bills, school fees', 332, 'Cashback'),
(327, 'Get 20% off talabat delivery', 332, 'get 20% off talabat delivery'),
(328, 'Unlimited Airport Lounge access', 332, 'Lounge Access'),
(329, '20% off on Careem rides', 332, 'Careem Discount'),
(330, '0% interest rate at quick cash & Balance transfer', 332, '0% interest rate at quick cash & balance transfer'),
(331, 'Enjoy Movies at AED 20 only', 332, 'Movie Discount'),
(332, 'Interest Free installment', 333, 'Interest Free'),
(333, 'Digital Card', 333, 'Digital Card'),
(334, 'No processing fees on installment', 333, 'No Processing Fees'),
(335, 'Welcome Bonus AED 500', 334, 'Welcome Bonus'),
(336, 'Free for First Year', 334, 'free for first year'),
(337, 'Travel Insurance', 334, 'Travel Insurance'),
(338, 'Cashback', 334, 'Cashback'),
(339, 'Careem Plus & Zomato Gold subscription', 334, 'Subscription Offer'),
(340, 'Welcome Bonus AED 500', 335, 'Welcome Bonus'),
(341, 'Free for First Year', 335, 'free for first year'),
(342, '5% cashback on fuel', 335, 'Cashback'),
(343, 'Earn 6% cashback on dining', 335, 'Cashback'),
(344, 'Travel Insurance', 335, 'Travel Insurance'),
(345, 'Zomato Gold subscription', 335, 'Subscription Offer'),
(346, 'Welcome Bonus AED 500', 336, 'Welcome Bonus'),
(347, 'Free for 1st year', 336, 'free for 1st year'),
(348, 'Travel Insurance', 336, 'Travel Insurance'),
(349, '1 Air Mile for every AED 1', 336, '1 air mile for every aed 1'),
(350, 'Dining Discounts', 336, 'Dining Offer'),
(351, 'Welcome Bonus up to 50K Skywards Miles', 337, 'Welcome Bonus'),
(352, 'Airport Lounge Access', 337, 'Lounge Access'),
(353, 'Silver Tier Benefits', 337, 'Silver Tier Benefits'),
(354, 'Multi-trip travel insurance', 337, 'Travel Insurance'),
(355, 'Get a complimentary Zomato Gold Dining membership', 337, 'Dining Offer'),
(356, 'Get a complimentary Careem Plus subscription', 337, 'Subscription Offer'),
(357, 'Welcome Bonus up to 20K Skywards Miles', 338, 'Welcome Bonus'),
(358, 'Airport Lounge Access', 338, 'Lounge Access'),
(359, 'Silver Tier Benefits', 338, 'Silver Tier Benefits'),
(360, 'Multi-trip travel insurance', 338, 'Travel Insurance'),
(361, 'Get a complimentary Zomato Gold Dining membership', 338, 'Dining Offer'),
(362, 'Get a complimentary Careem Plus subscription', 338, 'Subscription Offer'),
(363, 'Free for Life', 339, 'Free for Life'),
(364, 'Cashback', 339, 'Cashback'),
(365, 'Airport Lounge Access', 339, 'Lounge Access'),
(366, 'Movie Discounts', 339, 'Movie Discount'),
(367, 'Skywards Miles', 339, 'Skywards Miles'),
(368, 'Cashback', 340, 'Cashback'),
(369, 'Airport Lounge Access', 340, 'Lounge Access'),
(370, 'Movie Discounts', 340, 'Movie Discount'),
(371, 'Airport Transfer', 340, 'Airport Transfer'),
(372, 'Travel Insurance', 340, 'Travel Insurance');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `banks`
--
ALTER TABLE `banks`
  ADD PRIMARY KEY (`idbanks`);

--
-- Indexes for table `carddetailsdummy`
--
ALTER TABLE `carddetailsdummy`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `carddetailsrought`
--
ALTER TABLE `carddetailsrought`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cardfeatures`
--
ALTER TABLE `cardfeatures`
  ADD PRIMARY KEY (`idcardfeature`);

--
-- Indexes for table `cardtypes`
--
ALTER TABLE `cardtypes`
  ADD PRIMARY KEY (`idcardtype`);

--
-- Indexes for table `creditcards`
--
ALTER TABLE `creditcards`
  ADD PRIMARY KEY (`idcreditcards`),
  ADD KEY `fk_creditcards_1_idx` (`idcardtypes`),
  ADD KEY `fk_creditcards_2_idx` (`idbanks`);

--
-- Indexes for table `creditcardsbenefits`
--
ALTER TABLE `creditcardsbenefits`
  ADD PRIMARY KEY (`idcreditcardsbenefits`),
  ADD KEY `fk_creditcardsbenefits_1_idx` (`idcreditcards`);

--
-- Indexes for table `creditcardsfeatures`
--
ALTER TABLE `creditcardsfeatures`
  ADD PRIMARY KEY (`idcreditcardsfeatures`),
  ADD KEY `fk_creditcardsfeatures_1_idx` (`idcreditcards`),
  ADD KEY `fk_creditcardsfeatures_2_idx` (`idcardfeatures`);

--
-- Indexes for table `creditcardsfetures`
--
ALTER TABLE `creditcardsfetures`
  ADD PRIMARY KEY (`idcreditcardsbenefits`),
  ADD KEY `fk_creditcardsfetures_1_idx` (`idcreditcards`);

--
-- Indexes for table `creditcardsoffers`
--
ALTER TABLE `creditcardsoffers`
  ADD PRIMARY KEY (`idcreditcardsoffers`),
  ADD KEY `fk_creditcardsoffers_1_idx` (`idcreditcards`);

--
-- Indexes for table `creditcardstypes`
--
ALTER TABLE `creditcardstypes`
  ADD PRIMARY KEY (`idcreditcardstypes`),
  ADD KEY `fk_creditcardstypes_1_idx` (`idcardtype`),
  ADD KEY `fk_creditcardstypes_2` (`idcreditcards`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `banks`
--
ALTER TABLE `banks`
  MODIFY `idbanks` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `carddetailsdummy`
--
ALTER TABLE `carddetailsdummy`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `carddetailsrought`
--
ALTER TABLE `carddetailsrought`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `cardfeatures`
--
ALTER TABLE `cardfeatures`
  MODIFY `idcardfeature` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=199;

--
-- AUTO_INCREMENT for table `cardtypes`
--
ALTER TABLE `cardtypes`
  MODIFY `idcardtype` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `creditcards`
--
ALTER TABLE `creditcards`
  MODIFY `idcreditcards` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=341;

--
-- AUTO_INCREMENT for table `creditcardsbenefits`
--
ALTER TABLE `creditcardsbenefits`
  MODIFY `idcreditcardsbenefits` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `creditcardsfeatures`
--
ALTER TABLE `creditcardsfeatures`
  MODIFY `idcreditcardsfeatures` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `creditcardsfetures`
--
ALTER TABLE `creditcardsfetures`
  MODIFY `idcreditcardsbenefits` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=373;

--
-- AUTO_INCREMENT for table `creditcardsoffers`
--
ALTER TABLE `creditcardsoffers`
  MODIFY `idcreditcardsoffers` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=242;

--
-- AUTO_INCREMENT for table `creditcardstypes`
--
ALTER TABLE `creditcardstypes`
  MODIFY `idcreditcardstypes` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=779;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `creditcards`
--
ALTER TABLE `creditcards`
  ADD CONSTRAINT `fk_creditcards_1` FOREIGN KEY (`idcardtypes`) REFERENCES `cardtypes` (`idcardtype`),
  ADD CONSTRAINT `fk_creditcards_2` FOREIGN KEY (`idbanks`) REFERENCES `banks` (`idbanks`);

--
-- Constraints for table `creditcardsbenefits`
--
ALTER TABLE `creditcardsbenefits`
  ADD CONSTRAINT `fk_creditcardsbenefits_1` FOREIGN KEY (`idcreditcards`) REFERENCES `creditcards` (`idcreditcards`);

--
-- Constraints for table `creditcardsfeatures`
--
ALTER TABLE `creditcardsfeatures`
  ADD CONSTRAINT `fk_creditcardsfeatures_1` FOREIGN KEY (`idcreditcards`) REFERENCES `creditcards` (`idcreditcards`),
  ADD CONSTRAINT `fk_creditcardsfeatures_2` FOREIGN KEY (`idcardfeatures`) REFERENCES `cardfeatures` (`idcardfeature`);

--
-- Constraints for table `creditcardstypes`
--
ALTER TABLE `creditcardstypes`
  ADD CONSTRAINT `fk_creditcardstypes_1` FOREIGN KEY (`idcardtype`) REFERENCES `cardtypes` (`idcardtype`),
  ADD CONSTRAINT `fk_creditcardstypes_2` FOREIGN KEY (`idcreditcards`) REFERENCES `creditcards` (`idcreditcards`);
COMMIT;

/*!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 */;
