/*
|
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:02
|
*/
|
|
SET NAMES utf8mb4;
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
-- ----------------------------
|
-- Table structure for sys_dict_data
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_dict_data`;
|
CREATE TABLE `sys_dict_data` (
|
`id` bigint(20) NOT NULL COMMENT 'id',
|
`dict_type_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典ID',
|
`dict_type_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典识别码',
|
`value` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '值',
|
`label` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标签',
|
`sort` int(11) DEFAULT NULL COMMENT '排序',
|
`color` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '颜色。例如：#FFFFFF、blue、rgba(0,0,0,0.5)',
|
`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,
|
KEY `IX__value` (`value`) USING BTREE
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='字典字段表';
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
