Table postgres.omop.note_nlp
[CLINICAL] The NOTE_NLP table will encode all output of NLP on clinical notes. Each row represents a single extracted term from a note.

 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_nlp_id int8 19 A unique identifier for each term extracted from a note.
note_id int4 10
note.note_id fpk_note_nlp_note R
A foreign key to the Note table note the term was extracted from.
section_concept_id int4 10  √  null
concept.concept_id fpk_note_nlp_section_concept R
A foreign key to the predefined Concept in the Standardized Vocabularies representing the section of the extracted term.
snippet varchar 250  √  null A small window of text surrounding the term.
offset varchar 250  √  null Character offset of the extracted term in the input note.
lexical_variant varchar 250 Raw text extracted from the NLP tool.
note_nlp_concept_id int4 10  √  null
concept.concept_id fpk_note_nlp_concept R
A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the normalized concept for the extracted term. Domain of the term is represented as part of the Concept table.
note_nlp_source_concept_id int4 10  √  null A foreign key to a Concept that refers to the code in the source vocabulary used by the NLP system
nlp_system varchar 250  √  null Name and version of the NLP system that extracted the term.Useful for data provenance.
nlp_date date 13 The date of the note processing.Useful for data provenance.
nlp_datetime timestamp 29,6  √  null The date and time of the note processing. Useful for data provenance.
term_exists varchar 1  √  null A summary modifier that signifies presence or absence of the term for a given patient. Useful for quick querying. *
term_temporal varchar 50  √  null
term_modifiers varchar 2000  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
note_nlp_id Primary key Asc xpk_note_nlp
note_nlp_concept_id Performance Asc idx_note_nlp_concept_id
note_id Performance Asc idx_note_nlp_note_id

Close relationships  within of separation: