查看创表语句 SHOW CREATE TABLE t_idcard

SHOW CREATE TABLE t_idcard

复制后查看

CREATE TABLE `t_idcard` (
  `cardNum` VARCHAR(255) NOT NULL,
  `place` VARCHAR(20) DEFAULT NULL,
  `user_id` INT(11) DEFAULT NULL,
  PRIMARY KEY (`cardNum`),
  KEY `FK35AB3516DABEA15A` (`user_id`),
  CONSTRAINT `FK35AB3516DABEA15A` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`userId`)
) ENGINE=INNODB DEFAULT CHARSET=utf8

 

转载于:https://www.cnblogs.com/meethao/p/9755161.html