| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| encounter_num |
int8 |
19 |
√ |
|
null |
|
|
| patient_num |
int8 |
19 |
√ |
|
null |
|
|
| concept_cd |
varchar |
50 |
|
|
|
|
|
| provider_id |
varchar |
50 |
|
|
|
|
|
| start_date |
timestamp |
29,6 |
√ |
|
null |
|
|
| modifier_cd |
varchar |
100 |
√ |
|
null |
|
|
| valtype_cd |
varchar |
50 |
√ |
|
null |
|
|
| tval_char |
varchar |
255 |
√ |
|
null |
|
|
| nval_num |
float8 |
17,17 |
√ |
|
null |
|
|
| valueflag_cd |
varchar |
50 |
√ |
|
null |
|
|
| quantity_num |
float8 |
17,17 |
√ |
|
null |
|
|
| units_cd |
varchar |
50 |
√ |
|
null |
|
|
| end_date |
timestamp |
29,6 |
√ |
|
null |
|
|
| location_cd |
varchar |
50 |
|
|
|
|
|
| confidence_num |
int8 |
19 |
√ |
|
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 |
int8 |
19 |
√ |
|
null |
|
|
| observation_blob |
text |
2147483647 |
√ |
|
null |
|
|
| release_study |
varchar |
100 |
√ |
|
null |
|
|
Table contained 0 rows at Wed Jun 26 00:11 CEST 2019
|