I try to do this into mysql :
Create a first table with A, B, C columns and a composite primary key on A and B. Create a second table A, B, D, E columns with A, B, D as primary key and of course A, B referenced as a foreign from first table.
I use mysql workbench to creates columns, add keys and foreigns constraints, but when i try to apply i receive this error :
ERROR 1215: Cannot add foreign key constraint
The thing is that i don't know what exactly is wrong with my design.
Can you help me.