CREATE INDEX CONCURRENTLYIF NOT EXISTS account_resource__ginON"account"USING GIN (resource);
Search parameter: Account.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS account_resource__name_gin_trgmON"account"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
Search parameter: Account.period
CREATE INDEX CONCURRENTLYIF NOT EXISTS account_resource__period_maxON"account"USING btree (knife_extract_max_timestamptz(resource, '[["servicePeriod","start"],["servicePeriod","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS account_resource__period_minON"account"USING btree (knife_extract_min_timestamptz(resource, '[["servicePeriod","start"],["servicePeriod","end"]]'));
ActivityDefinition
Search parameter: ActivityDefinition.publisher
CREATE INDEX CONCURRENTLYIF NOT EXISTS activitydefinition_resource__publisher_gin_trgmON"activitydefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["publisher"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS activitydefinition_resource__ginON"activitydefinition"USING GIN (resource);
Search parameter: ActivityDefinition.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS activitydefinition_resource__name_gin_trgmON"activitydefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
Search parameter: ActivityDefinition.title
CREATE INDEX CONCURRENTLYIF NOT EXISTS activitydefinition_resource__title_gin_trgmON"activitydefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["title"]]$JSON$))) gin_trgm_ops);
Search parameter: ActivityDefinition.description
CREATE INDEX CONCURRENTLYIF NOT EXISTS activitydefinition_resource__description_gin_trgmON"activitydefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS activitydefinition_resource__context_quantity_maxON"activitydefinition"USING btree (knife_extract_max_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS activitydefinition_resource__context_quantity_minON"activitydefinition"USING btree (knife_extract_min_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));
Search parameter: ActivityDefinition.effective
CREATE INDEX CONCURRENTLYIF NOT EXISTS activitydefinition_resource__effective_maxON"activitydefinition"USING btree (knife_extract_max_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS activitydefinition_resource__effective_minON"activitydefinition"USING btree (knife_extract_min_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));
Search parameter: ActivityDefinition.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS activitydefinition_resource__date_maxON"activitydefinition"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS activitydefinition_resource__date_minON"activitydefinition"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS adverseevent_resource__ginON"adverseevent"USING GIN (resource);
Search parameter: AdverseEvent.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS adverseevent_resource__date_maxON"adverseevent"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS adverseevent_resource__date_minON"adverseevent"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS allergyintolerance_resource__ginON"allergyintolerance"USING GIN (resource);
Search parameter: AllergyIntolerance.last-date
CREATE INDEX CONCURRENTLYIF NOT EXISTS allergyintolerance_resource__last_date_maxON"allergyintolerance"USING btree (knife_extract_max_timestamptz(resource, '[["lastOccurrence"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS allergyintolerance_resource__last_date_minON"allergyintolerance"USING btree (knife_extract_min_timestamptz(resource, '[["lastOccurrence"]]'));
Search parameter: AllergyIntolerance.onset
CREATE INDEX CONCURRENTLYIF NOT EXISTS allergyintolerance_resource__onset_maxON"allergyintolerance"USING btree (knife_extract_max_timestamptz(resource, '[["reaction","onset"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS allergyintolerance_resource__onset_minON"allergyintolerance"USING btree (knife_extract_min_timestamptz(resource, '[["reaction","onset"]]'));
Search parameter: AllergyIntolerance.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS allergyintolerance_resource__date_maxON"allergyintolerance"USING btree (knife_extract_max_timestamptz(resource, '[["recordedDate"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS allergyintolerance_resource__date_minON"allergyintolerance"USING btree (knife_extract_min_timestamptz(resource, '[["recordedDate"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS appointment_resource__ginON"appointment"USING GIN (resource);
Search parameter: Appointment.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS appointment_resource__date_maxON"appointment"USING btree (knife_extract_max_timestamptz(resource, '[["start"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS appointment_resource__date_minON"appointment"USING btree (knife_extract_min_timestamptz(resource, '[["start"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS auditevent_resource__ginON"auditevent"USING GIN (resource);
Search parameter: AuditEvent.address
CREATE INDEX CONCURRENTLYIF NOT EXISTS auditevent_resource__address_gin_trgmON"auditevent"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["agent","network","address"]]$JSON$))) gin_trgm_ops);
Search parameter: AuditEvent.entity-name
CREATE INDEX CONCURRENTLYIF NOT EXISTS auditevent_resource__entity_name_gin_trgmON"auditevent"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["entity","name"]]$JSON$))) gin_trgm_ops);
Search parameter: AuditEvent.agent-name
CREATE INDEX CONCURRENTLYIF NOT EXISTS auditevent_resource__agent_name_gin_trgmON"auditevent"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["agent","name"]]$JSON$))) gin_trgm_ops);
Search parameter: AuditEvent.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS auditevent_resource__date_maxON"auditevent"USING btree (knife_extract_max_timestamptz(resource, '[["recorded"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS auditevent_resource__date_minON"auditevent"USING btree (knife_extract_min_timestamptz(resource, '[["recorded"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS basic_resource__ginON"basic"USING GIN (resource);
Search parameter: Basic.created
CREATE INDEX CONCURRENTLYIF NOT EXISTS basic_resource__created_maxON"basic"USING btree (knife_extract_max_timestamptz(resource, '[["created"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS basic_resource__created_minON"basic"USING btree (knife_extract_min_timestamptz(resource, '[["created"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS bodystructure_resource__ginON"bodystructure"USING GIN (resource);
Bundle
Search parameter: Bundle.type, Bundle.identifier
CREATE INDEX CONCURRENTLYIF NOT EXISTS bundle_resource__ginON"bundle"USING GIN (resource);
Search parameter: Bundle.composition
NOT SUPPORTED
Search parameter: Bundle.message
NOT SUPPORTED
Search parameter: Bundle.timestamp
CREATE INDEX CONCURRENTLYIF NOT EXISTS bundle_resource__timestamp_maxON"bundle"USING btree (knife_extract_max_timestamptz(resource, '[["timestamp"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS bundle_resource__timestamp_minON"bundle"USING btree (knife_extract_min_timestamptz(resource, '[["timestamp"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS careplan_resource__ginON"careplan"USING GIN (resource);
Search parameter: CarePlan.activity-date
CREATE INDEX CONCURRENTLYIF NOT EXISTS careplan_resource__activity_date_maxON"careplan"USING btree (knife_extract_max_timestamptz(resource, '[["activity","detail","scheduled","Period","start"],["activity","detail","scheduled","Period","end"],["activity","detail","scheduled","string"],["activity","detail","scheduled","Timing","event"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS careplan_resource__activity_date_minON"careplan"USING btree (knife_extract_min_timestamptz(resource, '[["activity","detail","scheduled","Period","start"],["activity","detail","scheduled","Period","end"],["activity","detail","scheduled","string"],["activity","detail","scheduled","Timing","event"]]'));
Search parameter: CarePlan.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS careplan_resource__date_maxON"careplan"USING btree (knife_extract_max_timestamptz(resource, '[["period","start"],["period","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS careplan_resource__date_minON"careplan"USING btree (knife_extract_min_timestamptz(resource, '[["period","start"],["period","end"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS careteam_resource__ginON"careteam"USING GIN (resource);
Search parameter: CareTeam.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS careteam_resource__date_maxON"careteam"USING btree (knife_extract_max_timestamptz(resource, '[["period","start"],["period","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS careteam_resource__date_minON"careteam"USING btree (knife_extract_min_timestamptz(resource, '[["period","start"],["period","end"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS chargeitem_resource__ginON"chargeitem"USING GIN (resource);
Search parameter: ChargeItem.entered-date
CREATE INDEX CONCURRENTLYIF NOT EXISTS chargeitem_resource__entered_date_maxON"chargeitem"USING btree (knife_extract_max_timestamptz(resource, '[["enteredDate"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS chargeitem_resource__entered_date_minON"chargeitem"USING btree (knife_extract_min_timestamptz(resource, '[["enteredDate"]]'));
Search parameter: ChargeItem.price-override
CREATE INDEX CONCURRENTLYIF NOT EXISTS chargeitem_resource__price_override_maxON"chargeitem"USING btree (knife_extract_max_numeric(resource, '[["priceOverride","value"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS chargeitem_resource__price_override_minON"chargeitem"USING btree (knife_extract_min_numeric(resource, '[["priceOverride","value"]]'));
Search parameter: ChargeItem.quantity
CREATE INDEX CONCURRENTLYIF NOT EXISTS chargeitem_resource__quantity_maxON"chargeitem"USING btree (knife_extract_max_numeric(resource, '[["quantity","value"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS chargeitem_resource__quantity_minON"chargeitem"USING btree (knife_extract_min_numeric(resource, '[["quantity","value"]]'));
Search parameter: ChargeItem.occurrence
CREATE INDEX CONCURRENTLYIF NOT EXISTS chargeitem_resource__occurrence_maxON"chargeitem"USING btree (knife_extract_max_timestamptz(resource, '[["occurrence","Period","start"],["occurrence","Period","end"],["occurrence","dateTime"],["occurrence","Timing","event"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS chargeitem_resource__occurrence_minON"chargeitem"USING btree (knife_extract_min_timestamptz(resource, '[["occurrence","Period","start"],["occurrence","Period","end"],["occurrence","dateTime"],["occurrence","Timing","event"]]'));
Search parameter: ChargeItem.factor-override
CREATE INDEX CONCURRENTLYIF NOT EXISTS chargeitem_resource__factor_override_maxON"chargeitem"USING btree (knife_extract_max_numeric(resource, '[["factorOverride"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS chargeitem_resource__factor_override_minON"chargeitem"USING btree (knife_extract_min_numeric(resource, '[["factorOverride"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS chargeitemdefinition_resource__ginON"chargeitemdefinition"USING GIN (resource);
Search parameter: ChargeItemDefinition.publisher
CREATE INDEX CONCURRENTLYIF NOT EXISTS chargeitemdefinition_resource__publisher_gin_trgmON"chargeitemdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["publisher"]]$JSON$))) gin_trgm_ops);
Search parameter: ChargeItemDefinition.title
CREATE INDEX CONCURRENTLYIF NOT EXISTS chargeitemdefinition_resource__title_gin_trgmON"chargeitemdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["title"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS chargeitemdefinition_resource__description_gin_trgmON"chargeitemdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
Search parameter: ChargeItemDefinition.effective
CREATE INDEX CONCURRENTLYIF NOT EXISTS chargeitemdefinition_resource__effective_maxON"chargeitemdefinition"USING btree (knife_extract_max_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS chargeitemdefinition_resource__effective_minON"chargeitemdefinition"USING btree (knife_extract_min_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS chargeitemdefinition_resource__context_quantity_maxON"chargeitemdefinition"USING btree (knife_extract_max_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS chargeitemdefinition_resource__context_quantity_minON"chargeitemdefinition"USING btree (knife_extract_min_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));
Search parameter: ChargeItemDefinition.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS chargeitemdefinition_resource__date_maxON"chargeitemdefinition"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS chargeitemdefinition_resource__date_minON"chargeitemdefinition"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS claim_resource__ginON"claim"USING GIN (resource);
Search parameter: Claim.created
CREATE INDEX CONCURRENTLYIF NOT EXISTS claim_resource__created_maxON"claim"USING btree (knife_extract_max_timestamptz(resource, '[["created"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS claim_resource__created_minON"claim"USING btree (knife_extract_min_timestamptz(resource, '[["created"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS claimresponse_resource__ginON"claimresponse"USING GIN (resource);
Search parameter: ClaimResponse.disposition
CREATE INDEX CONCURRENTLYIF NOT EXISTS claimresponse_resource__disposition_gin_trgmON"claimresponse"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["disposition"]]$JSON$))) gin_trgm_ops);
Search parameter: ClaimResponse.payment-date
CREATE INDEX CONCURRENTLYIF NOT EXISTS claimresponse_resource__payment_date_maxON"claimresponse"USING btree (knife_extract_max_timestamptz(resource, '[["payment","date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS claimresponse_resource__payment_date_minON"claimresponse"USING btree (knife_extract_min_timestamptz(resource, '[["payment","date"]]'));
Search parameter: ClaimResponse.created
CREATE INDEX CONCURRENTLYIF NOT EXISTS claimresponse_resource__created_maxON"claimresponse"USING btree (knife_extract_max_timestamptz(resource, '[["created"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS claimresponse_resource__created_minON"claimresponse"USING btree (knife_extract_min_timestamptz(resource, '[["created"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS clinicalimpression_resource__ginON"clinicalimpression"USING GIN (resource);
Search parameter: ClinicalImpression.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS clinicalimpression_resource__date_maxON"clinicalimpression"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS clinicalimpression_resource__date_minON"clinicalimpression"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CodeSystem
Search parameter: CodeSystem.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS codesystem_resource__name_gin_trgmON"codesystem"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS codesystem_resource__ginON"codesystem"USING GIN (resource);
Search parameter: CodeSystem.description
CREATE INDEX CONCURRENTLYIF NOT EXISTS codesystem_resource__description_gin_trgmON"codesystem"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
Search parameter: CodeSystem.title
CREATE INDEX CONCURRENTLYIF NOT EXISTS codesystem_resource__title_gin_trgmON"codesystem"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["title"]]$JSON$))) gin_trgm_ops);
Search parameter: CodeSystem.publisher
CREATE INDEX CONCURRENTLYIF NOT EXISTS codesystem_resource__publisher_gin_trgmON"codesystem"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["publisher"]]$JSON$))) gin_trgm_ops);
Search parameter: CodeSystem.context-quantity
CREATE INDEX CONCURRENTLYIF NOT EXISTS codesystem_resource__context_quantity_maxON"codesystem"USING btree (knife_extract_max_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS codesystem_resource__context_quantity_minON"codesystem"USING btree (knife_extract_min_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));
Search parameter: CodeSystem.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS codesystem_resource__date_maxON"codesystem"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS codesystem_resource__date_minON"codesystem"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS communication_resource__ginON"communication"USING GIN (resource);
Search parameter: Communication.received
CREATE INDEX CONCURRENTLYIF NOT EXISTS communication_resource__received_maxON"communication"USING btree (knife_extract_max_timestamptz(resource, '[["received"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS communication_resource__received_minON"communication"USING btree (knife_extract_min_timestamptz(resource, '[["received"]]'));
Search parameter: Communication.sent
CREATE INDEX CONCURRENTLYIF NOT EXISTS communication_resource__sent_maxON"communication"USING btree (knife_extract_max_timestamptz(resource, '[["sent"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS communication_resource__sent_minON"communication"USING btree (knife_extract_min_timestamptz(resource, '[["sent"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS communicationrequest_resource__ginON"communicationrequest"USING GIN (resource);
Search parameter: CommunicationRequest.authored
CREATE INDEX CONCURRENTLYIF NOT EXISTS communicationrequest_resource__authored_maxON"communicationrequest"USING btree (knife_extract_max_timestamptz(resource, '[["authoredOn"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS communicationrequest_resource__authored_minON"communicationrequest"USING btree (knife_extract_min_timestamptz(resource, '[["authoredOn"]]'));
Search parameter: CommunicationRequest.occurrence
CREATE INDEX CONCURRENTLYIF NOT EXISTS communicationrequest_resource__occurrence_maxON"communicationrequest"USING btree (knife_extract_max_timestamptz(resource, '[["occurrence","dateTime"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS communicationrequest_resource__occurrence_minON"communicationrequest"USING btree (knife_extract_min_timestamptz(resource, '[["occurrence","dateTime"]]'));
CompartmentDefinition
Search parameter: CompartmentDefinition.publisher
CREATE INDEX CONCURRENTLYIF NOT EXISTS compartmentdefinition_resource__publisher_gin_trgmON"compartmentdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["publisher"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS compartmentdefinition_resource__ginON"compartmentdefinition"USING GIN (resource);
Search parameter: CompartmentDefinition.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS compartmentdefinition_resource__name_gin_trgmON"compartmentdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS compartmentdefinition_resource__description_gin_trgmON"compartmentdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS compartmentdefinition_resource__context_quantity_maxON"compartmentdefinition"USING btree (knife_extract_max_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS compartmentdefinition_resource__context_quantity_minON"compartmentdefinition"USING btree (knife_extract_min_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));
Search parameter: CompartmentDefinition.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS compartmentdefinition_resource__date_maxON"compartmentdefinition"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS compartmentdefinition_resource__date_minON"compartmentdefinition"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS composition_resource__ginON"composition"USING GIN (resource);
Search parameter: Composition.title
CREATE INDEX CONCURRENTLYIF NOT EXISTS composition_resource__title_gin_trgmON"composition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["title"]]$JSON$))) gin_trgm_ops);
Search parameter: Composition.period
CREATE INDEX CONCURRENTLYIF NOT EXISTS composition_resource__period_maxON"composition"USING btree (knife_extract_max_timestamptz(resource, '[["event","period","start"],["event","period","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS composition_resource__period_minON"composition"USING btree (knife_extract_min_timestamptz(resource, '[["event","period","start"],["event","period","end"]]'));
Search parameter: Composition.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS composition_resource__date_maxON"composition"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS composition_resource__date_minON"composition"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS conceptmap_resource__ginON"conceptmap"USING GIN (resource);
Search parameter: ConceptMap.publisher
CREATE INDEX CONCURRENTLYIF NOT EXISTS conceptmap_resource__publisher_gin_trgmON"conceptmap"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["publisher"]]$JSON$))) gin_trgm_ops);
Search parameter: ConceptMap.description
CREATE INDEX CONCURRENTLYIF NOT EXISTS conceptmap_resource__description_gin_trgmON"conceptmap"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
Search parameter: ConceptMap.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS conceptmap_resource__name_gin_trgmON"conceptmap"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
Search parameter: ConceptMap.title
CREATE INDEX CONCURRENTLYIF NOT EXISTS conceptmap_resource__title_gin_trgmON"conceptmap"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["title"]]$JSON$))) gin_trgm_ops);
Search parameter: ConceptMap.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS conceptmap_resource__date_maxON"conceptmap"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS conceptmap_resource__date_minON"conceptmap"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
Search parameter: ConceptMap.context-quantity
CREATE INDEX CONCURRENTLYIF NOT EXISTS conceptmap_resource__context_quantity_maxON"conceptmap"USING btree (knife_extract_max_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS conceptmap_resource__context_quantity_minON"conceptmap"USING btree (knife_extract_min_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS condition_resource__ginON"condition"USING GIN (resource);
Search parameter: Condition.onset-info
CREATE INDEX CONCURRENTLYIF NOT EXISTS condition_resource__onset_info_gin_trgmON"condition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["onset","string"]]$JSON$))) gin_trgm_ops);
Search parameter: Condition.abatement-string
CREATE INDEX CONCURRENTLYIF NOT EXISTS condition_resource__abatement_string_gin_trgmON"condition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["abatement","string"]]$JSON$))) gin_trgm_ops);
Search parameter: Condition.onset-date
CREATE INDEX CONCURRENTLYIF NOT EXISTS condition_resource__onset_date_maxON"condition"USING btree (knife_extract_max_timestamptz(resource, '[["onset","dateTime"],["onset","Period","start"],["onset","Period","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS condition_resource__onset_date_minON"condition"USING btree (knife_extract_min_timestamptz(resource, '[["onset","dateTime"],["onset","Period","start"],["onset","Period","end"]]'));
Search parameter: Condition.recorded-date
CREATE INDEX CONCURRENTLYIF NOT EXISTS condition_resource__recorded_date_maxON"condition"USING btree (knife_extract_max_timestamptz(resource, '[["recordedDate"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS condition_resource__recorded_date_minON"condition"USING btree (knife_extract_min_timestamptz(resource, '[["recordedDate"]]'));
Search parameter: Condition.onset-age
CREATE INDEX CONCURRENTLYIF NOT EXISTS condition_resource__onset_age_maxON"condition"USING btree (knife_extract_max_numeric(resource, '[["onset","Age"],["onset","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS condition_resource__onset_age_minON"condition"USING btree (knife_extract_min_numeric(resource, '[["onset","Age"],["onset","Range"]]'));
Search parameter: Condition.abatement-date
CREATE INDEX CONCURRENTLYIF NOT EXISTS condition_resource__abatement_date_maxON"condition"USING btree (knife_extract_max_timestamptz(resource, '[["abatement","dateTime"],["abatement","Period","start"],["abatement","Period","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS condition_resource__abatement_date_minON"condition"USING btree (knife_extract_min_timestamptz(resource, '[["abatement","dateTime"],["abatement","Period","start"],["abatement","Period","end"]]'));
Search parameter: Condition.abatement-age
CREATE INDEX CONCURRENTLYIF NOT EXISTS condition_resource__abatement_age_maxON"condition"USING btree (knife_extract_max_numeric(resource, '[["abatement","Age"],["abatement","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS condition_resource__abatement_age_minON"condition"USING btree (knife_extract_min_numeric(resource, '[["abatement","Age"],["abatement","Range"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS consent_resource__ginON"consent"USING GIN (resource);
Search parameter: Consent.source-reference
NOT SUPPORTED
Search parameter: Consent.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS consent_resource__date_maxON"consent"USING btree (knife_extract_max_timestamptz(resource, '[["dateTime"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS consent_resource__date_minON"consent"USING btree (knife_extract_min_timestamptz(resource, '[["dateTime"]]'));
Search parameter: Consent.period
CREATE INDEX CONCURRENTLYIF NOT EXISTS consent_resource__period_maxON"consent"USING btree (knife_extract_max_timestamptz(resource, '[["provision","period","start"],["provision","period","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS consent_resource__period_minON"consent"USING btree (knife_extract_min_timestamptz(resource, '[["provision","period","start"],["provision","period","end"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS contract_resource__ginON"contract"USING GIN (resource);
Search parameter: Contract.issued
CREATE INDEX CONCURRENTLYIF NOT EXISTS contract_resource__issued_maxON"contract"USING btree (knife_extract_max_timestamptz(resource, '[["issued"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS contract_resource__issued_minON"contract"USING btree (knife_extract_min_timestamptz(resource, '[["issued"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS coverage_resource__ginON"coverage"USING GIN (resource);
Search parameter: Coverage.class-value
CREATE INDEX CONCURRENTLYIF NOT EXISTS coverage_resource__class_value_gin_trgmON"coverage"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["class","value"]]$JSON$))) gin_trgm_ops);
Search parameter: Coverage.dependent
CREATE INDEX CONCURRENTLYIF NOT EXISTS coverage_resource__dependent_gin_trgmON"coverage"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["dependent"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS coverageeligibilityrequest_resource__created_maxON"coverageeligibilityrequest"USING btree (knife_extract_max_timestamptz(resource, '[["created"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS coverageeligibilityrequest_resource__created_minON"coverageeligibilityrequest"USING btree (knife_extract_min_timestamptz(resource, '[["created"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS coverageeligibilityresponse_resource__disposition_gin_trgmON"coverageeligibilityresponse"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["disposition"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS coverageeligibilityresponse_resource__created_maxON"coverageeligibilityresponse"USING btree (knife_extract_max_timestamptz(resource, '[["created"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS coverageeligibilityresponse_resource__created_minON"coverageeligibilityresponse"USING btree (knife_extract_min_timestamptz(resource, '[["created"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS detectedissue_resource__ginON"detectedissue"USING GIN (resource);
Search parameter: DetectedIssue.identified
CREATE INDEX CONCURRENTLYIF NOT EXISTS detectedissue_resource__identified_maxON"detectedissue"USING btree (knife_extract_max_timestamptz(resource, '[["identified","Period","start"],["identified","Period","end"],["identified","dateTime"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS detectedissue_resource__identified_minON"detectedissue"USING btree (knife_extract_min_timestamptz(resource, '[["identified","Period","start"],["identified","Period","end"],["identified","dateTime"]]'));
Device
Search parameter: Device.udi-carrier
CREATE INDEX CONCURRENTLYIF NOT EXISTS device_resource__udi_carrier_gin_trgmON"device"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["udiCarrier","carrierHRF"]]$JSON$))) gin_trgm_ops);
Search parameter: Device.manufacturer
CREATE INDEX CONCURRENTLYIF NOT EXISTS device_resource__manufacturer_gin_trgmON"device"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["manufacturer"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS device_resource__ginON"device"USING GIN (resource);
Search parameter: Device.udi-di
CREATE INDEX CONCURRENTLYIF NOT EXISTS device_resource__udi_di_gin_trgmON"device"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["udiCarrier","deviceIdentifier"]]$JSON$))) gin_trgm_ops);
Search parameter: Device.model
CREATE INDEX CONCURRENTLYIF NOT EXISTS device_resource__model_gin_trgmON"device"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["modelNumber"]]$JSON$))) gin_trgm_ops);
Search parameter: Device.device-name
CREATE INDEX CONCURRENTLYIF NOT EXISTS device_resource__device_name_gin_trgmON"device"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["deviceName","name"],["type","coding","display"],["type","text"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS devicerequest_resource__ginON"devicerequest"USING GIN (resource);
Search parameter: DeviceRequest.event-date
CREATE INDEX CONCURRENTLYIF NOT EXISTS devicerequest_resource__event_date_maxON"devicerequest"USING btree (knife_extract_max_timestamptz(resource, '[["occurrence","dateTime"],["occurrence","Period","start"],["occurrence","Period","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS devicerequest_resource__event_date_minON"devicerequest"USING btree (knife_extract_min_timestamptz(resource, '[["occurrence","dateTime"],["occurrence","Period","start"],["occurrence","Period","end"]]'));
Search parameter: DeviceRequest.authored-on
CREATE INDEX CONCURRENTLYIF NOT EXISTS devicerequest_resource__authored_on_maxON"devicerequest"USING btree (knife_extract_max_timestamptz(resource, '[["authoredOn"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS devicerequest_resource__authored_on_minON"devicerequest"USING btree (knife_extract_min_timestamptz(resource, '[["authoredOn"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS diagnosticreport_resource__ginON"diagnosticreport"USING GIN (resource);
Search parameter: DiagnosticReport.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS diagnosticreport_resource__date_maxON"diagnosticreport"USING btree (knife_extract_max_timestamptz(resource, '[["effective","Period","start"],["effective","Period","end"],["effective","dateTime"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS diagnosticreport_resource__date_minON"diagnosticreport"USING btree (knife_extract_min_timestamptz(resource, '[["effective","Period","start"],["effective","Period","end"],["effective","dateTime"]]'));
Search parameter: DiagnosticReport.issued
CREATE INDEX CONCURRENTLYIF NOT EXISTS diagnosticreport_resource__issued_maxON"diagnosticreport"USING btree (knife_extract_max_timestamptz(resource, '[["issued"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS diagnosticreport_resource__issued_minON"diagnosticreport"USING btree (knife_extract_min_timestamptz(resource, '[["issued"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS documentmanifest_resource__ginON"documentmanifest"USING GIN (resource);
Search parameter: DocumentManifest.description
CREATE INDEX CONCURRENTLYIF NOT EXISTS documentmanifest_resource__description_gin_trgmON"documentmanifest"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
Search parameter: DocumentManifest.created
CREATE INDEX CONCURRENTLYIF NOT EXISTS documentmanifest_resource__created_maxON"documentmanifest"USING btree (knife_extract_max_timestamptz(resource, '[["created"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS documentmanifest_resource__created_minON"documentmanifest"USING btree (knife_extract_min_timestamptz(resource, '[["created"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS documentreference_resource__ginON"documentreference"USING GIN (resource);
Search parameter: DocumentReference.description
CREATE INDEX CONCURRENTLYIF NOT EXISTS documentreference_resource__description_gin_trgmON"documentreference"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
Search parameter: DocumentReference.period
CREATE INDEX CONCURRENTLYIF NOT EXISTS documentreference_resource__period_maxON"documentreference"USING btree (knife_extract_max_timestamptz(resource, '[["context","period","start"],["context","period","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS documentreference_resource__period_minON"documentreference"USING btree (knife_extract_min_timestamptz(resource, '[["context","period","start"],["context","period","end"]]'));
Search parameter: DocumentReference.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS documentreference_resource__date_maxON"documentreference"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS documentreference_resource__date_minON"documentreference"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS effectevidencesynthesis_resource__publisher_gin_trgmON"effectevidencesynthesis"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["publisher"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS effectevidencesynthesis_resource__description_gin_trgmON"effectevidencesynthesis"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
Search parameter: EffectEvidenceSynthesis.title
CREATE INDEX CONCURRENTLYIF NOT EXISTS effectevidencesynthesis_resource__title_gin_trgmON"effectevidencesynthesis"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["title"]]$JSON$))) gin_trgm_ops);
Search parameter: EffectEvidenceSynthesis.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS effectevidencesynthesis_resource__name_gin_trgmON"effectevidencesynthesis"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS effectevidencesynthesis_resource__effective_maxON"effectevidencesynthesis"USING btree (knife_extract_max_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS effectevidencesynthesis_resource__effective_minON"effectevidencesynthesis"USING btree (knife_extract_min_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));
Search parameter: EffectEvidenceSynthesis.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS effectevidencesynthesis_resource__date_maxON"effectevidencesynthesis"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS effectevidencesynthesis_resource__date_minON"effectevidencesynthesis"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS effectevidencesynthesis_resource__context_quantity_maxON"effectevidencesynthesis"USING btree (knife_extract_max_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS effectevidencesynthesis_resource__context_quantity_minON"effectevidencesynthesis"USING btree (knife_extract_min_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS encounter_resource__ginON"encounter"USING GIN (resource);
Search parameter: Encounter.length
CREATE INDEX CONCURRENTLYIF NOT EXISTS encounter_resource__length_maxON"encounter"USING btree (knife_extract_max_numeric(resource, '[["length"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS encounter_resource__length_minON"encounter"USING btree (knife_extract_min_numeric(resource, '[["length"]]'));
Search parameter: Encounter.location-period
CREATE INDEX CONCURRENTLYIF NOT EXISTS encounter_resource__location_period_maxON"encounter"USING btree (knife_extract_max_timestamptz(resource, '[["location","period","start"],["location","period","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS encounter_resource__location_period_minON"encounter"USING btree (knife_extract_min_timestamptz(resource, '[["location","period","start"],["location","period","end"]]'));
Search parameter: Encounter.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS encounter_resource__date_maxON"encounter"USING btree (knife_extract_max_timestamptz(resource, '[["period","start"],["period","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS encounter_resource__date_minON"encounter"USING btree (knife_extract_min_timestamptz(resource, '[["period","start"],["period","end"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS endpoint_resource__ginON"endpoint"USING GIN (resource);
Search parameter: Endpoint.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS endpoint_resource__name_gin_trgmON"endpoint"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS episodeofcare_resource__ginON"episodeofcare"USING GIN (resource);
Search parameter: EpisodeOfCare.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS episodeofcare_resource__date_maxON"episodeofcare"USING btree (knife_extract_max_timestamptz(resource, '[["period","start"],["period","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS episodeofcare_resource__date_minON"episodeofcare"USING btree (knife_extract_min_timestamptz(resource, '[["period","start"],["period","end"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS eventdefinition_resource__ginON"eventdefinition"USING GIN (resource);
Search parameter: EventDefinition.description
CREATE INDEX CONCURRENTLYIF NOT EXISTS eventdefinition_resource__description_gin_trgmON"eventdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
Search parameter: EventDefinition.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS eventdefinition_resource__name_gin_trgmON"eventdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
Search parameter: EventDefinition.title
CREATE INDEX CONCURRENTLYIF NOT EXISTS eventdefinition_resource__title_gin_trgmON"eventdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["title"]]$JSON$))) gin_trgm_ops);
Search parameter: EventDefinition.publisher
CREATE INDEX CONCURRENTLYIF NOT EXISTS eventdefinition_resource__publisher_gin_trgmON"eventdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["publisher"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS eventdefinition_resource__context_quantity_maxON"eventdefinition"USING btree (knife_extract_max_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS eventdefinition_resource__context_quantity_minON"eventdefinition"USING btree (knife_extract_min_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));
Search parameter: EventDefinition.effective
CREATE INDEX CONCURRENTLYIF NOT EXISTS eventdefinition_resource__effective_maxON"eventdefinition"USING btree (knife_extract_max_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS eventdefinition_resource__effective_minON"eventdefinition"USING btree (knife_extract_min_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));
Search parameter: EventDefinition.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS eventdefinition_resource__date_maxON"eventdefinition"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS eventdefinition_resource__date_minON"eventdefinition"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS evidence_resource__ginON"evidence"USING GIN (resource);
Search parameter: Evidence.publisher
CREATE INDEX CONCURRENTLYIF NOT EXISTS evidence_resource__publisher_gin_trgmON"evidence"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["publisher"]]$JSON$))) gin_trgm_ops);
Search parameter: Evidence.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS evidence_resource__name_gin_trgmON"evidence"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
Search parameter: Evidence.title
CREATE INDEX CONCURRENTLYIF NOT EXISTS evidence_resource__title_gin_trgmON"evidence"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["title"]]$JSON$))) gin_trgm_ops);
Search parameter: Evidence.description
CREATE INDEX CONCURRENTLYIF NOT EXISTS evidence_resource__description_gin_trgmON"evidence"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
Search parameter: Evidence.context-quantity
CREATE INDEX CONCURRENTLYIF NOT EXISTS evidence_resource__context_quantity_maxON"evidence"USING btree (knife_extract_max_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS evidence_resource__context_quantity_minON"evidence"USING btree (knife_extract_min_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));
Search parameter: Evidence.effective
CREATE INDEX CONCURRENTLYIF NOT EXISTS evidence_resource__effective_maxON"evidence"USING btree (knife_extract_max_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS evidence_resource__effective_minON"evidence"USING btree (knife_extract_min_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));
Search parameter: Evidence.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS evidence_resource__date_maxON"evidence"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS evidence_resource__date_minON"evidence"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS evidencevariable_resource__ginON"evidencevariable"USING GIN (resource);
Search parameter: EvidenceVariable.publisher
CREATE INDEX CONCURRENTLYIF NOT EXISTS evidencevariable_resource__publisher_gin_trgmON"evidencevariable"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["publisher"]]$JSON$))) gin_trgm_ops);
Search parameter: EvidenceVariable.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS evidencevariable_resource__name_gin_trgmON"evidencevariable"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
Search parameter: EvidenceVariable.description
CREATE INDEX CONCURRENTLYIF NOT EXISTS evidencevariable_resource__description_gin_trgmON"evidencevariable"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
Search parameter: EvidenceVariable.title
CREATE INDEX CONCURRENTLYIF NOT EXISTS evidencevariable_resource__title_gin_trgmON"evidencevariable"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["title"]]$JSON$))) gin_trgm_ops);
Search parameter: EvidenceVariable.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS evidencevariable_resource__date_maxON"evidencevariable"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS evidencevariable_resource__date_minON"evidencevariable"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
Search parameter: EvidenceVariable.effective
CREATE INDEX CONCURRENTLYIF NOT EXISTS evidencevariable_resource__effective_maxON"evidencevariable"USING btree (knife_extract_max_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS evidencevariable_resource__effective_minON"evidencevariable"USING btree (knife_extract_min_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS evidencevariable_resource__context_quantity_maxON"evidencevariable"USING btree (knife_extract_max_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS evidencevariable_resource__context_quantity_minON"evidencevariable"USING btree (knife_extract_min_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS examplescenario_resource__ginON"examplescenario"USING GIN (resource);
Search parameter: ExampleScenario.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS examplescenario_resource__name_gin_trgmON"examplescenario"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
Search parameter: ExampleScenario.publisher
CREATE INDEX CONCURRENTLYIF NOT EXISTS examplescenario_resource__publisher_gin_trgmON"examplescenario"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["publisher"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS examplescenario_resource__context_quantity_maxON"examplescenario"USING btree (knife_extract_max_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS examplescenario_resource__context_quantity_minON"examplescenario"USING btree (knife_extract_min_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));
Search parameter: ExampleScenario.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS examplescenario_resource__date_maxON"examplescenario"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS examplescenario_resource__date_minON"examplescenario"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS explanationofbenefit_resource__disposition_gin_trgmON"explanationofbenefit"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["disposition"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS explanationofbenefit_resource__ginON"explanationofbenefit"USING GIN (resource);
Search parameter: ExplanationOfBenefit.created
CREATE INDEX CONCURRENTLYIF NOT EXISTS explanationofbenefit_resource__created_maxON"explanationofbenefit"USING btree (knife_extract_max_timestamptz(resource, '[["created"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS explanationofbenefit_resource__created_minON"explanationofbenefit"USING btree (knife_extract_min_timestamptz(resource, '[["created"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS familymemberhistory_resource__ginON"familymemberhistory"USING GIN (resource);
Search parameter: FamilyMemberHistory.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS familymemberhistory_resource__date_maxON"familymemberhistory"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS familymemberhistory_resource__date_minON"familymemberhistory"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS flag_resource__ginON"flag"USING GIN (resource);
Search parameter: Flag.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS flag_resource__date_maxON"flag"USING btree (knife_extract_max_timestamptz(resource, '[["period","start"],["period","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS flag_resource__date_minON"flag"USING btree (knife_extract_min_timestamptz(resource, '[["period","start"],["period","end"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS goal_resource__ginON"goal"USING GIN (resource);
Search parameter: Goal.start-date
CREATE INDEX CONCURRENTLYIF NOT EXISTS goal_resource__start_date_maxON"goal"USING btree (knife_extract_max_timestamptz(resource, '[["start","date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS goal_resource__start_date_minON"goal"USING btree (knife_extract_min_timestamptz(resource, '[["start","date"]]'));
Search parameter: Goal.target-date
CREATE INDEX CONCURRENTLYIF NOT EXISTS goal_resource__target_date_maxON"goal"USING btree (knife_extract_max_timestamptz(resource, '[["target","due","date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS goal_resource__target_date_minON"goal"USING btree (knife_extract_min_timestamptz(resource, '[["target","due","date"]]'));
GraphDefinition
Search parameter: GraphDefinition.publisher
CREATE INDEX CONCURRENTLYIF NOT EXISTS graphdefinition_resource__publisher_gin_trgmON"graphdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["publisher"]]$JSON$))) gin_trgm_ops);
Search parameter: GraphDefinition.description
CREATE INDEX CONCURRENTLYIF NOT EXISTS graphdefinition_resource__description_gin_trgmON"graphdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS graphdefinition_resource__ginON"graphdefinition"USING GIN (resource);
Search parameter: GraphDefinition.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS graphdefinition_resource__name_gin_trgmON"graphdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
Search parameter: GraphDefinition.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS graphdefinition_resource__date_maxON"graphdefinition"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS graphdefinition_resource__date_minON"graphdefinition"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS graphdefinition_resource__context_quantity_maxON"graphdefinition"USING btree (knife_extract_max_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS graphdefinition_resource__context_quantity_minON"graphdefinition"USING btree (knife_extract_min_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS guidanceresponse_resource__ginON"guidanceresponse"USING GIN (resource);
HealthcareService
Search parameter: HealthcareService.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS healthcareservice_resource__name_gin_trgmON"healthcareservice"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS imagingstudy_resource__ginON"imagingstudy"USING GIN (resource);
Search parameter: ImagingStudy.started
CREATE INDEX CONCURRENTLYIF NOT EXISTS imagingstudy_resource__started_maxON"imagingstudy"USING btree (knife_extract_max_timestamptz(resource, '[["started"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS imagingstudy_resource__started_minON"imagingstudy"USING btree (knife_extract_min_timestamptz(resource, '[["started"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS immunization_resource__ginON"immunization"USING GIN (resource);
Search parameter: Immunization.series
CREATE INDEX CONCURRENTLYIF NOT EXISTS immunization_resource__series_gin_trgmON"immunization"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["protocolApplied","series"]]$JSON$))) gin_trgm_ops);
Search parameter: Immunization.lot-number
CREATE INDEX CONCURRENTLYIF NOT EXISTS immunization_resource__lot_number_gin_trgmON"immunization"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["lotNumber"]]$JSON$))) gin_trgm_ops);
Search parameter: Immunization.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS immunization_resource__date_maxON"immunization"USING btree (knife_extract_max_timestamptz(resource, '[["occurrence","string"],["occurrence","dateTime"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS immunization_resource__date_minON"immunization"USING btree (knife_extract_min_timestamptz(resource, '[["occurrence","string"],["occurrence","dateTime"]]'));
Search parameter: Immunization.reaction-date
CREATE INDEX CONCURRENTLYIF NOT EXISTS immunization_resource__reaction_date_maxON"immunization"USING btree (knife_extract_max_timestamptz(resource, '[["reaction","date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS immunization_resource__reaction_date_minON"immunization"USING btree (knife_extract_min_timestamptz(resource, '[["reaction","date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS immunizationevaluation_resource__ginON"immunizationevaluation"USING GIN (resource);
Search parameter: ImmunizationEvaluation.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS immunizationevaluation_resource__date_maxON"immunizationevaluation"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS immunizationevaluation_resource__date_minON"immunizationevaluation"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS immunizationrecommendation_resource__ginON"immunizationrecommendation"USING GIN (resource);
Search parameter: ImmunizationRecommendation.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS immunizationrecommendation_resource__date_maxON"immunizationrecommendation"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS immunizationrecommendation_resource__date_minON"immunizationrecommendation"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS implementationguide_resource__ginON"implementationguide"USING GIN (resource);
Search parameter: ImplementationGuide.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS implementationguide_resource__name_gin_trgmON"implementationguide"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
Search parameter: ImplementationGuide.description
CREATE INDEX CONCURRENTLYIF NOT EXISTS implementationguide_resource__description_gin_trgmON"implementationguide"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
Search parameter: ImplementationGuide.title
CREATE INDEX CONCURRENTLYIF NOT EXISTS implementationguide_resource__title_gin_trgmON"implementationguide"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["title"]]$JSON$))) gin_trgm_ops);
Search parameter: ImplementationGuide.publisher
CREATE INDEX CONCURRENTLYIF NOT EXISTS implementationguide_resource__publisher_gin_trgmON"implementationguide"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["publisher"]]$JSON$))) gin_trgm_ops);
Search parameter: ImplementationGuide.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS implementationguide_resource__date_maxON"implementationguide"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS implementationguide_resource__date_minON"implementationguide"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS implementationguide_resource__context_quantity_maxON"implementationguide"USING btree (knife_extract_max_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS implementationguide_resource__context_quantity_minON"implementationguide"USING btree (knife_extract_min_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS insuranceplan_resource__ginON"insuranceplan"USING GIN (resource);
Search parameter: InsurancePlan.address-country
CREATE INDEX CONCURRENTLYIF NOT EXISTS insuranceplan_resource__address_country_gin_trgmON"insuranceplan"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["contact","address","country"]]$JSON$))) gin_trgm_ops);
Search parameter: InsurancePlan.phonetic
CREATE INDEX CONCURRENTLYIF NOT EXISTS insuranceplan_resource__phonetic_gin_trgmON"insuranceplan"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
Search parameter: InsurancePlan.address-city
CREATE INDEX CONCURRENTLYIF NOT EXISTS insuranceplan_resource__address_city_gin_trgmON"insuranceplan"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["contact","address","city"]]$JSON$))) gin_trgm_ops);
Search parameter: InsurancePlan.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS insuranceplan_resource__name_gin_trgmON"insuranceplan"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"],["alias"]]$JSON$))) gin_trgm_ops);
Search parameter: InsurancePlan.address-state
CREATE INDEX CONCURRENTLYIF NOT EXISTS insuranceplan_resource__address_state_gin_trgmON"insuranceplan"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["contact","address","state"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS insuranceplan_resource__address_postalcode_gin_trgmON"insuranceplan"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["contact","address","postalCode"]]$JSON$))) gin_trgm_ops);
Search parameter: InsurancePlan.address
CREATE INDEX CONCURRENTLYIF NOT EXISTS insuranceplan_resource__address_gin_trgmON"insuranceplan"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["contact","address","text"],["contact","address","district"],["contact","address","country"],["contact","address","city"],["contact","address","line"],["contact","address","state"],["contact","address","postalCode"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS invoice_resource__ginON"invoice"USING GIN (resource);
Search parameter: Invoice.totalnet
CREATE INDEX CONCURRENTLYIF NOT EXISTS invoice_resource__totalnet_maxON"invoice"USING btree (knife_extract_max_numeric(resource, '[["totalNet","value"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS invoice_resource__totalnet_minON"invoice"USING btree (knife_extract_min_numeric(resource, '[["totalNet","value"]]'));
Search parameter: Invoice.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS invoice_resource__date_maxON"invoice"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS invoice_resource__date_minON"invoice"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
Search parameter: Invoice.totalgross
CREATE INDEX CONCURRENTLYIF NOT EXISTS invoice_resource__totalgross_maxON"invoice"USING btree (knife_extract_max_numeric(resource, '[["totalGross","value"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS invoice_resource__totalgross_minON"invoice"USING btree (knife_extract_min_numeric(resource, '[["totalGross","value"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS library_resource__ginON"library"USING GIN (resource);
Search parameter: Library.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS library_resource__name_gin_trgmON"library"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
Search parameter: Library.title
CREATE INDEX CONCURRENTLYIF NOT EXISTS library_resource__title_gin_trgmON"library"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["title"]]$JSON$))) gin_trgm_ops);
Search parameter: Library.publisher
CREATE INDEX CONCURRENTLYIF NOT EXISTS library_resource__publisher_gin_trgmON"library"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["publisher"]]$JSON$))) gin_trgm_ops);
Search parameter: Library.description
CREATE INDEX CONCURRENTLYIF NOT EXISTS library_resource__description_gin_trgmON"library"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
Search parameter: Library.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS library_resource__date_maxON"library"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS library_resource__date_minON"library"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
Search parameter: Library.context-quantity
CREATE INDEX CONCURRENTLYIF NOT EXISTS library_resource__context_quantity_maxON"library"USING btree (knife_extract_max_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS library_resource__context_quantity_minON"library"USING btree (knife_extract_min_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));
Search parameter: Library.effective
CREATE INDEX CONCURRENTLYIF NOT EXISTS library_resource__effective_maxON"library"USING btree (knife_extract_max_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS library_resource__effective_minON"library"USING btree (knife_extract_min_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS list_resource__ginON"list"USING GIN (resource);
Search parameter: List.notes
CREATE INDEX CONCURRENTLYIF NOT EXISTS list_resource__notes_gin_trgmON"list"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["note","text"]]$JSON$))) gin_trgm_ops);
Search parameter: List.title
CREATE INDEX CONCURRENTLYIF NOT EXISTS list_resource__title_gin_trgmON"list"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["title"]]$JSON$))) gin_trgm_ops);
Search parameter: List.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS list_resource__date_maxON"list"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS list_resource__date_minON"list"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
Location
Search parameter: Location.address-state
CREATE INDEX CONCURRENTLYIF NOT EXISTS location_resource__address_state_gin_trgmON"location"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","state"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS location_resource__ginON"location"USING GIN (resource);
Search parameter: Location.address
CREATE INDEX CONCURRENTLYIF NOT EXISTS location_resource__address_gin_trgmON"location"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","text"],["address","district"],["address","country"],["address","city"],["address","line"],["address","state"],["address","postalCode"]]$JSON$))) gin_trgm_ops);
Search parameter: Location.address-postalcode
CREATE INDEX CONCURRENTLYIF NOT EXISTS location_resource__address_postalcode_gin_trgmON"location"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","postalCode"]]$JSON$))) gin_trgm_ops);
Search parameter: Location.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS location_resource__name_gin_trgmON"location"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"],["alias"]]$JSON$))) gin_trgm_ops);
Search parameter: Location.address-country
CREATE INDEX CONCURRENTLYIF NOT EXISTS location_resource__address_country_gin_trgmON"location"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","country"]]$JSON$))) gin_trgm_ops);
Search parameter: Location.address-city
CREATE INDEX CONCURRENTLYIF NOT EXISTS location_resource__address_city_gin_trgmON"location"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","city"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS measure_resource__ginON"measure"USING GIN (resource);
Search parameter: Measure.description
CREATE INDEX CONCURRENTLYIF NOT EXISTS measure_resource__description_gin_trgmON"measure"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
Search parameter: Measure.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS measure_resource__name_gin_trgmON"measure"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
Search parameter: Measure.title
CREATE INDEX CONCURRENTLYIF NOT EXISTS measure_resource__title_gin_trgmON"measure"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["title"]]$JSON$))) gin_trgm_ops);
Search parameter: Measure.publisher
CREATE INDEX CONCURRENTLYIF NOT EXISTS measure_resource__publisher_gin_trgmON"measure"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["publisher"]]$JSON$))) gin_trgm_ops);
Search parameter: Measure.context-quantity
CREATE INDEX CONCURRENTLYIF NOT EXISTS measure_resource__context_quantity_maxON"measure"USING btree (knife_extract_max_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS measure_resource__context_quantity_minON"measure"USING btree (knife_extract_min_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));
Search parameter: Measure.effective
CREATE INDEX CONCURRENTLYIF NOT EXISTS measure_resource__effective_maxON"measure"USING btree (knife_extract_max_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS measure_resource__effective_minON"measure"USING btree (knife_extract_min_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));
Search parameter: Measure.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS measure_resource__date_maxON"measure"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS measure_resource__date_minON"measure"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS measurereport_resource__ginON"measurereport"USING GIN (resource);
Search parameter: MeasureReport.period
CREATE INDEX CONCURRENTLYIF NOT EXISTS measurereport_resource__period_maxON"measurereport"USING btree (knife_extract_max_timestamptz(resource, '[["period","start"],["period","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS measurereport_resource__period_minON"measurereport"USING btree (knife_extract_min_timestamptz(resource, '[["period","start"],["period","end"]]'));
Search parameter: MeasureReport.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS measurereport_resource__date_maxON"measurereport"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS measurereport_resource__date_minON"measurereport"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS media_resource__ginON"media"USING GIN (resource);
Search parameter: Media.created
CREATE INDEX CONCURRENTLYIF NOT EXISTS media_resource__created_maxON"media"USING btree (knife_extract_max_timestamptz(resource, '[["created","Period","start"],["created","Period","end"],["created","dateTime"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS media_resource__created_minON"media"USING btree (knife_extract_min_timestamptz(resource, '[["created","Period","start"],["created","Period","end"],["created","dateTime"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS medication_resource__ginON"medication"USING GIN (resource);
Search parameter: Medication.expiration-date
CREATE INDEX CONCURRENTLYIF NOT EXISTS medication_resource__expiration_date_maxON"medication"USING btree (knife_extract_max_timestamptz(resource, '[["batch","expirationDate"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS medication_resource__expiration_date_minON"medication"USING btree (knife_extract_min_timestamptz(resource, '[["batch","expirationDate"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS medicationadministration_resource__effective_time_maxON"medicationadministration"USING btree (knife_extract_max_timestamptz(resource, '[["effective","Period","start"],["effective","Period","end"],["effective","dateTime"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS medicationadministration_resource__effective_time_minON"medicationadministration"USING btree (knife_extract_min_timestamptz(resource, '[["effective","Period","start"],["effective","Period","end"],["effective","dateTime"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS medicationdispense_resource__ginON"medicationdispense"USING GIN (resource);
Search parameter: MedicationDispense.whenprepared
CREATE INDEX CONCURRENTLYIF NOT EXISTS medicationdispense_resource__whenprepared_maxON"medicationdispense"USING btree (knife_extract_max_timestamptz(resource, '[["whenPrepared"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS medicationdispense_resource__whenprepared_minON"medicationdispense"USING btree (knife_extract_min_timestamptz(resource, '[["whenPrepared"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS medicationdispense_resource__whenhandedover_maxON"medicationdispense"USING btree (knife_extract_max_timestamptz(resource, '[["whenHandedOver"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS medicationdispense_resource__whenhandedover_minON"medicationdispense"USING btree (knife_extract_min_timestamptz(resource, '[["whenHandedOver"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS medicationrequest_resource__ginON"medicationrequest"USING GIN (resource);
Search parameter: MedicationRequest.authoredon
CREATE INDEX CONCURRENTLYIF NOT EXISTS medicationrequest_resource__authoredon_maxON"medicationrequest"USING btree (knife_extract_max_timestamptz(resource, '[["authoredOn"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS medicationrequest_resource__authoredon_minON"medicationrequest"USING btree (knife_extract_min_timestamptz(resource, '[["authoredOn"]]'));
Search parameter: MedicationRequest.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS medicationrequest_resource__date_maxON"medicationrequest"USING btree (knife_extract_max_timestamptz(resource, '[["dosageInstruction","timing","event"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS medicationrequest_resource__date_minON"medicationrequest"USING btree (knife_extract_min_timestamptz(resource, '[["dosageInstruction","timing","event"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS medicationstatement_resource__ginON"medicationstatement"USING GIN (resource);
Search parameter: MedicationStatement.effective
CREATE INDEX CONCURRENTLYIF NOT EXISTS medicationstatement_resource__effective_maxON"medicationstatement"USING btree (knife_extract_max_timestamptz(resource, '[["effective","Period","start"],["effective","Period","end"],["effective","dateTime"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS medicationstatement_resource__effective_minON"medicationstatement"USING btree (knife_extract_min_timestamptz(resource, '[["effective","Period","start"],["effective","Period","end"],["effective","dateTime"]]'));
MedicinalProduct
Search parameter: MedicinalProduct.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS medicinalproduct_resource__name_gin_trgmON"medicinalproduct"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name","productName"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS messagedefinition_resource__ginON"messagedefinition"USING GIN (resource);
Search parameter: MessageDefinition.description
CREATE INDEX CONCURRENTLYIF NOT EXISTS messagedefinition_resource__description_gin_trgmON"messagedefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
Search parameter: MessageDefinition.publisher
CREATE INDEX CONCURRENTLYIF NOT EXISTS messagedefinition_resource__publisher_gin_trgmON"messagedefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["publisher"]]$JSON$))) gin_trgm_ops);
Search parameter: MessageDefinition.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS messagedefinition_resource__name_gin_trgmON"messagedefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
Search parameter: MessageDefinition.title
CREATE INDEX CONCURRENTLYIF NOT EXISTS messagedefinition_resource__title_gin_trgmON"messagedefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["title"]]$JSON$))) gin_trgm_ops);
Search parameter: MessageDefinition.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS messagedefinition_resource__date_maxON"messagedefinition"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS messagedefinition_resource__date_minON"messagedefinition"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS messagedefinition_resource__context_quantity_maxON"messagedefinition"USING btree (knife_extract_max_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS messagedefinition_resource__context_quantity_minON"messagedefinition"USING btree (knife_extract_min_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS messageheader_resource__ginON"messageheader"USING GIN (resource);
Search parameter: MessageHeader.destination
CREATE INDEX CONCURRENTLYIF NOT EXISTS messageheader_resource__destination_gin_trgmON"messageheader"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["destination","name"]]$JSON$))) gin_trgm_ops);
Search parameter: MessageHeader.source
CREATE INDEX CONCURRENTLYIF NOT EXISTS messageheader_resource__source_gin_trgmON"messageheader"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["source","name"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS molecularsequence_resource__ginON"molecularsequence"USING GIN (resource);
Search parameter: MolecularSequence.window-start
CREATE INDEX CONCURRENTLYIF NOT EXISTS molecularsequence_resource__window_start_maxON"molecularsequence"USING btree (knife_extract_max_numeric(resource, '[["referenceSeq","windowStart"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS molecularsequence_resource__window_start_minON"molecularsequence"USING btree (knife_extract_min_numeric(resource, '[["referenceSeq","windowStart"]]'));
Search parameter: MolecularSequence.window-end
CREATE INDEX CONCURRENTLYIF NOT EXISTS molecularsequence_resource__window_end_maxON"molecularsequence"USING btree (knife_extract_max_numeric(resource, '[["referenceSeq","windowEnd"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS molecularsequence_resource__window_end_minON"molecularsequence"USING btree (knife_extract_min_numeric(resource, '[["referenceSeq","windowEnd"]]'));
Search parameter: MolecularSequence.variant-start
CREATE INDEX CONCURRENTLYIF NOT EXISTS molecularsequence_resource__variant_start_maxON"molecularsequence"USING btree (knife_extract_max_numeric(resource, '[["variant","start"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS molecularsequence_resource__variant_start_minON"molecularsequence"USING btree (knife_extract_min_numeric(resource, '[["variant","start"]]'));
Search parameter: MolecularSequence.variant-end
CREATE INDEX CONCURRENTLYIF NOT EXISTS molecularsequence_resource__variant_end_maxON"molecularsequence"USING btree (knife_extract_max_numeric(resource, '[["variant","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS molecularsequence_resource__variant_end_minON"molecularsequence"USING btree (knife_extract_min_numeric(resource, '[["variant","end"]]'));
NamingSystem
Search parameter: NamingSystem.context-quantity
CREATE INDEX CONCURRENTLYIF NOT EXISTS namingsystem_resource__context_quantity_maxON"namingsystem"USING btree (knife_extract_max_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS namingsystem_resource__context_quantity_minON"namingsystem"USING btree (knife_extract_min_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));
Search parameter: NamingSystem.contact
CREATE INDEX CONCURRENTLYIF NOT EXISTS namingsystem_resource__contact_gin_trgmON"namingsystem"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["contact","name"]]$JSON$))) gin_trgm_ops);
Search parameter: NamingSystem.responsible
CREATE INDEX CONCURRENTLYIF NOT EXISTS namingsystem_resource__responsible_gin_trgmON"namingsystem"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["responsible"]]$JSON$))) gin_trgm_ops);
Search parameter: NamingSystem.period
CREATE INDEX CONCURRENTLYIF NOT EXISTS namingsystem_resource__period_maxON"namingsystem"USING btree (knife_extract_max_timestamptz(resource, '[["uniqueId","period","start"],["uniqueId","period","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS namingsystem_resource__period_minON"namingsystem"USING btree (knife_extract_min_timestamptz(resource, '[["uniqueId","period","start"],["uniqueId","period","end"]]'));
Search parameter: NamingSystem.publisher
CREATE INDEX CONCURRENTLYIF NOT EXISTS namingsystem_resource__publisher_gin_trgmON"namingsystem"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["publisher"]]$JSON$))) gin_trgm_ops);
Search parameter: NamingSystem.value
CREATE INDEX CONCURRENTLYIF NOT EXISTS namingsystem_resource__value_gin_trgmON"namingsystem"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["uniqueId","value"]]$JSON$))) gin_trgm_ops);
Search parameter: NamingSystem.description
CREATE INDEX CONCURRENTLYIF NOT EXISTS namingsystem_resource__description_gin_trgmON"namingsystem"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
Search parameter: NamingSystem.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS namingsystem_resource__date_maxON"namingsystem"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS namingsystem_resource__date_minON"namingsystem"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
Search parameter: NamingSystem.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS namingsystem_resource__name_gin_trgmON"namingsystem"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS nutritionorder_resource__ginON"nutritionorder"USING GIN (resource);
Search parameter: NutritionOrder.datetime
CREATE INDEX CONCURRENTLYIF NOT EXISTS nutritionorder_resource__datetime_maxON"nutritionorder"USING btree (knife_extract_max_timestamptz(resource, '[["dateTime"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS nutritionorder_resource__datetime_minON"nutritionorder"USING btree (knife_extract_min_timestamptz(resource, '[["dateTime"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS observation_resource__ginON"observation"USING GIN (resource);
Search parameter: Observation.value-string
CREATE INDEX CONCURRENTLYIF NOT EXISTS observation_resource__value_string_gin_trgmON"observation"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["value","string"],["value","CodeableConcept","text"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS observation_resource__combo_value_quantity_maxON"observation"USING btree (knife_extract_max_numeric(resource, '[["value","Quantity","value"],["value","SampledData"],["component","value","Quantity","value"],["component","value","SampledData"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS observation_resource__combo_value_quantity_minON"observation"USING btree (knife_extract_min_numeric(resource, '[["value","Quantity","value"],["value","SampledData"],["component","value","Quantity","value"],["component","value","SampledData"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS observation_resource__component_value_quantity_maxON"observation"USING btree (knife_extract_max_numeric(resource, '[["component","value","Quantity","value"],["component","value","SampledData"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS observation_resource__component_value_quantity_minON"observation"USING btree (knife_extract_min_numeric(resource, '[["component","value","Quantity","value"],["component","value","SampledData"]]'));
Search parameter: Observation.value-date
CREATE INDEX CONCURRENTLYIF NOT EXISTS observation_resource__value_date_maxON"observation"USING btree (knife_extract_max_timestamptz(resource, '[["value","dateTime"],["value","Period","start"],["value","Period","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS observation_resource__value_date_minON"observation"USING btree (knife_extract_min_timestamptz(resource, '[["value","dateTime"],["value","Period","start"],["value","Period","end"]]'));
Search parameter: Observation.value-quantity
CREATE INDEX CONCURRENTLYIF NOT EXISTS observation_resource__value_quantity_maxON"observation"USING btree (knife_extract_max_numeric(resource, '[["value","Quantity","value"],["value","SampledData"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS observation_resource__value_quantity_minON"observation"USING btree (knife_extract_min_numeric(resource, '[["value","Quantity","value"],["value","SampledData"]]'));
Search parameter: Observation.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS observation_resource__date_maxON"observation"USING btree (knife_extract_max_timestamptz(resource, '[["effective","Period","start"],["effective","Period","end"],["effective","dateTime"],["effective","Timing","event"],["effective","instant"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS observation_resource__date_minON"observation"USING btree (knife_extract_min_timestamptz(resource, '[["effective","Period","start"],["effective","Period","end"],["effective","dateTime"],["effective","Timing","event"],["effective","instant"]]'));
OperationDefinition
Search parameter: OperationDefinition.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS operationdefinition_resource__name_gin_trgmON"operationdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS operationdefinition_resource__ginON"operationdefinition"USING GIN (resource);
Search parameter: OperationDefinition.title
CREATE INDEX CONCURRENTLYIF NOT EXISTS operationdefinition_resource__title_gin_trgmON"operationdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["title"]]$JSON$))) gin_trgm_ops);
Search parameter: OperationDefinition.description
CREATE INDEX CONCURRENTLYIF NOT EXISTS operationdefinition_resource__description_gin_trgmON"operationdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
Search parameter: OperationDefinition.publisher
CREATE INDEX CONCURRENTLYIF NOT EXISTS operationdefinition_resource__publisher_gin_trgmON"operationdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["publisher"]]$JSON$))) gin_trgm_ops);
Search parameter: OperationDefinition.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS operationdefinition_resource__date_maxON"operationdefinition"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS operationdefinition_resource__date_minON"operationdefinition"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS operationdefinition_resource__context_quantity_maxON"operationdefinition"USING btree (knife_extract_max_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS operationdefinition_resource__context_quantity_minON"operationdefinition"USING btree (knife_extract_min_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));
Organization
Search parameter: Organization.address
CREATE INDEX CONCURRENTLYIF NOT EXISTS organization_resource__address_gin_trgmON"organization"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","text"],["address","district"],["address","country"],["address","city"],["address","line"],["address","state"],["address","postalCode"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS organization_resource__ginON"organization"USING GIN (resource);
Search parameter: Organization.address-postalcode
CREATE INDEX CONCURRENTLYIF NOT EXISTS organization_resource__address_postalcode_gin_trgmON"organization"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","postalCode"]]$JSON$))) gin_trgm_ops);
Search parameter: Organization.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS organization_resource__name_gin_trgmON"organization"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"],["alias"]]$JSON$))) gin_trgm_ops);
Search parameter: Organization.address-state
CREATE INDEX CONCURRENTLYIF NOT EXISTS organization_resource__address_state_gin_trgmON"organization"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","state"]]$JSON$))) gin_trgm_ops);
Search parameter: Organization.address-city
CREATE INDEX CONCURRENTLYIF NOT EXISTS organization_resource__address_city_gin_trgmON"organization"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","city"]]$JSON$))) gin_trgm_ops);
Search parameter: Organization.address-country
CREATE INDEX CONCURRENTLYIF NOT EXISTS organization_resource__address_country_gin_trgmON"organization"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","country"]]$JSON$))) gin_trgm_ops);
Search parameter: Organization.phonetic
CREATE INDEX CONCURRENTLYIF NOT EXISTS organization_resource__phonetic_gin_trgmON"organization"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS organizationaffiliation_resource__ginON"organizationaffiliation"USING GIN (resource);
Search parameter: OrganizationAffiliation.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS organizationaffiliation_resource__date_maxON"organizationaffiliation"USING btree (knife_extract_max_timestamptz(resource, '[["period","start"],["period","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS organizationaffiliation_resource__date_minON"organizationaffiliation"USING btree (knife_extract_min_timestamptz(resource, '[["period","start"],["period","end"]]'));
Patient
Search parameter: Patient.birthdate
CREATE INDEX CONCURRENTLYIF NOT EXISTS patient_resource__birthdate_maxON"patient"USING btree (knife_extract_max_timestamptz(resource, '[["birthDate"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS patient_resource__birthdate_minON"patient"USING btree (knife_extract_min_timestamptz(resource, '[["birthDate"]]'));
Search parameter: Patient.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS patient_resource__name_gin_trgmON"patient"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name","family"],["name","given"],["name","middle"],["name","text"]]$JSON$))) gin_trgm_ops);
Search parameter: Patient.death-date
CREATE INDEX CONCURRENTLYIF NOT EXISTS patient_resource__death_date_maxON"patient"USING btree (knife_extract_max_timestamptz(resource, '[["deceased","dateTime"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS patient_resource__death_date_minON"patient"USING btree (knife_extract_min_timestamptz(resource, '[["deceased","dateTime"]]'));
Search parameter: Patient.family
CREATE INDEX CONCURRENTLYIF NOT EXISTS patient_resource__family_gin_trgmON"patient"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name","family"]]$JSON$))) gin_trgm_ops);
Search parameter: Patient.address-city
CREATE INDEX CONCURRENTLYIF NOT EXISTS patient_resource__address_city_gin_trgmON"patient"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","city"]]$JSON$))) gin_trgm_ops);
Search parameter: Patient.given
CREATE INDEX CONCURRENTLYIF NOT EXISTS patient_resource__given_gin_trgmON"patient"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name","given"]]$JSON$))) gin_trgm_ops);
Search parameter: Patient.address-state
CREATE INDEX CONCURRENTLYIF NOT EXISTS patient_resource__address_state_gin_trgmON"patient"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","state"]]$JSON$))) gin_trgm_ops);
Search parameter: Patient.address-postalcode
CREATE INDEX CONCURRENTLYIF NOT EXISTS patient_resource__address_postalcode_gin_trgmON"patient"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","postalCode"]]$JSON$))) gin_trgm_ops);
Search parameter: Patient.address
CREATE INDEX CONCURRENTLYIF NOT EXISTS patient_resource__address_gin_trgmON"patient"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","text"],["address","district"],["address","country"],["address","city"],["address","line"],["address","state"],["address","postalCode"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS patient_resource__ginON"patient"USING GIN (resource);
Search parameter: Patient.phonetic
CREATE INDEX CONCURRENTLYIF NOT EXISTS patient_resource__phonetic_gin_trgmON"patient"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name","family"],["name","given"],["name","middle"],["name","text"]]$JSON$))) gin_trgm_ops);
Search parameter: Patient.address-country
CREATE INDEX CONCURRENTLYIF NOT EXISTS patient_resource__address_country_gin_trgmON"patient"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","country"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS paymentnotice_resource__ginON"paymentnotice"USING GIN (resource);
Search parameter: PaymentNotice.created
CREATE INDEX CONCURRENTLYIF NOT EXISTS paymentnotice_resource__created_maxON"paymentnotice"USING btree (knife_extract_max_timestamptz(resource, '[["created"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS paymentnotice_resource__created_minON"paymentnotice"USING btree (knife_extract_min_timestamptz(resource, '[["created"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS paymentreconciliation_resource__disposition_gin_trgmON"paymentreconciliation"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["disposition"]]$JSON$))) gin_trgm_ops);
Search parameter: PaymentReconciliation.created
CREATE INDEX CONCURRENTLYIF NOT EXISTS paymentreconciliation_resource__created_maxON"paymentreconciliation"USING btree (knife_extract_max_timestamptz(resource, '[["created"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS paymentreconciliation_resource__created_minON"paymentreconciliation"USING btree (knife_extract_min_timestamptz(resource, '[["created"]]'));
Person
Search parameter: Person.birthdate
CREATE INDEX CONCURRENTLYIF NOT EXISTS person_resource__birthdate_maxON"person"USING btree (knife_extract_max_timestamptz(resource, '[["birthDate"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS person_resource__birthdate_minON"person"USING btree (knife_extract_min_timestamptz(resource, '[["birthDate"]]'));
Search parameter: Person.address-state
CREATE INDEX CONCURRENTLYIF NOT EXISTS person_resource__address_state_gin_trgmON"person"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","state"]]$JSON$))) gin_trgm_ops);
Search parameter: Person.address-city
CREATE INDEX CONCURRENTLYIF NOT EXISTS person_resource__address_city_gin_trgmON"person"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","city"]]$JSON$))) gin_trgm_ops);
Search parameter: Person.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS person_resource__name_gin_trgmON"person"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name","family"],["name","given"],["name","middle"],["name","text"]]$JSON$))) gin_trgm_ops);
Search parameter: Person.address
CREATE INDEX CONCURRENTLYIF NOT EXISTS person_resource__address_gin_trgmON"person"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","text"],["address","district"],["address","country"],["address","city"],["address","line"],["address","state"],["address","postalCode"]]$JSON$))) gin_trgm_ops);
Search parameter: Person.address-postalcode
CREATE INDEX CONCURRENTLYIF NOT EXISTS person_resource__address_postalcode_gin_trgmON"person"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","postalCode"]]$JSON$))) gin_trgm_ops);
Search parameter: Person.address-country
CREATE INDEX CONCURRENTLYIF NOT EXISTS person_resource__address_country_gin_trgmON"person"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","country"]]$JSON$))) gin_trgm_ops);
Search parameter: Person.phonetic
CREATE INDEX CONCURRENTLYIF NOT EXISTS person_resource__phonetic_gin_trgmON"person"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name","family"],["name","given"],["name","middle"],["name","text"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS plandefinition_resource__ginON"plandefinition"USING GIN (resource);
Search parameter: PlanDefinition.description
CREATE INDEX CONCURRENTLYIF NOT EXISTS plandefinition_resource__description_gin_trgmON"plandefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
Search parameter: PlanDefinition.publisher
CREATE INDEX CONCURRENTLYIF NOT EXISTS plandefinition_resource__publisher_gin_trgmON"plandefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["publisher"]]$JSON$))) gin_trgm_ops);
Search parameter: PlanDefinition.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS plandefinition_resource__name_gin_trgmON"plandefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
Search parameter: PlanDefinition.title
CREATE INDEX CONCURRENTLYIF NOT EXISTS plandefinition_resource__title_gin_trgmON"plandefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["title"]]$JSON$))) gin_trgm_ops);
Search parameter: PlanDefinition.context-quantity
CREATE INDEX CONCURRENTLYIF NOT EXISTS plandefinition_resource__context_quantity_maxON"plandefinition"USING btree (knife_extract_max_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS plandefinition_resource__context_quantity_minON"plandefinition"USING btree (knife_extract_min_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));
Search parameter: PlanDefinition.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS plandefinition_resource__date_maxON"plandefinition"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS plandefinition_resource__date_minON"plandefinition"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
Search parameter: PlanDefinition.effective
CREATE INDEX CONCURRENTLYIF NOT EXISTS plandefinition_resource__effective_maxON"plandefinition"USING btree (knife_extract_max_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS plandefinition_resource__effective_minON"plandefinition"USING btree (knife_extract_min_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));
Practitioner
Search parameter: Practitioner.family
CREATE INDEX CONCURRENTLYIF NOT EXISTS practitioner_resource__family_gin_trgmON"practitioner"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name","family"]]$JSON$))) gin_trgm_ops);
Search parameter: Practitioner.given
CREATE INDEX CONCURRENTLYIF NOT EXISTS practitioner_resource__given_gin_trgmON"practitioner"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name","given"]]$JSON$))) gin_trgm_ops);
Search parameter: Practitioner.phonetic
CREATE INDEX CONCURRENTLYIF NOT EXISTS practitioner_resource__phonetic_gin_trgmON"practitioner"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name","family"],["name","given"],["name","middle"],["name","text"]]$JSON$))) gin_trgm_ops);
Search parameter: Practitioner.address-state
CREATE INDEX CONCURRENTLYIF NOT EXISTS practitioner_resource__address_state_gin_trgmON"practitioner"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","state"]]$JSON$))) gin_trgm_ops);
Search parameter: Practitioner.address-country
CREATE INDEX CONCURRENTLYIF NOT EXISTS practitioner_resource__address_country_gin_trgmON"practitioner"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","country"]]$JSON$))) gin_trgm_ops);
Search parameter: Practitioner.address
CREATE INDEX CONCURRENTLYIF NOT EXISTS practitioner_resource__address_gin_trgmON"practitioner"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","text"],["address","district"],["address","country"],["address","city"],["address","line"],["address","state"],["address","postalCode"]]$JSON$))) gin_trgm_ops);
Search parameter: Practitioner.address-city
CREATE INDEX CONCURRENTLYIF NOT EXISTS practitioner_resource__address_city_gin_trgmON"practitioner"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","city"]]$JSON$))) gin_trgm_ops);
Search parameter: Practitioner.address-postalcode
CREATE INDEX CONCURRENTLYIF NOT EXISTS practitioner_resource__address_postalcode_gin_trgmON"practitioner"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","postalCode"]]$JSON$))) gin_trgm_ops);
Search parameter: Practitioner.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS practitioner_resource__name_gin_trgmON"practitioner"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name","family"],["name","given"],["name","middle"],["name","text"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS practitionerrole_resource__ginON"practitionerrole"USING GIN (resource);
Search parameter: PractitionerRole.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS practitionerrole_resource__date_maxON"practitionerrole"USING btree (knife_extract_max_timestamptz(resource, '[["period","start"],["period","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS practitionerrole_resource__date_minON"practitionerrole"USING btree (knife_extract_min_timestamptz(resource, '[["period","start"],["period","end"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS procedure_resource__ginON"procedure"USING GIN (resource);
Search parameter: Procedure.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS procedure_resource__date_maxON"procedure"USING btree (knife_extract_max_timestamptz(resource, '[["performed","Age"],["performed","Period","start"],["performed","Period","end"],["performed","string"],["performed","dateTime"],["performed","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS procedure_resource__date_minON"procedure"USING btree (knife_extract_min_timestamptz(resource, '[["performed","Age"],["performed","Period","start"],["performed","Period","end"],["performed","string"],["performed","dateTime"],["performed","Range"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS provenance_resource__ginON"provenance"USING GIN (resource);
Search parameter: Provenance.recorded
CREATE INDEX CONCURRENTLYIF NOT EXISTS provenance_resource__recorded_maxON"provenance"USING btree (knife_extract_max_timestamptz(resource, '[["recorded"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS provenance_resource__recorded_minON"provenance"USING btree (knife_extract_min_timestamptz(resource, '[["recorded"]]'));
Search parameter: Provenance.when
CREATE INDEX CONCURRENTLYIF NOT EXISTS provenance_resource__when_maxON"provenance"USING btree (knife_extract_max_timestamptz(resource, '[["occurred","dateTime"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS provenance_resource__when_minON"provenance"USING btree (knife_extract_min_timestamptz(resource, '[["occurred","dateTime"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS questionnaire_resource__ginON"questionnaire"USING GIN (resource);
Search parameter: Questionnaire.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS questionnaire_resource__name_gin_trgmON"questionnaire"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
Search parameter: Questionnaire.description
CREATE INDEX CONCURRENTLYIF NOT EXISTS questionnaire_resource__description_gin_trgmON"questionnaire"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
Search parameter: Questionnaire.publisher
CREATE INDEX CONCURRENTLYIF NOT EXISTS questionnaire_resource__publisher_gin_trgmON"questionnaire"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["publisher"]]$JSON$))) gin_trgm_ops);
Search parameter: Questionnaire.title
CREATE INDEX CONCURRENTLYIF NOT EXISTS questionnaire_resource__title_gin_trgmON"questionnaire"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["title"]]$JSON$))) gin_trgm_ops);
Search parameter: Questionnaire.effective
CREATE INDEX CONCURRENTLYIF NOT EXISTS questionnaire_resource__effective_maxON"questionnaire"USING btree (knife_extract_max_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS questionnaire_resource__effective_minON"questionnaire"USING btree (knife_extract_min_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));
Search parameter: Questionnaire.context-quantity
CREATE INDEX CONCURRENTLYIF NOT EXISTS questionnaire_resource__context_quantity_maxON"questionnaire"USING btree (knife_extract_max_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS questionnaire_resource__context_quantity_minON"questionnaire"USING btree (knife_extract_min_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));
Search parameter: Questionnaire.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS questionnaire_resource__date_maxON"questionnaire"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS questionnaire_resource__date_minON"questionnaire"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS questionnaireresponse_resource__ginON"questionnaireresponse"USING GIN (resource);
Search parameter: QuestionnaireResponse.authored
CREATE INDEX CONCURRENTLYIF NOT EXISTS questionnaireresponse_resource__authored_maxON"questionnaireresponse"USING btree (knife_extract_max_timestamptz(resource, '[["authored"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS questionnaireresponse_resource__authored_minON"questionnaireresponse"USING btree (knife_extract_min_timestamptz(resource, '[["authored"]]'));
RelatedPerson
Search parameter: RelatedPerson.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS relatedperson_resource__name_gin_trgmON"relatedperson"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name","family"],["name","given"],["name","middle"],["name","text"]]$JSON$))) gin_trgm_ops);
Search parameter: RelatedPerson.address
CREATE INDEX CONCURRENTLYIF NOT EXISTS relatedperson_resource__address_gin_trgmON"relatedperson"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","text"],["address","district"],["address","country"],["address","city"],["address","line"],["address","state"],["address","postalCode"]]$JSON$))) gin_trgm_ops);
Search parameter: RelatedPerson.address-state
CREATE INDEX CONCURRENTLYIF NOT EXISTS relatedperson_resource__address_state_gin_trgmON"relatedperson"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","state"]]$JSON$))) gin_trgm_ops);
Search parameter: RelatedPerson.address-city
CREATE INDEX CONCURRENTLYIF NOT EXISTS relatedperson_resource__address_city_gin_trgmON"relatedperson"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","city"]]$JSON$))) gin_trgm_ops);
Search parameter: RelatedPerson.address-country
CREATE INDEX CONCURRENTLYIF NOT EXISTS relatedperson_resource__address_country_gin_trgmON"relatedperson"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","country"]]$JSON$))) gin_trgm_ops);
Search parameter: RelatedPerson.birthdate
CREATE INDEX CONCURRENTLYIF NOT EXISTS relatedperson_resource__birthdate_maxON"relatedperson"USING btree (knife_extract_max_timestamptz(resource, '[["birthDate"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS relatedperson_resource__birthdate_minON"relatedperson"USING btree (knife_extract_min_timestamptz(resource, '[["birthDate"]]'));
Search parameter: RelatedPerson.phonetic
CREATE INDEX CONCURRENTLYIF NOT EXISTS relatedperson_resource__phonetic_gin_trgmON"relatedperson"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name","family"],["name","given"],["name","middle"],["name","text"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS relatedperson_resource__address_postalcode_gin_trgmON"relatedperson"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["address","postalCode"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS requestgroup_resource__ginON"requestgroup"USING GIN (resource);
Search parameter: RequestGroup.authored
CREATE INDEX CONCURRENTLYIF NOT EXISTS requestgroup_resource__authored_maxON"requestgroup"USING btree (knife_extract_max_timestamptz(resource, '[["authoredOn"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS requestgroup_resource__authored_minON"requestgroup"USING btree (knife_extract_min_timestamptz(resource, '[["authoredOn"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS researchdefinition_resource__ginON"researchdefinition"USING GIN (resource);
Search parameter: ResearchDefinition.description
CREATE INDEX CONCURRENTLYIF NOT EXISTS researchdefinition_resource__description_gin_trgmON"researchdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
Search parameter: ResearchDefinition.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS researchdefinition_resource__name_gin_trgmON"researchdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
Search parameter: ResearchDefinition.publisher
CREATE INDEX CONCURRENTLYIF NOT EXISTS researchdefinition_resource__publisher_gin_trgmON"researchdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["publisher"]]$JSON$))) gin_trgm_ops);
Search parameter: ResearchDefinition.title
CREATE INDEX CONCURRENTLYIF NOT EXISTS researchdefinition_resource__title_gin_trgmON"researchdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["title"]]$JSON$))) gin_trgm_ops);
Search parameter: ResearchDefinition.effective
CREATE INDEX CONCURRENTLYIF NOT EXISTS researchdefinition_resource__effective_maxON"researchdefinition"USING btree (knife_extract_max_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS researchdefinition_resource__effective_minON"researchdefinition"USING btree (knife_extract_min_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS researchdefinition_resource__context_quantity_maxON"researchdefinition"USING btree (knife_extract_max_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS researchdefinition_resource__context_quantity_minON"researchdefinition"USING btree (knife_extract_min_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));
Search parameter: ResearchDefinition.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS researchdefinition_resource__date_maxON"researchdefinition"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS researchdefinition_resource__date_minON"researchdefinition"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS researchelementdefinition_resource__description_gin_trgmON"researchelementdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
Search parameter: ResearchElementDefinition.title
CREATE INDEX CONCURRENTLYIF NOT EXISTS researchelementdefinition_resource__title_gin_trgmON"researchelementdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["title"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS researchelementdefinition_resource__publisher_gin_trgmON"researchelementdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["publisher"]]$JSON$))) gin_trgm_ops);
Search parameter: ResearchElementDefinition.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS researchelementdefinition_resource__name_gin_trgmON"researchelementdefinition"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS researchelementdefinition_resource__context_quantity_maxON"researchelementdefinition"USING btree (knife_extract_max_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS researchelementdefinition_resource__context_quantity_minON"researchelementdefinition"USING btree (knife_extract_min_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS researchelementdefinition_resource__effective_maxON"researchelementdefinition"USING btree (knife_extract_max_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS researchelementdefinition_resource__effective_minON"researchelementdefinition"USING btree (knife_extract_min_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));
Search parameter: ResearchElementDefinition.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS researchelementdefinition_resource__date_maxON"researchelementdefinition"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS researchelementdefinition_resource__date_minON"researchelementdefinition"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS researchstudy_resource__ginON"researchstudy"USING GIN (resource);
Search parameter: ResearchStudy.title
CREATE INDEX CONCURRENTLYIF NOT EXISTS researchstudy_resource__title_gin_trgmON"researchstudy"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["title"]]$JSON$))) gin_trgm_ops);
Search parameter: ResearchStudy.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS researchstudy_resource__date_maxON"researchstudy"USING btree (knife_extract_max_timestamptz(resource, '[["period","start"],["period","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS researchstudy_resource__date_minON"researchstudy"USING btree (knife_extract_min_timestamptz(resource, '[["period","start"],["period","end"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS researchsubject_resource__ginON"researchsubject"USING GIN (resource);
Search parameter: ResearchSubject.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS researchsubject_resource__date_maxON"researchsubject"USING btree (knife_extract_max_timestamptz(resource, '[["period","start"],["period","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS researchsubject_resource__date_minON"researchsubject"USING btree (knife_extract_min_timestamptz(resource, '[["period","start"],["period","end"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS riskassessment_resource__ginON"riskassessment"USING GIN (resource);
Search parameter: RiskAssessment.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS riskassessment_resource__date_maxON"riskassessment"USING btree (knife_extract_max_timestamptz(resource, '[["occurrence","dateTime"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS riskassessment_resource__date_minON"riskassessment"USING btree (knife_extract_min_timestamptz(resource, '[["occurrence","dateTime"]]'));
Search parameter: RiskAssessment.probability
CREATE INDEX CONCURRENTLYIF NOT EXISTS riskassessment_resource__probability_maxON"riskassessment"USING btree (knife_extract_max_numeric(resource, '[["prediction","probability","Range"],["prediction","probability","decimal"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS riskassessment_resource__probability_minON"riskassessment"USING btree (knife_extract_min_numeric(resource, '[["prediction","probability","Range"],["prediction","probability","decimal"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS riskevidencesynthesis_resource__ginON"riskevidencesynthesis"USING GIN (resource);
Search parameter: RiskEvidenceSynthesis.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS riskevidencesynthesis_resource__name_gin_trgmON"riskevidencesynthesis"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
Search parameter: RiskEvidenceSynthesis.publisher
CREATE INDEX CONCURRENTLYIF NOT EXISTS riskevidencesynthesis_resource__publisher_gin_trgmON"riskevidencesynthesis"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["publisher"]]$JSON$))) gin_trgm_ops);
Search parameter: RiskEvidenceSynthesis.title
CREATE INDEX CONCURRENTLYIF NOT EXISTS riskevidencesynthesis_resource__title_gin_trgmON"riskevidencesynthesis"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["title"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS riskevidencesynthesis_resource__description_gin_trgmON"riskevidencesynthesis"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
Search parameter: RiskEvidenceSynthesis.effective
CREATE INDEX CONCURRENTLYIF NOT EXISTS riskevidencesynthesis_resource__effective_maxON"riskevidencesynthesis"USING btree (knife_extract_max_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS riskevidencesynthesis_resource__effective_minON"riskevidencesynthesis"USING btree (knife_extract_min_timestamptz(resource, '[["effectivePeriod","start"],["effectivePeriod","end"]]'));
Search parameter: RiskEvidenceSynthesis.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS riskevidencesynthesis_resource__date_maxON"riskevidencesynthesis"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS riskevidencesynthesis_resource__date_minON"riskevidencesynthesis"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS riskevidencesynthesis_resource__context_quantity_maxON"riskevidencesynthesis"USING btree (knife_extract_max_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS riskevidencesynthesis_resource__context_quantity_minON"riskevidencesynthesis"USING btree (knife_extract_min_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS schedule_resource__ginON"schedule"USING GIN (resource);
Search parameter: Schedule.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS schedule_resource__date_maxON"schedule"USING btree (knife_extract_max_timestamptz(resource, '[["planningHorizon","start"],["planningHorizon","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS schedule_resource__date_minON"schedule"USING btree (knife_extract_min_timestamptz(resource, '[["planningHorizon","start"],["planningHorizon","end"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS servicerequest_resource__ginON"servicerequest"USING GIN (resource);
Search parameter: ServiceRequest.occurrence
CREATE INDEX CONCURRENTLYIF NOT EXISTS servicerequest_resource__occurrence_maxON"servicerequest"USING btree (knife_extract_max_timestamptz(resource, '[["occurrence","Period","start"],["occurrence","Period","end"],["occurrence","dateTime"],["occurrence","Timing","event"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS servicerequest_resource__occurrence_minON"servicerequest"USING btree (knife_extract_min_timestamptz(resource, '[["occurrence","Period","start"],["occurrence","Period","end"],["occurrence","dateTime"],["occurrence","Timing","event"]]'));
Search parameter: ServiceRequest.authored
CREATE INDEX CONCURRENTLYIF NOT EXISTS servicerequest_resource__authored_maxON"servicerequest"USING btree (knife_extract_max_timestamptz(resource, '[["authoredOn"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS servicerequest_resource__authored_minON"servicerequest"USING btree (knife_extract_min_timestamptz(resource, '[["authoredOn"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS slot_resource__ginON"slot"USING GIN (resource);
Search parameter: Slot.start
CREATE INDEX CONCURRENTLYIF NOT EXISTS slot_resource__start_maxON"slot"USING btree (knife_extract_max_timestamptz(resource, '[["start"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS slot_resource__start_minON"slot"USING btree (knife_extract_min_timestamptz(resource, '[["start"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS specimen_resource__ginON"specimen"USING GIN (resource);
Search parameter: Specimen.collected
CREATE INDEX CONCURRENTLYIF NOT EXISTS specimen_resource__collected_maxON"specimen"USING btree (knife_extract_max_timestamptz(resource, '[["collection","collected","Period","start"],["collection","collected","Period","end"],["collection","collected","dateTime"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS specimen_resource__collected_minON"specimen"USING btree (knife_extract_min_timestamptz(resource, '[["collection","collected","Period","start"],["collection","collected","Period","end"],["collection","collected","dateTime"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS specimendefinition_resource__ginON"specimendefinition"USING GIN (resource);
StructureMap
Search parameter: StructureMap.publisher
CREATE INDEX CONCURRENTLYIF NOT EXISTS structuremap_resource__publisher_gin_trgmON"structuremap"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["publisher"]]$JSON$))) gin_trgm_ops);
CREATE INDEX CONCURRENTLYIF NOT EXISTS structuremap_resource__ginON"structuremap"USING GIN (resource);
Search parameter: StructureMap.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS structuremap_resource__name_gin_trgmON"structuremap"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
Search parameter: StructureMap.description
CREATE INDEX CONCURRENTLYIF NOT EXISTS structuremap_resource__description_gin_trgmON"structuremap"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
Search parameter: StructureMap.title
CREATE INDEX CONCURRENTLYIF NOT EXISTS structuremap_resource__title_gin_trgmON"structuremap"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["title"]]$JSON$))) gin_trgm_ops);
Search parameter: StructureMap.context-quantity
CREATE INDEX CONCURRENTLYIF NOT EXISTS structuremap_resource__context_quantity_maxON"structuremap"USING btree (knife_extract_max_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS structuremap_resource__context_quantity_minON"structuremap"USING btree (knife_extract_min_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));
Search parameter: StructureMap.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS structuremap_resource__date_maxON"structuremap"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS structuremap_resource__date_minON"structuremap"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS substance_resource__ginON"substance"USING GIN (resource);
Search parameter: Substance.expiry
CREATE INDEX CONCURRENTLYIF NOT EXISTS substance_resource__expiry_maxON"substance"USING btree (knife_extract_max_timestamptz(resource, '[["instance","expiry"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS substance_resource__expiry_minON"substance"USING btree (knife_extract_min_timestamptz(resource, '[["instance","expiry"]]'));
Search parameter: Substance.quantity
CREATE INDEX CONCURRENTLYIF NOT EXISTS substance_resource__quantity_maxON"substance"USING btree (knife_extract_max_numeric(resource, '[["instance","quantity","value"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS substance_resource__quantity_minON"substance"USING btree (knife_extract_min_numeric(resource, '[["instance","quantity","value"]]'));
SubstanceSpecification
Search parameter: SubstanceSpecification.code
CREATE INDEX CONCURRENTLYIF NOT EXISTS substancespecification_resource__ginON"substancespecification"USING GIN (resource);
CREATE INDEX CONCURRENTLYIF NOT EXISTS supplyrequest_resource__ginON"supplyrequest"USING GIN (resource);
Search parameter: SupplyRequest.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS supplyrequest_resource__date_maxON"supplyrequest"USING btree (knife_extract_max_timestamptz(resource, '[["authoredOn"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS supplyrequest_resource__date_minON"supplyrequest"USING btree (knife_extract_min_timestamptz(resource, '[["authoredOn"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS task_resource__ginON"task"USING GIN (resource);
Search parameter: Task.modified
CREATE INDEX CONCURRENTLYIF NOT EXISTS task_resource__modified_maxON"task"USING btree (knife_extract_max_timestamptz(resource, '[["lastModified"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS task_resource__modified_minON"task"USING btree (knife_extract_min_timestamptz(resource, '[["lastModified"]]'));
Search parameter: Task.period
CREATE INDEX CONCURRENTLYIF NOT EXISTS task_resource__period_maxON"task"USING btree (knife_extract_max_timestamptz(resource, '[["executionPeriod","start"],["executionPeriod","end"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS task_resource__period_minON"task"USING btree (knife_extract_min_timestamptz(resource, '[["executionPeriod","start"],["executionPeriod","end"]]'));
Search parameter: Task.authored-on
CREATE INDEX CONCURRENTLYIF NOT EXISTS task_resource__authored_on_maxON"task"USING btree (knife_extract_max_timestamptz(resource, '[["authoredOn"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS task_resource__authored_on_minON"task"USING btree (knife_extract_min_timestamptz(resource, '[["authoredOn"]]'));
CREATE INDEX CONCURRENTLYIF NOT EXISTS valueset_resource__ginON"valueset"USING GIN (resource);
Search parameter: ValueSet.title
CREATE INDEX CONCURRENTLYIF NOT EXISTS valueset_resource__title_gin_trgmON"valueset"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["title"]]$JSON$))) gin_trgm_ops);
Search parameter: ValueSet.publisher
CREATE INDEX CONCURRENTLYIF NOT EXISTS valueset_resource__publisher_gin_trgmON"valueset"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["publisher"]]$JSON$))) gin_trgm_ops);
Search parameter: ValueSet.description
CREATE INDEX CONCURRENTLYIF NOT EXISTS valueset_resource__description_gin_trgmON"valueset"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["description"]]$JSON$))) gin_trgm_ops);
Search parameter: ValueSet.name
CREATE INDEX CONCURRENTLYIF NOT EXISTS valueset_resource__name_gin_trgmON"valueset"USING GIN ((aidbox_text_search(knife_extract_text(resource, $JSON$[["name"]]$JSON$))) gin_trgm_ops);
Search parameter: ValueSet.context-quantity
CREATE INDEX CONCURRENTLYIF NOT EXISTS valueset_resource__context_quantity_maxON"valueset"USING btree (knife_extract_max_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS valueset_resource__context_quantity_minON"valueset"USING btree (knife_extract_min_numeric(resource, '[["useContext","value","Quantity","value"],["useContext","value","Range"]]'));
Search parameter: ValueSet.date
CREATE INDEX CONCURRENTLYIF NOT EXISTS valueset_resource__date_maxON"valueset"USING btree (knife_extract_max_timestamptz(resource, '[["date"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS valueset_resource__date_minON"valueset"USING btree (knife_extract_min_timestamptz(resource, '[["date"]]'));
VerificationResult
Search parameter: VerificationResult.target
CREATE INDEX CONCURRENTLYIF NOT EXISTS verificationresult_resource__ginON"verificationresult"USING GIN (resource);
CREATE INDEX CONCURRENTLYIF NOT EXISTS visionprescription_resource__ginON"visionprescription"USING GIN (resource);
Search parameter: VisionPrescription.datewritten
CREATE INDEX CONCURRENTLYIF NOT EXISTS visionprescription_resource__datewritten_maxON"visionprescription"USING btree (knife_extract_max_timestamptz(resource, '[["dateWritten"]]'));CREATE INDEX CONCURRENTLYIF NOT EXISTS visionprescription_resource__datewritten_minON"visionprescription"USING btree (knife_extract_min_timestamptz(resource, '[["dateWritten"]]'));