Changes between Version 19 and Version 20 of i2b2 Database Structure


Ignore:
Timestamp:
02/21/11 10:07:06 (14 years ago)
Author:
jeff.lusted
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 Database Structure

    v19 v20  
    6767   * 2nd character:    A = Active    I = Inactive     H = Hidden
    6868   * 3rd character:    E = editable
    69 '''C_TOTALNUM''': States not used, but suspect can be used in the latest version (for performance reasons?).[[br]]
     69'''C_TOTALNUM''': Not used, but suspect can be used in the latest version (for performance reasons?).[[br]]
    7070'''C_BASECODE''': the term that describes the ontological concept.[[br]]
    7171'''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]]
    … …  
    7373'''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]]
    7474'''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]]
    75 '''C_COLUMNDATATYPE''': either ‘T’ for text or ‘N’ for numeric and describes the datatype of the concept. Don't understand this fully. Questions raised on [[br]]
     75'''C_COLUMNDATATYPE''': either ‘T’ for text or ‘N’ for numeric and describes the datatype of the concept. Don't understand this fully. Jeff has questions about this.[[br]]
    7676'''C_OPERATOR''': the SQL operator used in the WHERE clause of the SQL query. It is usually either ‘LIKE’ or ‘=’.[[br]]
    7777'''C_DIMCODE''': the path that lives in the dimension table and maps to the concept path.[[br]]