Hello everyone,
Just for future reference in case someone else whats to implement the same thing, here is what we did:
So the Enumeration is divided into 3 schemas Enumeration, Value of enumeration and Alias of an enumeration value. Alias of an enumeration value has foreign keys for the other two schemas, while the Value of enumeration has the foreign key of Enumeration schema. So to insert a value in an enumeration we had to update the values as well as the foreign key in the respective schemas so that these values are linked with their corresponding values in other schemas.
To simply state, we updated the Primary key of the Enumeration schema against the foreign key in the Value of enumeration schema. Next, we updated the Primary key of the Enumeration schema and Primary key of Value of enumeration schema against the respective foreign keys in Alias of an enumeration value schema.
Kindly ask if you find this explanation confusing.
Thanks Milan, for pointing us in the right direction.
Regards,
Jayesh