The following script gives
ORA-02256: number of referencing columns must match referenced columns, cannot think about any reason, anyone have any idea?
Please help, I'm stuck on an Assignment.... !!!!
drop table qualitycheck;
drop table allocation;
drop table manager;
CREATE TABLE MANAGER (
mgrid number (4),
mfirstname varchar2(30),
msurname varchar2(30),
Primary Key (mgrid)
);
CREATE TABLE ALLOCATION (
prodid number (4) CONSTRAINT NN_PRODUCT_prodid NOT NULL,
mgrid number (4) CONSTRAINT NN_MANAGER_mgrid NOT NULL,
Primary Key (prodid,mgrid),
CONSTRAINT FK_ALLOCATION_MANAGER_mgrid Foreign Key (mgrid) REFERENCES MANAGER,
CONSTRAINT FK_ALLOCATION_PRODUCT_prodid Foreign Key (prodid) REFERENCES PRODUCT
);
CREATE TABLE QUALITYCHECK (
prodid number (4) CONSTRAINT NN_ALLOCATION_prodid NOT NULL,
mgrid number (4) CONSTRAINT NN_ALLOCATION_mgrid NOT NULL,
weekno number (2),
score number (1),
Primary Key (prodid,mgrid,weekno),
CONSTRAINT FK_QUALITYCHECK_PRODUCT_prodid Foreign Key (prodid) REFERENCES ALLOCATION,
CONSTRAINT FK_QUALITYCHECK_MANAGER_mgrid Foreign Key (mgrid) REFERENCES ALLOCATION
);