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 |  |
|             +=================+  |
+----------------------------------+