SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for bt_product_lib_audit
-- ----------------------------
DROP TABLE IF EXISTS `bt_product_lib_audit`;
CREATE TABLE `bt_product_lib_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_STATUS_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审核状态 -1 草稿箱 0 待审核 1 已通过 2 已打回 3 已关闭',
`AUDIT_DATE` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '审核时间',
`OPINION` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '审核意见',
`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;
文档更新时间: 2022-08-21 09:49 作者:admin