[Err] 1005 - Can't create table 'shop.tb

[Err] 1005 - Can't create table 'shop.tb_shop' (errno: 150)

来源：2-3 实体类设计与表创建B

cuteqing

2020-03-05

USE shop;
CREATE TABLE `tb_shop`(
`shop_id`INT(10)NOT NULL AUTO_INCREMENT,
`owner_id`INT(10)NOT NULL COMMENT'店铺创建人',
`area_id`INT(5)DEFAULT NULL,
`shop_category_id`int(11) DEFAULT NULL,
`shop_name`VARCHAR(256) NOT NULL,
`shop_desc`VARCHAR(1024) DEFAULT NULL,
`shop_addr`VARCHAR(200) DEFAULT NULL,
`phone`VARCHAR(128) DEFAULT NULL,
`shop_img`VARCHAR(1024)DEFAULT NULL,
`priority`INT(3) DEFAULT '0',
`create_time`datetime DEFAULT NULL,
`last_edit_time`datetime DEFAULT NULL,
`enable_status`INT(2) NOT NULL DEFAULT'0',
`advice`VARCHAR(255) DEFAULT NULL,
PRIMARY KEY(`shop_id`),
CONSTRAINT `fk_shop_area` FOREIGN KEY(`area_id`) REFERENCES `tb_area`(`area_id`),
CONSTRAINT `fk_shop_profile` FOREIGN KEY(`owner_id`) REFERENCES `tb_person_info`(`user_id`),
CONSTRAINT `fk_shop_shopcate` FOREIGN KEY (`shop_category_id`) REFERENCES `tb_shop_category`(`shop_category_id`)
)ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8

写回答

2回答