data_loan.rar_rodlok_入链贷款信息索引表_区块链

?# Host: 115.159.34.159 (Version 5.6.35-1+deb.sury.org~xenial+0.1-log) # Date: 2019-06-21 18:15:20 # Generator: MySQL-Front 6.1 (Build 1.26) # # Structure for table "gateway_payment" # DROP TABLE IF EXISTS `gateway_payment`; CREATE TABLE `gateway_payment` ( `id` int(11) NOT NULL AUTO_INCREMENT, `client_ip` varchar(32) DEFAULT NULL COMMENT '请求客户端的ip', `service_name` varchar(64) DEFAULT NULL COMMENT 'kong里对应服务名称', `service_id` varchar(64) DEFAULT NULL COMMENT 'kong里对应服务id', `app_seq` varchar(32) DEFAULT NULL COMMENT '合作方担保系统借款编号（借款申请单号）', `loan_order_id` varchar(32) DEFAULT NULL COMMENT '贷款订单编号', `payment_date` varchar(32) DEFAULT NULL COMMENT '放款日期', `payment_amount` decimal(12,2) DEFAULT NULL COMMENT '放款金额，单位（元）', `payment_interest_rate` decimal(12,2) DEFAULT NULL COMMENT '放款利率，年化百分比。例如：年化 8.5% -> 8.5', `payer_name` varchar(64) DEFAULT NULL COMMENT '付款人', `payer_account` varchar(32) DEFAULT NULL COMMENT '付款账号', `payer_bank` varchar(32) DEFAULT NULL COMMENT '付款银行', `payee_name` varchar(64) DEFAULT NULL COMMENT '收款人', `payee_account` varchar(32) DEFAULT NULL COMMENT '收款账号', `payee_bank` varchar(32) DEFAULT NULL COMMENT '收款银行', `status` varchar(32) DEFAULT 'Prepare' COMMENT '数据就绪状态(准备Prepare，齐备Ready，Complete完成)', `finchain_id` varchar(128) DEFAULT NULL COMMENT '区块链记录ID', `finchain_status` int(11) DEFAULT NULL COMMENT '区块链记录状态', `time_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录新建时间', `time_update` timestamp(3) NULL DEFAULT NULL COMMENT '记录更新时间', PRIMARY KEY (`id`), UNIQUE KEY `app_seq` (`app_seq`) ) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 COMMENT='付款上链数据表'; # # Data for table "gateway_payment" # INSERT INTO `gateway_payment` VALUES (1,'119.137.52.206','RenmaiCarloan','313cb172-c042-491c-b9dc-3ab50938bbf9','zy20190123002','d0d09089e35849f5ac257d56c10e724f','2019-04-01',80000.00,0.22,'厦门国际信托有限公司',NULL,NULL,'李倩倩','342625197506122910',NULL,'Complete','PMLNAT02BJvTGqrOeWYO/RAvINS6Sl9twOOgiWflStE2qbgXkl8MsxF6d08Vt2XTUFmRhoemxGwv1hKtBXMXechHZEYwEY6MmMerLhKbqcIZr/0h9wo0b6MmANz/tfQi',1,'2019-04-16 17:19:40','2019-06-21 10:30:14.507'),(105,'119.139.197.188','ZhengyuanRiskControl','7f71b53b-ae35-4625-8bf5-d5bff737d09c','2019006201358',NULL,NULL,NULL,0.22,'厦门国际信托有限公司',NULL,NULL,'贾进满','230101197911082569',NULL,'Prepare',NULL,NULL,'2019-06-20 14:10:58','2019-06-20 14:20:15.611'),(106,'119.139.196.212','ZhengyuanRiskControl','7f71b53b-ae35-4625-8bf5-d5bff737d09c','RM2019062001001',NULL,NULL,NULL,0.22,'厦门国际信托有限公司',NULL,NULL,'柯贵东','330110198610067140',NULL,'Prepare',NULL,NULL,'2019-06-20 14:10:58','2019-06-20 14:55:21.502'),(111,'119.139.197.188','ZhengyuanRiskControl','7f71b53b-ae35-4625-8bf5-d5bff737d09c','2019006201445',NULL,NULL,NULL,0.22,'厦门国际信托有限公司',NULL,NULL,'上官金奇','520122200002184299',NULL,'Prepare',NULL,NULL,'2019-06-20 14:44:29','2019-06-20 14:44:29.214'),(113,'119.139.197.188','ZhengyuanRiskControl','7f71b53b-ae35-4625-8bf5-d5bff737d09c','2019006201556',NULL,NULL,NULL,0.22,'厦门国际信托有限公司',NULL,NULL,'公孙伴梅','520101199909214946',NULL,'Prepare',NULL,NULL,'2019-06-20 15:57:07','2019-06-20 15:57:07.931'),(114,'119.139.197.188','ZhengyuanRiskControl','7f71b53b-ae35-4625-8bf5-d5bff737d09c','2019006201655',NULL,NULL,NULL,0.22,'厦门国际信托有限公司',NULL,NULL,'秦金花','340101199412303368',NULL,'Prepare',NULL,NULL,'2019-06-20 16:55:21','2019-06-20 16:55:21.920'),(116,'119.139.196.212','ZhengyuanRiskControl','7f71b53b-ae35-4625-8bf5-d5bff737d09c','RM2019062001004',NULL,NULL,NULL,0.22,'厦门国际信托有限公司',NULL,NULL,'东方薏方','440104198909156023',NULL,'Prepare',NULL,NULL,'2019-06-20 18:11:54','2019-06-20 18:11:54.156'),(118,'119.139.196.212','ZhengyuanRiskControl','7f71b53b-ae35-4625-8bf5-d5bff737d09c','RM2019062001005',NULL,NULL,NULL,0.22,'厦门国际信托有限公司',NULL,NULL,'胡若桓','610114199506222099',NULL,'Prepare',NULL,NULL,'2019-06-20 21:21:42','2019-06-20 21:21:42.044'),(119,'119.139.197.160','ZhengyuanRiskControl','7f71b53b-ae35-4625-8bf5-d5bff737d09c','201906211015',NULL,NULL,NULL,0.22,'厦门国际信托有限公司',NULL,NULL,'史远方','4101021979022215632',NULL,'Prepare',NULL,NULL,'2019-06-21 10:10:43','2019-06-21 10:33:34.257'),(126,'119.139.197.160','ZhengyuanRiskControl','7f71b53b-ae35-4625-8bf5-d5bff737d09c','201906211034',NULL,NULL,NULL,0.22,'厦门国际信托有限公司',NULL,NULL,'史远方','410102197902221563',NULL,'Prepare',NULL,NULL,'2019-06-21 10:34:24','2019-06-21 10:34:24.857');