CCMDB Data Structure: Difference between revisions

mNo edit summary
mNo edit summary
Line 14: Line 14:
** [[L_TISS Item table]]
** [[L_TISS Item table]]
** [[L_TmpV2 table]]
** [[L_TmpV2 table]]
** [[L_Labs_DSM table]] (in different file)
** [[L_TISS_Item]] (in different file)


====linking====
==== linking ====
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.mdb]]/[[PHI.mdb]], this data is all stored in [[L_Log]] in [[CCMDB.mdb]].
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.mdb]]/[[PHI.mdb]], this data is all stored in [[L_Log]] in [[CCMDB.mdb]].


=== support tables ===
=== support tables ===