L Log table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
m m
Line 1: Line 1:
'''L_Log''' is the main table where the basic patient information is stored. An entry is needed in L_Log in order to makes sense of entries in the other [[L-tables]].
<onlyinclude>'''L_Log''' is the main table where the basic patient information is stored. In the relational structure of our data, L_Log is the parent table to the other [[L-tables]].</onlyinclude>
 
As of [[CCMDB.mdb_Change_Log_2012#ver_2012-10-19|ver_2012-10-19]] the data for y/n drugs for [[pharmacy collection]] is also stored in L_Log. Each patient will have a yes or no for each of them, so from a relational data perspective it made sense to put them there.


== Data Structure ==
== Data Structure ==

Revision as of 09:22, 14 September 2016

L_Log is the main table where the basic patient information is stored. In the relational structure of our data, L_Log is the parent table to the other L-tables.

Data Structure

To see the data structure of this table, see most up-to-date ccmdb_data.mdb in Regional Server\data\Master CCMDB.mdb. More info about individual fields can be found via Category: L_Log table.

Retrieved from "https://ccmdb.kuality.ca/index.php?title=L_Log_table&oldid=49906"