Database schema
Aidbox database schema
Last updated
Was this helpful?
Aidbox database schema
Last updated
Was this helpful?
All resource types in Aidbox are stored in different tables, named with a lowercased resource type name. All these tables have a similar schema:
You use the DB Console to explore the database:
As you can see, resources are stored as JSONB documents in the resource column.
You can access attributes of resources using :
Check out our video tutorial about SQL on FHIR in PostgreSQL:
You can define and expose over REST API sophisticated queries in SQL on FHIR data using .