note_id |
int4 |
10 |
|
|
|
|
|
person_id |
int4 |
10 |
|
|
|
|
person.person_id
|
fpk_note_person R |
|
note_date |
date |
13 |
|
|
|
|
|
note_datetime |
timestamp |
29,6 |
√ |
|
null |
|
|
note_type_concept_id |
int4 |
10 |
|
|
|
|
concept.concept_id
|
fpk_note_type_concept R |
|
note_class_concept_id |
int4 |
10 |
|
|
|
|
concept.concept_id
|
fpk_note_class_concept R |
|
note_title |
varchar |
250 |
√ |
|
null |
|
|
note_text |
text |
2147483647 |
|
|
|
|
|
encoding_concept_id |
int4 |
10 |
|
|
|
|
concept.concept_id
|
fpk_note_encoding_concept R |
|
language_concept_id |
int4 |
10 |
|
|
|
|
concept.concept_id
|
fpk_language_concept R |
|
provider_id |
int4 |
10 |
√ |
|
null |
|
provider.provider_id
|
fpk_note_provider R |
|
visit_occurrence_id |
int4 |
10 |
√ |
|
null |
|
|
note_source_value |
varchar |
50 |
√ |
|
null |
|
|
visit_detail_id |
int4 |
10 |
√ |
|
null |
|
|