health-ssi-schema.md

#Simple Health Data Schema Generated using DbSchema

Simple Health Data Schema

Entity INSTANCE.AllergyIntoleraqnce

Subset of http://www.hl7.org/fhir/allergyintolerance.html

Idx	Name	Data Type
* 🔑	identifier	INT
* 🔑 ⬈	patient	INT
*	code	INT

Relationships

Type	Name	On
Vir	fk_AllergyIntoleraqnce_Patient	( patient ) ref INSTANCE.Patient (identifier)

Entity INSTANCE.InsuranceProof

Special version of http://fhir.ch/ig/ch-core/StructureDefinition-ch-core-patient.html

Idx	Name	Data Type	Description
* 🔑	identifier	INT
* 🔑 ⬈	identifier_avs13	VARCHAR(15)
*	identifier_insuranceNumber	VARCHAR(50)
*	name.family	VARCHAR(80)
*	name.given	VARCHAR(80)
*	gender	VARCHAR(15)	Values - male
*	birthDate	DATE

Relationships

Type	Name	On
Vir	fk_InsuranceProof_Patient	( identifier_avs13 ) ref INSTANCE.Patient (identifier_avs13)

Entity INSTANCE.MedicationRequest

Subset of http://www.hl7.org/fhir/medicationrequest.html

Idx	Name	Data Type	Description
* 🔑	identifier	INT
*	medication	INT
* 🔑 ⬈	subject	INT	Patient
* 🔑 ⬈	requester	INT	Practitioner
*	authoredOn	DATE

Relationships

Type	Name	On
Vir	fk_MedicationRequest_Patient	( subject ) ref INSTANCE.Patient (identifier)
Vir	fk_MedicationRequest_Practitioner	( requester ) ref INSTANCE.Practitioner (identifier)

Entity INSTANCE.Observation

Subset of http://www.hl7.org/fhir/observation.html

Used for allergy instances in this example

Idx	Name	Data Type	Description
* 🔑	identifier	INT
* 🔑 ⬈	subject	INT	Patient
	category	INT
*	code	INT	Examples - weight
	issued	DATE
* 🔑 ⬈	performer	INT
	value.Quantity.value	INT	Example 85
	valueQuantity.unit	INT	Example kg
	valueString	VARCHAR(100)

Relationships

Type	Name	On
Vir	fk_Observation_Patient	( subject ) ref INSTANCE.Patient (identifier)
Vir	fk_Observation_Practitioner	( performer ) ref INSTANCE.Practitioner (identifier)

Entity INSTANCE.Patient

Subset of http://www.hl7.org/fhir/patient.html

Should rather be «Person» based on the used subset.

Idx	Name	Data Type	Description
* 🔑 ⬋	identifier	INT
🔍 ⬋	identifier_avs13	VARCHAR(15)
	name.family	VARCHAR(80)
	name.given	VARCHAR(80)
	gender	VARCHAR(15)	Values - male
	birthDate	DATE
	address.line	VARCHAR(100)
	address.city	VARCHAR(100)
	address.postalCode	VARCHAR(20)
	address.country	VARCHAR(50)

Entity INSTANCE.Practitioner

Subset of http://www.hl7.org/fhir/practitioner.html

Idx	Name	Data Type	Description
* 🔑 ⬋	identifier	INT
	identifier_gln	INT
	name.family	VARCHAR(100)
	name.given	VARCHAR(50)
	gender	VARCHAR(15)	Values - male
	birthDate	DATE