erp_yzx/yuanzhongxiu.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 本地mysql 5.8
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : 127.0.0.1:3306
 Source Schema         : yuanzhongxiu

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

 Date: 11/01/2023 11:36:58
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for erp_activity
-- ----------------------------
DROP TABLE IF EXISTS `erp_activity`;
CREATE TABLE `erp_activity`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '活动标题',
  `start_time` int(10) NOT NULL COMMENT '开始时间',
  `end_time` int(10) NOT NULL COMMENT '结束时间',
  `delete_time` bigint(16) NULL DEFAULT NULL COMMENT '逻辑删除字段',
  `create_time` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '活动表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_activity
-- ----------------------------
INSERT INTO `erp_activity` VALUES (7, '年底大清仓', 1576252800, 1861718400, NULL, NULL, NULL, 0);
INSERT INTO `erp_activity` VALUES (8, '年初大甩卖', 1577203200, 1766592000, NULL, NULL, NULL, 0);

-- ----------------------------
-- Table structure for erp_activity_product
-- ----------------------------
DROP TABLE IF EXISTS `erp_activity_product`;
CREATE TABLE `erp_activity_product`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `activity_id` int(11) NOT NULL COMMENT '活动ID',
  `product_id` int(11) NOT NULL COMMENT '商品ID',
  `type` tinyint(2) NOT NULL DEFAULT 1 COMMENT '1=减免价;2=打折;',
  `discount` int(3) NOT NULL DEFAULT 0 COMMENT '打折',
  `reduced_price` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '减免价',
  `start_time` bigint(16) NULL DEFAULT NULL,
  `end_time` bigint(16) NULL DEFAULT NULL,
  `delete_time` bigint(16) NULL DEFAULT NULL COMMENT '逻辑删除字段',
  `create_time` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '活动商品关联表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_activity_product
-- ----------------------------
INSERT INTO `erp_activity_product` VALUES (14, 8, 1, 1, 0, 20.00, 1577203200, 1766592000, NULL, 1672046319, 1672046319, 0);
INSERT INTO `erp_activity_product` VALUES (15, 7, 1, 1, 0, 30.00, 1576252800, 1861718400, NULL, 1672046433, 1672046433, 0);

