Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
encounter_num |
numeric |
38 |
√ |
|
null |
|
|
patient_num |
numeric |
38 |
√ |
|
null |
|
|
concept_cd |
varchar |
50 |
√ |
|
null |
|
|
provider_id |
varchar |
50 |
√ |
|
null |
|
|
start_date |
timestamp |
29,6 |
√ |
|
null |
|
|
modifier_cd |
varchar |
100 |
√ |
|
null |
|
|
instance_num |
numeric |
18 |
√ |
|
null |
|
|
valtype_cd |
varchar |
50 |
√ |
|
null |
|
|
tval_char |
varchar |
255 |
√ |
|
null |
|
|
nval_num |
numeric |
18,5 |
√ |
|
null |
|
|
valueflag_cd |
varchar |
50 |
√ |
|
null |
|
|
quantity_num |
numeric |
18,5 |
√ |
|
null |
|
|
units_cd |
varchar |
50 |
√ |
|
null |
|
|
end_date |
timestamp |
29,6 |
√ |
|
null |
|
|
location_cd |
varchar |
50 |
√ |
|
null |
|
|
observation_blob |
text |
2147483647 |
√ |
|
null |
|
|
confidence_num |
numeric |
18,5 |
√ |
|
null |
|
|
update_date |
timestamp |
29,6 |
√ |
|
null |
|
|
download_date |
timestamp |
29,6 |
√ |
|
null |
|
|
import_date |
timestamp |
29,6 |
√ |
|
null |
|
|
sourcesystem_cd |
varchar |
50 |
√ |
|
null |
|
|
upload_id |
numeric |
38 |
√ |
|
null |
|
|
archive_upload_id |
numeric |
22 |
√ |
|
null |
|
|
Table contained 0 rows at Wed Jun 26 00:11 CEST 2019
|