MaxCompute云计算资源所需要的脚本内容有哪些_数据资源平台(DRP)-阿里云帮助中心

将MaxCompute脚本导入数据库，可用于初始化数据。本文为您提供MaxCompute云计算资源中所需要的数据表建表语句以及数据插入语句等SQL脚本内容。

背景信息

用数据库连接工具连接 MaxCompute 中的dataq_odps_dev数据库，将初始化数据导入数据库。

数据表含义说明

stg_base_xykbkjl_demo_di：信用卡信息表
stg_base_xykxfmx_demo_di：信用卡消费明细表
stg_base_yhkh_demo_di：银行客户信息表

建表及插入数据脚本

信用卡信息表

创建stg_base_xykbkjl_demo_di表，建表语句如下。

create table if not exists `stg_base_xykbkjl_demo_di` ( 
`id` bigint comment '主键',
`cid` string comment '卡id',
`climit` bigint comment '卡额度',
`actdate` bigint comment '统计日期',
`channel` string comment '办卡渠道',
`rid` string comment '持卡人id'
)
 comment '信用卡信息' ;

插入stg_base_xykbkjl_demo_di表中的数据，插入语句如下。

insert into stg_base_xykbkjl_demo_di values 
(1,'XYK-1001',5,1514736000,'渠道1','CKR-1000'),
(2,'XYK-1002',5,1517414400,'渠道1','CKR-1000'),
(3,'XYK-1003',10,1517587200,'渠道1','CKR-1000'),
(4,'XYK-1004',5,1520611200,'渠道1','CKR-1000'),
(5,'XYK-1005',10,1528128000,'渠道4','CKR-1000'),
(6,'XYK-1006',15,1528041600,'渠道4','CKR-1000'),
(7,'XYK-1007',10,1527955200,'渠道4','CKR-1000'),
(8,'XYK-1008',15,1527868800,'渠道4','CKR-1000'),
(9,'XYK-1009',10,1527782400,'渠道4','CKR-1000'),
(10,'XYK-2001',20,1483200000,'渠道1','CKR-2000'),
(11,'XYK-2002',10,1496246400,'渠道1','CKR-2000'),
(12,'XYK-2003',15,1515945600,'渠道2','CKR-2000'),
(13,'XYK-2004',5,1516809600,'渠道2','CKR-2000'),
(14,'XYK-2005',5,1527177600,'渠道3','CKR-2000'),
(15,'XYK-2006',15,1531584000,'渠道3','CKR-2000'),
(16,'XYK-3001',10,1520092800,'渠道3','CKR-3000'),
(17,'XYK-3002',10,1520092800,'渠道3','CKR-3000'),
(18,'XYK-3003',10,1520092800,'渠道3','CKR-3000'),
(19,'XYK-3004',10,1520179200,'渠道3','CKR-3000'),
(20,'XYK-3005',10,1520179200,'渠道3','CKR-3000'),
(21,'XYK-4001',10,1507910400,'渠道2','CKR-4000'),
(22,'XYK-4002',15,1522339200,'渠道2','CKR-4000'),
(23,'XYK-4003',5,1527782400,'渠道2','CKR-4000'),
(24,'XYK-5001',5,1527955200,'渠道4','CKR-5000'),
(25,'XYK-5002',10,1527955200,'渠道5','CKR-5000'),
(26,'XYK-5003',10,1527955200,'渠道5','CKR-5000'),
(27,'XYK-5004',20,1527955200,'渠道4','CKR-5000'),
(28,'XYK-5005',10,1528041600,'渠道4','CKR-5000'),
(29,'XYK-5006',10,1528041600,'渠道5','CKR-5000'),
(30,'XYK-5007',15,1528041600,'渠道4','CKR-5000'),
(31,'XYK-5008',5,1528214400,'渠道4','CKR-5000'),
(32,'XYK-5009',15,1528214400,'渠道4','CKR-5000'),
(33,'XYK-5010',5,1528300800,'渠道4','CKR-5000');

信用卡消费明细表

创建stg_base_xykxfmx_demo_di表，建表语句如下。

create table if not exists `stg_base_xykxfmx_demo_di` ( 
`id` bigint comment '主键',
`cid` string comment '卡id',
`xfrq` string comment '统计日期',
`rid` string comment '持卡人id',
`xfje` double comment '消费金额',
`xflx` string comment '消费类型'
)
 comment '信用卡消费' ;

插入stg_base_xykxfmx_demo_di表中的数据，插入语句如下。

