Change of behaviour while navigating the keys
When editing the keys, the clobs that can be selected in the dropdown menu must be of the correct clob_type.
This is complicated by the possibility of intermediate tables: for instance BMTF has BMTF_RS_KEYS and BMTF_INFRA_KEYS, while ALGO and HW points directly to the BMTF_CLOBS table.
A possible approach would be, using BMTF as example and starting from BMTF_KEYS:
- the columns HW and ALGO points to BMTF_CLOBS, so the ID shown in the dropdown can be selected "where CLOB_TYPE='hw'" or "where CLOB_TYPE='algo'"
- the column INFRA points to BMTF_INFRA_KEYS, nothing special to be implemented
- BMTF_INFRA has two columns, AMC13 and MP7, pointing to BMTF_CLOBS, so the ID shown in the dropdown can be selected "where CLOB_TYPE='infra_amc13'" or "where CLOB_TYPE='infra_mp7'"
The need to specify 'infra_' in the last case is due to the fact that BMTF_RS_KEYS has also AMC13 and MP7 columns. The other possibility is to change the column names wherever they are duplicated.
Other options can be evaluated.