Skip to main content
. 2021 Mar 26;117:103744. doi: 10.1016/j.jbi.2021.103744

Table 2.

Lab test in EHR represented as EAV data tables. ID - lab record ID; A - Attribute; V - Value.

Value type: text
Value type: numeric
Value type: date
ID A V ID A V ID A V
PT001-1 TEST CODE 26464-8 PT001-1 TEST RESULT 9.4 PT001-1 TEST DATE 2018-06-04
PT001-1 TEST NAME White blood cell PT001-2 TEST RESULT 99.0 PT001-2 TEST DATE 2019-08-05
PT001-1 TEST TYPE HEMAT PT002-1 TEST RESULT 96.0 PT001-3 TEST DATE 2020-05-21
PT001-1 TEST UNIT ×103/ul PT002-1 TEST DATE 2019-08-05