archevilangel
[H]ard|Gawd
- Joined
- Jan 15, 2003
- Messages
- 1,824
I'm getting the error message
REFERENCES CONTACT_HISTORY(Contact_ID),
*
ERROR at line 7:
ORA-02270: no matching unique or primary key for this column-list
when trying to execute this command:
CREATE TABLE CONTACT_REMINDER
( Contact_ID INT NOT NULL,
Project_ID INT NOT NULL,
Contact_Reminders VARCHAR(50),
PRIMARY KEY(Contact_ID, Project_ID, Contact_Reminders),
FOREIGN KEY(Contact_ID)
REFERENCES CONTACT_HISTORY(Contact_ID),
FOREIGN KEY(Project_ID)
REFERENCES CONTACT_HISTORY(Project_ID) );
Here's what "DESC CONTACT_HISTORY" looks like
Name Null? Type
CONTACT_ID NOT NULL NUMBER(38)
PROJECT_ID NOT NULL NUMBER(38)
CP_NAME VARCHAR2(20)
CONTACT_TYPE VARCHAR2(20)
CONTACT_DETAILS VARCHAR2(50)
REFERENCES CONTACT_HISTORY(Contact_ID),
*
ERROR at line 7:
ORA-02270: no matching unique or primary key for this column-list
when trying to execute this command:
CREATE TABLE CONTACT_REMINDER
( Contact_ID INT NOT NULL,
Project_ID INT NOT NULL,
Contact_Reminders VARCHAR(50),
PRIMARY KEY(Contact_ID, Project_ID, Contact_Reminders),
FOREIGN KEY(Contact_ID)
REFERENCES CONTACT_HISTORY(Contact_ID),
FOREIGN KEY(Project_ID)
REFERENCES CONTACT_HISTORY(Project_ID) );
Here's what "DESC CONTACT_HISTORY" looks like
Name Null? Type
CONTACT_ID NOT NULL NUMBER(38)
PROJECT_ID NOT NULL NUMBER(38)
CP_NAME VARCHAR2(20)
CONTACT_TYPE VARCHAR2(20)
CONTACT_DETAILS VARCHAR2(50)