sql语句错误
问题:Can’t create table ‘project.design_tb’ (errno: 150)
create TABLE design_tb(
id INT(11) PRIMARY KEY AUTO_INCREMENT,
description VARCHAR(128) ,
cid INT(11),
did INT(11),
sid INT(11),
CONSTRAINT design_fk_1 FOREIGN KEY (cid) REFERENCES construction_unit_tb(id),
CONSTRAINT design_fk_2 FOREIGN KEY (did) REFERENCES design_unit_tb(id), --检查发现这个表前面忘记建了
CONSTRAINT design_fk_3 FOREIGN KEY (sid) REFERENCES subject_tb(id)
);