CCMDB Data Structure: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "Centralized data.mdb" to "Centralized data.accdb" |
||
| Line 3: | Line 3: | ||
== Actual Data == | == Actual Data == | ||
All of these are 1-many, except for the link between [[L_Log table]] and [[L_PHI table]], which is 1-to-1. The only reason for the split in table is for de-identification in the [[Centralized data. | All of these are 1-many, except for the link between [[L_Log table]] and [[L_PHI table]], which is 1-to-1. The only reason for the split in table is for de-identification in the [[Centralized data.accdb]]/[[PHI.mdb]], this data is all stored in [[L_Log]] in [[CCMDB.mdb]]. Also see [[Entity Relationship Diagram for the Critical Care and Medicine Database]] for a visual representation. | ||
* [[L_Log table]] links to the following on [[D_ID]] | * [[L_Log table]] links to the following on [[D_ID]] | ||
** [[L_PHI table]] | ** [[L_PHI table]] | ||