create table BookChe (
check number(10) not null,
bookISBN number(13) not null,
bookCopy number(10) not null,
constraint pk_ResChe primary key (check, bookISBN, bookCopy),
constraint fk_ResChe_Che foreign key (check) references checkout,
constraint fk_ResChe_book foreign key (bookISBN, bookCopy) references book
);
1条答案
按热度按时间dxxyhpgq1#
check
是保留字。不要使用没有双引号的它。例如,如果我们将其更改为check_col
,则它可以正常工作:和带双引号的示例: