Changes between Version 10 and Version 11 of i2b2 Database Structure

Timestamp:

02/21/11 08:51:12 (15 years ago)

Author:

jeff.lusted

Comment:

--

i2b2 Database Structure

@@ -1 +1 @@
 == i2b2 - DB Basics ==
 
+=== Structure ===
 This is a very bare basics. At this stage we should be primarily interested in the observation_fact table and its relationship with the concept_dimension table within the CRC Cell. And then the correspondence with any ontology tables within the Ontology Cell. Interest in the patient_dimension, visit_dimension and other of the tables within the CRC are a little further down the line.[[BR]]
 
@@ -29 +30 @@
 +----------------------------------+
 }}}
+=== Ontology Cell: DDL for Table ONYX ===
+{{{
+-- ORACLE --
+  CREATE TABLE ONYX 
+   (    "C_HLEVEL"           NUMBER(22,0)   NOT NULL, 
+        "C_FULLNAME"         VARCHAR2(700)  NOT NULL, 
+        "C_NAME"             VARCHAR2(2000) NOT NULL, 
+        "C_SYNONYM_CD"       CHAR(1)        NOT NULL, 
+        "C_VISUALATTRIBUTES" CHAR(3)        NOT NULL, 
+        "C_TOTALNUM"         NUMBER(22,0)   NULL, 
+        "C_BASECODE"         VARCHAR2(50)   NULL, 
+        "C_METADATAXML"      CLOB           NULL, 
+        "C_FACTTABLECOLUMN"  VARCHAR2(50)   NOT NULL, 
+        "C_TABLENAME"        VARCHAR2(50)   NOT NULL, 
+        "C_COLUMNNAME"       VARCHAR2(50)   NOT NULL, 
+        "C_COLUMNDATATYPE"   VARCHAR2(50)   NOT NULL, 
+        "C_OPERATOR"         VARCHAR2(10)   NOT NULL, 
+        "C_DIMCODE"          VARCHAR2(700)  NOT NULL, 
+        "C_COMMENT"          CLOB           NULL, 
+        "C_TOOLTIP"          VARCHAR2(900)  NULL, 
+        "UPDATE_DATE"        DATE           NOT NULL, 
+        "DOWNLOAD_DATE"      DATE           NULL, 
+        "IMPORT_DATE"        DATE           NULL, 
+        "SOURCESYSTEM_CD"    VARCHAR2(50)   NULL, 
+        "VALUETYPE_CD"       VARCHAR2(50)   NULL
+   ) ;
+}}}