Table postgres.omop.note
[CLINICAL] The NOTE table captures unstructured information that was recorded by a provider about a patient in free text notes on a given date.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
note_id int4 10
note_nlp.note_id fpk_note_nlp_note R
A unique identifier for each note.
person_id int4 10
person.person_id fpk_note_person R
A foreign key identifier to the Person about whom the Note was recorded. The demographic details of that Person are stored in the PERSON table.
note_date date 13 The date the note was recorded.
note_datetime timestamp 29,6  √  null The date and time the note was recorded.
note_type_concept_id int4 10
concept.concept_id fpk_note_type_concept R
A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the type, origin or provenance of the Note.
note_class_concept_id int4 10
concept.concept_id fpk_note_class_concept R
A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the HL7 LOINC Document Type Vocabulary classification of the note.
note_title varchar 250  √  null The title of the Note as it appears in the source.
note_text text 2147483647 The content of the Note.
encoding_concept_id int4 10
concept.concept_id fpk_note_encoding_concept R
A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the note character encoding type
language_concept_id int4 10
concept.concept_id fpk_language_concept R
A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the language of the note
provider_id int4 10  √  null
provider.provider_id fpk_note_provider R
A foreign key to the Provider in the PROVIDER table who took the Note.
visit_occurrence_id int4 10  √  null
visit_occurrence.visit_occurrence_id fpk_note_visit R
Foreign key to the Visit in the VISIT_OCCURRENCE table when the Note was taken.
note_source_value varchar 50  √  null The source value associated with the origin of the note
visit_detail_id int4 10  √  null
visit_detail.visit_detail_id fpk_note_visit_detail R

Table contained 0 rows at dim. sept. 10 20:08 CEST 2017

Indexes:
Column(s) Type Sort Constraint Name
note_id Primary key Asc xpk_note
note_type_concept_id Performance Asc idx_note_concept_id
person_id Performance Asc idx_note_person_id
visit_detail_id Performance Asc idx_note_visit_detail_id
visit_occurrence_id Performance Asc idx_note_visit_id

Close relationships  within of separation: