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)
);
展开