Changes between Version 17 and Version 18 of i2b2 Database Structure


Ignore:
Timestamp:
02/21/11 09:58:54 (14 years ago)
Author:
jeff.lusted
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 Database Structure

    v17 v18  
    6868'''C_TOTALNUM''': States not used, but suspect can be used in the latest version (for performance reasons?).[[br]]
    6969'''C_BASECODE''': the term that describes the ontological concept.[[br]]
    70 '''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].
     70'''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].[[br]]
     71'''C_FACTTABLECOLUMN''': name of the column in the CRC cell observation_fact table that holds the concept code.[[br]]
     72'''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]]
     73'''C_COLUMNNAME''': the name of the column within the table described by C_TABLENAME that holds the concept path. In the top diagram this would be the column within the concept_dimension table, which in our case is called CONCEPT_PATH. See below. [[BR]]
     74
     75