Currently I have two problems to solve and I hope you can show me ways so solve them ;-)
We are using an oracle database to store our map data and have established direct connections to edit the map in different versions.
Problem 1: We are using some additional (none versioned) tables to store key-value pairs. In ArcMap we would like to see the "values" instead of the keys. Google told me to use Coded Value Domains - but as I understood its not possible to integrate own database tables. Are there any ways to create those coded values domains "on the fly"?
Problem 2: We would like to use referential integrity with those Key-Value tables. Because of the versioning of the data it makes no sense to create foreign keys. Are there any solutions for this problem, too?