CRM/crm_withdraw.sql

/*
 Navicat Premium Data Transfer

 Source Server         : beron
 Source Server Type    : MySQL
 Source Server Version : 50628
 Source Host           : 13.124.37.191:3306
 Source Schema         : beron_crm

 Target Server Type    : MySQL
 Target Server Version : 50628
 File Encoding         : 65001

 Date: 01/12/2019 21:01:37
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for crm_withdraw
-- ----------------------------
DROP TABLE IF EXISTS `crm_withdraw`;
CREATE TABLE `crm_withdraw`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `type` tinyint(4) NOT NULL COMMENT '出金状态（0：等待审核；1：不通过；2：已出金；3：管理员撤销；4：未分享朋友圈；5：暂不处理；6：处理中）',
  `member_id` bigint(20) NOT NULL COMMENT '代理商ID',
  `amount` decimal(21, 2) NOT NULL COMMENT '出金金额',
  `fee` decimal(21, 2) NOT NULL DEFAULT 0.00 COMMENT '手续费',
  `memo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `in_time` bigint(20) NOT NULL COMMENT '申请时间',
  `out_time` bigint(20) NOT NULL DEFAULT 0 COMMENT '出金时间',
  `true_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '姓名',
  `bank_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '银行名称',
  `bank_sub_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分行名称',
  `bank_card_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '银行卡号',
  `bank_province` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '银行省份',
  `bank_city` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '银行城市',
  `mobile` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '电话号码',
  `login` int(11) NOT NULL COMMENT 'mt4登录ID',
  `rate` decimal(20, 3) NOT NULL COMMENT '汇率',
  `swift` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Swift',
  `mt4_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'mt4 出金状态',
  `admin_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '操作人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '出金记录表' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of crm_withdraw
-- ----------------------------
INSERT INTO `crm_withdraw` VALUES (1, 1, 84634, 6995.00, 5.00, NULL, 1574988009697, 1575014528262, '李华', '建设银行', '铁路支行', '6217004260004135729', '甘肃省', '兰州市', '13993143504', 70100452, 6.700, NULL, 0, '管理员');
INSERT INTO `crm_withdraw` VALUES (2, 2, 84607, 1995.00, 5.00, NULL, 1575001587730, 1575014528910, '夏梅', '建设银行', '西江支行', '6217003380006044041', '广西', '柳州', '13768328320', 70100425, 6.700, NULL, 1, '管理员');
INSERT INTO `crm_withdraw` VALUES (3, 1, 84590, 5995.00, 5.00, NULL, 1575010652496, 0, '张春燕', '工商银行', '光华路支行', '62220802000080789', '北京', '北京', '15001077644', 70100408, 6.700, NULL, 0, '管理员');
INSERT INTO `crm_withdraw` VALUES (4, 6, 84586, 995.00, 5.00, NULL, 1575014910869, 0, '邵奕', '建设银行', '泗洪县泗州支行', '6222801344663000302', '江苏', '江苏省宿迁市', '15312716768', 70100404, 6.700, NULL, 0, '');
INSERT INTO `crm_withdraw` VALUES (5, 6, 84592, 1723.58, 5.00, NULL, 1575018577085, 0, '赵碧华', '农业银行', '浙江省', '6228480368967180275', '江苏省', '江苏省', '15051711256', 70100410, 6.700, NULL, 0, '');
INSERT INTO `crm_withdraw` VALUES (6, 6, 84611, 409.51, 5.00, NULL, 1575022319657, 0, '张晓霞', '建设银行', '封丘支行', '6217002500006372602', '河南省', '新乡市', '18603736587', 70100429, 6.700, NULL, 0, '');
INSERT INTO `crm_withdraw` VALUES (7, 6, 84607, 6995.00, 5.00, NULL, 1575039544640, 0, '夏梅', '建设银行', '西江支行', '6217003380006044041', '广西', '柳州', '13768328320', 70100425, 6.700, NULL, 0, '');

SET FOREIGN_KEY_CHECKS = 1;