Changes between Version 20 and Version 21 of i2b2 Database Structure

Timestamp:

02/21/11 10:13:02 (13 years ago)

Author:

jeff.lusted

Comment:

--

i2b2 Database Structure

@@ -69 +69 @@
 '''C_TOTALNUM''': Not used, but suspect can be used in the latest version (for performance reasons?).[[br]]
 '''C_BASECODE''': the term that describes the ontological concept.[[br]]
-'''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]]
+'''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]]
 '''C_FACTTABLECOLUMN''': name of the column in the CRC cell observation_fact table that holds the concept code.[[br]]
 '''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]]
@@ -77 +77 @@
 '''C_DIMCODE''': the path that lives in the dimension table and maps to the concept path.[[br]]
 
+=== CRC Cell: DDL for Table concept_dimension ===
+{{{
+-- Oracle -- 
+CREATE TABLE CONCEPT_DIMENSION ( 
+        CONCEPT_CD          VARCHAR2(50)   NOT NULL,
+        CONCEPT_PATH        VARCHAR2(700)  NOT NULL,
+        NAME_CHAR           VARCHAR2(2000) NULL,
+        CONCEPT_BLOB        CLOB           NULL,
+        UPDATE_DATE         DATE           NULL,
+        DOWNLOAD_DATE       DATE           NULL,
+        IMPORT_DATE         DATE           NULL,
+        SOURCESYSTEM_CD     VARCHAR2(50)   NULL,
+        UPLOAD_ID           NUMBER(38,0)   NULL,
+    CONSTRAINT CONCEPT_DIMENSION_PK PRIMARY KEY(CONCEPT_PATH)
+) ;     
+}}}
 
-