Untitled
public text v1 · immutableCREATE 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)