CareKit
테이블 (14)
care_plan
- 아이디 (id) — integer — 기본 키 — 자동생성ID-Z_PK
- Z_ENT (zent) — integer — Z_ENT
- Z_OPT (zopt) — integer — Z_OPT
- Patient ID (patient_id) — integer — 외래 키 → 환자.아이디 — 환자 ID
- created_date — timestamp
- deleted_date — timestamp
- effective_date — timestamp
- updated_date — timestamp
- asset — varchar
- group_identifier — varchar
- zid — varchar
- remote_id — varchar
- schema_version — varchar
- source — varchar
- timezone_identifier — varchar
- title — varchar
- zuuid — uuid
- user_info — text
clock
- 아이디 (id) — integer — 기본 키 — 자동생성ID-Z_PK
- Z_ENT (zent) — integer — Z_ENT
- Z_OPT (zopt) — integer — Z_OPT
- zuuid — uuid
- vector_clock — text
knowledge_element
- 아이디 (id) — integer — 기본 키 — 자동생성ID-Z_PK
- Z_ENT (zent) — integer — Z_ENT
- Z_OPT (zopt) — integer — Z_OPT
- time — integer
- care_plan_id — integer
- contact_id — integer
- outcome_id — integer
- patient_id — integer
- task_id — integer
- task14_id — integer
- zuuid — uuid
note
- 아이디 (id) — integer — 기본 키 — 자동생성ID-Z_PK
- Z_ENT (zent) — integer — Z_ENT
- Z_OPT (zopt) — integer — Z_OPT
- contact_id — integer
- outcome_id — integer
- patient_id — integer
- plan_id — integer
- schedule_element_id — integer
- task_id — integer
- task14_id — integer
- author — varchar
- content — varchar
- title — varchar
tag
- 아이디 (id) — integer — 기본 키 — 자동생성ID-Z_PK
- Z_ENT (zent) — integer — Z_ENT
- Z_OPT (zopt) — integer — Z_OPT
- 태그 (title) — varchar — 태그
개인명 (person_name)
- 아이디 (id) — integer — 기본 키 — 자동생성ID-Z_PK
- Z_ENT (zent) — integer — Z_ENT
- Z_OPT (zopt) — integer — Z_OPT
- contact_id — integer
- parent_id — integer
- patient_id — integer
- phonetic_representation — integer
- family_name — varchar
- given_name — varchar
- middle_name — varchar
- name_prefix — varchar
- name_suffix — varchar
- nickname — varchar
수행결과 (outcome)
- 아이디 (id) — integer — 기본 키 — 자동생성ID-Z_PK
- Z_ENT (zent) — integer — Z_ENT
- Z_OPT (zopt) — integer — Z_OPT
- 타스크 아이디 (task_id) — integer — 외래 키 → 플랜타스크.아이디 — 타스트 ID
- task_occurrence_index — integer — 결과발생순번
- task14_id — integer
- created_date — timestamp
- deleted_date — timestamp
- effective_date — timestamp
- end_date — timestamp
- start_date — timestamp
- updated_date — timestamp
- asset — varchar
- group_identifier — varchar
- zid — varchar
- remote_id — varchar
- schema_version — varchar
- source — varchar
- timezone_identifier — varchar
- zuuid — uuid
- user_info — text
수행결과값 (outcome_value)
- 아이디 (id) — integer — 기본 키 — 자동생성ID-Z_PK
- Z_ENT (zent) — integer — Z_ENT
- Z_OPT (zopt) — integer — Z_OPT
- 수행결과ID (outcome_id) — integer — 외래 키 → 수행결과.아이디 — 수행결과ID
- 스케쥴ID (schedule_element_id) — integer — 외래 키 → 스케쥴.아이디 — 스케쥴ID
- boolean_value — integer
- integer_value — integer
- created_date — timestamp
- date_value — timestamp
- double_value — double
- kind — varchar
- text_value — varchar
- type_string — varchar
- units — varchar
- binary_value — bytea
스케쥴 (schedule_element)
- 아이디 (id) — integer — 기본 키 — 자동생성ID-Z_PK
- Z_ENT (zent) — integer — Z_ENT
- Z_OPT (zopt) — integer — Z_OPT
- is_allday — integer
- years_interval — integer
- months_interval — integer
- weeks_interval — integer
- days_interval — integer
- hours_interval — integer
- minutes_interval — integer
- seconds_interval — integer
- 타스크ID (task_id) — integer — 외래 키 → 플랜타스크.아이디 — 플랜 타스트 ID
- task14 — integer
- duration_in_seconds — double
- end_date — timestamp
- start_date — timestamp
- ztext — varchar
주소 (postal_address)
- 아이디 (id) — integer — 기본 키 — 자동생성ID-Z_PK
- Z_ENT (zent) — integer — Z_ENT
- zopt — integer
- contact ID (contact_id) — integer — 외래 키 → 플랜연락처.아이디 — Contact ID
- city — varchar
- country — varchar
- iso_country_code — varchar
- postalcode — varchar
- state — varchar
- street — varchar
- subadministrative_area — varchar
- sublocality — varchar
플랜연락처 (contact)
- 아이디 (id) — integer — 기본 키 — 자동생성ID-Z_PK
- Z_ENT (zent) — integer — Z_ENT
- Z_OPT (zopt) — integer — Z_OPT
- 대표 address ID (address_id) — integer — 대표주소
- 플랜ID (care_plan_id) — integer — 외래 키 → care_plan.아이디 — Care Plan ID
- 개인명 ID (name_id) — integer — 외래 키 → 개인명.아이디 — person name ID
- created_date — timestamp
- deleted_date — timestamp
- effective_date — timestamp
- updated_date — timestamp
- asset — varchar
- category — varchar
- group_identifier — varchar
- zid — varchar
- organization — varchar
- remote_id — varchar
- role — varchar
- schema_version — varchar
- source — varchar
- timezone_identifier — varchar
- title — varchar
- zuuid — uuid
- emailaddressesdictionary — text
- messagingnumbersdictionary — text
- othercontactinfodictionary — text
- phonenumbersdictionary — text
- user_info — text
플랜타스크 (taskbase)
- 아이디 (id) — integer — 기본 키 — 자동생성ID-Z_PK
- Z_ENT (zent) — integer — Z_ENT
- Z_OPT (zopt) — integer — Z_OPT
- impacts_adherence — integer
- Care Plan ID (care_plan_id) — integer — 외래 키 → care_plan.아이디 — Care 플랜 ID
- 헬스킷연결ID (healthkit_linkage_id) — integer — 외래 키 → 헬스킷연결.아이디 — 헬스킷연결
- created_date — timestamp
- deleted_date — timestamp
- effective_date — timestamp
- updated_date — timestamp
- asset — varchar
- group_identifier — varchar
- zid — varchar
- instructions — varchar
- remote_id — varchar
- schema_version — varchar
- source — varchar
- timezone_identifier — varchar
- title — varchar
- zuuid — uuid
- user_info — text
헬스킷연결 (healthkit_linkage)
- 아이디 (id) — integer — 기본 키 — 자동생성ID-Z_PK
- Z_ENT (zent) — integer — Z_ENT
- Z_OPT (zopt) — integer — Z_OPT
- 플랜task ID (task_id) — integer — 플랜 타스트 ID
- quantity_identifier — varchar
- quantity_type — varchar
- unit_string — varchar
환자 (patient)
- 아이디 (id) — integer — 기본 키 — 자동생성ID-Z_PK
- Z_ENT (zent) — integer — Z_ENT
- Z_OPT (zopt) — integer — Z_OPT
- name ID (name_id) — integer — 외래 키 → 개인명.아이디 — person_name 아이디
- birthday — timestamp
- created_date — timestamp
- deleted_date — timestamp
- effective_date — timestamp
- updated_date — timestamp
- asset — varchar
- group_identifier — varchar
- 관리환자ID (zid) — varchar — 사용자 관리 환자 ID
- remote_id — varchar
- schema_version — varchar
- sex — varchar
- source — varchar
- timezone_identifier — varchar
- zuuid — uuid
- allergies — text
- user_info — text