急求解数据库模型图中这两个箭头表示什么意思? 贴出箭头2和3包括的三个表的建表语句show create table XX 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 箭头2:CREATE TABLE `authority` ( `AUTHORITY_ID` bigint(20) NOT NULL AUTO_INCREMENT, `OBJ_VERSION` int(11) NOT NULL, `USER_ID` bigint(20) NOT NULL, `ROLE` varchar(32) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`AUTHORITY_ID`), UNIQUE KEY `USER_ID` (`USER_ID`,`ROLE`), KEY `ALLAUTHORITIES` (`USER_ID`), CONSTRAINT `ALLAUTHORITIES` FOREIGN KEY (`USER_ID`) REFERENCES `user` (`USER_ID`)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE `user` ( `USER_ID` bigint(20) NOT NULL AUTO_INCREMENT, `OBJ_VERSION` int(11) NOT NULL, `NAME` varchar(50) COLLATE utf8_bin NOT NULL, `PASSWORD` varchar(50) COLLATE utf8_bin NOT NULL, `GROUP_ID` bigint(20) NOT NULL, `EMAIL` varchar(64) COLLATE utf8_bin NOT NULL, `LOCKED` bit(1) NOT NULL, `ENABLED` bit(1) NOT NULL, `EXPIRATION` datetime NOT NULL, PRIMARY KEY (`USER_ID`), UNIQUE KEY `NAME` (`NAME`), KEY `ALLUSERS` (`GROUP_ID`), CONSTRAINT `ALLUSERS` FOREIGN KEY (`GROUP_ID`) REFERENCES `m_group` (`GROUP_ID`)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE `m_group` ( `GROUP_ID` bigint(20) NOT NULL AUTO_INCREMENT, `OBJ_VERSION` int(11) NOT NULL, `NAME` varchar(50) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`GROUP_ID`), UNIQUE KEY `NAME` (`NAME`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 后台编辑产品数据,mysql会逐步吃完内存导致WEB卡死 mysql 如何使用多核CPU? 求助一个高难度的sql写法 如何在my.cnf里面设置binlog_format? pgsql中时间函数怎么写?快点来结贴快 Mysql的select 能不能像oracle那样生成rownum password函数的逆过程是什么? prepare from不支持临时变量吗,为什么会报错 请大家看看这个查询怎么能优化 百度云数据库怎么连接,一直报错。 mysql存储过程异常问题 MySQL 递归查询
CREATE TABLE `authority` (
`AUTHORITY_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`OBJ_VERSION` int(11) NOT NULL,
`USER_ID` bigint(20) NOT NULL,
`ROLE` varchar(32) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`AUTHORITY_ID`),
UNIQUE KEY `USER_ID` (`USER_ID`,`ROLE`),
KEY `ALLAUTHORITIES` (`USER_ID`),
CONSTRAINT `ALLAUTHORITIES` FOREIGN KEY (`USER_ID`) REFERENCES `user` (`USER_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;CREATE TABLE `user` (
`USER_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`OBJ_VERSION` int(11) NOT NULL,
`NAME` varchar(50) COLLATE utf8_bin NOT NULL,
`PASSWORD` varchar(50) COLLATE utf8_bin NOT NULL,
`GROUP_ID` bigint(20) NOT NULL,
`EMAIL` varchar(64) COLLATE utf8_bin NOT NULL,
`LOCKED` bit(1) NOT NULL,
`ENABLED` bit(1) NOT NULL,
`EXPIRATION` datetime NOT NULL,
PRIMARY KEY (`USER_ID`),
UNIQUE KEY `NAME` (`NAME`),
KEY `ALLUSERS` (`GROUP_ID`),
CONSTRAINT `ALLUSERS` FOREIGN KEY (`GROUP_ID`) REFERENCES `m_group` (`GROUP_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
CREATE TABLE `m_group` (
`GROUP_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`OBJ_VERSION` int(11) NOT NULL,
`NAME` varchar(50) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`GROUP_ID`),
UNIQUE KEY `NAME` (`NAME`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;