Cannot create relationships using 'Create foreign key' function

What steps will reproduce the problem?
1. Attempt to create a relationship between two tables in the schema designer 
using the 'Create foreign key' function.
2. Note that ORDS tells you there was an error dealing with this request - 
though the foreign key field and the line indicating a relationship appear as 
expected.
3. Discover that if you try to change the name of the foreign key field, ORDS 
tells you it doesn't exist. If you save the changes and then exit and re-enter 
the schema designer, the foreign key field and the relationship have 
disappeared.

What is the expected output? What do you see instead?

When ORDS tries to create the table and says there's been an error, it also 
suggests looking at the error console for more details. The console displays 
the following:

POST 
https://dev.ords.ox.ac.uk/ordsProjectNode/sd/database/545860/main/table/first_ta
ble/column/id_second_table 500 (Internal Server Error)wwwsqldesigner.js:100 
(anonymous function)wwwsqldesigner.js:67 
SQL.Request.Promisewwwsqldesigner.js:2169 SQL.RowManager.tableClickoz.js:88 
c.dispatchwwwsqldesigner.js:973 SQL.Table.click

Please use labels and text to provide additional information.

Dev version, v. 1.0.6 - 4006

Original issue reported on code.google.com by meriel.p...@gmail.com on 16 Jan 2015 at 4:15

google-code-export / ords

Cannot create relationships using 'Create foreign key' function #603