alterdbexam3.sql

来自「ssd7考试exam3,绝对有用~欢迎下载」· SQL 代码 · 共 8 行

CREATE TABLE FavoriteTitles
(
TitleID		char(20) NOT NULL,
CustomerID	char(64) NOT NULL,
PRIMARY KEY (TitleID, CustomerID),
FOREIGN KEY (TitleID) REFERENCES Booktitle(callnumber),
FOREIGN KEY (CustomerID) REFERENCES Customer (customerID)
);