/*
|
Navicat Premium Data Transfer
|
|
Source Server : localhost
|
Source Server Type : MySQL
|
Source Server Version : 80011 (8.0.11)
|
Source Host : localhost:3306
|
Source Schema : fortec-bm
|
|
Target Server Type : MySQL
|
Target Server Version : 80011 (8.0.11)
|
File Encoding : 65001
|
|
Date: 24/02/2025 08:45:14
|
*/
|
|
SET NAMES utf8mb4;
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
-- ----------------------------
|
-- Table structure for sys_dict_type
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_dict_type`;
|
CREATE TABLE `sys_dict_type` (
|
`id` bigint(20) NOT NULL COMMENT 'id',
|
`code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '识别码',
|
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典名称',
|
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述',
|
`creator` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'creator',
|
`gmt_create` datetime DEFAULT NULL COMMENT 'gmt_create',
|
`modifier` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'modifier',
|
`gmt_modified` datetime DEFAULT NULL COMMENT 'gmt_modified',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='字典表';
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
