建borrow表.sql

来自「1.写出建立BORROW表的SQL语句」· SQL 代码 · 共 8 行

CREATE TABLE BORROW
  (CNO CHAR(8) NOT NULL,
   BNO CHAR(8)NOT NULL,
   
 RDATE DATETIME,
   PRIMARY KEY(CNO,BNO),
   FOREIGN KEY(CNO)REFERENCES CARD(CNO),
   FOREIGN KEY(BNO)REFERENCES BOOKS(BNO))