数据库

/*
 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: 21/01/2022 15:04:18
*/

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`  (
  `SU_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `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、采购员）',
  `IS_ENABLED` int(0) NULL DEFAULT NULL COMMENT '店员状态 1 启用 0 禁用',
  PRIMARY KEY (`SU_ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;