/*
Navicat Premium Data Transfer
Source Server : localhost_3306
Source Server Type : MySQL
Source Server Version : 80020
Source Host : localhost:3306
Source Schema : you_hu
Target Server Type : MySQL
Target Server Version : 80020
File Encoding : 65001
Date: 01/10/2020 15:34:29
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for bank_card_bin
-- ----------------------------
DROP TABLE IF EXISTS `bank_card_bin`;
CREATE TABLE `bank_card_bin` (
`bin` varchar(20) NOT NULL COMMENT '银行卡bin',
`bin_len` int DEFAULT NULL COMMENT '银行卡bin长度',
`bank` varchar(100) DEFAULT NULL COMMENT '发卡行名称\r\n及机构代码',
`card_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '银行卡名',
`card_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '银行卡类型',
`card_len` int DEFAULT NULL COMMENT '银行卡长度',
PRIMARY KEY (`bin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='银行卡bin信息表';
-- ----------------------------
-- Records of bank_card_bin
-- ----------------------------
BEGIN;
INSERT INTO `bank_card_bin` VALUES ('00405512', 8, '交通银行\n(03010000)', '太平洋互连卡', '借记卡', 17);
INSERT INTO `bank_card_bin` VALUES ('00601428', 8, '交通银行\n(03010000)', '太平洋万事顺卡', '借记卡', 17);
INSERT INTO `bank_card_bin` VALUES ('018572', 6, '昆明农联社\n(14097310)', '金碧卡', '借记卡', 18);
INSERT INTO `bank_card_bin` VALUES ('103', 3, '农业银行\n(01030000)', '金穗借记卡', '借记卡', 19);
INSERT INTO `bank_card_bin` VALUES ('303', 3, '光大银行\n(03030000)', '阳光卡', '借记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('3033751', 7, '光大银行厦门支行\n(03033930)', '阳光卡', '借记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('3033752', 7, '光大银行厦门支行\n(03033930)', '阳光卡', '借记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('3033753', 7, '光大银行厦门支行\n(03033930)', '阳光卡', '借记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('3037645', 7, '南京光大\n(03033010)', '阳光卡', '借记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('3037646', 7, '南京光大\n(03033010)', '阳光卡', '借记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('3037647', 7, '南京光大\n(03033010)', '阳光卡', '借记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('3037648', 7, '南京光大\n(03033010)', '阳光卡', '借记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('3037649', 7, '南京光大\n(03033010)', '阳光卡', '借记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('3037650', 7, '南京光大\n(03033010)', '阳光卡', '借记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('3037651', 7, '南京光大\n(03033010)', '阳光卡', '借记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('3037652', 7, '南京光大\n(03033010)', '阳光卡', '借记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('3037653', 7, '南京光大\n(03033010)', '阳光卡', '借记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('3037655', 7, '南京光大\n(03033010)', '阳光卡', '借记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('3037751', 7, '光大银行厦门支行\n(03033930)', '阳光卡', '借记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('3037752', 7, '光大银行厦门支行\n(03033930)', '阳光卡', '借记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('3037753', 7, '光大银行厦门支行\n(03033930)', '阳光卡', '借记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356390', 6, '中信银行信用卡中心\n(63020000)', '中信JCB美元卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356391', 6, '中信银行信用卡中心\n(63020000)', '中信JCB美元卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356392', 6, '中信银行信用卡中心\n(63020000)', '中信JCB美元卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356827', 6, '上海银行\n(04012902)', '申卡贷记卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356828', 6, '上海银行\n(04012902)', '申卡贷记卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356829', 6, '上海银行\n(04012902)', '分期付款信用卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356830', 6, '上海银行\n(04012902)', 'J分期付款信用卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356833', 6, '中国银行\n(01040000)', '中银JCB卡金卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356835', 6, '中国银行\n(01040000)', '中银JCB卡普卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356839', 6, '中国光大银行\n(63030000)', '阳光商旅信用卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356840', 6, '中国光大银行\n(63030000)', '阳光商旅信用卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356850', 6, '浦东发展银行\n(03100000)', '浦发JCB普卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356851', 6, '浦东发展银行\n(03100000)', '浦发JCB金卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356852', 6, '浦东发展银行\n(03100000)', '浦发JCB白金卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356856', 6, '民生银行\n(03050001)', '民生JCB普卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356857', 6, '民生银行\n(03050001)', '民生JCB金卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356858', 6, '民生银行\n(03050001)', '民生JCB白金卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356859', 6, '民生银行\n(03050001)', '民生JCB信用卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356868', 6, '平安银行股份有限公司\n(05105840)', '信用卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356869', 6, '平安银行股份有限公司\n(05105840)', '信用卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356879', 6, '中国工商银行\n(01020000)', '牡丹JCB信用卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356880', 6, '中国工商银行\n(01020000)', '牡丹JCB信用卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356881', 6, '中国工商银行\n(01020000)', '牡丹JCB信用卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356882', 6, '中国工商银行\n(01020000)', '牡丹JCB信用卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356885', 6, '招商银行\n(03080000)', '招商银行信用卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356886', 6, '招商银行\n(03080000)', '招商银行信用卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356887', 6, '招商银行\n(03080000)', '招商银行信用卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356888', 6, '招商银行\n(03080000)', '招商银行信用卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356889', 6, '招商银行\n(03080000)', '招商银行信用卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356890', 6, '招商银行\n(03080000)', '招商银行信用卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356895', 6, '中国建设银行\n(01059999)', '龙卡JCB普卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356896', 6, '中国建设银行\n(01059999)', '龙卡JCB金卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('356899', 6, '中国建设银行\n(01059999)', '龙卡JCB白金卡', '贷记卡', 16);
INSERT INTO `bank_card_bin` VALUES ('360883', 6, '中国工商银行\n(01020000)', '牡丹工银大来卡', '贷记卡', 14);
INSERT INTO `bank_card_bin` VALUES ('360884', 6, '中国工商银行\n(01020000)', '牡丹工银大莱卡', '贷记卡', 14);
INSERT INTO `bank_card_bin` VALUES ('370246', 6, '工商银行\n(01020000)', '牡丹运通卡金卡', '贷记卡', 15);
INSERT INTO `bank_card_bin` VALU
银行卡bin数据(Excel+MySQL)-2020最新最全-银联官方发布
3星 · 超过75%的资源 需积分: 48 73 浏览量
2020-10-01
15:38:49
上传
评论 6
收藏 1.12MB ZIP 举报
白夜鸦羽
- 粉丝: 46
- 资源: 6