insert into stg_base_xykxfmx_demo_di values
(1,'XYK-1001',201801,'CKR-1000',1.3,'大额消费'),
(2,'XYK-1001',201801,'CKR-1000',2,'大额整数消费'),
(3,'XYK-1001',201801,'CKR-1000',0.8,'用一商户连续刷卡'),
(4,'XYK-1001',201801,'CKR-1000',1.3,'购买基金'),
(5,'XYK-1001',201801,'CKR-1000',0.1,'娱乐消费'),
(6,'XYK-1001',201801,'CKR-1000',0.5,'购买保险'),
(7,'XYK-1001',201802,'CKR-1000',1.3,'大额消费'),
(8,'XYK-1001',201802,'CKR-1000',1,'大额整数消费'),
(9,'XYK-1001',201802,'CKR-1000',0.8,'用一商户连续刷卡'),
(10,'XYK-1001',201802,'CKR-1000',1.3,'购买基金'),
(11,'XYK-1001',201802,'CKR-1000',0.1,'娱乐消费'),
(12,'XYK-1001',201802,'CKR-1000',0.5,'购买保险'),
(13,'XYK-1001',201803,'CKR-1000',1.3,'大额消费'),
(14,'XYK-1001',201803,'CKR-1000',1,'大额整数消费'),
(15,'XYK-1001',201803,'CKR-1000',0.8,'用一商户连续刷卡'),
(16,'XYK-1001',201803,'CKR-1000',1.3,'购买基金'),
(17,'XYK-1001',201803,'CKR-1000',0.1,'娱乐消费'),
(18,'XYK-1001',201803,'CKR-1000',0.5,'购买保险'),
(19,'XYK-1001',201804,'CKR-1000',1.3,'大额消费'),
(20,'XYK-1001',201804,'CKR-1000',1,'大额整数消费'),
(21,'XYK-1001',201804,'CKR-1000',0.8,'用一商户连续刷卡'),
(22,'XYK-1001',201804,'CKR-1000',1.3,'购买基金'),
(23,'XYK-1001',201804,'CKR-1000',0.1,'娱乐消费'),
(24,'XYK-1001',201804,'CKR-1000',0.5,'购买保险'),
(25,'XYK-1001',201805,'CKR-1000',1.3,'大额消费'),
(26,'XYK-1001',201805,'CKR-1000',1,'大额整数消费'),
(27,'XYK-1001',201805,'CKR-1000',0.8,'用一商户连续刷卡'),
(28,'XYK-1001',201805,'CKR-1000',1.3,'购买基金'),
(29,'XYK-1001',201805,'CKR-1000',0.1,'娱乐消费'),
(30,'XYK-1001',201805,'CKR-1000',0.5,'购买保险'),
(31,'XYK-1001',201806,'CKR-1000',1.3,'大额消费'),
(32,'XYK-1001',201806,'CKR-1000',1,'大额整数消费'),
(33,'XYK-1001',201806,'CKR-1000',0.8,'用一商户连续刷卡'),
(34,'XYK-1001',201806,'CKR-1000',1.3,'购买基金'),
(35,'XYK-1001',201806,'CKR-1000',0.1,'娱乐消费'),
(36,'XYK-1001',201806,'CKR-1000',0.5,'购买保险'),
(37,'XYK-1001',201807,'CKR-1000',1.3,'大额消费'),
(38,'XYK-1001',201807,'CKR-1000',1,'大额整数消费'),
(39,'XYK-1001',201807,'CKR-1000',0.8,'用一商户连续刷卡'),
(40,'XYK-1001',201807,'CKR-1000',1.3,'购买基金'),
(41,'XYK-1001',201807,'CKR-1000',0.1,'娱乐消费'),
(42,'XYK-1001',201807,'CKR-1000',0.5,'购买保险'),
(43,'XYK-1001',201808,'CKR-1000',1.3,'大额消费'),
(44,'XYK-1001',201808,'CKR-1000',1,'大额整数消费'),
(45,'XYK-1001',201808,'CKR-1000',0.8,'用一商户连续刷卡'),
(46,'XYK-1001',201808,'CKR-1000',1.3,'购买基金'),
(47,'XYK-1001',201808,'CKR-1000',0.1,'娱乐消费'),
(48,'XYK-1001',201808,'CKR-1000',0.5,'购买保险'),
(49,'XYK-1001',201809,'CKR-1000',1.3,'大额消费'),
(50,'XYK-1001',201809,'CKR-1000',1,'大额整数消费'),
(51,'XYK-1001',201809,'CKR-1000',0.8,'用一商户连续刷卡'),
(52,'XYK-1001',201809,'CKR-1000',1.3,'购买基金'),
(53,'XYK-1001',201809,'CKR-1000',0.1,'娱乐消费'),
(54,'XYK-1001',201809,'CKR-1000',0.5,'购买保险'),
(55,'XYK-1002',201810,'CKR-1000',1.4,'大额消费'),
(56,'XYK-1002',201810,'CKR-1000',1,'大额整数消费'),
(57,'XYK-1002',201810,'CKR-1000',0.2,'用一商户连续刷卡'),
(58,'XYK-1002',201810,'CKR-1000',1.4,'购买基金'),
(59,'XYK-1002',201810,'CKR-1000',0.2,'娱乐消费'),
(60,'XYK-1002',201810,'CKR-1000',3.4,'购买保险'),
(61,'XYK-1002',201801,'CKR-1000',1.4,'大额消费'),
(62,'XYK-1002',201801,'CKR-1000',1,'大额整数消费'),
(63,'XYK-1002',201801,'CKR-1000',0.2,'用一商户连续刷卡'),
(64,'XYK-1002',201801,'CKR-1000',1.4,'购买基金'),
(65,'XYK-1002',201801,'CKR-1000',0.2,'娱乐消费'),
(66,'XYK-1002',201801,'CKR-1000',3.4,'购买保险'),
(67,'XYK-1002',201802,'CKR-1000',1.4,'大额消费'),
(68,'XYK-1002',201802,'CKR-1000',1,'大额整数消费'),
(69,'XYK-1002',201802,'CKR-1000',0.2,'用一商户连续刷卡'),
(70,'XYK-1002',201802,'CKR-1000',1.4,'购买基金'),
(71,'XYK-1002',201802,'CKR-1000',0.2,'娱乐消费'),
(72,'XYK-1002',201802,'CKR-1000',3.4,'购买保险'),
(73,'XYK-1002',201803,'CKR-1000',1.4,'大额消费'),
(74,'XYK-1002',201803,'CKR-1000',1,'大额整数消费'),
(75,'XYK-1002',201803,'CKR-1000',0.2,'用一商户连续刷卡'),
(76,'XYK-1002',201803,'CKR-1000',1.4,'购买基金'),
(77,'XYK-1002',201803,'CKR-1000',0.2,'娱乐消费'),
(78,'XYK-1002',201803,'CKR-1000',3.4,'购买保险'),
(79,'XYK-1002',201804,'CKR-1000',1.4,'大额消费'),
(80,'XYK-1002',201804,'CKR-1000',1,'大额整数消费'),
(81,'XYK-1002',201804,'CKR-1000',0.2,'用一商户连续刷卡'),
(82,'XYK-1002',201804,'CKR-1000',1.4,'购买基金'),
(83,'XYK-1002',201804,'CKR-1000',0.2,'娱乐消费'),
(84,'XYK-1002',201804,'CKR-1000',3.4,'购买保险'),
(85,'XYK-1002',201805,'CKR-1000',1.4,'大额消费'),
(86,'XYK-1002',201805,'CKR-1000',1,'大额整数消费'),
(87,'XYK-1002',201805,'CKR-1000',0.2,'用一商户连续刷卡'),
(88,'XYK-1002',201805,'CKR-1000',1.4,'购买基金'),
(89,'XYK-1002',201805,'CKR-1000',0.2,'娱乐消费'),
(90,'XYK-1002',201805,'CKR-1000',3.4,'购买保险'),
(91,'XYK-1002',201806,'CKR-1000',1.4,'大额消费'),
(92,'XYK-1002',201806,'CKR-1000',1,'大额整数消费'),
(93,'XYK-1002',201806,'CKR-1000',0.2,'用一商户连续刷卡'),
(94,'XYK-1002',201806,'CKR-1000',1.4,'购买基金'),
(95,'XYK-1002',201806,'CKR-1000',0.2,'娱乐消费'),
(96,'XYK-1002',201806,'CKR-1000',3.4,'购买保险'),
(97,'XYK-1002',201807,'CKR-1000',1.4,'大额消费'),
(98,'XYK-1002',201807,'CKR-1000',1,'大额整数消费'),
(99,'XYK-1002',201807,'CKR-1000',0.2,'用一商户连续刷卡'),
(100,'XYK-1002',201807,'CKR-1000',1.4,'购买基金'),
(101,'XYK-1002',201807,'CKR-1000',0.2,'娱乐消费'),
(102,'XYK-1002',201807,'CKR-1000',3.4,'购买保险'),
(103,'XYK-1003',201803,'CKR-1000',2.3,'大额消费'),
(104,'XYK-1003',201803,'CKR-1000',3,'大额整数消费'),
(105,'XYK-1003',201803,'CKR-1000',0.4,'用一商户连续刷卡'),
(106,'XYK-1003',201803,'CKR-1000',2.3,'购买基金'),
(107,'XYK-1003',201803,'CKR-1000',0.3,'娱乐消费'),
(108,'XYK-1003',201803,'CKR-1000',1.2,'购买保险'),
(109,'XYK-1004',201801,'CKR-1000',0.8,'大额消费'),
(110,'XYK-1004',201801,'CKR-1000',1,'大额整数消费'),
(111,'XYK-1004',201801,'CKR-1000',0.5,'用一商户连续刷卡'),
(112,'XYK-1004',201801,'CKR-1000',0.8,'购买基金'),
(113,'XYK-1004',201801,'CKR-1000',0.4,'娱乐消费'),
(114,'XYK-1004',201801,'CKR-1000',3,'购买保险'),
(115,'XYK-1004',201802,'CKR-1000',0.8,'大额消费'),
(116,'XYK-1004',201802,'CKR-1000',1,'大额整数消费'),
(117,'XYK-1004',201802,'CKR-1000',0.5,'用一商户连续刷卡'),
(118,'XYK-1004',201802,'CKR-1000',0.8,'购买基金'),
(119,'XYK-1004',201802,'CKR-1000',0.4,'娱乐消费'),
(120,'XYK-1004',201802,'CKR-1000',3,'购买保险'),
(121,'XYK-1004',201803,'CKR-1000',0.8,'大额消费'),
(122,'XYK-1004',201803,'CKR-1000',1,'大额整数消费'),
(123,'XYK-1004',201803,'CKR-1000',0.5,'用一商户连续刷卡'),
(124,'XYK-1004',201803,'CKR-1000',0.8,'购买基金'),
(125,'XYK-1004',201803,'CKR-1000',0.4,'娱乐消费'),
(126,'XYK-1004',201803,'CKR-1000',3,'购买保险'),
(127,'XYK-1004',201804,'CKR-1000',0.8,'大额消费'),
(128,'XYK-1004',201804,'CKR-1000',1,'大额整数消费'),
(129,'XYK-1004',201804,'CKR-1000',0.5,'用一商户连续刷卡'),
(130,'XYK-1004',201804,'CKR-1000',0.8,'购买基金'),
(131,'XYK-1004',201804,'CKR-1000',0.4,'娱乐消费'),
(132,'XYK-1004',201804,'CKR-1000',3,'购买保险'),
(133,'XYK-1004',201805,'CKR-1000',0.8,'大额消费'),
(134,'XYK-1004',201805,'CKR-1000',1,'大额整数消费'),
(135,'XYK-1004',201805,'CKR-1000',0.5,'用一商户连续刷卡'),
(136,'XYK-1004',201805,'CKR-1000',0.8,'购买基金'),
(137,'XYK-1004',201805,'CKR-1000',0.4,'娱乐消费'),
(138,'XYK-1004',201805,'CKR-1000',3,'购买保险'),
(139,'XYK-1004',201806,'CKR-1000',0.8,'大额消费'),
(140,'XYK-1004',201806,'CKR-1000',1,'大额整数消费'),
(141,'XYK-1004',201806,'CKR-1000',0.5,'用一商户连续刷卡'),
(142,'XYK-1004',201806,'CKR-1000',0.8,'购买基金'),
(143,'XYK-1004',201806,'CKR-1000',0.4,'娱乐消费'),
(144,'XYK-1004',201806,'CKR-1000',3,'购买保险'),
(145,'XYK-1004',201807,'CKR-1000',0.8,'大额消费'),
(146,'XYK-1004',201807,'CKR-1000',1,'大额整数消费'),
(147,'XYK-1004',201807,'CKR-1000',0.5,'用一商户连续刷卡'),
(148,'XYK-1004',201807,'CKR-1000',0.8,'购买基金'),
(149,'XYK-1004',201807,'CKR-1000',0.4,'娱乐消费'),
(150,'XYK-1004',201807,'CKR-1000',3,'购买保险'),
(151,'XYK-1004',201808,'CKR-1000',0.8,'大额消费'),
(152,'XYK-1004',201808,'CKR-1000',1,'大额整数消费'),
(153,'XYK-1004',201808,'CKR-1000',0.5,'用一商户连续刷卡'),
(154,'XYK-1004',201808,'CKR-1000',0.8,'购买基金'),
(155,'XYK-1004',201808,'CKR-1000',0.4,'娱乐消费'),
(156,'XYK-1004',201808,'CKR-1000',3,'购买保险'),
(157,'XYK-1004',201809,'CKR-1000',0.8,'大额消费'),
(158,'XYK-1004',201809,'CKR-1000',1,'大额整数消费'),
(159,'XYK-1004',201809,'CKR-1000',0.5,'用一商户连续刷卡'),
(160,'XYK-1004',201809,'CKR-1000',0.8,'购买基金'),
(161,'XYK-1004',201809,'CKR-1000',0.4,'娱乐消费'),
(162,'XYK-1004',201809,'CKR-1000',3,'购买保险'),
(163,'XYK-1005',201805,'CKR-1000',2.3,'大额消费'),
(164,'XYK-1005',201805,'CKR-1000',1,'大额整数消费'),
(165,'XYK-1005',201805,'CKR-1000',0.9,'用一商户连续刷卡'),
(166,'XYK-1005',201805,'CKR-1000',2.3,'购买基金'),
(167,'XYK-1005',201805,'CKR-1000',0.5,'娱乐消费'),
(168,'XYK-1005',201805,'CKR-1000',1,'购买保险'),
(169,'XYK-1006',201806,'CKR-1000',0.5,'大额消费'),
(170,'XYK-1006',201806,'CKR-1000',1,'大额整数消费'),
(171,'XYK-1006',201806,'CKR-1000',1,'用一商户连续刷卡'),
(172,'XYK-1006',201806,'CKR-1000',0.5,'购买基金'),
(173,'XYK-1006',201806,'CKR-1000',0.6,'娱乐消费'),
(174,'XYK-1006',201806,'CKR-1000',2.8,'购买保险'),
(175,'XYK-1007',201807,'CKR-1000',1.4,'大额消费'),
(176,'XYK-1007',201807,'CKR-1000',2,'大额整数消费'),
(177,'XYK-1007',201807,'CKR-1000',1.8,'用一商户连续刷卡'),
(178,'XYK-1007',201807,'CKR-1000',1.4,'购买基金'),
(179,'XYK-1007',201807,'CKR-1000',0.7,'娱乐消费'),
(180,'XYK-1007',201807,'CKR-1000',0.8,'购买保险'),
(181,'XYK-1008',201808,'CKR-1000',0.4,'大额消费'),
(182,'XYK-1008',201808,'CKR-1000',2,'大额整数消费'),
(183,'XYK-1008',201808,'CKR-1000',3.5,'用一商户连续刷卡'),
(184,'XYK-1008',201808,'CKR-1000',4,'购买基金'),
(185,'XYK-1008',201808,'CKR-1000',0.8,'娱乐消费'),
(186,'XYK-1008',201808,'CKR-1000',0.7,'购买保险'),
(187,'XYK-1009',201801,'CKR-1000',0.3,'大额消费'),
(188,'XYK-1009',201801,'CKR-1000',1,'大额整数消费'),
(189,'XYK-1009',201801,'CKR-1000',1.4,'用一商户连续刷卡'),
(190,'XYK-1009',201801,'CKR-1000',3,'购买基金'),
(191,'XYK-1009',201801,'CKR-1000',0.9,'娱乐消费'),
(192,'XYK-1009',201801,'CKR-1000',0.8,'购买保险'),
(193,'XYK-2001',201802,'CKR-2000',4,'大额消费'),
(194,'XYK-2001',201802,'CKR-2000',4,'大额整数消费'),
(195,'XYK-2001',201802,'CKR-2000',1.3,'用一商户连续刷卡'),
(196,'XYK-2001',201802,'CKR-2000',1,'购买基金'),
(197,'XYK-2001',201802,'CKR-2000',1,'娱乐消费'),
(198,'XYK-2001',201802,'CKR-2000',0.7,'购买保险'),
(199,'XYK-2002',201803,'CKR-2000',2.8,'大额消费'),
(200,'XYK-2002',201803,'CKR-2000',2,'大额整数消费'),
(201,'XYK-2002',201803,'CKR-2000',1,'用一商户连续刷卡'),
(202,'XYK-2002',201803,'CKR-2000',0.8,'购买基金'),
(203,'XYK-2002',201803,'CKR-2000',1.1,'娱乐消费'),
(204,'XYK-2002',201803,'CKR-2000',0.4,'购买保险'),
(205,'XYK-2003',201804,'CKR-2000',1.5,'大额消费'),
(206,'XYK-2003',201804,'CKR-2000',5,'大额整数消费'),
(207,'XYK-2003',201804,'CKR-2000',1.5,'用一商户连续刷卡'),
(208,'XYK-2003',201804,'CKR-2000',2.5,'购买基金'),
(209,'XYK-2003',201804,'CKR-2000',1.2,'娱乐消费'),
(210,'XYK-2003',201804,'CKR-2000',0.4,'购买保险'),
(211,'XYK-2004',201805,'CKR-2000',1.7,'大额消费'),
(212,'XYK-2004',201805,'CKR-2000',5,'大额整数消费'),
(213,'XYK-2004',201805,'CKR-2000',1.6,'用一商户连续刷卡'),
(214,'XYK-2004',201805,'CKR-2000',1.7,'购买基金'),
(215,'XYK-2004',201805,'CKR-2000',1.3,'娱乐消费'),
(216,'XYK-2004',201805,'CKR-2000',1.5,'购买保险'),
(217,'XYK-2005',201806,'CKR-2000',1.8,'大额消费'),
(218,'XYK-2005',201806,'CKR-2000',4,'大额整数消费'),
(219,'XYK-2005',201806,'CKR-2000',2.4,'用一商户连续刷卡'),
(220,'XYK-2005',201806,'CKR-2000',1.8,'购买基金'),
(221,'XYK-2005',201806,'CKR-2000',1.4,'娱乐消费'),
(222,'XYK-2005',201806,'CKR-2000',1.3,'购买保险'),
(223,'XYK-2006',201807,'CKR-2000',2.7,'大额消费'),
(224,'XYK-2006',201807,'CKR-2000',3,'大额整数消费'),
(225,'XYK-2006',201807,'CKR-2000',2.9,'用一商户连续刷卡'),
(226,'XYK-2006',201807,'CKR-2000',2.7,'购买基金'),
(227,'XYK-2006',201807,'CKR-2000',1.5,'娱乐消费'),
(228,'XYK-2006',201807,'CKR-2000',1.5,'购买保险'),
(229,'XYK-3001',201808,'CKR-3000',2,'大额消费'),
(230,'XYK-3001',201808,'CKR-3000',2,'大额整数消费'),
(231,'XYK-3001',201808,'CKR-3000',2.6,'用一商户连续刷卡'),
(232,'XYK-3001',201808,'CKR-3000',2,'购买基金'),
(233,'XYK-3001',201808,'CKR-3000',1.6,'娱乐消费'),
(234,'XYK-3001',201808,'CKR-3000',1.6,'购买保险'),
(235,'XYK-3002',201801,'CKR-3000',4.5,'大额消费'),
(236,'XYK-3002',201801,'CKR-3000',1,'大额整数消费'),
(237,'XYK-3002',201801,'CKR-3000',2.1,'用一商户连续刷卡'),
(238,'XYK-3002',201801,'CKR-3000',4,'购买基金'),
(239,'XYK-3002',201801,'CKR-3000',1.7,'娱乐消费'),
(240,'XYK-3002',201801,'CKR-3000',1.8,'购买保险'),
(241,'XYK-3003',201802,'CKR-3000',0.15,'大额消费'),
(242,'XYK-3003',201802,'CKR-3000',2,'大额整数消费'),
(243,'XYK-3003',201802,'CKR-3000',1.6,'用一商户连续刷卡'),
(244,'XYK-3003',201802,'CKR-3000',0.15,'购买基金'),
(245,'XYK-3003',201802,'CKR-3000',1.8,'娱乐消费'),
(246,'XYK-3003',201802,'CKR-3000',2.8,'购买保险'),
(247,'XYK-3003',201803,'CKR-3000',0.15,'大额消费'),
(248,'XYK-3003',201803,'CKR-3000',2,'大额整数消费'),
(249,'XYK-3003',201803,'CKR-3000',1.6,'用一商户连续刷卡'),
(250,'XYK-3003',201803,'CKR-3000',0.15,'购买基金'),
(251,'XYK-3003',201803,'CKR-3000',1.8,'娱乐消费'),
(252,'XYK-3003',201803,'CKR-3000',2.8,'购买保险'),
(253,'XYK-3003',201804,'CKR-3000',0.15,'大额消费'),
(254,'XYK-3003',201804,'CKR-3000',2,'大额整数消费'),
(255,'XYK-3003',201804,'CKR-3000',1.6,'用一商户连续刷卡'),
(256,'XYK-3003',201804,'CKR-3000',0.15,'购买基金'),
(257,'XYK-3003',201804,'CKR-3000',1.8,'娱乐消费'),
(258,'XYK-3003',201804,'CKR-3000',2.8,'购买保险'),
(259,'XYK-3003',201805,'CKR-3000',0.15,'大额消费'),
(260,'XYK-3003',201805,'CKR-3000',2,'大额整数消费'),
(261,'XYK-3003',201805,'CKR-3000',1.6,'用一商户连续刷卡'),
(262,'XYK-3003',201805,'CKR-3000',0.15,'购买基金'),
(263,'XYK-3003',201805,'CKR-3000',1.8,'娱乐消费'),
(264,'XYK-3003',201805,'CKR-3000',2.8,'购买保险'),
(265,'XYK-3003',201806,'CKR-3000',0.15,'大额消费'),
(266,'XYK-3003',201806,'CKR-3000',2,'大额整数消费'),
(267,'XYK-3003',201806,'CKR-3000',1.6,'用一商户连续刷卡'),
(268,'XYK-3003',201806,'CKR-3000',0.15,'购买基金'),
(269,'XYK-3003',201806,'CKR-3000',1.8,'娱乐消费'),
(270,'XYK-3003',201806,'CKR-3000',2.8,'购买保险'),
(271,'XYK-3003',201807,'CKR-3000',0.15,'大额消费'),
(272,'XYK-3003',201807,'CKR-3000',2,'大额整数消费'),
(273,'XYK-3003',201807,'CKR-3000',1.6,'用一商户连续刷卡'),
(274,'XYK-3003',201807,'CKR-3000',0.15,'购买基金'),
(275,'XYK-3003',201807,'CKR-3000',1.8,'娱乐消费'),
(276,'XYK-3003',201807,'CKR-3000',2.8,'购买保险'),
(277,'XYK-3003',201808,'CKR-3000',0.15,'大额消费'),
(278,'XYK-3003',201808,'CKR-3000',2,'大额整数消费'),
(279,'XYK-3003',201808,'CKR-3000',1.6,'用一商户连续刷卡'),
(280,'XYK-3003',201808,'CKR-3000',0.15,'购买基金'),
(281,'XYK-3003',201808,'CKR-3000',1.8,'娱乐消费'),
(282,'XYK-3003',201808,'CKR-3000',2.8,'购买保险'),
(283,'XYK-3003',201809,'CKR-3000',0.15,'大额消费'),
(284,'XYK-3003',201809,'CKR-3000',2,'大额整数消费'),
(285,'XYK-3003',201809,'CKR-3000',1.6,'用一商户连续刷卡'),
(286,'XYK-3003',201809,'CKR-3000',0.15,'购买基金'),
(287,'XYK-3003',201809,'CKR-3000',1.8,'娱乐消费'),
(288,'XYK-3003',201809,'CKR-3000',2.8,'购买保险'),
(289,'XYK-3003',201810,'CKR-3000',0.15,'大额消费'),
(290,'XYK-3003',201810,'CKR-3000',2,'大额整数消费'),
(291,'XYK-3003',201810,'CKR-3000',1.6,'用一商户连续刷卡'),
(292,'XYK-3003',201810,'CKR-3000',0.15,'购买基金'),
(293,'XYK-3003',201810,'CKR-3000',1.8,'娱乐消费'),
(294,'XYK-3003',201810,'CKR-3000',2.8,'购买保险'),
(295,'XYK-3004',201803,'CKR-3000',1.3,'大额消费'),
(296,'XYK-3004',201803,'CKR-3000',7,'大额整数消费'),
(297,'XYK-3004',201803,'CKR-3000',3.4,'用一商户连续刷卡'),
(298,'XYK-3004',201803,'CKR-3000',1.3,'购买基金'),
(299,'XYK-3004',201803,'CKR-3000',1.9,'娱乐消费'),
(300,'XYK-3004',201803,'CKR-3000',2.7,'购买保险'),
(301,'XYK-3005',201804,'CKR-3000',1.5,'大额消费'),
(302,'XYK-3005',201804,'CKR-3000',3,'大额整数消费'),
(303,'XYK-3005',201804,'CKR-3000',3.2,'用一商户连续刷卡'),
(304,'XYK-3005',201804,'CKR-3000',1.5,'购买基金'),
(305,'XYK-3005',201804,'CKR-3000',2,'娱乐消费'),
(306,'XYK-3005',201804,'CKR-3000',3.4,'购买保险'),
(307,'XYK-4001',201805,'CKR-4000',1.6,'大额消费'),
(308,'XYK-4001',201805,'CKR-4000',2,'大额整数消费'),
(309,'XYK-4001',201805,'CKR-4000',3.6,'用一商户连续刷卡'),
(310,'XYK-4001',201805,'CKR-4000',1.6,'购买基金'),
(311,'XYK-4001',201805,'CKR-4000',0.1,'娱乐消费'),
(312,'XYK-4001',201805,'CKR-4000',3.2,'购买保险'),
(313,'XYK-4002',201806,'CKR-4000',1.8,'大额消费'),
(314,'XYK-4002',201806,'CKR-4000',1,'大额整数消费'),
(315,'XYK-4002',201806,'CKR-4000',3.7,'用一商户连续刷卡'),
(316,'XYK-4002',201806,'CKR-4000',1.8,'购买基金'),
(317,'XYK-4002',201806,'CKR-4000',0.2,'娱乐消费'),
(318,'XYK-4002',201806,'CKR-4000',3.6,'购买保险'),
(319,'XYK-4003',201807,'CKR-4000',2.8,'大额消费'),
(320,'XYK-4003',201807,'CKR-4000',3,'大额整数消费'),
(321,'XYK-4003',201807,'CKR-4000',3.5,'用一商户连续刷卡'),
(322,'XYK-4003',201807,'CKR-4000',2.8,'购买基金'),
(323,'XYK-4003',201807,'CKR-4000',0.3,'娱乐消费'),
(324,'XYK-4003',201807,'CKR-4000',3.7,'购买保险'),
(325,'XYK-5001',201808,'CKR-5000',2.7,'大额消费'),
(326,'XYK-5001',201808,'CKR-5000',4,'大额整数消费'),
(327,'XYK-5001',201808,'CKR-5000',4.6,'用一商户连续刷卡'),
(328,'XYK-5001',201808,'CKR-5000',0.7,'购买基金'),
(329,'XYK-5001',201808,'CKR-5000',0.4,'娱乐消费'),
(330,'XYK-5001',201808,'CKR-5000',3.5,'购买保险'),
(331,'XYK-5002',201801,'CKR-5000',3.4,'大额消费'),
(332,'XYK-5002',201801,'CKR-5000',2,'大额整数消费'),
(333,'XYK-5002',201801,'CKR-5000',2.6,'用一商户连续刷卡'),
(334,'XYK-5002',201801,'CKR-5000',0.4,'购买基金'),
(335,'XYK-5002',201801,'CKR-5000',0.5,'娱乐消费'),
(336,'XYK-5002',201801,'CKR-5000',4.6,'购买保险'),
(337,'XYK-5003',201802,'CKR-5000',3.2,'大额消费'),
(338,'XYK-5003',201802,'CKR-5000',2,'大额整数消费'),
(339,'XYK-5003',201802,'CKR-5000',4.2,'用一商户连续刷卡'),
(340,'XYK-5003',201802,'CKR-5000',0.2,'购买基金'),
(341,'XYK-5003',201802,'CKR-5000',0.6,'娱乐消费'),
(342,'XYK-5003',201802,'CKR-5000',2.6,'购买保险'),
(343,'XYK-5004',201803,'CKR-5000',3.6,'大额消费'),
(344,'XYK-5004',201803,'CKR-5000',8,'大额整数消费'),
(345,'XYK-5004',201803,'CKR-5000',1.8,'用一商户连续刷卡'),
(346,'XYK-5004',201803,'CKR-5000',0.6,'购买基金'),
(347,'XYK-5004',201803,'CKR-5000',0.7,'娱乐消费'),
(348,'XYK-5004',201803,'CKR-5000',4.2,'购买保险'),
(349,'XYK-5005',201804,'CKR-5000',3.7,'大额消费'),
(350,'XYK-5005',201804,'CKR-5000',3,'大额整数消费'),
(351,'XYK-5005',201804,'CKR-5000',1.3,'用一商户连续刷卡'),
(352,'XYK-5005',201804,'CKR-5000',0.7,'购买基金'),
(353,'XYK-5005',201804,'CKR-5000',0.8,'娱乐消费'),
(354,'XYK-5005',201804,'CKR-5000',1.8,'购买保险'),
(355,'XYK-5006',201805,'CKR-5000',0.5,'大额消费'),
(356,'XYK-5006',201805,'CKR-5000',5,'大额整数消费'),
(357,'XYK-5006',201805,'CKR-5000',1.4,'用一商户连续刷卡'),
(358,'XYK-5006',201805,'CKR-5000',0.5,'购买基金'),
(359,'XYK-5006',201805,'CKR-5000',1.9,'娱乐消费'),
(360,'XYK-5006',201805,'CKR-5000',1.3,'购买保险'),
(361,'XYK-5007',201806,'CKR-5000',0.6,'大额消费'),
(362,'XYK-5007',201806,'CKR-5000',2,'大额整数消费'),
(363,'XYK-5007',201806,'CKR-5000',2.3,'用一商户连续刷卡'),
(364,'XYK-5007',201806,'CKR-5000',0.6,'购买基金'),
(365,'XYK-5007',201806,'CKR-5000',3,'娱乐消费'),
(366,'XYK-5007',201806,'CKR-5000',1.4,'购买保险'),
(367,'XYK-5008',201807,'CKR-5000',2.6,'大额消费'),
(368,'XYK-5008',201807,'CKR-5000',4,'大额整数消费'),
(369,'XYK-5008',201807,'CKR-5000',0.8,'用一商户连续刷卡'),
(370,'XYK-5008',201807,'CKR-5000',2.6,'购买基金'),
(371,'XYK-5008',201807,'CKR-5000',2.1,'娱乐消费'),
(372,'XYK-5008',201807,'CKR-5000',2.3,'购买保险'),
(373,'XYK-5009',201801,'CKR-5000',0.2,'大额消费'),
(374,'XYK-5009',201801,'CKR-5000',6,'大额整数消费'),
(375,'XYK-5009',201801,'CKR-5000',2.3,'用一商户连续刷卡'),
(376,'XYK-5009',201801,'CKR-5000',2.2,'购买基金'),
(377,'XYK-5009',201801,'CKR-5000',2.2,'娱乐消费'),
(378,'XYK-5009',201801,'CKR-5000',0.8,'购买保险'),
(379,'XYK-5009',201802,'CKR-5000',0.2,'大额消费'),
(380,'XYK-5009',201802,'CKR-5000',6,'大额整数消费'),
(381,'XYK-5009',201802,'CKR-5000',2.3,'用一商户连续刷卡'),
(382,'XYK-5009',201802,'CKR-5000',2.2,'购买基金'),
(383,'XYK-5009',201802,'CKR-5000',2.2,'娱乐消费'),
(384,'XYK-5009',201802,'CKR-5000',0.8,'购买保险'),
(385,'XYK-5009',201803,'CKR-5000',0.2,'大额消费'),
(386,'XYK-5009',201803,'CKR-5000',6,'大额整数消费'),
(387,'XYK-5009',201803,'CKR-5000',2.3,'用一商户连续刷卡'),
(388,'XYK-5009',201803,'CKR-5000',2.2,'购买基金'),
(389,'XYK-5009',201803,'CKR-5000',2.2,'娱乐消费'),
(390,'XYK-5009',201803,'CKR-5000',0.8,'购买保险'),
(391,'XYK-5009',201804,'CKR-5000',0.2,'大额消费'),
(392,'XYK-5009',201804,'CKR-5000',6,'大额整数消费'),
(393,'XYK-5009',201804,'CKR-5000',2.3,'用一商户连续刷卡'),
(394,'XYK-5009',201804,'CKR-5000',2.2,'购买基金'),
(395,'XYK-5009',201804,'CKR-5000',2.2,'娱乐消费'),
(396,'XYK-5009',201804,'CKR-5000',0.8,'购买保险'),
(397,'XYK-5009',201805,'CKR-5000',0.2,'大额消费'),
(398,'XYK-5009',201805,'CKR-5000',6,'大额整数消费'),
(399,'XYK-5009',201805,'CKR-5000',2.3,'用一商户连续刷卡'),
(400,'XYK-5009',201805,'CKR-5000',2.2,'购买基金'),
(401,'XYK-5009',201805,'CKR-5000',2.2,'娱乐消费'),
(402,'XYK-5009',201805,'CKR-5000',0.8,'购买保险'),
(403,'XYK-5009',201806,'CKR-5000',0.2,'大额消费'),
(404,'XYK-5009',201806,'CKR-5000',6,'大额整数消费'),
(405,'XYK-5009',201806,'CKR-5000',2.3,'用一商户连续刷卡'),
(406,'XYK-5009',201806,'CKR-5000',2.2,'购买基金'),
(407,'XYK-5009',201806,'CKR-5000',2.2,'娱乐消费'),
(408,'XYK-5009',201806,'CKR-5000',0.8,'购买保险'),
(409,'XYK-5009',201807,'CKR-5000',0.2,'大额消费'),
(410,'XYK-5009',201807,'CKR-5000',6,'大额整数消费'),
(411,'XYK-5009',201807,'CKR-5000',2.3,'用一商户连续刷卡'),
(412,'XYK-5009',201807,'CKR-5000',2.2,'购买基金'),
(413,'XYK-5009',201807,'CKR-5000',2.2,'娱乐消费'),
(414,'XYK-5009',201807,'CKR-5000',0.8,'购买保险'),
(415,'XYK-5010',201808,'CKR-5000',1.8,'大额消费'),
(416,'XYK-5010',201808,'CKR-5000',1,'大额整数消费'),
(417,'XYK-5010',201808,'CKR-5000',0.5,'用一商户连续刷卡'),
(418,'XYK-5010',201808,'CKR-5000',1.8,'购买基金'),
(419,'XYK-5010',201808,'CKR-5000',3.3,'娱乐消费'),
(420,'XYK-5010',201808,'CKR-5000',2.3,'购买保险');

