Changes between Version 21 and Version 22 of i2b2 Database Structure

Timestamp:

02/21/11 10:19:34 (14 years ago)

Author:

jeff.lusted

Comment:

--

i2b2 Database Structure

@@ -78 +78 @@
 
 === CRC Cell: DDL for Table concept_dimension ===
+The following sentences are from the design document...[[br]]
+The concept_dimension table contains one row for each concept. Possible
+concept types are diagnoses, procedures, medications and lab tests. The structure
+of the table gives enough flexibility to store virtually any concept type, such as
+demographics and genetics data.
 {{{
 -- Oracle -- 
@@ -93 +98 @@
 ) ;     
 }}}
+The design document also states that the concept_dimension table has three required columns:
+   1. concept_path: path that delineates the concept’s hierarchy.
+   1. concept_cd: code that represents the diagnosis, procedure, or any other coded value.
+   1. name_char: name of the concept.
 
+