All pastes #995719 Raw Edit

Untitled

public text v1 · immutable
#995719 ·published 2008-04-24 12:50 UTC
rendered paste body
CREATE TABLE Plane
(
	regno     VARCHAR(8),
	make      VARCHAR(10),
	model     VARCHAR(10),
        owner     VARCHAR(10) NOT NULL,
        name      VARCHAR(30),
	CONSTRAINT Plane_FK FOREIGN KEY (make,model) REFERENCES Planemodel (varchar(10), varchar(10)),
	CONSTRAINT Plane_PK PRIMARY KEY (regno)
);

I am trying to make "make" and "model" 2 foreign references that occur in Planemodel. Both are varchar(10)