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