Eureka! Clinical's extensions to the i2b2 metadata schema start from the i2b2 version 1.7 metadata schema. See the i2b2 metaschema changelog for database-agnostic DDL for these extensions.
Eureka! Clinical ontology tables contain one additional column over stock i2b2, EK_UNIQUE_ID, which is a VARCHAR with length 700. It is expected to be globally unique. We also index the column.
The additional tables are represented in the following model:
When i2b2 modifiers are specified as records in an i2b2 metadata table, there is insufficient metadata for Eureka! Clinical to map a modifier to a Eureka! Clinical property. The EK_MODIFIER_INTERP table annotates such modifier records to indicate the modifier to which they belong.
A transaction-scoped temporary table for caching EK_UNIQUE_ID values during retrieval of metadata.
A session-scoped temporary table for caching Eureka! Clinical property information during retrieval of metadata.