wiki:i2b2 Database Structure

Version 1 (modified by jeff.lusted, 13 years ago) ( diff )

--

i2b2 - DB Basics

This is a very bare basics. I'm only interested at present 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. 

+--------------CRC Cell----------------+
|
|
|        +===================+ 
|        | concept_dimension |
|        +=========^=========+
|                  |
|                  |
|                  |
|        +=========^=========+
|        | observation_fact  |
|        +===V===========V===+  
|            |           |
|            |           |
| +==========V========+  |
| | patient_dimension |  |
| +===================+  |
|                        |
|             +==========V======+
|             | visit_dimension |
|             +=================+
Note: See TracWiki for help on using the wiki.