数据库

mall_commodity_file 替换为对应的业务表

/*
 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: 04/02/2022 11:06:55
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for mall_commodity_file
-- ----------------------------
DROP TABLE IF EXISTS `mall_commodity_file`;
CREATE TABLE `mall_commodity_file`  (
  `ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'newid()' COMMENT '自动编号(不用ID避免主表)',
  `OBJECT_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '所属对象ID',
  `OBJECT_TYPE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '对象类别，通常为表名小写',
  `SYS_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属系统',
  `NAME` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文件名称(不用NAME避免关键字)',
  `SIZE` int(0) NULL DEFAULT 0 COMMENT '文件大小（KB）',
  `URL` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '存储路径',
  `SUFFIX` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件后缀名 （.docx）',
  `IS_IMG` int(0) NULL DEFAULT 0 COMMENT '是否图片',
  `IS_ENABLED` int(0) NULL DEFAULT 1 COMMENT '是否启用 1是 0 不是',
  `SORT` int(0) NULL DEFAULT 0 COMMENT '排序',
  `POSITION` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '显示位置 app、pc、ipad',
  `IS_DEFAULT` int(0) NULL DEFAULT 0 COMMENT '是否默认 1是 0 不是',
  `CREATE_USER_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建用户 BO_USER_ID',
  `CREATE_DATE` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`ID`) USING BTREE,
  UNIQUE INDEX `idx_uq_bo_file_library`(`ID`) USING BTREE,
  INDEX `idx_no_bo_file_library_name`(`NAME`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;