银行客户信息表

创建stg_base_yhkh_demo_di表，建表语句如下。

create table if not exists `stg_base_yhkh_demo_di` ( 
`id` bigint comment '主键',
`zzhm` string comment '证件号码',
`khmc` string comment '客户名称',
`nl` bigint comment '年龄',
`xb` bigint comment '性别 0:男 1:女',
`yddh1` string comment '移动电话1',
`csrq` string comment '出生日期',
`jysp` bigint comment '教育水平 0:研究生 1:本科 2:高中 3:职业高中 4:职业学院',
`career` bigint comment '职业 0:保险 1:教师 2:外企白领 3:自由职业 4:it工程师',
`hyzk` bigint comment '婚姻状况 0:已婚 1:未婚',
`gz` bigint comment '工资',
`decdbyjyje` bigint comment '大额存单本月交易金额',
`decdbyjybs` bigint comment '大额存单本月交易笔数',
`zjzdjyrq` string comment '最近主动交易日期',
`jtnsr` bigint comment '家庭年收入',
`dqckcy` bigint comment '定期存款持有'
)
 comment '信用卡客户信息' 
;

插入stg_base_yhkh_demo_di表中的数据，插入语句如下。

insert into stg_base_yhkh_demo_di values
(1,'CKR-1000','谢xx',33,0,'(86)3193462****','2002-03-06',0,3,1,80000,95429,31,'2019-05-13',1425574,83489),
(2,'CKR-2000','罗xx',68,1,'+862364755****','2009-11-15',0,3,0,40000,54194,34,'2001-10-15',4732362,99694),
(3,'CKR-3000','汤xx',46,1,'3390454****','1993-09-04',0,3,1,40000,61863,58,'1987-10-06',7593193,11215),
(4,'CKR-4000','何xx',44,0,'2829044****','1999-07-22',1,3,0,35000,61082,60,'1989-10-07',9177195,60752),
(5,'CKR-5000','文xx',36,0,'2523516****','1992-07-15',1,3,0,25000,71953,35,'2001-04-04',2925278,4165),
(6,'CKR-1005','江xx',15,0,'2663132****','1981-03-04',1,3,0,15000,43857,42,'2014-01-08',5253141,65308),
(7,'CKR-1006','汤xx',6,0,'1809917****','1986-10-20',1,3,1,10000,8503,86,'1970-09-12',5296756,85285),
(8,'CKR-1007','江xx',62,1,'2173135****','1982-04-27',0,3,0,17000,65718,86,'1989-05-23',1762593,96453),
(9,'CKR-1008','雷xx',34,0,'2164763****','1989-06-23',4,3,0,50000,97157,12,'1977-08-16',763445,99478),
(10,'CKR-1009','孟xx',95,0,'1515331****','2008-07-12',0,2,1,15000,68605,54,'2011-10-13',6635322,87174),
(11,'CKR-1010','常xx',71,0,'1547604****','2008-06-10',0,2,1,8500,49055,98,'1978-01-21',3847031,51571),
(12,'CKR-1011','乔xx',34,1,'1705034****','1977-11-03',1,2,1,15000,72188,65,'2019-08-09',9715625,11546),
(13,'CKR-1012','金xx',4,1,'+862836471****','1977-11-11',1,2,0,17000,65132,39,'1992-11-26',9875371,93019),
(14,'CKR-1013','龚xx',78,0,'3332179****','2005-12-10',1,2,0,12000,15774,83,'1973-12-30',5007852,78029),
(15,'CKR-1014','何xx',57,0,'2037733****','1977-01-27',1,2,1,17000,12815,55,'2007-10-22',409723,62655),
(16,'CKR-1015','贺xx',18,1,'1636923****','2001-12-25',4,4,1,10000,90515,3,'1989-01-07',751082,18248),
(17,'CKR-1016','潘xx',76,0,'2853950****','2003-12-24',4,4,1,17000,68525,44,'1995-07-22',7495966,81766),
(18,'CKR-1017','潘xx',74,1,'2211007****','1973-06-06',1,4,1,10000,71531,78,'2011-07-26',366257,7696),
(19,'CKR-1018','顾xx',92,0,'1573868****','2017-11-11',1,4,0,30000,62387,1,'1988-05-21',2213117,85397),
(20,'CKR-1019','马xx',13,0,'+862170822****','2014-07-02',1,4,0,35000,66701,68,'1990-11-03',8238187,65044),
(21,'CKR-1020','曾xx',78,0,'2120056****','1983-05-18',1,1,0,35000,53658,26,'2001-04-06',7262309,36107),
(22,'CKR-1021','阎xx',77,0,'2325277****','2014-05-21',1,1,1,15000,38751,18,'2006-01-18',4477225,12690),
(23,'CKR-1022','魏xx',96,1,'3368398****','1978-04-18',4,1,1,17000,31883,2,'1983-03-11',8062079,48940),
(24,'CKR-1023','赵xx',55,1,'1519715****','1998-05-10',0,0,1,12000,52528,97,'1999-10-03',4701315,97298),
(25,'CKR-1024','魏xx',12,0,'3153563****','1999-02-13',2,0,1,15000,33481,27,'1985-10-14',7808248,8086),
(26,'CKR-1025','乔xx',38,1,'+861679917****','1978-03-29',1,0,0,16000,71075,83,'1993-09-10',5946732,7717),
(27,'CKR-1026','邓xx',79,0,'3432791****','2007-08-20',4,0,0,14000,44632,84,'1976-08-17',9530773,22782),
(28,'CKR-1027','贺xx',38,0,'3308911****','2006-05-24',0,0,0,8500,94004,49,'1983-02-01',6219669,29030),
(29,'CKR-1028','谭xx',80,0,'+862028374****','1973-12-13',4,0,0,15000,7536,24,'2003-11-18',8550386,9772),
(30,'CKR-1029','余xx',93,1,'2409191****','2017-10-26',4,0,1,14000,77595,40,'1977-11-19',5950564,73535),
(31,'CKR-1030','谢xx',21,0,'2166235****','1992-12-31',2,0,0,17000,65481,86,'1978-11-14',5902767,80462),
(32,'CKR-1031','陆xx',900,0,'(86)2106548****','2018-03-04',1,0,1,17000,16100,45,'1999-07-13',7209351,18872),
(33,'CKR-1032','谭xx',14,1,'3365810****','1986-01-09',0,0,0,7000,87617,40,'2013-07-14',7266776,26436),
(34,'CKR-1033','李xx',17,0,'2507836****','2002-02-13',1,2,1,11000,11490,67,'1993-01-25',1498183,51372),
(35,'CKR-1034','史xx',60,0,'1431977****','1973-05-16',1,2,1,45000,87909,24,'2018-06-05',2030521,26098),
(36,'CKR-1035','苏xx',72,0,'3404743****','1988-10-30',1,2,1,6700,29314,5,'1995-10-09',7693879,68804),
(37,'CKR-1036','叶xx',71,0,'2043307****','2018-04-02',2,2,0,8000,81260,43,'2000-11-27',7005542,29571),
(38,'CKR-1037','潘xx',14,0,'1448963****','1987-12-23',1,2,1,10000,8007,8,'2018-02-23',9003028,20745),
(39,'CKR-1038','许xx',4,0,'2140561****','1990-08-22',2,2,0,10000,78111,74,'1994-01-01',9313883,19159),
(40,'CKR-1039','余xx',300,0,'(86)3069930****','2002-12-20',2,1,1,8500,43071,34,'1992-01-19',3081415,94513),
(41,'CKR-1040','崔xx',11,0,'1402993****','1986-06-19',2,1,0,5000,87999,5,'1987-02-13',178974,61325),
(42,'CKR-1041','贺xx',97,0,'2535329****','2001-02-18',4,1,1,6700,78972,78,'1972-02-13',5901890,70525),
(43,'CKR-1042','许xx',85,0,'1691396****','2002-05-06',1,0,1,5000,91055,24,'2018-01-05',6859793,78753),
(44,'CKR-1043','沈xx',10,0,'(86)2587028****','1981-09-02',0,0,0,6800,63460,13,'1980-10-23',2177974,76217),
(45,'CKR-1044','万xx',20,1,'2696176****','1979-04-07',2,0,1,6600,39348,94,'1985-12-10',1728750,36261),
(46,'CKR-1045','袁xx',99,0,'2966678****','1989-10-22',2,0,0,6500,92593,2,'1990-03-07',1821075,11599),
(47,'CKR-1046','傅xx',23,1,'2692373****','2004-02-17',4,0,0,7200,68864,99,'2016-08-26',1387723,28969),
(48,'CKR-1047','龚xx',6,1,'2615557****','1989-02-04',0,0,1,5000,79006,60,'1988-01-04',7876225,82518),
(49,'CKR-1048','彭xx',17,0,'2820032****','1999-05-11',1,0,1,5000,14056,61,'1983-08-25',5280068,75582),
(50,'CKR-1049','乔xx',44,0,'2004758****','1983-01-15',2,1,0,5000,6073,86,'1970-03-27',6822252,55308),
(51,'CKR-1050','贺xx',4,0,'2445783****','1990-10-21',4,1,0,5000,89753,89,'2004-07-30',8107579,27253),
(52,'CKR-1051','蒋xx',83,0,'1318798****','1981-07-26',2,1,0,12000,89547,39,'1996-03-27',9546849,98847),
(53,'CKR-1052','阎xx',43,0,'2496603****','1994-10-30',4,0,1,9000,56956,44,'1975-01-18',115463,75243),
(54,'CKR-1053','范xx',92,1,'2073525****','2016-11-16',3,0,1,8000,99009,10,'2014-07-05',6628234,97674),
(55,'CKR-1054','苏xx',34,0,'1426190****','2014-07-15',2,0,0,7000,81145,33,'2004-07-14',4140885,14247),
(56,'CKR-1055','赵xx',91,0,'2522975****','2001-04-04',1,0,0,8500,60527,5,'1988-04-21',3255066,88485),
(57,'CKR-1056','赵xx',84,0,'3389265****','1980-11-27',1,0,0,8500,42275,51,'1988-10-16',8660761,75908),
(58,'CKR-1057','邓xx',11,0,'2490308****','1973-11-06',4,0,0,9000,57619,62,'1998-09-11',8035936,6989),
(59,'CKR-1058','张xx',36,0,'2659901****','1973-02-09',1,0,1,7200,33170,35,'1980-08-20',3885281,42114),
(60,'CKR-1059','孙xx',35,0,'3012420****','1989-05-29',1,3,0,6800,29221,17,'2001-06-08',7175461,39317),
(61,'CKR-1060','金xx',4,1,'3298975****','2018-04-06',0,3,0,6900,56864,48,'1984-09-19',5103692,34747),
(62,'CKR-1061','谢xx',37,1,'2232568****','1981-05-12',4,3,1,7100,32834,34,'2006-05-05',8119980,44347),
(63,'CKR-1062','石xx',28,0,'3115119****','2013-02-06',4,3,0,7000,45832,81,'2016-06-03',7215690,60679),
(64,'CKR-1063','蒋xx',83,0,'3272740****','1975-08-14',1,3,1,7000,28624,67,'2005-05-19',401890,4493),
(65,'CKR-1064','尹xx',14,0,'2696614****','2014-12-16',2,2,1,5000,50594,88,'2010-09-03',4781451,52552),
(66,'CKR-1065','阎xx',4,1,'2977108****','1983-01-12',1,2,1,9000,34747,46,'1972-12-15',3021194,99764),
(67,'CKR-1066','杨xx',3,1,'2588012****','2005-11-01',4,2,0,6500,93199,33,'1989-07-26',772627,25525),
(68,'CKR-1067','雷xx',100,1,'2150176****','2016-04-02',1,2,1,7500,33137,78,'1989-09-21',3897294,95987),
(69,'CKR-1068','许xx',13,0,'1480894****','2004-06-12',2,3,1,4400,14611,90,'1992-03-07',8212692,30070),
(70,'CKR-1069','熊xx',80,1,'3423815****','2003-03-07',3,3,1,4800,76704,63,'1977-02-16',5031631,8627),
(71,'CKR-1070','邓xx',96,0,'1676364****','1983-12-15',0,3,0,3700,74704,82,'2002-11-05',3221507,43394),
(72,'CKR-1071','赖xx',4,0,'2456341****','1996-10-11',4,3,0,6500,96055,18,'2008-03-21',7341282,90341),
(73,'CKR-1072','王xx',27,1,'1867428****','1980-08-30',2,3,1,5200,87710,34,'1985-10-11',6442607,52075),
(74,'CKR-1073','秦xx',95,1,'3218186****','2018-04-25',1,2,0,4650,88563,96,'2009-01-05',2643763,84598),
(75,'CKR-1074','贺xx',10,0,'1306344****','2006-10-14',1,2,1,4550,13903,18,'1984-01-26',345408,81526),
(76,'CKR-1075','雷xx',61,0,'2471314****','1996-08-30',2,2,1,4400,32375,0,'1992-06-04',7901871,29745),
(77,'CKR-1076','秦xx',61,0,'2243587****','2013-07-03',2,2,1,4700,16121,49,'1979-04-15',8668010,15787),
(78,'CKR-1077','郭xx',12,1,'2744727****','2014-02-23',1,3,1,4500,32254,2,'1988-10-12',2226230,18156),
(79,'CKR-1078','苏xx',76,0,'2089097****','1973-04-28',1,3,0,8000,53199,2,'1982-07-07',635335,73580),
(80,'CKR-1079','朱xx',22,1,'3402858****','2018-10-06',4,3,1,10000,85964,38,'1999-06-05',8596230,14763),
(81,'CKR-1080','孙xx',93,1,'2619516****','1994-09-18',0,3,0,10000,15577,82,'1975-03-25',5012535,14102);