Changes between Version 3 and Version 4 of i2b2 Database Structure

Timestamp:

02/20/11 21:53:13 (14 years ago)

Author:

jeff.lusted

Comment:

--

i2b2 Database Structure

@@ -4 +4 @@
 
 {{{
-+-------------CRC Cell-------------+   +-----------Ontology Cell--------------+
-|                                  |   |                                      
-|                                  |   |
-|        +===================+     |   |     +=====================+
-|        | concept_dimension |<<<--------->>>| an ontology table   |  
-|        +=========^=========+     |   |     +======================+
-|                  |               |   |
-|                  |               |   |
-|                  |               |   |
-|        +=========^=========+     |   |     +======================+
-|        | observation_fact  |     |   |     |   table_access       
-|        +===V===========V===+     |   |     +======================
-|            |           |         |
-|            |           |         |
-| +==========V========+  |         |
-| | patient_dimension |  |         |
-| +===================+  |         |
-|                        |         |
++-------------CRC Cell-------------+   +-----------Ontology Cell---------+
+|                                  |   |                                 |        
+|                                  |   |                                 |
+|        +===================+     |   |     +=====================+     |
+|        | concept_dimension |<<<=========>>>| an ontology table   |>:   | 
+|        +=========^=========+     |   |     +==========^==========+ :   |
+|                  |               |   |                |            :   |
+|                  |               |   |                |            :   |
+|                  |               |   |                |            :   |
+|        +=========^=========+     |   |     +==========^==========+ :   |
+|        | observation_fact  |     |   |     |   table_access      | :   | 
+|        +===V===========V===+     |   |     +=====================+ :   |
+|            |           |         |   |                             :   |
+|            |           |         |   +-----------------------------:---+
+| +==========V========+  |         |                                 :
+| | patient_dimension |  |         |           +------------+        :
+| +===================+  |         |<<<<<<<<<<<| QUERY TOOL |<<<<<<<<:
+|                        |         |           +------------+  
 |             +==========V======+  |
 |             | visit_dimension |  |