CREATE TABLE `ts_dict` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '字典名称',
  `value` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '字典类型',
  `grade` int DEFAULT '1' COMMENT '等级',
  `sort` int DEFAULT NULL COMMENT '排序',
  `pid` bigint DEFAULT NULL COMMENT '字典上级id',
  `status` int DEFAULT '1' COMMENT '状态（1启用 0不启用）',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '更新人',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除(1:已删除，0:未删除)',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `name_Index` (`name`) USING BTREE,
  KEY `type_Index` (`type`) USING BTREE,
  KEY `pid_Index` (`pid`) USING BTREE,
  KEY `grade_Index` (`grade`) USING BTREE,
  KEY `status_Index` (`status`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1005011 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='字典表';