person_id |
int4 |
10 |
|
|
|
|
|
gender_concept_id |
int4 |
10 |
|
|
|
|
concept.concept_id
|
fpk_person_gender_concept R |
|
year_of_birth |
int4 |
10 |
|
|
|
|
|
month_of_birth |
int4 |
10 |
√ |
|
null |
|
|
day_of_birth |
int4 |
10 |
√ |
|
null |
|
|
birth_datetime |
timestamp |
29,6 |
√ |
|
null |
|
|
race_concept_id |
int4 |
10 |
|
|
|
|
concept.concept_id
|
fpk_person_race_concept R |
|
ethnicity_concept_id |
int4 |
10 |
|
|
|
|
concept.concept_id
|
fpk_person_ethnicity_concept R |
|
location_id |
int4 |
10 |
√ |
|
null |
|
location.location_id
|
fpk_person_location R |
|
provider_id |
int4 |
10 |
√ |
|
null |
|
provider.provider_id
|
fpk_person_provider R |
|
care_site_id |
int4 |
10 |
√ |
|
null |
|
care_site.care_site_id
|
fpk_person_care_site R |
|
person_source_value |
varchar |
50 |
√ |
|
null |
|
|
gender_source_value |
varchar |
50 |
√ |
|
null |
|
|
gender_source_concept_id |
int4 |
10 |
√ |
|
null |
|
concept.concept_id
|
fpk_person_gender_concept_s R |
|
race_source_value |
varchar |
50 |
√ |
|
null |
|
|
race_source_concept_id |
int4 |
10 |
√ |
|
null |
|
concept.concept_id
|
fpk_person_race_concept_s R |
|
ethnicity_source_value |
varchar |
50 |
√ |
|
null |
|
|
ethnicity_source_concept_id |
int4 |
10 |
√ |
|
null |
|
concept.concept_id
|
fpk_person_ethnicity_concept_s R |
|