审核日志表table_audit

/*
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: 03/01/2022 19:37:18
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

– Table structure for mall_supplier_audit

DROP TABLE IF EXISTS mall_supplier_audit;
CREATE TABLE mall_supplier_audit (
AUDIT_ID varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘newid()’ COMMENT ‘审核记录Id’,
AUDIT_USER_NAME varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘审核记录名称’,
AUDIT_USER_ID varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT ‘’ COMMENT ‘审核用户 BO_USER’,
AUDIT_STATUS int(0) NULL DEFAULT NULL COMMENT ‘审核状态 -1 草稿箱 0 待审核 1 已通过 2 已打回 3 已关闭’,
AUDIT_DATE datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘审核时间’,
OPINION varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT ‘’ COMMENT ‘审核意见’,
AUDIT_STATUS_NAME varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘审核状态 -1 草稿箱 0 待审核 1 已通过 2 已打回 3 已关闭’,
OBJECT_ID varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘审核对象ID’,
PRIMARY KEY (AUDIT_ID) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;