-- ----------------------------
-- Table structure for erp_admin
-- ----------------------------
DROP TABLE IF EXISTS `erp_admin`;
CREATE TABLE `erp_admin`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '账号',
  `nickname` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '昵称',
  `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '电话',
  `password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码',
  `token` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '令牌',
  `department_id` int(11) NOT NULL DEFAULT 0 COMMENT '部门ID',
  `store_ids` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '门店权限',
  `is_login_backstage` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否能登录后台',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除字段',
  `create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10010 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管理员表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_admin
-- ----------------------------
INSERT INTO `erp_admin` VALUES (10000, 'admin', 'admin', '15574920251', 'e10adc3949ba59abbe56e057f20f883e', 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJqd3RfYWRtaW4iLCJpYXQiOjE2NzM0MDM1NDMsImV4cCI6MTY3MzQxMDc0MywibmJmIjoxNjczNDAzNTQzLCJqdGkiOiJiN2M0Mzg5YmRhNzBkNWUxMmNjMjM1ZDFjNDMyZGE2OSIsImFkbWluX2lkIjoxMDAwMCwiYWNjb3VudCI6ImFkbWluIiwibmlja25hbWUiOiJhZG1pbiJ9.2vvuWg61L4UkBHAxXpUYz1GiiuncW6MHWB_MnHq2G9o', 5, NULL, 1, 0, 1670394265, 1670394265);
INSERT INTO `erp_admin` VALUES (10007, '10086', 'Caviar.', '15574920253', 'e10adc3949ba59abbe56e057f20f883e', 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJqd3RfdXNlciIsImlhdCI6MTY3MzIzMzUyNSwiZXhwIjoxNjczMjgzOTI1LCJuYmYiOjE2NzMyMzM1MjUsImp0aSI6ImI0NDYyYWRkN2ZhMGIxOWNjOWZiYzI4NTRiYzlmYmY1IiwiYWRtaW5faWQiOjEwMDA3LCJhY2NvdW50IjoiMTAwODYiLCJuaWNrbmFtZSI6IkNhdmlhci4iLCJncm91cF9pZCI6NiwiZ3JvdXBfbmFtZSI6IumXqOW6l-S4u-euoSJ9.4qUUzIqdyV1W_EOcW5G7IuiFYvsSs4557lZIQ4tpODM', 5, '10003', 0, 0, 1671104782, 1672107031);
INSERT INTO `erp_admin` VALUES (10008, 'AMK_001', 'AMK_001', '18898762524', 'e10adc3949ba59abbe56e057f20f883e', NULL, 6, '10003', 1, 0, 1671644910, 1671644910);
INSERT INTO `erp_admin` VALUES (10009, 'AMK_Manager', 'AMK管理员', '18894746725', 'e10adc3949ba59abbe56e057f20f883e', NULL, 17, '10004,10003', 1, 0, 1671700601, 1671701309);

-- ----------------------------
-- Table structure for erp_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `erp_auth_group`;
CREATE TABLE `erp_auth_group`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '组名',
  `pid` int(11) NULL DEFAULT 0,
  `rules` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '后台规则ID',
  `reception_rules` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '前端功能',
  `data_rules` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '前端数据权限',
  `department_id` int(11) NULL DEFAULT NULL COMMENT '部门ID',
  `describe` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '描述',
  `create_time` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '权限角色组表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_auth_group
-- ----------------------------
INSERT INTO `erp_auth_group` VALUES (1, '超级管理员', 0, '*', NULL, NULL, NULL, '超级管理员', 1234567890, 1234567890, 0);
INSERT INTO `erp_auth_group` VALUES (6, '门店主管', 0, '8,10,11,1', '10001,10002,10003,10004,10005,10006,10007,10008,10009,10010', '10001,10002,10003,10004,10005,10006,10007,10008,10009,10010', 5, '佛堂', 1234567890, 1673074875, 0);
INSERT INTO `erp_auth_group` VALUES (9, '门店老师', 0, '14,16,15', '10003', NULL, NULL, '门店老师', 1234567890, 1671592052, 0);
INSERT INTO `erp_auth_group` VALUES (11, '门店顾问', 0, '8,10,11,4,27,6,7', '10002', NULL, 5, '门店顾问', 1671076663, 1671700359, 0);
INSERT INTO `erp_auth_group` VALUES (12, '门店促销员', 0, '8,10,11', '10001', NULL, 5, '门店促销员', 1671076782, 1671700370, 0);
INSERT INTO `erp_auth_group` VALUES (18, '佛堂负责人', 0, '12', NULL, NULL, 17, '佛堂负责人', 1671592229, 1671700382, 0);
INSERT INTO `erp_auth_group` VALUES (19, '佛堂前台', 0, '12', NULL, NULL, NULL, '佛堂前台', 1671592265, 1671592265, 0);
INSERT INTO `erp_auth_group` VALUES (20, '佛堂道士', 0, '12', NULL, NULL, NULL, '佛堂道士', 1671592293, 1671592293, 0);
INSERT INTO `erp_auth_group` VALUES (21, '佛堂和尚', 0, '12', NULL, NULL, NULL, '佛堂和尚', 1671592329, 1671592329, 0);
INSERT INTO `erp_auth_group` VALUES (23, '物流负责人', 0, '8,10,11', NULL, NULL, NULL, '物流负责人', 1671592414, 1671592414, 0);
INSERT INTO `erp_auth_group` VALUES (24, '物流助理', 0, NULL, NULL, NULL, NULL, '物流助理', 1671592442, 1671592442, 0);
INSERT INTO `erp_auth_group` VALUES (26, '财务负责人', 0, '18', NULL, NULL, NULL, '财务负责人', 1671592520, 1671592540, 1);
INSERT INTO `erp_auth_group` VALUES (27, '门店经销商', 0, NULL, NULL, NULL, NULL, '门店经销商', 1671592590, 1671592590, 1);
INSERT INTO `erp_auth_group` VALUES (28, '财务负责人', 0, '18', NULL, NULL, NULL, '管理财务板块', 1671635953, 1671635953, 0);
INSERT INTO `erp_auth_group` VALUES (30, 'Test', 0, '30,19,21,20,17,14,16,15,8,10,11,4,27,6,7,1', '10001,10002,10003,10004,10005,10007,10008,10009', '10001,10002,10003,10004,10005,10006,10007', 7, '测试角色', 1671699421, 1671699551, 0);

-- ----------------------------
-- Table structure for erp_auth_group_access
-- ----------------------------
DROP TABLE IF EXISTS `erp_auth_group_access`;
CREATE TABLE `erp_auth_group_access`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_id` int(10) UNSIGNED NOT NULL COMMENT '会员ID',
  `group_id` int(10) UNSIGNED NOT NULL COMMENT '级别ID',
  `create_time` int(10) NULL DEFAULT NULL,
  `update_time` int(10) NULL DEFAULT NULL,
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除字段',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uid_group_id`(`admin_id`, `group_id`) USING BTREE,
  INDEX `uid`(`admin_id`) USING BTREE,
  INDEX `group_id`(`group_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '管理员与分组关系表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_auth_group_access
-- ----------------------------
INSERT INTO `erp_auth_group_access` VALUES (1, 10000, 1, 1670394265, 1670394265, 0);
INSERT INTO `erp_auth_group_access` VALUES (4, 10006, 1, 1671101252, 1671101252, 0);
INSERT INTO `erp_auth_group_access` VALUES (5, 10007, 6, 1671104782, 1671104782, 0);
INSERT INTO `erp_auth_group_access` VALUES (6, 10008, 12, 1671644911, 1671644911, 0);
INSERT INTO `erp_auth_group_access` VALUES (7, 10009, 6, 1671700602, 1671700602, 0);

-- ----------------------------
-- Table structure for erp_auth_group_copy
-- ----------------------------
DROP TABLE IF EXISTS `erp_auth_group_copy`;
CREATE TABLE `erp_auth_group_copy`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '组名',
  `pid` int(10) NOT NULL DEFAULT 0 COMMENT '父级部门',
  `rules` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '规则ID',
  `store_ids` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '关联门店',
  `describe` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '描述',
  `create_time` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '权限角色组表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_auth_group_copy
-- ----------------------------
INSERT INTO `erp_auth_group_copy` VALUES (1, '超级管理员', 0, '*', NULL, '超级管理员', 1234567890, 1234567890, 0);
INSERT INTO `erp_auth_group_copy` VALUES (5, '门店', 0, '4,27,6,7,1', NULL, '门店', 1234567890, 1671591955, 0);
INSERT INTO `erp_auth_group_copy` VALUES (6, '门店主管', 5, '12,1', NULL, '佛堂', 1234567890, 1671083167, 0);
INSERT INTO `erp_auth_group_copy` VALUES (7, '物流', 1, '8,10,1', NULL, '物流部', 1234567890, 1671083197, 1);
INSERT INTO `erp_auth_group_copy` VALUES (8, '财务', 1, '18', NULL, '财务', 1234567890, 1671083239, 1);
INSERT INTO `erp_auth_group_copy` VALUES (9, '门店老师', 5, '14,16,15', '10003', '门店老师', 1234567890, 1671592052, 0);
INSERT INTO `erp_auth_group_copy` VALUES (11, '门店顾问', 5, '8,10,11', '10002', '门店顾问', 1671076663, 1671592097, 0);
INSERT INTO `erp_auth_group_copy` VALUES (12, '门店促销员', 5, '8,10,11', '10001', '门店促销员', 1671076782, 1671592126, 0);
INSERT INTO `erp_auth_group_copy` VALUES (13, '门店-西站店', 5, '1', '10000', '门店4', 1671093023, 1671100435, 1);
INSERT INTO `erp_auth_group_copy` VALUES (16, '系统管理员', 1, '18,12,22,24,23,19,20,17,14,16,15,8,10,11,4,27,6,7,29,3,2,1', NULL, '后台管理系统员', 1671100003, 1671100003, 0);
INSERT INTO `erp_auth_group_copy` VALUES (17, '佛堂', 0, '12', NULL, '佛堂', 1671592191, 1671592191, 0);
INSERT INTO `erp_auth_group_copy` VALUES (18, '佛堂负责人', 17, '12', NULL, '佛堂负责人', 1671592229, 1671592229, 0);
INSERT INTO `erp_auth_group_copy` VALUES (19, '佛堂前台', 17, '12', NULL, '佛堂前台', 1671592265, 1671592265, 0);
INSERT INTO `erp_auth_group_copy` VALUES (20, '佛堂道士', 17, '12', NULL, '佛堂道士', 1671592293, 1671592293, 0);
INSERT INTO `erp_auth_group_copy` VALUES (21, '佛堂和尚', 17, '12', NULL, '佛堂和尚', 1671592329, 1671592329, 0);
INSERT INTO `erp_auth_group_copy` VALUES (22, '物流部', 0, '8,10', NULL, '物流部', 1671592379, 1671592379, 0);
INSERT INTO `erp_auth_group_copy` VALUES (23, '物流负责人', 22, '8,10,11', NULL, '物流负责人', 1671592414, 1671592414, 0);
INSERT INTO `erp_auth_group_copy` VALUES (24, '物流助理', 22, NULL, NULL, '物流助理', 1671592442, 1671592442, 0);
INSERT INTO `erp_auth_group_copy` VALUES (25, '财务', 0, '18', NULL, '财务', 1671592499, 1671592499, 0);
INSERT INTO `erp_auth_group_copy` VALUES (26, '财务负责人', 25, '18', NULL, '财务负责人', 1671592520, 1671592540, 0);
INSERT INTO `erp_auth_group_copy` VALUES (27, '门店经销商', 5, NULL, NULL, '门店经销商', 1671592590, 1671592590, 0);

-- ----------------------------
-- Table structure for erp_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `erp_auth_rule`;
CREATE TABLE `erp_auth_rule`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `type` enum('menu','page','btn') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'menu为菜单,file为权限节点',
  `pid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父ID',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '规则名称',
  `lang` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '规则变量',
  `icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '图标',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '规则URL',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '备注',
  `weigh` int(10) NOT NULL DEFAULT 0 COMMENT '权重',
  `status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '状态 0 否 1是',
  `create_time` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除字段',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `name`(`name`) USING BTREE,
  INDEX `pid`(`pid`) USING BTREE,
  INDEX `weigh`(`weigh`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '节点表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_auth_rule
-- ----------------------------
INSERT INTO `erp_auth_rule` VALUES (1, 'page', 0, '后台首页', 'home', 'mdi mdi-home', '/admin/index/home', '', 1000, 1, NULL, NULL, 0);
INSERT INTO `erp_auth_rule` VALUES (2, 'page', 29, '客户列表', 'customer_list', '#', '/admin/customer/index', '', 999, 1, NULL, NULL, 0);
INSERT INTO `erp_auth_rule` VALUES (3, 'page', 29, '客户沟通', 'customer_communication', '#', '#', '', 998, 1, NULL, NULL, 1);
INSERT INTO `erp_auth_rule` VALUES (4, 'menu', 0, '商品管理', 'commodity_management', 'mdi mdi-corn', '#', '', 997, 1, NULL, NULL, 0);
INSERT INTO `erp_auth_rule` VALUES (6, 'page', 4, '商品列表', 'product_list', 'mdi mdi-home', '/admin/product/index', '', 996, 1, NULL, NULL, 0);
INSERT INTO `erp_auth_rule` VALUES (7, 'page', 4, '商品分类', 'commodity_classification', 'mdi mdi-home', '/admin/product_category/index', '', 1000, 1, NULL, NULL, 0);
INSERT INTO `erp_auth_rule` VALUES (8, 'menu', 0, '进销存管理', 'Sale_and_Storage_of_Commodity', 'mdi mdi-codepen', '#', '', 996, 1, NULL, NULL, 0);
INSERT INTO `erp_auth_rule` VALUES (10, 'page', 8, '订单管理', 'order_management', 'mdi mdi-home', '/admin/order/index', '', 995, 1, NULL, NULL, 0);
INSERT INTO `erp_auth_rule` VALUES (11, 'page', 8, '库存管理', 'stock_control', 'mdi mdi-home', '/admin/stock/index', '', 996, 1, NULL, NULL, 0);
INSERT INTO `erp_auth_rule` VALUES (12, 'page', 0, '佛教管理', 'management_of_Buddhism', 'mdi mdi-buffer', '#', '', 0, 1, NULL, NULL, 1);
INSERT INTO `erp_auth_rule` VALUES (14, 'menu', 0, '门店管理', 'store_management', 'mdi mdi-store', '#', '', 993, 1, NULL, NULL, 0);
INSERT INTO `erp_auth_rule` VALUES (15, 'page', 14, '门店列表', 'store_list', 'mdi mdi-home', '/admin/store/index', '', 992, 1, NULL, NULL, 0);
INSERT INTO `erp_auth_rule` VALUES (16, 'page', 14, '电子商务', 'e_commerce', 'mdi mdi-home', '#', '', 991, 1, NULL, NULL, 1);
INSERT INTO `erp_auth_rule` VALUES (17, 'page', 19, '员工管理', 'staff_management', 'mdi mdi-home', '/admin/admin/index', '', 990, 1, NULL, NULL, 0);
INSERT INTO `erp_auth_rule` VALUES (18, 'page', 0, '财务管理', 'financial_management', 'mdi mdi-file', '#', '', 0, 1, NULL, NULL, 0);
INSERT INTO `erp_auth_rule` VALUES (19, 'menu', 0, '账号管理', 'account_management', 'mdi mdi-folder-account', '#', '', 988, 1, NULL, NULL, 0);
INSERT INTO `erp_auth_rule` VALUES (20, 'page', 19, '角色管理', 'role_management', 'mdi mdi-home', '/admin/auth_group/index', '', 987, 1, NULL, NULL, 0);
INSERT INTO `erp_auth_rule` VALUES (21, 'page', 19, '部门管理', 'division_management', 'mdi mdi-home', '/admin/department/index', '', 986, 1, NULL, NULL, 0);
INSERT INTO `erp_auth_rule` VALUES (22, 'menu', 0, '系统设置', 'system_settings', 'mdi mdi-key-variant', '#', '', 985, 1, NULL, NULL, 0);
INSERT INTO `erp_auth_rule` VALUES (23, 'page', 22, '收款渠道管理', 'collection_channel_management', 'mdi mdi-home', '/admin/payment_channel/index', '', 984, 1, NULL, NULL, 0);
INSERT INTO `erp_auth_rule` VALUES (24, 'page', 22, '御龙币管理', 'yu_long_bi_management', 'mdi mdi-home', '/admin/zue_coin/index', '', 983, 1, NULL, NULL, 0);
INSERT INTO `erp_auth_rule` VALUES (27, 'page', 4, '活动管理', 'activity_management', 'mdi mdi-home', '/admin/activity/index', '', 0, 1, NULL, NULL, 0);
INSERT INTO `erp_auth_rule` VALUES (29, 'menu', 0, '客户管理', 'customer_management', 'mdi mdi-account-plus', '#', '', 1000, 1, NULL, NULL, 0);
INSERT INTO `erp_auth_rule` VALUES (30, 'page', 0, '公司管理', 'company_management', 'mdi mdi-home', '/admin/company/index', '', 0, 1, NULL, NULL, 0);
INSERT INTO `erp_auth_rule` VALUES (32, 'page', 22, '系统配置', 'system_settings', '', '/admin/config/index', '', 0, 1, NULL, NULL, 0);
INSERT INTO `erp_auth_rule` VALUES (33, 'menu', 18, '订单报表', 'order_report', '', '/admin/order_report/index', '', 0, 1, NULL, NULL, 0);
INSERT INTO `erp_auth_rule` VALUES (34, 'menu', 18, '库存报表', 'stock_report', '', '/admin/stock_report/index', '', 0, 1, NULL, NULL, 0);

-- ----------------------------
-- Table structure for erp_company
-- ----------------------------
DROP TABLE IF EXISTS `erp_company`;
CREATE TABLE `erp_company`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '供应商名称',
  `introduce` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司介绍',
  `create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '供应商/公司' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_company
-- ----------------------------
INSERT INTO `erp_company` VALUES (3, 'Company_3', 'Product A 代理公司', 1671188583, 1671976221, 0);
INSERT INTO `erp_company` VALUES (4, 'company_4', 'company_4', 1671703703, 1671704277, 0);

-- ----------------------------
-- Table structure for erp_config
-- ----------------------------
DROP TABLE IF EXISTS `erp_config`;
CREATE TABLE `erp_config`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sales_tax_rate` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '消费税比例',
  `delete_time` int(10) NULL DEFAULT NULL COMMENT '逻辑删除字段',
  `create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统设置表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_config
-- ----------------------------
INSERT INTO `erp_config` VALUES (1, 30.00, NULL, NULL, NULL, 0);

-- ----------------------------
-- Table structure for erp_credit_card_config
-- ----------------------------
DROP TABLE IF EXISTS `erp_credit_card_config`;
CREATE TABLE `erp_credit_card_config`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `channel_id` int(11) NOT NULL COMMENT '支付方式Id',
  `is_stage` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否分期付款',
  `bank` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '分期付款银行',
  `stage_6` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '[0,0]' COMMENT '分6期',
  `stage_9` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '[0,0]',
  `stage_12` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '[0,0]',
  `stage_24` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '[0,0]',
  `stage_36` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '[0,0]',
  `create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 34 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '收款渠道' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_credit_card_config
-- ----------------------------
INSERT INTO `erp_credit_card_config` VALUES (25, 4, 0, 'Maybank', '[0,\"0\"]', '[0,\"0\"]', '[0,\"0\"]', '[0,\"0\"]', '[0,\"0\"]', 1671782983, 1671782983, 0);
INSERT INTO `erp_credit_card_config` VALUES (26, 4, 0, 'UOB', '[0,\"0\"]', '[0,\"0\"]', '[0,\"0\"]', '[0,\"0\"]', '[0,\"0\"]', 1671782983, 1671782983, 0);
INSERT INTO `erp_credit_card_config` VALUES (27, 4, 0, 'DBS', '[0,\"0\"]', '[0,\"0\"]', '[0,\"0\"]', '[0,\"0\"]', '[0,\"0\"]', 1671782983, 1671782983, 0);
INSERT INTO `erp_credit_card_config` VALUES (28, 4, 1, 'MayBank', '[1,\"3\"]', '[0,\"0\"]', '[1,\"4\"]', '[1,\"6\"]', '[1,\"9\"]', 1671782983, 1671782983, 0);
INSERT INTO `erp_credit_card_config` VALUES (29, 4, 1, 'UOB', '[1,\"2\"]', '[0,\"0\"]', '[1,\"5\"]', '[1,\"8\"]', '[1,\"10\"]', 1671782983, 1671782983, 0);
INSERT INTO `erp_credit_card_config` VALUES (30, 4, 1, 'HSBC', '[1,\"4\"]', '[0,\"0\"]', '[1,\"8\"]', '[0,\"0\"]', '[0,\"0\"]', 1671782984, 1671782984, 0);
INSERT INTO `erp_credit_card_config` VALUES (31, 4, 1, 'Dinners', '[1,\"1\"]', '[0,\"0\"]', '[1,\"3\"]', '[0,\"0\"]', '[0,\"0\"]', 1671782984, 1671782984, 0);
INSERT INTO `erp_credit_card_config` VALUES (32, 7, 1, 'DINERS', '[1,\"5\"]', '[1,\"8\"]', '[1,\"12\"]', '[1,\"30\"]', '[0,\"0\"]', 1671783071, 1671783071, 0);
INSERT INTO `erp_credit_card_config` VALUES (33, 7, 0, 'DINERS', '[0,\"0\"]', '[0,\"0\"]', '[0,\"0\"]', '[0,\"0\"]', '[0,\"0\"]', 1672911475, 1672911475, 0);

-- ----------------------------
-- Table structure for erp_customer
-- ----------------------------
DROP TABLE IF EXISTS `erp_customer`;
CREATE TABLE `erp_customer`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name_zh` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '客户名称_zn',
  `name_en` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户名称_en',
  `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '手机号码',
  `sex` tinyint(4) NOT NULL COMMENT '性别 1 男 2女 3未知',
  `sun_calendar` datetime NULL DEFAULT NULL COMMENT '阳历',
  `lunar_calendar` datetime NULL DEFAULT NULL COMMENT '阴历',
  `create_user_id` int(11) NULL DEFAULT NULL COMMENT '创建人ID',
  `create_username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建者名称',
  `follow_user_id` int(10) NOT NULL COMMENT '专属顾问',
  `follow_username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '专属顾问名称',
  `linkman` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系人',
  `relation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '与客户关系',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地址',
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `store_id` int(11) NOT NULL COMMENT '门店ID',
  `store_abbr` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '门店简称',
  `create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10059 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '客户表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_customer
-- ----------------------------
INSERT INTO `erp_customer` VALUES (10052, '贝克汉姆', 'David Robert Joseph Beckham', '18774388888', 1, '1989-12-23 00:00:00', '1988-02-29 00:00:00', 10007, 'Caviar.', 10007, 'Caviar.', '特德·贝克汉姆', '父子', '英国科茨沃尔德', 'Beckham@vip.com', 10003, 'AMK', 1671785146, 1671785146, 0);
INSERT INTO `erp_customer` VALUES (10053, '小小尹', 'Mr Yin', '15567876543', 2, '2022-12-25 00:00:00', '2022-12-25 00:00:00', 10008, 'AMK_001', 10008, 'AMK_001', '青蛙小王子', '配偶', '美国华盛顿', 'wangzi@163.com', 10003, 'AMK', 1671972546, 1671973235, 0);
INSERT INTO `erp_customer` VALUES (10056, '中文名', '英文名', '手机号', 1, '2022-10-11 18:00:00', '2022-10-11 18:00:00', 10007, 'Caviar.', 10008, 'AMK_001', '帅哥', '父子', '美国洛杉矶', 'G@163.com', 10003, 'AMK', 1672055789, 1672055789, 0);
INSERT INTO `erp_customer` VALUES (10057, '中文名', '英文名', '155749202531', 1, '2022-10-11 18:00:00', '2022-10-11 18:00:00', 10007, 'Caviar.', 10008, 'AMK_001', '帅哥', '父子', '美国洛杉矶', 'G@163.com', 10003, 'AMK', 1672056110, 1672056110, 0);
INSERT INTO `erp_customer` VALUES (10058, '小包子', 'xbz', '15574920253', 1, '2022-04-04 04:00:00', '2019-04-04 06:00:00', 10007, 'Caviar.', 10008, 'AMK_001', '小狗子', '朋友', 'ABC', 'ABC@163.com', 10003, 'AMK', 1672996943, 1672996943, 0);

-- ----------------------------
-- Table structure for erp_customer_zue_coin
-- ----------------------------
DROP TABLE IF EXISTS `erp_customer_zue_coin`;
CREATE TABLE `erp_customer_zue_coin`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) NOT NULL COMMENT '客户ID',
  `zue_coin` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '御龙币',
  `lose_time` bigint(11) NOT NULL COMMENT '失效时间',
  `delete_time` bigint(11) NULL DEFAULT NULL COMMENT '逻辑删除字段',
  `create_time` bigint(11) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` bigint(11) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统设置表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_customer_zue_coin
-- ----------------------------
INSERT INTO `erp_customer_zue_coin` VALUES (1, 10052, 7457.90, 3811334400, NULL, 1671785146, 1671785146, 0);
INSERT INTO `erp_customer_zue_coin` VALUES (2, 1, 1.00, 3811334400, NULL, 1672055789, 1672055789, 0);
INSERT INTO `erp_customer_zue_coin` VALUES (3, 10057, 1.00, 3811334400, NULL, 1672056110, 1672056110, 0);
INSERT INTO `erp_customer_zue_coin` VALUES (4, 10053, 9986.22, 3811334400, NULL, 1672056110, 1672056110, 0);

-- ----------------------------
-- Table structure for erp_department
-- ----------------------------
DROP TABLE IF EXISTS `erp_department`;
CREATE TABLE `erp_department`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '部门名称',
  `pid` int(10) NOT NULL DEFAULT 0 COMMENT '父级部门',
  `store_id` int(11) NULL DEFAULT NULL COMMENT '关联门店ID',
  `describe` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '描述',
  `create_time` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '部门' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_department
-- ----------------------------
INSERT INTO `erp_department` VALUES (5, '市场部', 0, NULL, '111', 1234567890, 1671642753, 0);
INSERT INTO `erp_department` VALUES (6, 'AMK Hub Branch', 5, 10003, 'AMK Hub Branch', 1234567890, 1671083167, 0);
INSERT INTO `erp_department` VALUES (7, '物流部', 0, NULL, '物流部', 1234567890, 1671083197, 0);
INSERT INTO `erp_department` VALUES (8, '财务部', 0, NULL, '财务', 1234567890, 1671083239, 0);
INSERT INTO `erp_department` VALUES (17, '佛堂部', 0, NULL, '佛堂', 1671592191, 1671592191, 0);
INSERT INTO `erp_department` VALUES (28, '1', 0, NULL, '1', 1671631145, 1671632469, 1);
INSERT INTO `erp_department` VALUES (29, '1111111', 0, NULL, '11111', 1671631497, 1671632444, 1);
INSERT INTO `erp_department` VALUES (31, 'JEM Hub Branch', 5, 10004, 'JEM Hub Branch', 1671697864, 1671697864, 0);
INSERT INTO `erp_department` VALUES (32, 'test', 5, 10005, 'test', 1672021600, 1672021600, 0);

-- ----------------------------
-- Table structure for erp_order
-- ----------------------------
DROP TABLE IF EXISTS `erp_order`;
CREATE TABLE `erp_order`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `no` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单编号',
  `customer_id` int(11) NOT NULL COMMENT '客户ID',
  `customer_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '客户名称',
  `obj_names` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品名称集合',
  `rental_amount` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '项目总额',
  `receivable_amount` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '应收金额',
  `receive_amount` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '实收金额',
  `imposed_amount` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '待收金额',
  `product_amount` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '商品的费用',
  `total_sales_tax` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '总消费税',
  `service_charge_amount` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '总信用卡服务费',
  `total_annual_fee` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '总年费费用',
  `zue_coin` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '消耗了多少御龙币',
  `zue_coin_amount` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '御龙币兑换了多少钱',
  `type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '订单类型 1=正常订单,2=定金订单',
  `store_id` int(11) NOT NULL COMMENT '门店ID',
  `advisor_ids` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '所属权限者IDs',
  `remarks` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订单表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_order
-- ----------------------------
INSERT INTO `erp_order` VALUES (29, 'AMK10000001', 10052, 'David Robert Joseph Beckham|贝克汉姆', '胸坠,小番茄', 306.40, 306.40, 306.40, 0.00, 168.00, 50.40, 0.00, 88.00, 0.00, 0.00, 1, 10003, '10007', '备注1', 1672383934, 1672383934, 0);
INSERT INTO `erp_order` VALUES (30, 'AMK10000002', 10052, 'David Robert Joseph Beckham|贝克汉姆', '胸坠,斑马', 11267.39, 11267.39, 0.00, 11267.39, 10137.99, 1041.40, 0.00, 88.00, 0.00, 0.00, 2, 10003, '10008,10007', NULL, 1672823748, 1672823748, 0);
INSERT INTO `erp_order` VALUES (31, 'AMK10000003', 10052, 'David Robert Joseph Beckham|贝克汉姆', '胸坠,斑马,火龙果', 11269.83, 11269.83, 0.00, 11269.83, 10139.87, 1041.96, 0.00, 88.00, 0.00, 0.00, 2, 10003, '10009,10008', NULL, 1672833900, 1672833900, 0);
INSERT INTO `erp_order` VALUES (32, 'AMK10000004', 10053, 'Mr Yin|小小尹', '胸坠', 1337.00, 1337.00, 1337.00, 0.00, 690.00, 207.00, 0.00, 440.00, 0.00, 0.00, 1, 10003, '10008,10009', NULL, 1672885349, 1672885349, 0);
INSERT INTO `erp_order` VALUES (33, 'AMK10000005', 10056, '英文名|中文名', '胸坠,火龙果', 544.56, 544.56, 544.56, 0.00, 283.52, 85.04, 0.00, 176.00, 0.00, 0.00, 1, 10003, '10008,10009', NULL, 1672885475, 1672885475, 0);
INSERT INTO `erp_order` VALUES (34, 'AMK10000006', 10053, 'Mr Yin|小小尹', '火龙果,胸坠', 302.32, 274.76, 274.76, 0.00, 141.76, 42.52, 30.04, 88.00, 13.78, 27.56, 1, 10003, '10008', NULL, 1672985214, 1672985214, 0);
INSERT INTO `erp_order` VALUES (35, 'AMK10000007', 10053, 'Mr Yin|小小尹', '小番茄', 19.50, 19.50, 19.50, 0.00, 15.00, 4.50, 0.00, 0.00, 0.00, 0.00, 1, 10003, '10007', NULL, 1672986161, 1672986161, 0);
INSERT INTO `erp_order` VALUES (36, 'AMK10000008', 10053, 'Mr Yin|小小尹', '胸坠', 267.40, 267.40, 17.54, 497.76, 138.00, 41.40, 0.00, 88.00, 0.00, 0.00, 2, 10003, '10007', NULL, 1672987367, 1672987367, 0);
INSERT INTO `erp_order` VALUES (37, 'AMK10000009', 10053, 'Mr Yin|小小尹', '小番茄', 19.50, 19.50, 1.00, 18.50, 15.00, 4.50, 0.00, 0.00, 0.00, 0.00, 2, 10003, '10007', NULL, 1672989412, 1672989412, 0);
INSERT INTO `erp_order` VALUES (38, 'AMK10000010', 10052, 'David Robert Joseph Beckham|贝克汉姆', '火龙果,小番茄,斑马', 11024.37, 11024.37, 11024.37, 0.00, 10018.75, 1005.62, 0.00, 0.00, 0.00, 0.00, 1, 10003, '10007', NULL, 1672999996, 1672999996, 0);
INSERT INTO `erp_order` VALUES (39, 'AMK10000011', 10058, 'xbz|小包子', '斑马,火龙果,胸坠', 22272.26, 22272.26, 22272.26, 0.00, 20141.74, 2042.52, 0.00, 88.00, 0.00, 0.00, 1, 10003, '10007', NULL, 1673074779, 1673074779, 0);
INSERT INTO `erp_order` VALUES (40, 'AMK10000012', 10052, 'David Robert Joseph Beckham|贝克汉姆', '胸坠', 267.40, 267.40, 267.40, 0.00, 138.00, 41.40, 0.00, 88.00, 0.00, 0.00, 1, 10003, '10008', NULL, 1673075325, 1673075325, 1);
INSERT INTO `erp_order` VALUES (41, 'AMK10000013', 10058, 'xbz|小包子', '胸坠,火龙果,斑马', 11272.27, 11272.27, 11272.27, 0.00, 10141.75, 1042.52, 0.00, 88.00, 0.00, 0.00, 1, 10003, '10007', 'zhaoling 17.06', 1673088892, 1673088892, 0);

-- ----------------------------
-- Table structure for erp_order_annual_fee
-- ----------------------------
DROP TABLE IF EXISTS `erp_order_annual_fee`;
CREATE TABLE `erp_order_annual_fee`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL COMMENT '订单编号',
  `customer_id` int(11) NOT NULL COMMENT '客户ID',
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '客户中英文名',
  `customer_mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '客户手机号码',
  `customer_create_username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '建表人',
  `order_product_id` int(11) NOT NULL COMMENT '商品ID',
  `order_product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品名称',
  `fee` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '费用',
  `is_pay` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已支付',
  `index` int(11) NOT NULL DEFAULT 1 COMMENT '第几年的年费',
  `start_time` bigint(16) NOT NULL COMMENT '开始时间',
  `end_time` bigint(16) NOT NULL COMMENT '结束时间',
  `order_create_time` bigint(16) NOT NULL DEFAULT 0 COMMENT '订单创建时间',
  `adviser_ids` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '销售顾问',
  `store_id` int(11) NOT NULL COMMENT '门店Id',
  `delete_time` bigint(16) NULL DEFAULT 0,
  `create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 44 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '年费管理 根据商品来生成' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_order_annual_fee
-- ----------------------------
INSERT INTO `erp_order_annual_fee` VALUES (19, 29, 10052, 'David Robert Joseph Beckham|贝克汉姆', '18774388888', 'Caviar.', 38, '胸坠', 88.00, 0, 1, 1672389780, 1703925780, 1672383934, '10007', 10003, 1672740615, 1672389780, 1672389780, 1);
INSERT INTO `erp_order_annual_fee` VALUES (20, 29, 10052, 'David Robert Joseph Beckham|贝克汉姆', '18774388888', 'Caviar.', 39, '斑马', 88.00, 0, 1, 1672389780, 1703925780, 1672383934, '10007', 10003, 1672734839, 1672389780, 1672389780, 1);
INSERT INTO `erp_order_annual_fee` VALUES (21, 29, 10052, 'David Robert Joseph Beckham|贝克汉姆', '18774388888', 'Caviar.', 38, '胸坠', 88.00, 0, 1, 1672390837, 1703926837, 1672383934, '10007', 10003, 1672740615, 1672390837, 1672390837, 1);
INSERT INTO `erp_order_annual_fee` VALUES (22, 29, 10052, 'David Robert Joseph Beckham|贝克汉姆', '18774388888', 'Caviar.', 39, '斑马', 88.00, 0, 1, 1672390837, 1703926837, 1672383934, '10007', 10003, 1672734839, 1672390837, 1672390837, 1);
INSERT INTO `erp_order_annual_fee` VALUES (23, 29, 10052, 'David Robert Joseph Beckham|贝克汉姆', '18774388888', 'Caviar.', 38, '胸坠', 88.00, 0, 1, 1672391529, 1703927529, 1672383934, '10007', 10003, 1672740615, 1672391529, 1672391529, 1);
INSERT INTO `erp_order_annual_fee` VALUES (24, 29, 10052, 'David Robert Joseph Beckham|贝克汉姆', '18774388888', 'Caviar.', 39, '斑马', 88.00, 0, 1, 1672391529, 1703927529, 1672383934, '10007', 10003, 1672734839, 1672391529, 1672391529, 1);
INSERT INTO `erp_order_annual_fee` VALUES (25, 29, 10052, 'David Robert Joseph Beckham|贝克汉姆', '18774388888', 'Caviar.', 49, '胸坠', 88.00, 1, 1, 1672741219, 1704277219, 1672383934, '10007', 10003, 1673074074, 1672741219, 1673000461, 1);
INSERT INTO `erp_order_annual_fee` VALUES (26, 29, 10052, 'David Robert Joseph Beckham|贝克汉姆', '18774388888', 'Caviar.', 50, '斑马', 88.00, 0, 1, 1672741219, 1704277219, 1672383934, '10007', 10003, 1673074611, 1672741219, 1672741219, 1);
INSERT INTO `erp_order_annual_fee` VALUES (27, 33, 10056, '英文名|中文名', '手机号', 'Caviar.', 61, '胸坠', 88.00, 1, 1, 1672985035, 1704521035, 1672885475, '10007', 10003, 0, 1672985035, 1673000495, 0);
INSERT INTO `erp_order_annual_fee` VALUES (28, 33, 10056, '英文名|中文名', '手机号', 'Caviar.', 62, '胸坠', 88.00, 1, 1, 1672985035, 1704521035, 1672885475, '10007', 10003, 0, 1672985035, 1673000740, 0);
INSERT INTO `erp_order_annual_fee` VALUES (29, 34, 10053, 'Mr Yin|小小尹', '15567876543', 'AMK_001', 69, '胸坠', 88.00, 0, 1, 1672986101, 1704522101, 1672985214, '10007', 10003, 0, 1672986101, 1672986101, 0);
INSERT INTO `erp_order_annual_fee` VALUES (30, 35, 10053, 'Mr Yin|小小尹', '15567876543', 'AMK_001', 70, '斑马', 88.00, 0, 1, 1672986363, 1704522363, 1672986161, '10007', 10003, 1673088280, 1672986363, 1672986363, 1);
INSERT INTO `erp_order_annual_fee` VALUES (31, 32, 10053, 'Mr Yin|小小尹', '15567876543', 'AMK_001', 56, '胸坠', 88.00, 0, 1, 1672987507, 1704523507, 1672885349, '10007', 10003, 0, 1672987507, 1672987507, 0);
INSERT INTO `erp_order_annual_fee` VALUES (32, 32, 10053, 'Mr Yin|小小尹', '15567876543', 'AMK_001', 57, '胸坠', 88.00, 0, 1, 1672987507, 1704523507, 1672885349, '10007', 10003, 0, 1672987507, 1672987507, 0);
INSERT INTO `erp_order_annual_fee` VALUES (33, 32, 10053, 'Mr Yin|小小尹', '15567876543', 'AMK_001', 58, '胸坠', 88.00, 0, 1, 1672987507, 1704523507, 1672885349, '10007', 10003, 0, 1672987507, 1672987507, 0);
INSERT INTO `erp_order_annual_fee` VALUES (34, 32, 10053, 'Mr Yin|小小尹', '15567876543', 'AMK_001', 59, '胸坠', 88.00, 0, 1, 1672987507, 1704523507, 1672885349, '10007', 10003, 0, 1672987507, 1672987507, 0);
INSERT INTO `erp_order_annual_fee` VALUES (35, 32, 10053, 'Mr Yin|小小尹', '15567876543', 'AMK_001', 60, '胸坠', 88.00, 0, 1, 1672987507, 1704523507, 1672885349, '10007', 10003, 0, 1672987507, 1672987507, 0);
INSERT INTO `erp_order_annual_fee` VALUES (36, 38, 10052, 'David Robert Joseph Beckham|贝克汉姆', '18774388888', 'Caviar.', 73, '胸坠', 88.00, 0, 1, 1672999999, 1704535999, 1672999996, '10007', 10003, 1673086778, 1672999999, 1672999999, 1);
INSERT INTO `erp_order_annual_fee` VALUES (37, 29, 10052, 'David Robert Joseph Beckham|贝克汉姆', '18774388888', 'Caviar.', 78, '胸坠', 88.00, 1, 1, 1673074134, 1704610134, 1672383934, '10007', 10003, 0, 1673074134, 1673074134, 0);
INSERT INTO `erp_order_annual_fee` VALUES (38, 39, 10058, 'xbz|小包子', '15574920253', 'Caviar.', 85, '胸坠', 88.00, 1, 1, 1673074783, 1704610783, 1673074779, '10007', 10003, 0, 1673074783, 1673074783, 0);
INSERT INTO `erp_order_annual_fee` VALUES (39, 40, 10052, 'David Robert Joseph Beckham|贝克汉姆', '18774388888', 'Caviar.', 86, '胸坠', 88.00, 1, 1, 1673075330, 1704611330, 1673075325, '10008', 10003, 1673084532, 1673075330, 1673075330, 1);
INSERT INTO `erp_order_annual_fee` VALUES (40, 40, 10052, 'David Robert Joseph Beckham|贝克汉姆', '18774388888', 'Caviar.', 87, '胸坠', 88.00, 1, 1, 1673075330, 1704611330, 1673075325, '10008', 10003, 1673084666, 1673075330, 1673075330, 1);
INSERT INTO `erp_order_annual_fee` VALUES (41, 39, 10058, 'xbz|小包子', '15574920253', 'Caviar.', 85, '胸坠', 88.00, 1, 1, 1673087851, 1704623851, 1673074779, '10007', 10003, 0, 1673087851, 1673087851, 0);
INSERT INTO `erp_order_annual_fee` VALUES (42, 39, 10058, 'xbz|小包子', '15574920253', 'Caviar.', 90, '胸坠', 88.00, 1, 1, 1673087851, 1704623851, 1673074779, '10007', 10003, 1673087903, 1673087851, 1673087851, 1);
INSERT INTO `erp_order_annual_fee` VALUES (43, 41, 10058, 'xbz|小包子', '15574920253', 'Caviar.', 94, '胸坠', 88.00, 1, 1, 1673088896, 1704624896, 1673088892, '10007', 10003, 0, 1673088896, 1673088896, 0);

-- ----------------------------
-- Table structure for erp_order_payment
-- ----------------------------
DROP TABLE IF EXISTS `erp_order_payment`;
CREATE TABLE `erp_order_payment`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL COMMENT '订单ID',
  `channel_id` int(10) NOT NULL COMMENT '支付渠道ID',
  `channel_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '支付渠道名称',
  `fee` float(10, 2) NOT NULL COMMENT '支付了多少钱',
  `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '支付编码',
  `credit_card_id` int(11) NULL DEFAULT NULL COMMENT '信用卡支付ID',
  `credit_card_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '信用卡支付银行名称',
  `stage_num` int(11) NULL DEFAULT NULL COMMENT '信用卡config',
  `service_charge` float(10, 2) NULL DEFAULT 0.00 COMMENT '手续费',
  `service_charge_rate` int(4) NULL DEFAULT 0 COMMENT '手续费比例',
  `create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 126 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订单组合支付表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_order_payment
-- ----------------------------
INSERT INTO `erp_order_payment` VALUES (42, 29, 1, 'Cash', 1.00, NULL, NULL, NULL, NULL, NULL, NULL, 1672383974, 1672383974, 0);
INSERT INTO `erp_order_payment` VALUES (43, 29, 1, 'Cash', 1.00, NULL, NULL, NULL, NULL, NULL, NULL, 1672383977, 1672383977, 0);
INSERT INTO `erp_order_payment` VALUES (44, 29, 1, 'Cash', 1.00, NULL, NULL, NULL, NULL, NULL, NULL, 1672383978, 1672383978, 0);
INSERT INTO `erp_order_payment` VALUES (45, 29, 4, 'Visa / Master', 5000.00, 'Test', 28, 'MayBank', 6, 150.00, 3, 1672384099, 1672384099, 0);
INSERT INTO `erp_order_payment` VALUES (46, 29, 4, 'Visa / Master', 5000.00, 'Test1', 29, 'UOB', 12, 250.00, 5, 1672384099, 1672384099, 0);
INSERT INTO `erp_order_payment` VALUES (47, 29, 1, 'Cash', 1.00, NULL, NULL, NULL, NULL, NULL, NULL, 1672384483, 1672384483, 0);
INSERT INTO `erp_order_payment` VALUES (48, 29, 1, 'Cash', 500.00, NULL, NULL, NULL, NULL, NULL, NULL, 1672384523, 1672384523, 0);
INSERT INTO `erp_order_payment` VALUES (49, 29, 1, 'Cash', 600.00, NULL, NULL, NULL, NULL, NULL, NULL, 1672384771, 1672384771, 0);
INSERT INTO `erp_order_payment` VALUES (50, 29, 11, 'Zue Coin', 1.00, NULL, NULL, NULL, NULL, NULL, NULL, 1672384890, 1672384890, 0);
INSERT INTO `erp_order_payment` VALUES (51, 29, 11, 'Zue Coin', 1.00, NULL, NULL, NULL, NULL, NULL, NULL, 1672384914, 1672384914, 0);
INSERT INTO `erp_order_payment` VALUES (52, 29, 11, 'Zue Coin', 1.00, NULL, NULL, NULL, NULL, NULL, NULL, 1672384941, 1672384941, 0);
INSERT INTO `erp_order_payment` VALUES (53, 29, 11, 'Zue Coin', 275.70, NULL, NULL, NULL, NULL, NULL, NULL, 1672385132, 1672385132, 0);
INSERT INTO `erp_order_payment` VALUES (54, 29, 11, 'Zue Coin', 3.00, NULL, NULL, NULL, NULL, NULL, NULL, 1672389780, 1672389780, 0);
INSERT INTO `erp_order_payment` VALUES (55, 29, 1, 'Cash', 1.00, NULL, NULL, NULL, NULL, NULL, NULL, 1672390837, 1672390837, 0);
INSERT INTO `erp_order_payment` VALUES (56, 29, 1, 'Cash', 1.00, NULL, NULL, NULL, NULL, NULL, NULL, 1672391529, 1672391529, 0);
INSERT INTO `erp_order_payment` VALUES (58, 29, 0, 'Exchange a purchase', -10840.48, NULL, NULL, NULL, NULL, 0.00, 0, 1672735097, 1672735097, 0);
INSERT INTO `erp_order_payment` VALUES (76, 29, 0, 'Exchange a purchase', -131.07, NULL, NULL, NULL, NULL, 0.00, 0, 1672740615, 1672740615, 0);
INSERT INTO `erp_order_payment` VALUES (77, 29, 0, 'Exchange a purchase', 11137.39, NULL, NULL, NULL, NULL, 0.00, 0, 1672741219, 1672741219, 0);
INSERT INTO `erp_order_payment` VALUES (78, 33, 1, 'Cash', 1.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, NULL, 0);
INSERT INTO `erp_order_payment` VALUES (79, 33, 1, 'Cash', 188.88, NULL, NULL, NULL, NULL, 0.00, 0, NULL, NULL, 0);
INSERT INTO `erp_order_payment` VALUES (80, 33, 1, 'Cash', 354.68, NULL, NULL, NULL, NULL, NULL, NULL, 1672985035, 1672985035, 0);
INSERT INTO `erp_order_payment` VALUES (81, 34, 1, 'Cash', 1.00, NULL, NULL, NULL, NULL, NULL, NULL, 1672985224, 1672985224, 0);
INSERT INTO `erp_order_payment` VALUES (82, 34, 1, 'Cash', 2.00, NULL, NULL, NULL, NULL, NULL, NULL, 1672985229, 1672985229, 0);
INSERT INTO `erp_order_payment` VALUES (83, 34, 2, 'NETS', 100.00, '1', NULL, NULL, NULL, NULL, NULL, 1672985550, 1672985550, 0);
INSERT INTO `erp_order_payment` VALUES (84, 34, 4, 'Visa / Master', 1.00, '1', 30, 'HSBC', 6, 0.04, 4, 1672985568, 1672985568, 0);
INSERT INTO `erp_order_payment` VALUES (85, 34, 11, 'Zue Coin', 1.00, NULL, NULL, NULL, NULL, NULL, NULL, 1672985692, 1672985692, 0);
INSERT INTO `erp_order_payment` VALUES (86, 34, 11, 'Zue Coin', 0.52, NULL, NULL, NULL, NULL, NULL, NULL, 1672985705, 1672985705, 0);
INSERT INTO `erp_order_payment` VALUES (87, 34, 11, 'Zue Coin', 10.00, NULL, NULL, NULL, NULL, NULL, NULL, 1672985738, 1672985738, 0);
INSERT INTO `erp_order_payment` VALUES (88, 34, 7, 'DINERS', 100.00, '速度发放', 32, 'DINERS', 24, 30.00, 30, 1672985763, 1672985763, 0);
INSERT INTO `erp_order_payment` VALUES (89, 34, 11, 'Zue Coin', 0.97, NULL, NULL, NULL, NULL, NULL, NULL, 1672985818, 1672985818, 0);
INSERT INTO `erp_order_payment` VALUES (90, 34, 11, 'Zue Coin', 0.87, NULL, NULL, NULL, NULL, NULL, NULL, 1672985827, 1672985827, 0);
INSERT INTO `erp_order_payment` VALUES (91, 34, 11, 'Zue Coin', 0.42, NULL, NULL, NULL, NULL, NULL, NULL, 1672986045, 1672986045, 0);
INSERT INTO `erp_order_payment` VALUES (92, 34, 1, 'Cash', 0.76, NULL, NULL, NULL, NULL, NULL, NULL, 1672986075, 1672986075, 0);
INSERT INTO `erp_order_payment` VALUES (93, 34, 9, 'Paynow', 70.00, NULL, NULL, NULL, NULL, NULL, NULL, 1672986101, 1672986101, 0);
INSERT INTO `erp_order_payment` VALUES (94, 35, 11, 'Zue Coin', 550.00, NULL, NULL, NULL, NULL, NULL, NULL, 1672986194, 1672986194, 0);
INSERT INTO `erp_order_payment` VALUES (95, 35, 4, 'Visa / Master', 8888.00, 'IIIOOPS', 30, 'HSBC', 12, 711.04, 8, 1672986297, 1672986297, 0);
INSERT INTO `erp_order_payment` VALUES (96, 35, 5, 'Voucher', 1723.03, NULL, NULL, NULL, NULL, NULL, NULL, 1672986363, 1672986363, 0);
INSERT INTO `erp_order_payment` VALUES (97, 36, 1, 'Cash', 1.00, NULL, NULL, NULL, NULL, NULL, NULL, 1672987385, 1672987385, 0);
INSERT INTO `erp_order_payment` VALUES (98, 36, 1, 'Cash', 2.50, NULL, NULL, NULL, NULL, NULL, NULL, 1672987391, 1672987391, 0);
INSERT INTO `erp_order_payment` VALUES (99, 36, 11, 'Zue Coin', 0.98, NULL, NULL, NULL, NULL, NULL, NULL, 1672987404, 1672987404, 0);
INSERT INTO `erp_order_payment` VALUES (100, 36, 1, 'Cash', 1.04, NULL, NULL, NULL, NULL, NULL, NULL, 1672987426, 1672987426, 0);
INSERT INTO `erp_order_payment` VALUES (101, 36, 10, 'Stripe', 13.00, NULL, NULL, NULL, NULL, NULL, NULL, 1672987446, 1672987446, 0);
INSERT INTO `erp_order_payment` VALUES (102, 32, 1, 'Cash', 1337.00, NULL, NULL, NULL, NULL, NULL, NULL, 1672987507, 1672987507, 0);
INSERT INTO `erp_order_payment` VALUES (103, 37, 1, 'Cash', 1.00, NULL, NULL, NULL, NULL, NULL, NULL, 1672989888, 1672989888, 0);
INSERT INTO `erp_order_payment` VALUES (104, 38, 1, 'Cash', 11289.33, NULL, NULL, NULL, NULL, NULL, NULL, 1672999999, 1672999999, 0);
INSERT INTO `erp_order_payment` VALUES (105, 29, 0, 'Exchange a purchase', -2.44, NULL, NULL, NULL, NULL, 0.00, 0, 1673062225, 1673062225, 0);
INSERT INTO `erp_order_payment` VALUES (106, 29, 0, 'Exchange a purchase', -247.90, NULL, NULL, NULL, NULL, 0.00, 0, 1673074074, 1673074074, 0);
INSERT INTO `erp_order_payment` VALUES (107, 29, 0, 'Exchange a purchase', 247.90, NULL, NULL, NULL, NULL, 0.00, 0, 1673074134, 1673074134, 0);
INSERT INTO `erp_order_payment` VALUES (108, 29, 0, 'Exchange a purchase', -10960.99, NULL, NULL, NULL, NULL, 0.00, 0, 1673074611, 1673074611, 0);
INSERT INTO `erp_order_payment` VALUES (109, 39, 1, 'Cash', 22289.32, NULL, NULL, NULL, NULL, NULL, NULL, 1673074783, 1673074783, 0);
INSERT INTO `erp_order_payment` VALUES (110, 40, 1, 'Cash', 534.80, NULL, NULL, NULL, NULL, NULL, NULL, 1673075330, 1673075330, 0);
INSERT INTO `erp_order_payment` VALUES (111, 40, 0, 'Exchange a purchase', -267.40, NULL, NULL, NULL, NULL, 0.00, 0, 1673084532, 1673084532, 0);
INSERT INTO `erp_order_payment` VALUES (112, 40, 0, 'Exchange a purchase', -267.40, NULL, NULL, NULL, NULL, 0.00, 0, 1673084666, 1673084666, 0);
INSERT INTO `erp_order_payment` VALUES (113, 38, 0, 'Exchange a purchase', -264.96, NULL, NULL, NULL, NULL, 0.00, 0, 1673086778, 1673086778, 0);
INSERT INTO `erp_order_payment` VALUES (114, 39, 0, 'Exchange a purchase', 0.00, NULL, NULL, NULL, NULL, 0.00, 0, 1673087487, 1673087487, 0);
INSERT INTO `erp_order_payment` VALUES (115, 39, 0, 'Exchange a purchase', 247.90, NULL, NULL, NULL, NULL, 0.00, 0, 1673087561, 1673087561, 0);
INSERT INTO `erp_order_payment` VALUES (116, 39, 1, 'Cash', 247.90, NULL, NULL, NULL, NULL, NULL, NULL, 1673087851, 1673087851, 0);
INSERT INTO `erp_order_payment` VALUES (117, 39, 0, 'Exchange a purchase', -264.96, NULL, NULL, NULL, NULL, 0.00, 0, 1673087903, 1673087903, 0);
INSERT INTO `erp_order_payment` VALUES (118, 36, 0, 'Exchange a purchase', 247.90, NULL, NULL, NULL, NULL, 0.00, 0, 1673088203, 1673088203, 0);
INSERT INTO `erp_order_payment` VALUES (119, 35, 0, 'Exchange a purchase', -11691.53, NULL, NULL, NULL, NULL, 0.00, 0, 1673088280, 1673088280, 0);
INSERT INTO `erp_order_payment` VALUES (120, 41, 1, 'Cash', 11289.33, NULL, NULL, NULL, NULL, NULL, NULL, 1673088896, 1673088896, 0);
INSERT INTO `erp_order_payment` VALUES (121, 41, 0, 'Exchange a purchase', -17.06, NULL, NULL, NULL, NULL, 0.00, 0, 1673088956, 1673088956, 0);
INSERT INTO `erp_order_payment` VALUES (122, 41, 0, 'Exchange a purchase', -17.06, NULL, NULL, NULL, NULL, 0.00, 0, 1673090844, 1673090844, 0);
INSERT INTO `erp_order_payment` VALUES (123, 35, 0, 'Exchange a purchase', -22283.06, NULL, NULL, NULL, NULL, 0.00, 0, 1673090974, 1673090974, 0);
INSERT INTO `erp_order_payment` VALUES (124, 38, 0, 'Exchange a purchase', -529.92, NULL, NULL, NULL, NULL, 0.00, 0, 1673090990, 1673090990, 0);
INSERT INTO `erp_order_payment` VALUES (125, 39, 0, 'Exchange a purchase', -529.92, NULL, NULL, NULL, NULL, 0.00, 0, 1673091005, 1673091005, 0);

-- ----------------------------
-- Table structure for erp_order_proceeds
-- ----------------------------
DROP TABLE IF EXISTS `erp_order_proceeds`;
CREATE TABLE `erp_order_proceeds`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL COMMENT '订单编号',
  `channels` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '支付渠道',
  `fee` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '费用',
  `admin_id` int(11) NOT NULL COMMENT '收款者ID',
  `admin_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '收款者名称',
  `create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 94 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '年费管理 根据商品来生成' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_order_proceeds
-- ----------------------------
INSERT INTO `erp_order_proceeds` VALUES (51, 29, '[Cash]', 1.00, 10007, 'Caviar.', 1672383974, 1672383974, 0);
INSERT INTO `erp_order_proceeds` VALUES (52, 29, '[Cash]', 1.00, 10007, 'Caviar.', 1672383977, 1672383977, 0);
INSERT INTO `erp_order_proceeds` VALUES (53, 29, '[Cash]', 1.00, 10007, 'Caviar.', 1672383978, 1672383978, 0);
INSERT INTO `erp_order_proceeds` VALUES (54, 29, '[Visa / Master]', 10000.00, 10007, 'Caviar.', 1672384099, 1672384099, 0);
INSERT INTO `erp_order_proceeds` VALUES (55, 29, '[Cash]', 1.00, 10007, 'Caviar.', 1672384483, 1672384483, 0);
INSERT INTO `erp_order_proceeds` VALUES (56, 29, '[Cash]', 500.00, 10007, 'Caviar.', 1672384523, 1672384523, 0);
INSERT INTO `erp_order_proceeds` VALUES (57, 29, '[Cash]', 600.00, 10007, 'Caviar.', 1672384771, 1672384771, 0);
INSERT INTO `erp_order_proceeds` VALUES (58, 29, '[Zue Coin]', 0.00, 10007, 'Caviar.', 1672384890, 1672384890, 0);
INSERT INTO `erp_order_proceeds` VALUES (59, 29, '[Zue Coin]', 0.00, 10007, 'Caviar.', 1672384914, 1672384914, 0);
INSERT INTO `erp_order_proceeds` VALUES (60, 29, '[Zue Coin]', 0.00, 10007, 'Caviar.', 1672384941, 1672384941, 0);
INSERT INTO `erp_order_proceeds` VALUES (61, 29, '[Zue Coin]', 0.00, 10007, 'Caviar.', 1672385132, 1672385132, 0);
INSERT INTO `erp_order_proceeds` VALUES (62, 29, '[Zue Coin]', 0.00, 10007, 'Caviar.', 1672389780, 1672389780, 0);
INSERT INTO `erp_order_proceeds` VALUES (63, 29, '[Cash]', 1.00, 10007, 'Caviar.', 1672390837, 1672390837, 0);
INSERT INTO `erp_order_proceeds` VALUES (64, 29, '[Cash]', 1.00, 10007, 'Caviar.', 1672391529, 1672391529, 0);
INSERT INTO `erp_order_proceeds` VALUES (65, 33, '[Cash]', 354.68, 10007, 'Caviar.', 1672985036, 1672985036, 0);
INSERT INTO `erp_order_proceeds` VALUES (66, 34, '[Cash]', 1.00, 10007, 'Caviar.', 1672985224, 1672985224, 0);
INSERT INTO `erp_order_proceeds` VALUES (67, 34, '[Cash]', 2.00, 10007, 'Caviar.', 1672985229, 1672985229, 0);
INSERT INTO `erp_order_proceeds` VALUES (68, 34, '[NETS]', 100.00, 10007, 'Caviar.', 1672985550, 1672985550, 0);
INSERT INTO `erp_order_proceeds` VALUES (69, 34, '[Visa / Master]', 1.00, 10007, 'Caviar.', 1672985568, 1672985568, 0);
INSERT INTO `erp_order_proceeds` VALUES (70, 34, '[Zue Coin]', 0.00, 10007, 'Caviar.', 1672985692, 1672985692, 0);
INSERT INTO `erp_order_proceeds` VALUES (71, 34, '[Zue Coin]', 0.00, 10007, 'Caviar.', 1672985705, 1672985705, 0);
INSERT INTO `erp_order_proceeds` VALUES (72, 34, '[Zue Coin]', 0.00, 10007, 'Caviar.', 1672985738, 1672985738, 0);
INSERT INTO `erp_order_proceeds` VALUES (73, 34, '[DINERS]', 100.00, 10007, 'Caviar.', 1672985763, 1672985763, 0);
INSERT INTO `erp_order_proceeds` VALUES (74, 34, '[Zue Coin]', 0.00, 10007, 'Caviar.', 1672985818, 1672985818, 0);
INSERT INTO `erp_order_proceeds` VALUES (75, 34, '[Zue Coin]', 0.00, 10007, 'Caviar.', 1672985827, 1672985827, 0);
INSERT INTO `erp_order_proceeds` VALUES (76, 34, '[Zue Coin]', 0.00, 10007, 'Caviar.', 1672986045, 1672986045, 0);
INSERT INTO `erp_order_proceeds` VALUES (77, 34, '[Cash]', 0.76, 10007, 'Caviar.', 1672986075, 1672986075, 0);
INSERT INTO `erp_order_proceeds` VALUES (78, 34, '[Paynow]', 70.00, 10007, 'Caviar.', 1672986101, 1672986101, 0);
INSERT INTO `erp_order_proceeds` VALUES (79, 35, '[Zue Coin]', 0.00, 10007, 'Caviar.', 1672986194, 1672986194, 0);
INSERT INTO `erp_order_proceeds` VALUES (80, 35, '[Visa / Master]', 8888.00, 10007, 'Caviar.', 1672986297, 1672986297, 0);
INSERT INTO `erp_order_proceeds` VALUES (81, 35, '[Voucher]', 1723.03, 10007, 'Caviar.', 1672986363, 1672986363, 0);
INSERT INTO `erp_order_proceeds` VALUES (82, 36, '[Cash]', 1.00, 10007, 'Caviar.', 1672987385, 1672987385, 0);
INSERT INTO `erp_order_proceeds` VALUES (83, 36, '[Cash]', 2.50, 10007, 'Caviar.', 1672987391, 1672987391, 0);
INSERT INTO `erp_order_proceeds` VALUES (84, 36, '[Zue Coin]', 0.00, 10007, 'Caviar.', 1672987404, 1672987404, 0);
INSERT INTO `erp_order_proceeds` VALUES (85, 36, '[Cash]', 1.04, 10007, 'Caviar.', 1672987426, 1672987426, 0);
INSERT INTO `erp_order_proceeds` VALUES (86, 36, '[Stripe]', 13.00, 10007, 'Caviar.', 1672987446, 1672987446, 0);
INSERT INTO `erp_order_proceeds` VALUES (87, 32, '[Cash]', 1337.00, 10007, 'Caviar.', 1672987507, 1672987507, 0);
INSERT INTO `erp_order_proceeds` VALUES (88, 37, '[Cash]', 1.00, 10007, 'Caviar.', 1672989888, 1672989888, 0);
INSERT INTO `erp_order_proceeds` VALUES (89, 38, '[Cash]', 11289.33, 10007, 'Caviar.', 1672999999, 1672999999, 0);
INSERT INTO `erp_order_proceeds` VALUES (90, 39, '[Cash]', 22289.32, 10007, 'Caviar.', 1673074783, 1673074783, 0);
INSERT INTO `erp_order_proceeds` VALUES (91, 40, '[Cash]', 534.80, 10007, 'Caviar.', 1673075330, 1673075330, 0);
INSERT INTO `erp_order_proceeds` VALUES (92, 39, '[Cash]', 247.90, 10007, 'Caviar.', 1673087851, 1673087851, 0);
INSERT INTO `erp_order_proceeds` VALUES (93, 41, '[Cash]', 11289.33, 10007, 'Caviar.', 1673088896, 1673088896, 0);

-- ----------------------------
-- Table structure for erp_order_product
-- ----------------------------
DROP TABLE IF EXISTS `erp_order_product`;
CREATE TABLE `erp_order_product`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL COMMENT '订单ID',
  `order_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单编号',
  `customer_id` int(11) NOT NULL COMMENT '客户ID',
  `product_id` int(11) NOT NULL COMMENT '商品ID',
  `store_product_id` int(11) NOT NULL COMMENT '门店商品关系ID',
  `product_category_id` int(11) NOT NULL COMMENT '商品类别ID',
  `product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品名称',
  `is_serve` tinyint(1) NOT NULL DEFAULT 0 COMMENT '商品/服务',
  `adviser_1_id` int(11) NULL DEFAULT NULL COMMENT '顾问1',
  `adviser_1_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `adviser_2_id` int(11) NULL DEFAULT NULL COMMENT '顾问2',
  `adviser_2_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `teacher_1_id` int(11) NULL DEFAULT NULL COMMENT '老师1',
  `teacher_1_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '老师1名称',
  `teacher_2_id` int(11) NULL DEFAULT NULL COMMENT '老师2',
  `teacher_2_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `is_upload_numerology` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否需要上传命理报告',
  `is_upload` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已经上传命理报告',
  `report` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '命理报告',
  `is_gather_annuity` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否收取年费',
  `annuity` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '年费',
  `real_price` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '商品真实价格',
  `transaction_price` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '商品的成交价格',
  `service_charge` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '信用卡支付所需要的服务费',
  `reduce_price` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '减少了多少价格',
  `reduce_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 没有选择 1=活动折扣；2=活动减免价',
  `sales_tax_rate` int(10) NOT NULL DEFAULT 0 COMMENT '消费税比例',
  `sales_tax` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '消费税',
  `zue_coin` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '御龙币抵扣',
  `zue_coin_amount` float(10, 2) NULL DEFAULT 0.00 COMMENT '单项御龙币扣除的费用',
  `is_pay` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已支付',
  `channel_ids` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '查询使用 无其他意义',
  `delete_time` bigint(16) NULL DEFAULT 0,
  `create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 99 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订单商品表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_order_product
-- ----------------------------
INSERT INTO `erp_order_product` VALUES (38, 29, 'AMK10000001', 10052, 1, 5, 7, '胸坠', 0, 10008, 'AMK_001', 10007, 'Caviar.', NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 88.00, 138.00, 263.51, 9.49, 30.00, 1, 30, 41.40, 6.69, 13.38, 1, '', 1672740615, 1672383934, 1672383934, 1);
INSERT INTO `erp_order_product` VALUES (39, 29, 'AMK10000001', 10052, 13, 3, 5, '斑马', 1, 10007, 'Caviar.', 10008, 'AMK_001', NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 0.00, 9999.99, 10840.48, 390.51, 0.00, 0, 10, 1000.00, 275.01, 550.02, 1, NULL, 1672735097, 1672383934, 1672383934, 1);
INSERT INTO `erp_order_product` VALUES (47, 29, 'AMK10000001', 10052, 2, 6, 4, '斑马幼崽001', 0, 10007, 'Caviar.', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0.00, 100.00, 130.00, 0.00, 0.00, 0, 30, 30.00, 0.00, 0.00, 1, NULL, 1672741219, 1672740615, 1672740615, 1);
INSERT INTO `erp_order_product` VALUES (48, 29, 'AMK10000001', 10052, 8, 4, 6, '火龙果', 0, 10007, 'Caviar.', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0.00, 1.88, 2.44, 0.00, 0.00, 0, 30, 0.56, 0.00, 0.00, 1, NULL, 1673062225, 1672740615, 1672740615, 1);
INSERT INTO `erp_order_product` VALUES (49, 29, 'AMK10000001', 10052, 1, 5, 7, '胸坠', 0, 10007, 'Caviar.', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 88.00, 138.00, 267.40, 0.00, 30.00, 1, 30, 41.40, 0.00, 0.00, 1, NULL, 1673074074, 1672741219, 1672741219, 1);
INSERT INTO `erp_order_product` VALUES (50, 29, 'AMK10000001', 10052, 13, 3, 5, '斑马', 1, 10007, 'Caviar.', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 0.00, 9999.99, 10999.99, 0.00, 0.00, 0, 10, 1000.00, 0.00, 0.00, 1, NULL, 1673074611, 1672741219, 1672741219, 1);
INSERT INTO `erp_order_product` VALUES (51, 30, 'AMK10000002', 10052, 1, 5, 7, '胸坠', 0, 10008, 'AMK_001', 10007, 'Caviar.', NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 88.00, 138.00, 267.40, 0.00, 30.00, 1, 30, 41.40, 0.00, 0.00, 0, NULL, 0, 1672823748, 1672823748, 0);
INSERT INTO `erp_order_product` VALUES (52, 30, 'AMK10000002', 10052, 13, 3, 5, '斑马', 1, 10007, 'Caviar.', 10008, 'AMK_001', NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 0.00, 9999.99, 10999.99, 0.00, 0.00, 0, 10, 1000.00, 0.00, 0.00, 0, NULL, 0, 1672823748, 1672823748, 0);
INSERT INTO `erp_order_product` VALUES (53, 31, 'AMK10000003', 10052, 1, 5, 7, '胸坠', 0, 10009, 'AMK管理员', 10008, 'AMK_001', 10008, 'AMK_001', NULL, NULL, 1, 0, NULL, 1, 88.00, 138.00, 267.40, 0.00, 30.00, 1, 30, 41.40, 0.00, 0.00, 0, NULL, 0, 1672833900, 1672833900, 0);
INSERT INTO `erp_order_product` VALUES (54, 31, 'AMK10000003', 10052, 13, 3, 5, '斑马', 1, 10008, 'AMK_001', 10009, 'AMK管理员', 10009, 'AMK管理员', NULL, NULL, 1, 0, NULL, 1, 0.00, 9999.99, 10999.99, 0.00, 0.00, 0, 10, 1000.00, 0.00, 0.00, 0, NULL, 0, 1672833900, 1672833900, 0);
INSERT INTO `erp_order_product` VALUES (55, 31, 'AMK10000003', 10052, 8, 4, 6, '火龙果', 0, 10009, 'AMK管理员', NULL, NULL, 10009, 'AMK管理员', NULL, NULL, 0, 0, NULL, 0, 0.00, 1.88, 2.44, 0.00, 0.00, 0, 30, 0.56, 0.00, 0.00, 0, NULL, 0, 1672833900, 1672833900, 0);
INSERT INTO `erp_order_product` VALUES (56, 32, 'AMK10000004', 10053, 1, 5, 7, '胸坠', 0, 10008, 'AMK_001', 10009, 'AMK管理员', 10009, 'AMK管理员', 10008, 'AMK_001', 1, 1, '/storage/numerology/20230106/f0d971b77600e674593f2d572bf76f57.jpg', 1, 88.00, 138.00, 267.40, 0.00, 30.00, 1, 30, 41.40, 0.00, 0.00, 1, NULL, 0, 1672885349, 1672991351, 0);
INSERT INTO `erp_order_product` VALUES (57, 32, 'AMK10000004', 10053, 1, 5, 7, '胸坠', 0, 10008, 'AMK_001', 10009, 'AMK管理员', 10009, 'AMK管理员', 10008, 'AMK_001', 1, 1, '/storage/numerology/20230106/30568ba79b480111a2f5ce0d4745a58c.jpg', 1, 88.00, 138.00, 267.40, 0.00, 30.00, 1, 30, 41.40, 0.00, 0.00, 1, NULL, 0, 1672885349, 1672991442, 0);
INSERT INTO `erp_order_product` VALUES (58, 32, 'AMK10000004', 10053, 1, 5, 7, '胸坠', 0, 10008, 'AMK_001', 10009, 'AMK管理员', 10009, 'AMK管理员', 10008, 'AMK_001', 1, 0, NULL, 1, 88.00, 138.00, 267.40, 0.00, 30.00, 1, 30, 41.40, 0.00, 0.00, 1, NULL, 0, 1672885349, 1672885349, 0);
INSERT INTO `erp_order_product` VALUES (59, 32, 'AMK10000004', 10053, 1, 5, 7, '胸坠', 0, 10008, 'AMK_001', 10009, 'AMK管理员', 10009, 'AMK管理员', 10008, 'AMK_001', 1, 0, NULL, 1, 88.00, 138.00, 267.40, 0.00, 30.00, 1, 30, 41.40, 0.00, 0.00, 1, NULL, 0, 1672885349, 1672885349, 0);
INSERT INTO `erp_order_product` VALUES (60, 32, 'AMK10000004', 10053, 1, 5, 7, '胸坠', 0, 10008, 'AMK_001', 10009, 'AMK管理员', 10009, 'AMK管理员', 10008, 'AMK_001', 1, 0, NULL, 1, 88.00, 138.00, 267.40, 0.00, 30.00, 1, 30, 41.40, 0.00, 0.00, 1, NULL, 0, 1672885349, 1672885349, 0);
INSERT INTO `erp_order_product` VALUES (61, 33, 'AMK10000005', 10056, 1, 5, 7, '胸坠', 0, 10008, 'AMK_001', 10009, 'AMK管理员', NULL, NULL, NULL, NULL, 1, 1, '/storage/numerology/20230106/3425bf11942816dd81eec48b3331210f.jpg', 1, 88.00, 138.00, 267.40, 0.00, 30.00, 1, 30, 41.40, 0.00, 0.00, 1, NULL, 0, 1672885475, 1672995320, 0);
INSERT INTO `erp_order_product` VALUES (62, 33, 'AMK10000005', 10056, 1, 5, 7, '胸坠', 0, 10008, 'AMK_001', 10009, 'AMK管理员', NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 88.00, 138.00, 267.40, 0.00, 30.00, 1, 30, 41.40, 0.00, 0.00, 1, NULL, 0, 1672885475, 1672885475, 0);
INSERT INTO `erp_order_product` VALUES (63, 33, 'AMK10000005', 10056, 8, 4, 6, '火龙果', 0, 10009, 'AMK管理员', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0.00, 1.88, 2.44, 0.00, 0.00, 0, 30, 0.56, 0.00, 0.00, 1, NULL, 0, 1672885475, 1672885475, 0);
INSERT INTO `erp_order_product` VALUES (64, 33, 'AMK10000005', 10056, 8, 4, 6, '火龙果', 0, 10009, 'AMK管理员', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0.00, 1.88, 2.44, 0.00, 0.00, 0, 30, 0.56, 0.00, 0.00, 1, NULL, 0, 1672885475, 1672885475, 0);
INSERT INTO `erp_order_product` VALUES (65, 33, 'AMK10000005', 10056, 8, 4, 6, '火龙果', 0, 10009, 'AMK管理员', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0.00, 1.88, 2.44, 0.00, 0.00, 0, 30, 0.56, 0.00, 0.00, 1, NULL, 0, 1672885475, 1672885475, 0);
INSERT INTO `erp_order_product` VALUES (66, 33, 'AMK10000005', 10056, 8, 4, 6, '火龙果', 0, 10009, 'AMK管理员', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0.00, 1.88, 2.44, 0.00, 0.00, 0, 30, 0.56, 0.00, 0.00, 1, NULL, 0, 1672885475, 1672885475, 0);
INSERT INTO `erp_order_product` VALUES (67, 34, 'AMK10000006', 10053, 8, 4, 6, '火龙果 ', 0, 10008, 'AMK_001', NULL, NULL, 10007, 'Caviar.', NULL, NULL, 0, 0, NULL, 0, 0.00, 1.88, 2.71, 0.27, 0.00, 0, 30, 0.56, 0.12, 0.00, 1, NULL, 0, 1672985214, 1672985214, 0);
INSERT INTO `erp_order_product` VALUES (68, 34, 'AMK10000006', 10053, 8, 4, 6, '火龙果', 0, 10008, 'AMK_001', NULL, NULL, 10007, 'Caviar.', NULL, NULL, 0, 0, NULL, 0, 0.00, 1.88, 2.71, 0.27, 0.00, 0, 30, 0.56, 0.12, 0.00, 1, NULL, 0, 1672985214, 1672985214, 0);
INSERT INTO `erp_order_product` VALUES (69, 34, 'AMK10000006', 10053, 1, 5, 7, '胸坠', 0, 10008, 'AMK_001', NULL, NULL, 10007, 'Caviar.', NULL, NULL, 1, 1, '/storage/numerology/20230106/ef9eacd6a2fdca18e966751a35f4e7bf.jpg', 1, 88.00, 138.00, 296.90, 29.50, 30.00, 1, 30, 41.40, 13.53, 0.00, 1, NULL, 0, 1672985214, 1672991236, 0);
INSERT INTO `erp_order_product` VALUES (70, 35, 'AMK10000007', 10053, 13, 3, 5, '斑马', 1, 10007, 'Caviar.', NULL, NULL, 10007, 'Caviar.', NULL, NULL, 1, 1, '/storage/numerology/20230106/8195aa9eb68945e56d9637a402c96d19.jpg', 1, 0.00, 9999.99, 11711.03, 711.04, 0.00, 0, 10, 1000.00, 550.00, 0.00, 1, NULL, 1673088280, 1672986161, 1672991206, 1);
INSERT INTO `erp_order_product` VALUES (71, 36, 'AMK10000008', 10053, 3, 2, 7, '小番茄', 0, 10007, 'Caviar.', NULL, NULL, 10008, 'AMK_001', NULL, NULL, 0, 0, NULL, 0, 0.00, 15.00, 19.50, 0.00, 0.00, 0, 30, 4.50, 0.98, 0.00, 1, NULL, 1673088203, 1672987367, 1672987367, 1);
INSERT INTO `erp_order_product` VALUES (72, 37, 'AMK10000009', 10053, 3, 2, 7, '小番茄', 0, 10007, 'Caviar.', NULL, NULL, 10007, 'Caviar.', NULL, NULL, 0, 0, NULL, 0, 0.00, 15.00, 19.50, 0.00, 0.00, 0, 30, 4.50, 0.00, 0.00, 0, NULL, 0, 1672989412, 1672989412, 0);
INSERT INTO `erp_order_product` VALUES (73, 38, 'AMK10000010', 10052, 1, 5, 7, '胸坠', 0, 10007, 'Caviar.', NULL, NULL, 10007, 'Caviar.', NULL, NULL, 1, 0, NULL, 1, 88.00, 138.00, 267.40, 0.00, 30.00, 1, 30, 41.40, 0.00, 0.00, 1, NULL, 1673086778, 1672999996, 1672999996, 1);
INSERT INTO `erp_order_product` VALUES (74, 38, 'AMK10000010', 10052, 8, 4, 6, '火龙果', 0, 10007, 'Caviar.', NULL, NULL, 10007, 'Caviar.', NULL, NULL, 0, 0, NULL, 0, 0.00, 1.88, 2.44, 0.00, 0.00, 0, 30, 0.56, 0.00, 0.00, 1, NULL, 0, 1672999996, 1672999996, 0);
INSERT INTO `erp_order_product` VALUES (75, 38, 'AMK10000010', 10052, 3, 2, 7, '小番茄', 0, 10007, 'Caviar.', NULL, NULL, 10007, 'Caviar.', NULL, NULL, 0, 0, NULL, 0, 0.00, 15.00, 19.50, 0.00, 0.00, 0, 30, 4.50, 0.00, 0.00, 1, NULL, 0, 1672999996, 1672999996, 0);
INSERT INTO `erp_order_product` VALUES (76, 38, 'AMK10000010', 10052, 13, 3, 5, '斑马', 1, 10007, 'Caviar.', NULL, NULL, 10007, 'Caviar.', NULL, NULL, 1, 0, NULL, 1, 0.00, 9999.99, 10999.99, 0.00, 0.00, 0, 10, 1000.00, 0.00, 0.00, 1, NULL, 0, 1672999996, 1672999996, 0);
INSERT INTO `erp_order_product` VALUES (77, 29, 'AMK10000001', 10052, 3, 2, 7, '小番茄', 0, 10007, 'Caviar.', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0.00, 15.00, 19.50, 0.00, 0.00, 0, 30, 4.50, 0.00, 0.00, 1, NULL, 1673074134, 1673074074, 1673074074, 1);
INSERT INTO `erp_order_product` VALUES (78, 29, 'AMK10000001', 10052, 1, 5, 7, '胸坠', 0, 10007, 'Caviar.', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 88.00, 138.00, 267.40, 0.00, 30.00, 1, 30, 41.40, 0.00, 0.00, 1, NULL, 0, 1673074134, 1673074134, 0);
INSERT INTO `erp_order_product` VALUES (79, 29, 'AMK10000001', 10052, 3, 2, 7, '小番茄', 0, 10007, 'Caviar.', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0.00, 15.00, 19.50, 0.00, 0.00, 0, 30, 4.50, 0.00, 0.00, 1, NULL, 0, 1673074611, 1673074611, 0);
INSERT INTO `erp_order_product` VALUES (80, 29, 'AMK10000001', 10052, 3, 2, 7, '小番茄', 0, 10007, 'Caviar.', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0.00, 15.00, 19.50, 0.00, 0.00, 0, 30, 4.50, 0.00, 0.00, 1, NULL, 0, 1673074611, 1673074611, 0);
INSERT INTO `erp_order_product` VALUES (81, 39, 'AMK10000011', 10058, 13, 3, 5, '斑马', 1, 10007, 'Caviar.', NULL, NULL, 10007, 'Caviar.', NULL, NULL, 1, 0, NULL, 1, 0.00, 9999.99, 10999.99, 0.00, 0.00, 0, 10, 1000.00, 0.00, 0.00, 1, NULL, 1673087487, 1673074779, 1673074779, 1);
INSERT INTO `erp_order_product` VALUES (82, 39, 'AMK10000011', 10058, 13, 3, 5, '斑马', 1, 10007, 'Caviar.', NULL, NULL, 10007, 'Caviar.', NULL, NULL, 1, 0, NULL, 1, 0.00, 9999.99, 10999.99, 0.00, 0.00, 0, 10, 1000.00, 0.00, 0.00, 1, NULL, 0, 1673074779, 1673074779, 0);
INSERT INTO `erp_order_product` VALUES (83, 39, 'AMK10000011', 10058, 3, 2, 7, '小番茄', 0, 10007, 'Caviar.', NULL, NULL, 10007, 'Caviar.', NULL, NULL, 0, 0, NULL, 0, 0.00, 15.00, 19.50, 0.00, 0.00, 0, 30, 4.50, 0.00, 0.00, 1, NULL, 1673087561, 1673074779, 1673074779, 1);
INSERT INTO `erp_order_product` VALUES (84, 39, 'AMK10000011', 10058, 8, 4, 6, '火龙果', 0, 10007, 'Caviar.', NULL, NULL, 10007, 'Caviar.', NULL, NULL, 0, 0, NULL, 0, 0.00, 1.88, 2.44, 0.00, 0.00, 0, 30, 0.56, 0.00, 0.00, 1, NULL, 0, 1673074779, 1673074779, 0);
INSERT INTO `erp_order_product` VALUES (85, 39, 'AMK10000011', 10058, 1, 5, 7, '胸坠', 0, 10007, 'Caviar.', NULL, NULL, 10007, 'Caviar.', NULL, NULL, 1, 0, NULL, 1, 88.00, 138.00, 267.40, 0.00, 30.00, 1, 30, 41.40, 0.00, 0.00, 1, NULL, 0, 1673074779, 1673074779, 0);
INSERT INTO `erp_order_product` VALUES (86, 40, 'AMK10000012', 10052, 1, 5, 7, '胸坠', 0, 10008, 'AMK_001', NULL, NULL, 10008, 'AMK_001', NULL, NULL, 1, 0, NULL, 1, 88.00, 138.00, 267.40, 0.00, 30.00, 1, 30, 41.40, 0.00, 0.00, 1, NULL, 1673084532, 1673075325, 1673075325, 1);
INSERT INTO `erp_order_product` VALUES (87, 40, 'AMK10000012', 10052, 1, 5, 7, '胸坠', 0, 10008, 'AMK_001', NULL, NULL, 10008, 'AMK_001', NULL, NULL, 1, 0, NULL, 1, 88.00, 138.00, 267.40, 0.00, 30.00, 1, 30, 41.40, 0.00, 0.00, 1, NULL, 1673084666, 1673075325, 1673075325, 1);
INSERT INTO `erp_order_product` VALUES (88, 38, 'AMK10000010', 10052, 8, 4, 6, '火龙果', 0, 10007, 'Caviar.', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0.00, 1.88, 2.44, 0.00, 0.00, 0, 30, 0.56, 0.00, 0.00, 1, NULL, 0, 1673086778, 1673086778, 0);
INSERT INTO `erp_order_product` VALUES (89, 39, 'AMK10000011', 10058, 13, 3, 5, '斑马', 1, 10007, 'Caviar.', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 0.00, 9999.99, 10999.99, 0.00, 0.00, 0, 10, 1000.00, 0.00, 0.00, 1, NULL, 0, 1673087487, 1673087487, 0);
INSERT INTO `erp_order_product` VALUES (90, 39, 'AMK10000011', 10058, 1, 5, 7, '胸坠', 0, 10007, 'Caviar.', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 88.00, 138.00, 267.40, 0.00, 30.00, 1, 30, 41.40, 0.00, 0.00, 1, NULL, 1673087903, 1673087561, 1673087561, 1);
INSERT INTO `erp_order_product` VALUES (91, 39, 'AMK10000011', 10058, 8, 4, 6, '火龙果', 0, 10007, 'Caviar.', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0.00, 1.88, 2.44, 0.00, 0.00, 0, 30, 0.56, 0.00, 0.00, 1, NULL, 0, 1673087903, 1673087903, 0);
INSERT INTO `erp_order_product` VALUES (92, 36, 'AMK10000008', 10053, 1, 5, 7, '胸坠', 0, 10007, 'Caviar.', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 1, 88.00, 138.00, 267.40, 0.00, 30.00, 1, 30, 41.40, 0.00, 0.00, 0, NULL, 0, 1673088203, 1673088203, 0);
INSERT INTO `erp_order_product` VALUES (93, 35, 'AMK10000007', 10053, 3, 2, 7, '小番茄', 0, 10007, 'Caviar.', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0.00, 15.00, 19.50, 0.00, 0.00, 0, 30, 4.50, 0.00, 0.00, 1, NULL, 0, 1673088280, 1673088280, 0);
INSERT INTO `erp_order_product` VALUES (94, 41, 'AMK10000013', 10058, 1, 5, 7, '胸坠', 0, 10007, 'Caviar.', NULL, NULL, 10007, 'Caviar.', NULL, NULL, 1, 0, NULL, 1, 88.00, 138.00, 267.40, 0.00, 30.00, 1, 30, 41.40, 0.00, 0.00, 1, NULL, 0, 1673088892, 1673088892, 0);
INSERT INTO `erp_order_product` VALUES (95, 41, 'AMK10000013', 10058, 8, 4, 6, '火龙果', 0, 10007, 'Caviar.', NULL, NULL, 10007, 'Caviar.', NULL, NULL, 0, 0, NULL, 0, 0.00, 1.88, 2.44, 0.00, 0.00, 0, 30, 0.56, 0.00, 0.00, 1, NULL, 0, 1673088892, 1673088892, 0);
INSERT INTO `erp_order_product` VALUES (96, 41, 'AMK10000013', 10058, 13, 3, 5, '斑马', 1, 10007, 'Caviar.', NULL, NULL, 10007, 'Caviar.', NULL, NULL, 1, 0, NULL, 1, 0.00, 9999.99, 10999.99, 0.00, 0.00, 0, 10, 1000.00, 0.00, 0.00, 1, NULL, 0, 1673088892, 1673088892, 0);
INSERT INTO `erp_order_product` VALUES (97, 41, 'AMK10000013', 10058, 3, 2, 7, '小番茄', 0, 10007, 'Caviar.', NULL, NULL, 10007, 'Caviar.', NULL, NULL, 0, 0, NULL, 0, 0.00, 15.00, 19.50, 0.00, 0.00, 0, 30, 4.50, 0.00, 0.00, 1, NULL, 1673088956, 1673088892, 1673088892, 1);
INSERT INTO `erp_order_product` VALUES (98, 41, 'AMK10000013', 10058, 8, 4, 6, '火龙果', 0, 10007, 'Caviar.', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, 0.00, 1.88, 2.44, 0.00, 0.00, 0, 30, 0.56, 0.00, 0.00, 1, NULL, 0, 1673088956, 1673088956, 0);

-- ----------------------------
-- Table structure for erp_order_product_exchangd
-- ----------------------------
DROP TABLE IF EXISTS `erp_order_product_exchangd`;
CREATE TABLE `erp_order_product_exchangd`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `store_id` int(11) NOT NULL COMMENT '门店Id',
  `order_id` int(11) NOT NULL COMMENT '订单ID',
  `origin_order_product_ids` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '原来的订单商品ID',
  `after_order_product_ids` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '后来的订单商品ID',
  `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '类型 1=退货;2=换货',
  `diff_price` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '差价',
  `admin_id` int(10) NOT NULL COMMENT '操作者ID',
  `create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '商品退换货记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_order_product_exchangd
-- ----------------------------

-- ----------------------------
-- Table structure for erp_payment_channel
-- ----------------------------
DROP TABLE IF EXISTS `erp_payment_channel`;
CREATE TABLE `erp_payment_channel`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
  `index` int(10) NOT NULL DEFAULT 0,
  `icon` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'icon',
  `type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '1=无任何设置；2=御龙币设置；3=信用卡设置',
  `is_upload_code` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否需要上传记录付款编号',
  `zue_coin_exchange_rate` float(5, 2) NULL DEFAULT NULL COMMENT '兑换比例 不如 1Zue Coin = 2人民币',
  `zue_coin_consume_rate` float(5, 2) NULL DEFAULT NULL COMMENT '御龙币单笔订单消费比例 单笔订单消费 1000元 御龙币可抵消 30%',
  `create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '收款渠道' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_payment_channel
-- ----------------------------
INSERT INTO `erp_payment_channel` VALUES (1, 'Cash', 0, '/storage/icon/1.png', 1, 0, NULL, NULL, 1670572647, 1671783101, 0);
INSERT INTO `erp_payment_channel` VALUES (2, 'NETS', 1, '/storage/icon/2.png', 1, 1, NULL, NULL, 1670572647, 1670572647, 0);
INSERT INTO `erp_payment_channel` VALUES (3, 'Cheque', 2, '/storage/icon/3.png', 1, 1, NULL, NULL, 1670572647, 1670572647, 0);
INSERT INTO `erp_payment_channel` VALUES (4, 'Visa / Master', 3, '/storage/icon/4.png', 3, 1, NULL, NULL, 1670572647, 1671782982, 0);
INSERT INTO `erp_payment_channel` VALUES (5, 'Voucher', 4, '/storage/icon/5.png', 1, 0, NULL, NULL, 1670572647, 1671783165, 0);
INSERT INTO `erp_payment_channel` VALUES (6, 'AMEX', 5, '/storage/icon/6.png', 1, 1, NULL, NULL, 1670572647, 1670572647, 0);
INSERT INTO `erp_payment_channel` VALUES (7, 'DINERS', 6, '/storage/icon/7.png', 3, 1, NULL, NULL, 1670572647, 1672911475, 0);
INSERT INTO `erp_payment_channel` VALUES (8, 'FAVE', 7, '/storage/icon/8.png', 1, 0, NULL, NULL, 1670572647, 1671783188, 0);
INSERT INTO `erp_payment_channel` VALUES (9, 'Paynow', 8, '/storage/icon/9.png', 1, 0, NULL, NULL, 1670572647, 1671783203, 0);
INSERT INTO `erp_payment_channel` VALUES (10, 'Stripe', 9, '/storage/icon/10.png', 1, 0, NULL, NULL, 1670572647, 1671783224, 0);
INSERT INTO `erp_payment_channel` VALUES (11, 'Zue Coin', 10, '/storage/icon/11.png', 2, 1, 2.00, 10.00, 1670572647, 1671783149, 0);
INSERT INTO `erp_payment_channel` VALUES (12, 'WeChat', 11, '/storage/icon/12.png', 1, 0, NULL, NULL, 1670572647, 1671783245, 1);
INSERT INTO `erp_payment_channel` VALUES (13, 'Alipay', 12, '/storage/icon/13.png', 1, 0, NULL, NULL, 1670572647, 1671783236, 1);

-- ----------------------------
-- Table structure for erp_product
-- ----------------------------
DROP TABLE IF EXISTS `erp_product`;
CREATE TABLE `erp_product`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bar_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品条码',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品名称',
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图片',
  `category_id` int(11) NOT NULL COMMENT '商品类别ID',
  `company_id` int(11) NULL DEFAULT NULL COMMENT '公司ID',
  `is_serve` tinyint(1) NOT NULL DEFAULT 0 COMMENT '商品/服务',
  `purchase_price` float(10, 2) NULL DEFAULT 0.00 COMMENT '进价',
  `real_price` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '真实卖价',
  `lineate_price` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '划线价',
  `is_upload_numerology` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否上传命理报告',
  `is_gather_annuity` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否收取年费',
  `annuity` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '年费价格',
  `sales_tax_rate` float(5, 2) NOT NULL DEFAULT 0.00 COMMENT '消费税',
  `supplier_id` int(11) NULL DEFAULT NULL COMMENT '供应商ID',
  `create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '商品表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_product
-- ----------------------------
INSERT INTO `erp_product` VALUES (1, '10010', '胸坠', '/storage/product/20221212/99e753ccc50771a0b6214ff9bb1f7f4c.jpg', 7, 3, 0, 68.00, 168.00, 1680.00, 1, 1, 88.00, 0.00, NULL, 1670572647, 1672046070, 0);
INSERT INTO `erp_product` VALUES (2, 'BanMaYouZai', '斑马幼崽001', '/storage/product/20221212/59303b361cf7c3e9b8b9fc2feddc5da5.jpg', 4, 1, 0, 10.00, 100.00, 1000.00, 0, 0, 0.00, 0.00, NULL, 1670817701, 1670817701, 0);
INSERT INTO `erp_product` VALUES (3, 'XFQ', '小番茄', '/storage/product/20221212/1433bf125d23a87fef582876243650d2.jpg', 7, 3, 0, 10.00, 15.00, 150.00, 0, 0, 0.00, 0.00, NULL, 1670824713, 1670824713, 0);
INSERT INTO `erp_product` VALUES (4, 'XFQ_01', '小番茄', '/storage/product/20221212/1433bf125d23a87fef582876243650d2.jpg', 7, 1, 0, 10.00, 15.00, 150.00, 0, 0, 0.00, 0.00, NULL, 1670824752, 1670824752, 1);
INSERT INTO `erp_product` VALUES (5, 'FZ_001', '红枣', '/storage/product/20221212/91d84a02ebed9fd7a9812f117645ece3.jpg', 5, 1, 0, 0.80, 15.00, 150.00, 0, 0, 0.00, 0.00, NULL, 1670824844, 1670824844, 0);
INSERT INTO `erp_product` VALUES (8, 'HLG_01', '火龙果', '/storage/product/20221212/bc29bd00a0c3fa7c7fdb23008be9087d.jpg', 6, 1, 0, 1.80, 1.88, 18.80, 0, 0, 0.00, 0.00, NULL, 1670825260, 1670825260, 0);
INSERT INTO `erp_product` VALUES (9, 'CZ_001', '橙子', '/storage/product/20221212/479261101c03b33f53c15c48f0bee5d2.jpg', 8, 1, 0, 0.50, 0.88, 8.80, 0, 0, 0.00, 0.00, NULL, 1670825321, 1670825321, 0);
INSERT INTO `erp_product` VALUES (10, 'DLJ_001', '剁辣椒', '/storage/product/20221212/efa70d9df3e76ca6d51ceb49a163dc72.jpg', 2, 1, 0, 0.55, 88.00, 880.00, 0, 1, 688.00, 0.00, NULL, 1670825361, 1670825361, 0);
INSERT INTO `erp_product` VALUES (11, 'BM001', '斑马', '/storage/product/20221212/59303b361cf7c3e9b8b9fc2feddc5da5.jpg', 6, 1, 0, 18888.00, 68888.00, 688880.00, 1, 0, 0.00, 0.00, NULL, 1670825411, 1670825411, 0);
INSERT INTO `erp_product` VALUES (12, 'JL001', '鸡柳', '/storage/product/20221212/4659ba3b989a96413ae083d2c89260d1.jpg', 8, 1, 0, 5.88, 6.68, 66.80, 0, 0, 0.00, 0.00, NULL, 1670825467, 1670825467, 0);
INSERT INTO `erp_product` VALUES (13, 'banma001', '斑马', '/storage/product/20221212/59303b361cf7c3e9b8b9fc2feddc5da5.jpg', 5, 3, 1, 8888.00, 9999.99, 99990.00, 1, 1, 0.00, 10.00, NULL, 1670825538, 1672123755, 0);
INSERT INTO `erp_product` VALUES (14, 'HongZhao001', '小红枣_', '/storage/product/20221212/e216cdff1173320f982eaf5aca33969a.jpg', 3, 1, 0, 1.00, 1.00, 10.00, 0, 0, 0.00, 0.00, NULL, 1670825755, 1670825755, 1);
INSERT INTO `erp_product` VALUES (15, 'Test001', 'Caviar', '/storage/product/20221212/eb068fd6f446c5a2b2c8a6c584b266cc.jpg', 2, 3, 0, 1.00, 2.00, 20.00, 1, 1, 0.00, 0.00, NULL, 1670828169, 1672019917, 0);
INSERT INTO `erp_product` VALUES (16, 'BG001', 'Bg', '/storage/product/20221216/0466840eebd4a6d9b581f359960ff721.jpg', 3, 4, 0, 0.99, 1.99, 2.99, 1, 1, 1999.00, 1.00, NULL, 1671171837, 1671973545, 0);

-- ----------------------------
-- Table structure for erp_product_category
-- ----------------------------
DROP TABLE IF EXISTS `erp_product_category`;
CREATE TABLE `erp_product_category`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(10) NOT NULL DEFAULT 0,
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '类别昵称',
  `create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '商品分类表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_product_category
-- ----------------------------
INSERT INTO `erp_product_category` VALUES (2, 0, '佛基', 1670394265, 1670394265, 0);
INSERT INTO `erp_product_category` VALUES (3, 0, '生基', 1670394265, 1670394265, 0);
INSERT INTO `erp_product_category` VALUES (4, 0, '斗', 1670394265, 1670394265, 0);
INSERT INTO `erp_product_category` VALUES (5, 0, '建庙', 1670394265, 1670394265, 0);
INSERT INTO `erp_product_category` VALUES (6, 0, '阵法', 1670394265, 1670394265, 0);
INSERT INTO `erp_product_category` VALUES (7, 0, '胸坠', 1670394265, 1670394265, 0);
INSERT INTO `erp_product_category` VALUES (8, 0, '紫薇斗数', 1670394265, 1670394265, 0);
INSERT INTO `erp_product_category` VALUES (9, 0, '风水服务', 1672229549, 1672229549, 0);

-- ----------------------------
-- Table structure for erp_store
-- ----------------------------
DROP TABLE IF EXISTS `erp_store`;
CREATE TABLE `erp_store`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '店名',
  `abbr` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '简称',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '位置',
  `create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10006 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门店表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_store
-- ----------------------------
INSERT INTO `erp_store` VALUES (10003, 'AMK Hub Branch', 'AMK', '湖南省长沙市岳麓区西湖公园', 1670899223, 1671637024, 0);
INSERT INTO `erp_store` VALUES (10004, 'JEM Hub Branch', 'JEM', '印度尼西亚', NULL, NULL, 0);
INSERT INTO `erp_store` VALUES (10005, 'test', 'test', 'wewewe', 1672021600, 1672021600, 0);

-- ----------------------------
-- Table structure for erp_store_product
-- ----------------------------
DROP TABLE IF EXISTS `erp_store_product`;
CREATE TABLE `erp_store_product`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `store_id` int(10) NOT NULL COMMENT '门店ID',
  `product_id` int(10) NOT NULL COMMENT '商品ID',
  `product_bar_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品bar_code',
  `product_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品名称',
  `now_stock` int(10) NOT NULL DEFAULT 0 COMMENT '门店当前库存',
  `sale_stock` int(10) NOT NULL DEFAULT 0 COMMENT '当前卖出多少',
  `create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '商店商品库存表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_store_product
-- ----------------------------
INSERT INTO `erp_store_product` VALUES (2, 10003, 3, 'XFQ', '小番茄', 6, 4, 1670844652, 1670844652, 0);
INSERT INTO `erp_store_product` VALUES (3, 10003, 13, 'banma001', '斑马', 91, 9, 1671154866, 1671154866, 0);
INSERT INTO `erp_store_product` VALUES (4, 10003, 8, 'HLG_01', '火龙果', 1991, 8, 1671262870, 1671262870, 0);
INSERT INTO `erp_store_product` VALUES (5, 10003, 1, '10010', '胸坠', 989, 11, 1672046107, 1672046107, 0);
INSERT INTO `erp_store_product` VALUES (6, 10004, 2, 'BanMaYouZai', '斑马幼崽001', 21, -1, 1672713467, 1672713476, 0);

-- ----------------------------
-- Table structure for erp_store_user_relation
-- ----------------------------
DROP TABLE IF EXISTS `erp_store_user_relation`;
CREATE TABLE `erp_store_user_relation`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `store_id` int(10) NOT NULL COMMENT '门店ID',
  `user_id` int(10) NOT NULL COMMENT '员工ID',
  `store_role` tinyint(4) NOT NULL DEFAULT 1 COMMENT '门店角色:促销员=1,顾问=2,主管=3,店长=4',
  `create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门店与店员的关系表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_store_user_relation
-- ----------------------------

-- ----------------------------
-- Table structure for erp_user
-- ----------------------------
DROP TABLE IF EXISTS `erp_user`;
CREATE TABLE `erp_user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号码',
  `password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码',
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'token',
  `store_id` int(10) NOT NULL COMMENT '门店ID',
  `store_abbr` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '门店简称',
  `rule` tinyint(2) NOT NULL DEFAULT 1 COMMENT '1=促销员,2=顾问,3=顾问主管,4=店长',
  `create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 100003 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_user
-- ----------------------------
INSERT INTO `erp_user` VALUES (100000, 'Caviar.', '15574920253', '', '', 10000, 'FSC', 1, 1670394265, 1670394265, 0);
INSERT INTO `erp_user` VALUES (100001, 'Json.', '15574992125', '', '', 10001, 'FJHS', 1, 1670394265, 1670394265, 0);
INSERT INTO `erp_user` VALUES (100002, 'AoLiAo.', '15574920251', '14e1b600b1fd579f47433b88e8d85291', NULL, 10001, 'QZFD', 4, 1670915647, 1670916495, 0);

-- ----------------------------
-- Table structure for erp_zue_coin_record
-- ----------------------------
DROP TABLE IF EXISTS `erp_zue_coin_record`;
CREATE TABLE `erp_zue_coin_record`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `zue_coin_id` int(10) NOT NULL COMMENT '御龙币劵ID',
  `order_id` int(11) NOT NULL DEFAULT -1 COMMENT 'order_id',
  `origin` int(11) NOT NULL DEFAULT 0 COMMENT '原来的',
  `change` int(11) NOT NULL DEFAULT 0 COMMENT '更改的',
  `after` int(10) NOT NULL DEFAULT 0 COMMENT '改变后的',
  `reason` tinyint(4) NOT NULL DEFAULT 1 COMMENT '更改的原因 1=购买商品 2=前台添加,3=商品退换',
  `delete_time` int(10) NULL DEFAULT NULL COMMENT '逻辑删除字段',
  `create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 51 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统设置表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of erp_zue_coin_record
-- ----------------------------
INSERT INTO `erp_zue_coin_record` VALUES (1, 1, 29, 10000, 100, 9900, 1, NULL, 1671785146, 1671785146, 0);
INSERT INTO `erp_zue_coin_record` VALUES (2, 1, 29, 9900, 12, 9888, 1, NULL, 1671785146, 1671785146, 0);
INSERT INTO `erp_zue_coin_record` VALUES (3, 1, 29, 9888, 800, 9088, 1, NULL, 1671785146, 1671785146, 0);
INSERT INTO `erp_zue_coin_record` VALUES (4, 1, 29, 9088, 150, 8938, 1, NULL, 1671785146, 1671785146, 0);
INSERT INTO `erp_zue_coin_record` VALUES (5, 1, 29, 8938, 50, 8888, 1, NULL, 1671785146, 1671785146, 0);
INSERT INTO `erp_zue_coin_record` VALUES (6, 3, 29, 0, 1, 1, 2, NULL, 1672056110, 1672056110, 0);
INSERT INTO `erp_zue_coin_record` VALUES (10, 1, 29, 8888, 1, 8887, 1, NULL, 1672310825, 1672310825, 0);
INSERT INTO `erp_zue_coin_record` VALUES (11, 1, 29, 8887, 562, 8325, 1, NULL, 1672310878, 1672310878, 0);
INSERT INTO `erp_zue_coin_record` VALUES (12, 1, 29, 8325, 563, 7761, 1, NULL, 1672381197, 1672381197, 0);
INSERT INTO `erp_zue_coin_record` VALUES (13, 1, 29, 7761, 578, 7183, 1, NULL, 1672383188, 1672383188, 0);
INSERT INTO `erp_zue_coin_record` VALUES (14, 1, 29, 7183, 1, 7182, 1, NULL, 1672384890, 1672384890, 0);
INSERT INTO `erp_zue_coin_record` VALUES (15, 1, 29, 7182, 1, 7181, 1, NULL, 1672384914, 1672384914, 0);
INSERT INTO `erp_zue_coin_record` VALUES (16, 1, 29, 7181, 1, 7180, 1, NULL, 1672384941, 1672384941, 0);
INSERT INTO `erp_zue_coin_record` VALUES (17, 1, 29, 7180, 276, 6904, 1, NULL, 1672385132, 1672385132, 0);
INSERT INTO `erp_zue_coin_record` VALUES (18, 1, 29, 6904, 3, 6901, 1, NULL, 1672389780, 1672389780, 0);
INSERT INTO `erp_zue_coin_record` VALUES (21, 1, 29, 6901, 275, 7176, 3, NULL, 1672734839, 1672734839, 0);
INSERT INTO `erp_zue_coin_record` VALUES (22, 1, 29, 7176, 275, 7451, 3, NULL, 1672735097, 1672735097, 0);
INSERT INTO `erp_zue_coin_record` VALUES (40, 1, 29, 7451, 7, 7458, 3, NULL, 1672740615, 1672740615, 0);
INSERT INTO `erp_zue_coin_record` VALUES (41, 4, 34, 10000, -1, 9999, 1, NULL, 1672985692, 1672985692, 0);
INSERT INTO `erp_zue_coin_record` VALUES (42, 4, 34, 9999, -1, 9998, 1, NULL, 1672985705, 1672985705, 0);
INSERT INTO `erp_zue_coin_record` VALUES (43, 4, 34, 9998, -10, 9988, 1, NULL, 1672985738, 1672985738, 0);
INSERT INTO `erp_zue_coin_record` VALUES (44, 4, 34, 9988, -1, 9988, 1, NULL, 1672985818, 1672985818, 0);
INSERT INTO `erp_zue_coin_record` VALUES (45, 4, 34, 9988, -1, 9987, 1, NULL, 1672985827, 1672985827, 0);
INSERT INTO `erp_zue_coin_record` VALUES (46, 4, 34, 9987, 0, 9986, 1, NULL, 1672986045, 1672986045, 0);
INSERT INTO `erp_zue_coin_record` VALUES (47, 4, 35, 9986, -550, 9436, 1, NULL, 1672986194, 1672986194, 0);
INSERT INTO `erp_zue_coin_record` VALUES (48, 4, 36, 9436, -1, 9435, 1, NULL, 1672987404, 1672987404, 0);
INSERT INTO `erp_zue_coin_record` VALUES (49, 4, 36, 9435, 1, 9436, 3, NULL, 1673088203, 1673088203, 0);
INSERT INTO `erp_zue_coin_record` VALUES (50, 4, 35, 9436, 550, 9986, 3, NULL, 1673088280, 1673088280, 0);

SET FOREIGN_KEY_CHECKS = 1;