Changes between Version 35 and Version 36 of i2b2 Database Structure


Ignore:
Timestamp:
12/09/15 20:01:29 (9 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 Database Structure

    v35 v36  
    7575'''C_TOTALNUM''': Not used, but suspect can be used in the latest version (for performance reasons?).[[br]]
    7676'''C_BASECODE''': the term that describes the ontological concept.[[br]]
    77 '''C_METADATAXML''': an optional field to store extra information about the concept in xml format. It is currently used to describe value metadata associated with a lab finding. For further details, see [http://trac.briccs.org.uk/wiki/i2b2%20-%20Documents Documents page].Jeff  has points to make about this.[[br]]
     77'''C_METADATAXML''': an optional field to store extra information about the concept in xml format. see [[i2b2 Ontology c_metadataxml Column]].[[br]]
    7878'''C_FACTTABLECOLUMN''': name of the column in the CRC cell observation_fact table that holds the concept code.[[br]]
    7979'''C_TABLENAME''': name of the lookup table within the CRC cell that holds the concept code and concept path. In the top diagram this would be concept_dimension.[[br]]