Changes between Version 18 and Version 19 of i2b2 Database Structure

Timestamp:

02/21/11 10:05:21 (14 years ago)

Author:

jeff.lusted

Comment:

--

i2b2 Database Structure

@@ -58 +58 @@
    ) ;
 }}}
+These are worth highlighting...[[br]]
 '''C_HLEVEL''': hierarchical level in the tree. 0,1,2 etc[[br]]
 '''C_FULLNAME''': full path within the tree.[[br]]
@@ -72 +73 @@
 '''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]]
 '''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]]
+'''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]]
+'''C_OPERATOR''': the SQL operator used in the WHERE clause of the SQL query. It is usually either ‘LIKE’ or ‘=’.[[br]]
+'''C_DIMCODE''': the path that lives in the dimension table and maps to the concept path.[[br]]
 
 
+