Table postgres.omop.care_site
[SYSTEM] The CARE_SITE table contains a list of uniquely identified institutional (physical or organizational) units where healthcare delivery is practiced (offices, wards, hospitals, clinics, 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
care_site_id int4 10
person.care_site_id fpk_person_care_site R
provider.care_site_id fpk_provider_care_site R
visit_detail.care_site_id fpk_visit_care_site R
visit_occurrence.care_site_id fpk_visit_care_site R
A unique identifier for each Care Site.
care_site_name varchar 255  √  null The verbatim description or name of the Care Site as in data source
place_of_service_concept_id int4 10  √  null
concept.concept_id fpk_care_site_place R
A foreign key that refers to a Place of Service Concept ID in the Standardized Vocabularies.
location_id int4 10  √  null
location.location_id fpk_care_site_location R
A foreign key to the geographic Location in the LOCATION table, where the detailed address information is stored.
care_site_source_value varchar 50  √  null The identifier for the Care Site in the source data, stored here for reference.
place_of_service_source_value varchar 50  √  null The source code for the Place of Service as it appears in the source data, stored here for reference.

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

Indexes:
Column(s) Type Sort Constraint Name
care_site_id Primary key Asc xpk_care_site

Close relationships  within of separation: