mysql ora-02270:此列列表的唯一关键字或主键不匹配_ORA-02270: 此列列表的唯一关键字或主键不匹配...

CREATETABLELoan(LnoVARCHAR2(8)PRIMARYKEY,CidVARCHAR2(18)NOTNULL,DVD1VARCHAR2(10)NOTNULL,DVD2VARCHAR2(10),DVD3VARCHAR2(10),DepositNUMBER(5)NOTNULL,ReturnedVARCHAR2(10),Lda...

CREATE TABLE Loan

(

Lno VARCHAR2(8) PRIMARY KEY,

Cid VARCHAR2(18) NOT NULL ,

DVD1 VARCHAR2(10) NOT NULL ,

DVD2 VARCHAR2(10) ,

DVD3 VARCHAR2(10) ,

Deposit NUMBER(5) NOT NULL ,

Returned VARCHAR2(10) ,

Ldate DATE ,

Rdate DATE ,

FOREIGN KEY (Cid) REFERENCES Customer(Cid)

);

CREATE TABLE Videoinfo

(

Dno VARCHAR2(10) PRIMARY KEY ,

Dname VARCHAR2(20) NOT NULL ,

Type VARCHAR2(20) NOT NULL ,

Area VARCHAR2(10) NOT NULL ,

Info VARCHAR2(1000) ,

Total NUMBER(5) NOT NULL ,

Inventory NUMBER(5) NOT NULL ,

FOREIGN KEY (Dno) REFERENCES Loan(DVD1),

FOREIGN KEY (Dno) REFERENCES Loan(DVD2),

FOREIGN KEY (Dno) REFERENCES Loan(DVD3)

);

展开