供应商管理员mall_supplier_user

/*
 Navicat Premium Data Transfer

 Source Server         : mysql.localhost
 Source Server Type    : MySQL
 Source Server Version : 80020
 Source Host           : localhost:3306
 Source Schema         : rg_bs_mall

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

 Date: 30/12/2021 11:01:53
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for mall_supplier_user
-- ----------------------------
DROP TABLE IF EXISTS `mall_supplier_user`;
CREATE TABLE `mall_supplier_user`  (
  `SUPPLIER_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '供应商Id',
  `USER_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '供应商成员',
  `USER_SHOW_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户显示名',
  `USER_TYPE` int(0) NULL DEFAULT NULL COMMENT '员工类别 0、待审核 1、老板（档口/商户），2、(伙计)本店员、3、供应商（货主）4、收银  5、采购 6、市场管理公司',
  `IS_ENABLED` int(0) NULL DEFAULT NULL COMMENT '店员状态 1 启用 0 禁用',
  `MU_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `SETTLE_LAST_DAY` int(0) NULL DEFAULT NULL COMMENT '欠款宽限天数',
  PRIMARY KEY (`MU_ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;