General Knowledge
The table that contains our users' email addresses and authentication information.
What is user_user?
The acronym FHIR is a concise way of expressing this statement.
What are Fast Health Interoperability Resources?
This FHIR table stores patient profile information.
What is fhir_patient?
This table represents visits (and subvisits pertaining to particular health topics).
What is fhir_encounter?
This field on Observations is used to track how a finding was elicited (e.g. RFE extraction, manual KB search, AR, etc).
What is method?
The table that contains our chat messages.
What is chat_message_2?
At Curai, our FHIR data is stored in this format (which is one of at least 4 different options officially supported by the spec).
What is JSON?
This FHIR table stores health coach and doctor information - including role, qualifications, and biodata.
What is fhir_practitioner?
This table represents findings and symptoms.
What is fhir_observation?
Episode-of-care specific follow-ups used to be stored on encounters, but are now stored on this resource.
What is a CarePlan?
These tables are foreign-keyed back to the user_user table, and delineate patient and HC / doctor profiles. Coincidentally (or not), both are deprecated as far as information storage and retrieval is concerned.
What are user_customer and user_professional?
All FHIR resources have some basic properties, such as id, meta, and this array field which allows you to persist data that isn't part of the official resource specification.
What are extensions?
This client library is used to serialize and deserialize our data to and from Python classes.
What is the Smart-on-FHIR `fhirclient` library?
This table represents diagnoses, and is used for two purposes: naming episodes of care (via reference), and logging per-encounter differential diagnoses (via reference, with rank).
What is fhir_condition?
What is a DiagnosticReport?
When in the IN_CHAT_HC_FOP state (e.g. prime encounter, chatting with health coach), this is how many state transitions are possible.
What is 3?
(escalate, transfer, close)
At Curai, we use transactions to handle two things. One is an audit trail - the other is a term for when two people try to edit a resource concurrently.
What is contention?
These helpers back-populate FHIR patient and practitioner data.
What are backfill_fhir_patient and backfill_fhir_practitioner?
This relational DB term (abused slightly since we're storing documents) accurately describes the relationships between episodes of care and encounters.
What is many-to-many?
What is statusHistory?
These three columns are present on all Curai Health PostgreSQL tables, FHIR or not.
What are _id, _created, and _updated?
FHIR references usually have two fields - a "type" field, used to denote which resource type we are linking to, and this field, which identifies (hehe) the resource uniquely.
What is "identifier"?
These top-level fields on patient profiles are lists, much to JS developers' chagrin.
What are name and address?
To accurately retrieve a list of mother encounters, you must only include encounters where this nested field is null.
What is partOf?
When a medication request or lab order is first sent to the patient for confirmation, it is in this state.
What is "draft"?