Table postgres.omop.provider
[SYSTEM] The PROVIDER table contains a list of uniquely identified healthcare providers. These are individuals providing hands-on healthcare to patients, such as physicians, nurses, midwives, physical therapists etc.

 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
provider_id int4 10
condition_occurrence.provider_id fpk_condition_provider R
device_exposure.provider_id fpk_device_provider R
drug_exposure.provider_id fpk_drug_provider R
measurement.provider_id fpk_measurement_provider R
note.provider_id fpk_note_provider R
observation.provider_id fpk_observation_provider R
person.provider_id fpk_person_provider R
procedure_occurrence.provider_id fpk_procedure_provider R
visit_detail.provider_id fpk_visit_provider R
visit_occurrence.provider_id fpk_visit_provider R
A unique identifier for each Provider.
provider_name varchar 255  √  null A description of the Provider.
npi varchar 20  √  null The National Provider Identifier (NPI) of the provider.
dea varchar 20  √  null The Drug Enforcement Administration (DEA) number of the provider.
specialty_concept_id int4 10  √  null
concept.concept_id fpk_provider_specialty R
A foreign key to a Standard Specialty Concept ID in the Standardized Vocabularies.
care_site_id int4 10  √  null
care_site.care_site_id fpk_provider_care_site R
A foreign key to the main Care Site where the provider is practicing.
year_of_birth int4 10  √  null The year of birth of the Provider.
gender_concept_id int4 10  √  null
concept.concept_id fpk_provider_gender R
The gender of the Provider.
provider_source_value varchar 50  √  null The identifier used for the Provider in the source data, stored here for reference.
specialty_source_value varchar 50  √  null The source code for the Provider specialty as it appears in the source data, stored here for reference.
specialty_source_concept_id int4 10  √  null
concept.concept_id fpk_provider_specialty_s R
A foreign key to a Concept that refers to the code used in the source.
gender_source_value varchar 50  √  null The gender code for the Provider as it appears in the source data, stored here for reference.
gender_source_concept_id int4 10  √  null
concept.concept_id fpk_provider_gender_s R
A foreign key to a Concept that refers to the code used in the source.

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

Indexes:
Column(s) Type Sort Constraint Name
provider_id Primary key Asc xpk_provider

Close relationships  within of separation: