AnsweredAssumed Answered

Referential integrity / Coded Value Domains

Question asked by Grabenmeier on Dec 8, 2015
Latest reply on Jan 6, 2016 by LukeW

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?