Database schema

Journl Streamed’s database schema is designed to support the diverse needs of healthcare data management. It includes tables for various FHIR resources, indexed to optimize search and retrieval operations.

Resource Tables

• Each FHIR resource type (e.g., Patient, Observation, Medication) has its own table, with columns corresponding to the attributes defined by the FHIR standard.

• Foreign key relationships are used to link related resources, ensuring data integrity and consistency.

Audit Tables

• To support robust audit and compliance requirements, Journl Streamed maintains audit tables that log changes to FHIR resources.

• These tables capture details such as the type of operation (create, update, delete), the user or system initiating the change, and timestamps.