[BUG] Unused field foreignKeyProperties in databaseColumnElement

[lcpopa]

Is there an existing issue for this?

• I have searched the existing issues

Current Behavior

Field is empty when retrieving a column via the integrator context

Expected Behavior

Field contains foreign key information

Steps To Reproduce

Trigger metadata transfer of jdbc-integrator

Environment

- Egeria:
- OS:
- Java:
- Browser (for UI issues):
- Additional connectors and integration: jdbc-connector

Any Further Information?

No response

[lcpopa]

As discussed during community calls, API needs to be enhanced to include the foreign key column GUID. Field contains information, but it is not enough for foreign key relationship removal

[mandy-chessell]

I had a look at the code and the guid/qualifiedName of the primary key column should be in the referencedColumnGUID and referencedColumnQualifiedName but the converter was adding the the values from the wrong end of the relationship.

[mandy-chessell]

I had a look at the code and the guid/qualifiedName of the primary key column should be in the referencedColumnGUID and referencedColumnQualifiedName but the converter was adding the the values from the wrong end of the relationship.