|
You are missing the columns storeid and itemcode in the Orders table.
You actually have to create them in order to make a foreign key on them.
there is also no data type of IDENTITY in mysql. I believe that is Oracle or SQL Server that supports that type.
|