/*
 Navicat Premium Data Transfer

 Source Server         : mysql8
 Source Server Type    : MySQL
 Source Server Version : 80020
 Source Host           : localhost:3307
 Source Schema         : zzh_stock_admin

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

 Date: 25/04/2024 15:55:01
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for zzh_depot
-- ----------------------------
DROP TABLE IF EXISTS `zzh_depot`;
CREATE TABLE `zzh_depot`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '仓库名称',
  `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '仓库地址',
  `type` int NULL DEFAULT NULL COMMENT '类型',
  `sort` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '排序',
  `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `principal` bigint NULL DEFAULT NULL COMMENT '负责人',
  `status` tinyint(1) NULL DEFAULT 1 COMMENT '状态，0：删除，1：正常，2封禁',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '仓库表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of zzh_depot
-- ----------------------------
INSERT INTO `zzh_depot` VALUES (1, '仓库一号', '四川省南充市嘉陵区耀目路39号', NULL, '1', '无', 1, 1);
INSERT INTO `zzh_depot` VALUES (2, '仓库二号', '四川省南充市顺庆区39号', NULL, '1', '无', 1, 1);

-- ----------------------------
-- Table structure for zzh_depot_head
-- ----------------------------
DROP TABLE IF EXISTS `zzh_depot_head`;
CREATE TABLE `zzh_depot_head`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型(出库/入库)',
  `sub_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出入库分类',
  `number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '票据号',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `oper_time` datetime NULL DEFAULT NULL COMMENT '出入库时间',
  `organ_id` bigint NULL DEFAULT NULL COMMENT '供应商id',
  `creator` bigint NULL DEFAULT NULL COMMENT '操作员',
  `oper_number` decimal(24, 6) NULL DEFAULT NULL COMMENT '商品数量',
  `change_amount` decimal(24, 6) NULL DEFAULT NULL COMMENT '变动金额(收款/付款)',
  `back_amount` decimal(24, 6) NULL DEFAULT NULL COMMENT '找零金额',
  `pay_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '付款类型(现金、记账等)',
  `discount` decimal(24, 6) NULL DEFAULT NULL COMMENT '优惠率',
  `discount_money` decimal(24, 6) NULL DEFAULT NULL COMMENT '优惠金额',
  `discount_last_money` decimal(24, 6) NULL DEFAULT NULL COMMENT '优惠后金额',
  `link_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联订单号',
  `file_name` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '附件名称',
  `remark` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `source` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '单据来源，0-pc，1-手机',
  `status` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '状态，0未审核、1已审核、2完成采购|销售、3部分采购|销售、9审核中',
  `delete_flag` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FK2A80F214B610FC06`(`organ_id`) USING BTREE,
  INDEX `FK2A80F214AAE50527`(`oper_number`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '单据主表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of zzh_depot_head
-- ----------------------------
INSERT INTO `zzh_depot_head` VALUES (1, '其它', '采购订单', 'CG1001', '2024-04-21 02:39:23', NULL, 1, NULL, 10.000000, NULL, NULL, '', 10.000000, 5050.000000, 45450.000000, '', '', '无', '0', '0', '0');
INSERT INTO `zzh_depot_head` VALUES (2, '入库', '采购', 'RK1001', '2024-04-21 03:16:47', NULL, 1, NULL, 1000.000000, NULL, NULL, NULL, NULL, NULL, 5000000.000000, '', NULL, '无', '0', '1', '0');
INSERT INTO `zzh_depot_head` VALUES (3, '出库', '采购退货', 'CGTK1001', '2024-04-21 03:17:53', NULL, 1, NULL, 500.000000, NULL, NULL, '', NULL, 0.000000, 2500000.000000, '', '', '', '0', '1', '0');
INSERT INTO `zzh_depot_head` VALUES (4, '其它', '采购订单', 'CG1003', '2024-04-21 04:33:33', NULL, 1, 2, 500.000000, NULL, NULL, NULL, 10.000000, 330000.000000, 2970000.000000, '', NULL, '无', '0', '1', '1');
INSERT INTO `zzh_depot_head` VALUES (5, '其它', '采购订单', 'CG1004', '2024-04-21 04:45:27', NULL, 3, 2, 500.000000, NULL, NULL, NULL, 10.000000, 330000.000000, 2970000.000000, '', NULL, '无', '0', '0', '0');
INSERT INTO `zzh_depot_head` VALUES (6, '出库', '采购退货', 'CGTH1002', '2024-04-21 04:46:08', NULL, 3, 2, 200.000000, NULL, NULL, NULL, NULL, NULL, 1200000.000000, '', NULL, '', '0', '0', '0');
INSERT INTO `zzh_depot_head` VALUES (7, '其它', '采购订单', 'CG1006', '2024-04-21 05:32:56', NULL, 3, 2, 500.000000, NULL, NULL, NULL, 10.000000, 330000.000000, 2970000.000000, '', NULL, '无', '0', '2', '0');
INSERT INTO `zzh_depot_head` VALUES (8, '其它', '销售订单', 'XS1001', '2024-04-21 05:37:17', NULL, 2, 3, 500.000000, NULL, NULL, NULL, 10.000000, 275000.000000, 2475000.000000, '', NULL, '无', '0', '0', '0');
INSERT INTO `zzh_depot_head` VALUES (9, '其它', '销售订单', 'XS1003', '2024-04-21 05:40:48', NULL, 5, 3, 500.000000, NULL, NULL, NULL, 10.000000, 275000.000000, 2475000.000000, '', NULL, '无', '0', '2', '0');
INSERT INTO `zzh_depot_head` VALUES (10, '出库', '销售', 'CK1001', '2024-04-21 05:42:16', NULL, 5, 1, 500.000000, NULL, NULL, NULL, 10.000000, 275000.000000, 2475000.000000, 'XS1003', NULL, '无', '0', '1', '0');
INSERT INTO `zzh_depot_head` VALUES (11, '入库', '采购', 'RK1002', '2024-04-21 05:48:01', NULL, 3, 1, 500.000000, NULL, NULL, NULL, 10.000000, 330000.000000, 2970000.000000, 'CG1006', NULL, '无', '0', '1', '0');
INSERT INTO `zzh_depot_head` VALUES (12, '出库', '销售', 'CK1002', '2024-04-21 05:48:32', NULL, 2, 1, 1000.000000, NULL, NULL, NULL, NULL, NULL, 6000000.000000, '', NULL, '', '0', '1', '0');
INSERT INTO `zzh_depot_head` VALUES (13, '其它', '销售订单', 'XS1004', '2024-04-21 05:53:47', NULL, 2, 3, 1000.000000, NULL, NULL, NULL, NULL, NULL, 6000000.000000, '', NULL, '无', '0', '2', '0');
INSERT INTO `zzh_depot_head` VALUES (14, '出库', '销售', 'CK1003', '2024-04-21 05:54:52', NULL, 2, 1, 1000.000000, NULL, NULL, NULL, NULL, 0.000000, 6000000.000000, 'XS1004', NULL, '无', '0', '1', '0');
INSERT INTO `zzh_depot_head` VALUES (15, '入库', '其它', 'QTRK1001', '2024-04-21 05:58:45', NULL, 3, 4, 500.000000, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', '0', '1', '0');
INSERT INTO `zzh_depot_head` VALUES (16, '出库', '其它', 'QTCK1001', '2024-04-21 05:59:12', NULL, 2, 4, 500.000000, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', '0', '1', '0');
INSERT INTO `zzh_depot_head` VALUES (17, '其它', '采购订单', 'CG1009', '2024-04-23 02:12:08', NULL, 1, 2, 500.000000, NULL, NULL, NULL, 10.000000, 275000.000000, 2475000.000000, '', NULL, '无', '0', '1', '0');
INSERT INTO `zzh_depot_head` VALUES (18, '入库', '采购', 'RK1009', '2024-04-23 02:14:11', NULL, 1, 4, 500.000000, NULL, NULL, NULL, 10.000000, 275000.000000, 2475000.000000, 'CG1009', NULL, '无', '0', '0', '0');

-- ----------------------------
-- Table structure for zzh_depot_item
-- ----------------------------
DROP TABLE IF EXISTS `zzh_depot_item`;
CREATE TABLE `zzh_depot_item`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `header_id` bigint NOT NULL COMMENT '表头Id',
  `material_id` bigint NOT NULL COMMENT '商品Id',
  `material_unit` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '计量单位',
  `sku` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '多属性',
  `basic_number` decimal(24, 6) NULL DEFAULT NULL COMMENT '基础数量，如kg、瓶',
  `oper_number` decimal(24, 6) NULL DEFAULT NULL COMMENT '商品数量',
  `unit_price` decimal(24, 6) NULL DEFAULT NULL COMMENT '单价',
  `all_price` decimal(24, 6) NULL DEFAULT NULL COMMENT '金额',
  `tax_rate` decimal(24, 6) NULL DEFAULT NULL COMMENT '税率',
  `tax_money` decimal(24, 6) NULL DEFAULT NULL COMMENT '税额',
  `tax_last_money` decimal(24, 6) NULL DEFAULT NULL COMMENT '价税合计',
  `remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `depot_id` bigint NULL DEFAULT NULL COMMENT '仓库ID',
  `another_depot_id` bigint NULL DEFAULT NULL COMMENT '调拨时，对方仓库Id',
  `delete_flag` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FK2A819F475D61CCF7`(`material_id`) USING BTREE,
  INDEX `FK2A819F474BB6190E`(`header_id`) USING BTREE,
  INDEX `FK2A819F479485B3F5`(`depot_id`) USING BTREE,
  INDEX `FK2A819F47729F5392`(`another_depot_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '单据子表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of zzh_depot_item
-- ----------------------------
INSERT INTO `zzh_depot_item` VALUES (1, 1, 1, NULL, NULL, 10.000000, 10.000000, 5000.000000, 50000.000000, 1.000000, 500.000000, 50500.000000, '无', NULL, NULL, '0');
INSERT INTO `zzh_depot_item` VALUES (2, 2, 1, NULL, NULL, 1000.000000, 1000.000000, 5000.000000, 5000000.000000, NULL, NULL, 5000000.000000, '无', 1, NULL, '0');
INSERT INTO `zzh_depot_item` VALUES (3, 3, 1, NULL, NULL, 500.000000, 500.000000, 5000.000000, 2500000.000000, NULL, 0.000000, 2500000.000000, '', 1, NULL, '0');
INSERT INTO `zzh_depot_item` VALUES (4, 4, 3, NULL, NULL, 500.000000, 500.000000, 6000.000000, 3000000.000000, 10.000000, 300000.000000, 3300000.000000, '无', NULL, NULL, '0');
INSERT INTO `zzh_depot_item` VALUES (5, 5, 3, NULL, NULL, 500.000000, 500.000000, 6000.000000, 3000000.000000, 10.000000, 300000.000000, 3300000.000000, '无', NULL, NULL, '0');
INSERT INTO `zzh_depot_item` VALUES (6, 6, 3, NULL, NULL, 200.000000, 200.000000, 6000.000000, 1200000.000000, NULL, NULL, 1200000.000000, '', 1, NULL, '0');
INSERT INTO `zzh_depot_item` VALUES (7, 7, 3, NULL, NULL, 500.000000, 500.000000, 6000.000000, 3000000.000000, 10.000000, 300000.000000, 3300000.000000, '无', NULL, NULL, '0');
INSERT INTO `zzh_depot_item` VALUES (8, 8, 1, NULL, NULL, 500.000000, 500.000000, 5000.000000, 2500000.000000, 10.000000, 250000.000000, 2750000.000000, '无', NULL, NULL, '0');
INSERT INTO `zzh_depot_item` VALUES (9, 9, 1, NULL, NULL, 500.000000, 500.000000, 5000.000000, 2500000.000000, 10.000000, 250000.000000, 2750000.000000, '无', NULL, NULL, '0');
INSERT INTO `zzh_depot_item` VALUES (10, 10, 1, NULL, NULL, 500.000000, 500.000000, 5000.000000, 2500000.000000, 10.000000, 250000.000000, 2750000.000000, '无', 1, NULL, '0');
INSERT INTO `zzh_depot_item` VALUES (11, 11, 3, NULL, NULL, 500.000000, 500.000000, 6000.000000, 3000000.000000, 10.000000, 300000.000000, 3300000.000000, '无', 1, NULL, '0');
INSERT INTO `zzh_depot_item` VALUES (12, 12, 3, NULL, NULL, 1000.000000, 1000.000000, 6000.000000, 6000000.000000, NULL, NULL, 6000000.000000, '', 1, NULL, '0');
INSERT INTO `zzh_depot_item` VALUES (13, 13, 3, NULL, NULL, 1000.000000, 1000.000000, 6000.000000, 6000000.000000, NULL, NULL, 6000000.000000, '无', NULL, NULL, '0');
INSERT INTO `zzh_depot_item` VALUES (14, 14, 3, NULL, NULL, 1000.000000, 1000.000000, 6000.000000, 6000000.000000, NULL, 0.000000, 6000000.000000, '无', 1, NULL, '0');
INSERT INTO `zzh_depot_item` VALUES (15, 15, 1, NULL, NULL, 500.000000, 500.000000, 5000.000000, 2500000.000000, NULL, NULL, NULL, '', 1, NULL, '0');
INSERT INTO `zzh_depot_item` VALUES (16, 16, 3, NULL, NULL, 500.000000, 500.000000, 6000.000000, 3000000.000000, NULL, NULL, NULL, '', 2, NULL, '0');
INSERT INTO `zzh_depot_item` VALUES (17, 17, 1, NULL, NULL, 500.000000, 500.000000, 5000.000000, 2500000.000000, 10.000000, 250000.000000, 2750000.000000, '无', NULL, NULL, '0');
INSERT INTO `zzh_depot_item` VALUES (18, 18, 1, NULL, NULL, 500.000000, 500.000000, 5000.000000, 2500000.000000, 10.000000, 250000.000000, 2750000.000000, '无', 1, NULL, '0');

-- ----------------------------
-- Table structure for zzh_function
-- ----------------------------
DROP TABLE IF EXISTS `zzh_function`;
CREATE TABLE `zzh_function`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编号',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `parent_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上级编号',
  `url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '触发函数',
  `component` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '跳转页面',
  `state` bit(1) NULL DEFAULT NULL COMMENT '收缩',
  `sort` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '排序',
  `enabled` bit(1) NULL DEFAULT NULL COMMENT '启用',
  `type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型',
  `push_btn` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限',
  `icon` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标',
  `delete_flag` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '功能模块表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of zzh_function
-- ----------------------------
INSERT INTO `zzh_function` VALUES (1, '0001', '员工管理', '0', '/SystemManage', '/system', b'1', '0', b'1', 'index', '1,5', 'el-icon-setting', '0');
INSERT INTO `zzh_function` VALUES (2, '000102', '角色管理', '0001', '/RoleManage', '/system/RoleManage.vue', b'0', '0', b'1', 'roleManage', '1,5', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (3, '000103', '用户管理', '0001', '/StaffManage', '/system/StaffManage.vue', b'0', '0', b'1', 'staffManage', '1,5', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (4, '000104', '部门管理', '0001', '/Organization', '/system/OrganizationManage.vue', b'0', '0', b'1', 'organization', '1,5', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (5, '0002', '商品管理', '0', '/ProductManage', '/Index.vue', b'0', '0', b'1', 'index', '2,4,3', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (6, '000101', '商品类别', '0002', '/productCategory', '/product/ProductCategory.vue', b'0', '0', b'1', 'productCategory', ',4,2', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (7, '000102', '商品信息', '0002', '/Product', '/product/Product.vue', b'0', '0', b'1', 'product', '2,4,3', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (8, '000103', '计量单位', '0002', '/ProductUnit', '/product/ProductUnit.vue', b'0', '0', b'1', 'productUnit', ',4,2', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (9, '000104', '多属性', '0002', '/ProductAttribute', '/product/ProductAttribute.vue', b'0', '0', b'1', 'productAttribute', ',4,2', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (10, '0003', '资料管理', '0', '/Basedata', '/Index.vue', b'0', '0', b'1', 'index', '2,4,3', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (11, '000301', '供应商信息', '0003', '/SupplierManage', '/basedata/UserManage.vue', b'0', '0', b'1', 'userManage', '2', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (12, '000302', '客户信息', '0003', '/UserManage', '/basedata/UserManage.vue', b'0', '0', b'1', 'userManage', '3', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (13, '000303', '仓库信息', '0003', '/DepotManage', '/basedata/DepotManage.vue', b'0', '0', b'1', 'depotManage', '4', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (14, '0004', '采购管理', '0', '/PurchaseManage', '/Index.vue', b'0', '0', b'1', 'index', '1,4,2', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (15, '000401', '采购订单', '0004', '/PurchaseOrder', '/purchase/PurchaseOrder.vue', b'0', '0', b'1', 'purchaseOrder', '1,2', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (16, '000402', '采购入库', '0004', '/PurchaseReceipt', '/purchase/PurchaseReceipt.vue', b'0', '0', b'1', 'purchaseReceipt', '1,4', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (17, '000403', '采购退货', '0004', '/PurchaseReturn', '/purchase/PurchaseReturn.vue', b'0', '0', b'1', 'purchaseReturn', '1,2', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (18, '0005', '销售管理', '0', '/saleManage', '/Index.vue', b'0', '0', b'1', 'index', '1,3,4', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (19, '000501', '销售订单', '0005', '/saleOrder', '/sale/SaleOrder.vue', b'0', '0', b'1', 'saleOrder', '1,3', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (20, '000502', '销售出库', '0005', '/saleReceipt', '/sale/SaleReceipt.vue', b'0', '0', b'1', 'saleReceipt', '1,4', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (21, '000503', '销售退货', '0005', '/saleReturn', '/sale/SaleReturn.vue', b'0', '0', b'1', 'saleReturn', '1,3', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (22, '0006', '仓库管理', '0', '/depotManage', '/Index.vue', b'0', '0', b'1', 'index', '1,4', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (23, '000601', '其他入库', '0006', '/inDepot', '/depot/InDepot.vue', b'0', '0', b'1', 'inDepot', '1,4', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (24, '000602', '其他出库', '0006', '/outDepot', '/depot/OutDepot.vue', b'0', '0', b'1', 'outDepot', '1,4', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (26, '0007', '报表统计', '0', '/reportManage', '/Index.vue', b'0', '0', b'1', 'index', '1', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (27, '000701', '库存报表', '0007', '/indexChar', '/charjs/IndexChar.vue', b'0', '0', b'1', 'indexChar', '1', 'el-icon-s-help', '0');
INSERT INTO `zzh_function` VALUES (28, '000702', '金额报表', '0007', '/moneyChar', '/charjs/moneyChar.vue', b'0', '0', b'1', 'moneyChar', '1', 'el-icon-s-help', '0');

-- ----------------------------
-- Table structure for zzh_organization
-- ----------------------------
DROP TABLE IF EXISTS `zzh_organization`;
CREATE TABLE `zzh_organization`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `org_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '机构编号',
  `org_abr` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '机构简称',
  `org_full_name` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '机构全称',
  `parent_id` bigint NULL DEFAULT NULL COMMENT '父机构id',
  `sort` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '机构显示顺序',
  `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `delete_flag` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标记，1未删除，0删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '机构表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of zzh_organization
-- ----------------------------
INSERT INTO `zzh_organization` VALUES (1, 'XS1', '销售部', '销售部门', NULL, '', '', NULL, NULL, '1');
INSERT INTO `zzh_organization` VALUES (2, 'CG1', '采购部', '采购部门', NULL, '', '', NULL, NULL, '1');
INSERT INTO `zzh_organization` VALUES (3, 'CK1', '仓库部', '仓库部门', NULL, '', '', NULL, NULL, '1');
INSERT INTO `zzh_organization` VALUES (4, 'XS11', '销售一部', '销售一部', 1, '1', '无', NULL, NULL, '1');
INSERT INTO `zzh_organization` VALUES (5, 'XS2', '销售二部', '销售二部', 1, '1', '无', NULL, NULL, '0');
INSERT INTO `zzh_organization` VALUES (6, 'XS2', '销售二部', '销售二部门', 1, '', '', NULL, NULL, '0');

-- ----------------------------
-- Table structure for zzh_product
-- ----------------------------
DROP TABLE IF EXISTS `zzh_product`;
CREATE TABLE `zzh_product`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `category_id` bigint NULL DEFAULT NULL COMMENT '产品类型id',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `mfrs` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '制造商',
  `model` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '型号',
  `standard` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规格',
  `color` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '颜色',
  `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `img_name` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片名称',
  `unit_id` bigint NULL DEFAULT NULL COMMENT '计量单位Id',
  `expiry_num` int NULL DEFAULT NULL COMMENT '保质期天数',
  `weight` decimal(24, 6) NULL DEFAULT NULL COMMENT '基础重量(kg)',
  `position` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '仓位货架',
  `status` tinyint(1) NULL DEFAULT 1 COMMENT '0删除，1启用，2禁用',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FK675951272AB6672C`(`category_id`) USING BTREE,
  INDEX `UnitId`(`unit_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '产品表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of zzh_product
-- ----------------------------
INSERT INTO `zzh_product` VALUES (1, 4, '华为Mate 60', '华为', 'Mate 60', '无', '黑色', '无', '1.jpg', 2, NULL, 208.000000, '1', 1);
INSERT INTO `zzh_product` VALUES (2, 4, '华为Mate 50', '华为', 'Mate 50', '', '白色', '无', '', 1, NULL, 222.000000, '1', 1);
INSERT INTO `zzh_product` VALUES (3, 5, '苹果15', '苹果', '苹果15', '无', '红色', '无', '', 2, NULL, 200.000000, '1', 1);
INSERT INTO `zzh_product` VALUES (4, 6, '大疆无人机mini3', '大疆', 'mini3', '无', '灰色', '无', '60b2f145-28ab-45c3-a63b-d13c10f77affbg1.jpg', 2, NULL, 200.000000, '3', 1);

-- ----------------------------
-- Table structure for zzh_product_attribute
-- ----------------------------
DROP TABLE IF EXISTS `zzh_product_attribute`;
CREATE TABLE `zzh_product_attribute`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `attribute_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '属性名',
  `attribute_value` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '属性值',
  `status` tinyint(1) NULL DEFAULT 1 COMMENT '0删除，1启用，2禁用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '产品属性表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of zzh_product_attribute
-- ----------------------------
INSERT INTO `zzh_product_attribute` VALUES (1, '颜色', '红|黄|绿', 1);
INSERT INTO `zzh_product_attribute` VALUES (2, '外观', '盒子|箱子', 1);

-- ----------------------------
-- Table structure for zzh_product_category
-- ----------------------------
DROP TABLE IF EXISTS `zzh_product_category`;
CREATE TABLE `zzh_product_category`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `parent_id` bigint NULL DEFAULT NULL COMMENT '上级id',
  `sort` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '显示顺序',
  `remark` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `status` tinyint(1) NULL DEFAULT 1 COMMENT '0删除，1启用，2禁用',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FK3EE7F725237A77D8`(`parent_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '产品类型表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of zzh_product_category
-- ----------------------------
INSERT INTO `zzh_product_category` VALUES (1, '手机', NULL, '1', '无', '2024-04-21 09:47:10', '2024-04-21 09:47:10', 1);
INSERT INTO `zzh_product_category` VALUES (2, '衣服', NULL, '1', '无', '2024-04-21 09:47:17', '2024-04-21 09:47:17', 1);
INSERT INTO `zzh_product_category` VALUES (3, '裤子', NULL, '1', '无', '2024-04-21 09:47:25', '2024-04-21 09:47:25', 1);
INSERT INTO `zzh_product_category` VALUES (4, '华为', 1, '', '', '2024-04-21 09:47:42', '2024-04-21 09:47:42', 1);
INSERT INTO `zzh_product_category` VALUES (5, '苹果', 1, '1', '无', '2024-04-21 12:28:39', '2024-04-21 12:28:39', 1);
INSERT INTO `zzh_product_category` VALUES (6, '飞行器', NULL, '1', 'yyds', '2024-04-21 12:28:53', '2024-04-21 12:29:04', 1);
INSERT INTO `zzh_product_category` VALUES (7, '大疆无人机', 6, '1', '1', '2024-04-23 10:09:16', '2024-04-23 10:09:16', 1);

-- ----------------------------
-- Table structure for zzh_product_price
-- ----------------------------
DROP TABLE IF EXISTS `zzh_product_price`;
CREATE TABLE `zzh_product_price`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `material_id` bigint NULL DEFAULT NULL COMMENT '商品id',
  `bar_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品条码',
  `commodity_unit` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品单位',
  `sku` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '多属性',
  `purchase_decimal` decimal(24, 6) NULL DEFAULT NULL COMMENT '采购价格',
  `wholesale_decimal` decimal(24, 6) NULL DEFAULT NULL COMMENT '销售价格',
  `low_decimal` decimal(24, 6) NULL DEFAULT NULL COMMENT '最低售价',
  `default_flag` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '是否为默认单位，1是，0否',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建日期',
  `create_serial` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人编码',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新日期',
  `update_serial` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人编码',
  `status` tinyint(1) NULL DEFAULT 1 COMMENT '0删除，1启用，2禁用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '产品价格扩展' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of zzh_product_price
-- ----------------------------
INSERT INTO `zzh_product_price` VALUES (1, 1, 'SP1001', '个', '1', 5000.000000, 7000.000000, 6000.000000, '', NULL, NULL, NULL, NULL, 1);
INSERT INTO `zzh_product_price` VALUES (2, 2, 'SP1002', '个', '1', 4000.000000, 5000.000000, 4500.000000, '', NULL, NULL, NULL, NULL, 1);
INSERT INTO `zzh_product_price` VALUES (3, 3, 'SP1003', '个', '1', 6000.000000, 8000.000000, 7000.000000, '', NULL, NULL, NULL, NULL, 1);
INSERT INTO `zzh_product_price` VALUES (4, 4, 'SP1004', '个', '1', 300.000000, 5000.000000, 4000.000000, '', NULL, NULL, NULL, NULL, 1);

-- ----------------------------
-- Table structure for zzh_product_stock
-- ----------------------------
DROP TABLE IF EXISTS `zzh_product_stock`;
CREATE TABLE `zzh_product_stock`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `material_id` bigint NULL DEFAULT NULL COMMENT '产品id',
  `depot_id` bigint NULL DEFAULT NULL COMMENT '仓库id',
  `current_number` decimal(24, 6) NULL DEFAULT NULL COMMENT '当前库存数量',
  `low_number` decimal(24, 0) NULL DEFAULT NULL COMMENT '最低安全库存数量',
  `high_number` decimal(24, 0) NULL DEFAULT NULL COMMENT '最高安全库存数量',
  `status` tinyint(1) NULL DEFAULT 1 COMMENT '0删除，1启用，2禁用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '产品当前库存' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of zzh_product_stock
-- ----------------------------
INSERT INTO `zzh_product_stock` VALUES (1, 1, 1, 2000.000000, 100, 10000, 1);
INSERT INTO `zzh_product_stock` VALUES (2, 1, 2, 5000.000000, 100, 10000, 1);
INSERT INTO `zzh_product_stock` VALUES (3, 2, 1, 2000.000000, 500, 50000, 1);
INSERT INTO `zzh_product_stock` VALUES (4, 2, 2, 5000.000000, 500, 50000, 1);
INSERT INTO `zzh_product_stock` VALUES (5, 3, 1, 2500.000000, 100, 10000, 1);
INSERT INTO `zzh_product_stock` VALUES (6, 3, 2, 4500.000000, 100, 10000, 1);
INSERT INTO `zzh_product_stock` VALUES (7, 4, 1, 5000.000000, 10000, 10000, 1);
INSERT INTO `zzh_product_stock` VALUES (8, 4, 2, 3000.000000, 10000, 10000, 1);

-- ----------------------------
-- Table structure for zzh_product_unit
-- ----------------------------
DROP TABLE IF EXISTS `zzh_product_unit`;
CREATE TABLE `zzh_product_unit`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称，支持多单位',
  `basic_unit` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '基础单位',
  `other_unit` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '副单位',
  `other_unit_two` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '副单位2',
  `ratio` decimal(24, 3) NULL DEFAULT NULL COMMENT '比例',
  `ratio_two` decimal(24, 3) NULL DEFAULT NULL COMMENT '比例2',
  `status` bigint NULL DEFAULT 1 COMMENT '0删除，1启用，2禁用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '多单位表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of zzh_product_unit
-- ----------------------------
INSERT INTO `zzh_product_unit` VALUES (1, '盒/(箱=50盒)', '盒', '箱', '', 50.000, NULL, 1);
INSERT INTO `zzh_product_unit` VALUES (2, '个/(盒=10个)/(箱子=50个)', '个', '盒', '箱子', 10.000, 50.000, 1);
INSERT INTO `zzh_product_unit` VALUES (3, '个/(袋=30个)', '个', '袋', '', 30.000, NULL, 0);

-- ----------------------------
-- Table structure for zzh_role
-- ----------------------------
DROP TABLE IF EXISTS `zzh_role`;
CREATE TABLE `zzh_role`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型',
  `description` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `sort` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '排序',
  `status` tinyint(1) NULL DEFAULT 1 COMMENT '0删除，1启用，2禁用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of zzh_role
-- ----------------------------
INSERT INTO `zzh_role` VALUES (1, '管理员', '全部数据', '管理员工数据', '1', 1);
INSERT INTO `zzh_role` VALUES (2, '采购员', '全部数据', '找供应商采购商品', '1', 1);
INSERT INTO `zzh_role` VALUES (3, '销售员', '全部数据', '先客户推销商品', '1', 1);
INSERT INTO `zzh_role` VALUES (4, '仓库员', '全部数据', '管理仓库的出入管理', '1', 1);
INSERT INTO `zzh_role` VALUES (5, '采购员1', '全部数据', 'good', '1', 1);
INSERT INTO `zzh_role` VALUES (6, '采购员2', '全部数据', '无', '1', 1);
INSERT INTO `zzh_role` VALUES (7, '销售员1', '全部数据', '1', '1', 1);

-- ----------------------------
-- Table structure for zzh_staff
-- ----------------------------
DROP TABLE IF EXISTS `zzh_staff`;
CREATE TABLE `zzh_staff`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户姓名--例如张三',
  `login_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录用户名',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登陆密码',
  `position` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职位',
  `department` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属部门',
  `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电子邮箱',
  `phonenum` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号码',
  `ismanager` tinyint NOT NULL DEFAULT 1 COMMENT '是否为管理者 0==管理者 1==员工',
  `isystem` tinyint NOT NULL DEFAULT 0 COMMENT '是否系统自带数据 ',
  `Status` tinyint NULL DEFAULT 1 COMMENT '状态，0：删除，1：正常，2封禁',
  `description` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户描述信息',
  `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of zzh_staff
-- ----------------------------
INSERT INTO `zzh_staff` VALUES (1, '张针豪', 'root', '4813494d137e1631bba301d5acab6e7bb7aa74ce1185d456565ef51d737677b2', '1', '无', '1274244085@qq.com', '17383727516', 1, 0, 1, '无', '无');
INSERT INTO `zzh_staff` VALUES (2, '张三', '123456', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '2', '2', '1274244085@qq.com', '17383727516', 1, 0, 1, '采购商品', '无');
INSERT INTO `zzh_staff` VALUES (3, '李四', 'lisi', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '3', '1', 'zzhtun@qq.com', '17383727514', 1, 0, 1, '销售商品', '无');
INSERT INTO `zzh_staff` VALUES (4, '王五', 'wangwu', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '4', '3', '12@qq.com', '17738782896', 1, 0, 1, '无', '无');
INSERT INTO `zzh_staff` VALUES (5, '赵六', 'zhaoliu', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '4', '3', '12356@qq.com', '13183766718', 1, 0, 1, '', '');
INSERT INTO `zzh_staff` VALUES (6, '李八', 'liba', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '2', '2', '5646@qq.com', '13183766714', 1, 0, 0, '123', '213');
INSERT INTO `zzh_staff` VALUES (7, '十九世', '123456789', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '2', '2', '5566@qq.com', '13183766718', 1, 0, 1, '1', '1');

-- ----------------------------
-- Table structure for zzh_user
-- ----------------------------
DROP TABLE IF EXISTS `zzh_user`;
CREATE TABLE `zzh_user`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '供应商-客户名称',
  `contacts` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人',
  `telephone` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机',
  `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电子邮箱',
  `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
  `type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型(供应商|客户)',
  `description` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `status` tinyint(1) NULL DEFAULT 1 COMMENT '状态，0：删除，1：正常，2封禁',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '供应商/客户信息表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of zzh_user
-- ----------------------------
INSERT INTO `zzh_user` VALUES (1, '华为供应商', '张三丰', '13183766718', 'zzhtun@qq.com', '四川省南充市嘉陵区火花街1号', '供应商', '无', 1);
INSERT INTO `zzh_user` VALUES (2, '万达客户', '万达', '17383727516', '123456789@qq.com', '四川省顺庆区1号', '客户', '无', 1);
INSERT INTO `zzh_user` VALUES (3, '苹果供应商', '王睿', '17383711569', 'sdmiawdn@qq.com', '四川省成都市双流区1号', '供应商', '无', 1);
INSERT INTO `zzh_user` VALUES (4, '无人机供应商', '吴兵', '13183755169', '1274244085@qq.com', '四川省绵阳市1号', '供应商', 'wu', 1);
INSERT INTO `zzh_user` VALUES (5, '大润发客户', '赵路', '13156893176', '125awda@qq.com', '四川省南充市高坪区1号', '客户', '无', 1);
INSERT INTO `zzh_user` VALUES (6, '金牛客户', '金牛', '13183744569', '15463265@qq.com', '四川省成都市金牛区1号', '客户', 'wu', 2);

SET FOREIGN_KEY_CHECKS = 1;