常用基础数据库表

1. mysql 数据字典

CREATE TABLE `sys_dic` (
  `ID` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `GROUP_VAL` varchar(100) NOT NULL COMMENT '分组',
  `KEY` varchar(50) NOT NULL COMMENT '关键字',
  `NAME` varchar(50) NOT NULL COMMENT '名称',
  `VALUE` varchar(100) NOT NULL COMMENT '值',
  `LANGUAGE_KEY` varchar(50) DEFAULT NULL COMMENT '国际化语言KEY',
  `REMARK` varchar(255) DEFAULT NULL COMMENT '说明',
  `SORT` bigint(5) NOT NULL DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`ID`) USING BTREE,
  UNIQUE KEY `idx_sys_dic_key` (`KEY`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='智慧大脑---数据字典';

2. mysql 系统配置

-- ----------------------------
-- Table structure for system_config
-- ----------------------------
DROP TABLE IF EXISTS `system_config`;
CREATE TABLE `system_config`  (
  `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `TYPE` int(10) NOT NULL COMMENT '类型',
  `PROPERTY` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '属性',
  `VALUE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容',
  `DEFAULT_VALUE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '默认内容',
  PRIMARY KEY (`ID`) USING BTREE,
  INDEX `idx_type`(`TYPE`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统配置' ROW_FORMAT = Dynamic;