常用基础数据库表
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;
原文地址：https://blog.csdn.net/johnrui/article/details/143676341
免责声明：本站文章内容转载自网络资源，如本站内容侵犯了原著者的合法权益，可联系本站删除。更多内容请关注自学内容网（zxcms.com）！