Is it possible to create additional 'fields' in the geodatabase domain system table (GDB_items) in SDE 10.3/Oracle?
It would be handy to store additional information in domains. For example:
- CODE [domain coded value]
- NAME [domain description]
- Additional fields: DETAILS, COMMENTS, RELATED_DOCUMENT, etc.
I know it wouldn't be accessible in ArcGIS desktop's out-of-box functionality, but maybe it would be possible to query it with SQL?
The SQL used to access the domain would look like this, but include additional 'fields':
SELECT
EXTRACTVALUE(CodedValues.COLUMN_VALUE, 'CodedValue/Code') AS DOMAIN_CODE,
EXTRACTVALUE(CodedValues.COLUMN_VALUE, 'CodedValue/Name') AS DOMAIN_DESCRIPTION
FROM
SDE.GDB_ITEMS_VW
JOIN SDE.GDB_ITEMTYPES
ON SDE.GDB_ITEMS_VW.Type = SDE.GDB_ITEMTYPES.UUID,
TABLE(XMLSEQUENCE(XMLType(Definition).Extract('/GPCodedValueDomain2/CodedValues/CodedValue'))) CodedValues
WHERE
SDE.GDB_ITEMS_VW.NAME = 'STRATEGY'
Or, as an alternative, would it be an acceptable practice to create a separate table that is related to the domain by the CODE value? And then join to it using the query mentioned above?