Re: Foreign Key constraint problem while using InnoDB

[Vinod Sugur]

Hi Aayush,

The below statement is wrong:

ALTER TABLE DATASOURCE_DOCUMENTS ADD FOREIGN KEY(APPUSAGE_ID) REFERENCES DATASOURCE_COLLECTIONS(COLLECTION_NAME,APPUSAGE_ID);

a. One column of DATASOURCE_DOCUMENTS table is mapped with two columns of DATASOURCE_COLLECTIONS table.

b. The foreign key column/columns should map to appropriate primary key column/columns.



Let me know if this helps.

Regards,
Vinod