ORACLE约束:主键,外键,非空,唯一,条件
create table COMPUTERS(
CNO NUMBER(3) CONSTRAINT PK_COMPUTERS PRIMARY KEY,
CUSER VARCHAR(4)
);
INSERT INTO COMPUTERS(CNO,CUSER) VALUES(1,'MIKE');
create table CPU(
CPUNO NUMBER(3) CONSTRAINT PK_CPU PRIMARY KEY,
COMPUTERNO NUMBER(3),CONSTRAINT FK_CPU FOREIGN KEY(COMPUTERNO) REFERENCES COMPUTERS(CNO),
BUYTIME DATE NOT NULL,
CPUMODEL VARCHAR2(64) UNIQUE,
PRICE NUMBER(7,2) CONSTRAINT CPU_PRICE CHECK(PRICE>0 AND PRICE < 3000)
);
INSERT INTO CPU(CPUNO,COMPUTERNO,BUYTIME,CPUMODEL,PRICE) VALUES(888,1,SYSDATE,'MVBCQ-B3VPW-CT369-VM9TB-YFGBP',555.55);