在被引用表 ✀times✀ 中没有与外键 ✀FK__states__fTime__1B0907CE✀ 中的引用列列表匹配的主键或候选键.

create table food(fID char(5) primary key,fName char(20),fType smallint, check(fType in (-1, 0, 1, 2)),fPrice float, check(fPrice > 0),fHave bit default 1,fImage image,)select * from foodcreate table desk(dId char(5) primary key,dState smallint check(dState in (-1, 1, 0)) default 0,)select * from deskcreate table times(fTime date,dId char(5),checkoutTime date,primary key(fTime, dId),foreign key(dId) references desk(dId))select * from timescreate table states(fTime date,fId char(5),dId char(5),fNum smallint check(fNum >= 0),backState smallint check(backState in (-1, 0, 1)),primary key(fTime, fId, dId),foreign key(fTime) references times(fTime), 上面times出错foreign key(fId) references food(fId),foreign key(dId) references desk(dId))