Table postgres.omop.location
[SYSTEM] The LOCATION table represents a generic way to capture physical location or address information of Persons and Care Sites.

 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
location_id int4 10
care_site.location_id fpk_care_site_location R
person.location_id fpk_person_location R
A unique identifier for each geographic location.
address_1 varchar 50  √  null The address field 1, typically used for the street address, as it appears in the source data.
address_2 varchar 50  √  null The address field 2, typically used for additional detail such as buildings, suites, floors, as it appears in the source data.
city varchar 50  √  null The city field as it appears in the source data.
state varchar 2  √  null The state field as it appears in the source data.
zip varchar 9  √  null The zip or postal code.
county varchar 20  √  null The county.
location_source_value varchar 50  √  null The verbatim information that is used to uniquely identify the location as it appears in the source data.

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

Indexes:
Column(s) Type Sort Constraint Name
location_id Primary key Asc xpk_location

Close relationships  within of separation: