Editing Kaute Postgres (section)

==Schema==
Data is organised broadly by topic or domain under different schema. Currently the following schema are in use:

{| class="wikitable sortable"
|-
! Schema   !! Description
|-
| imms  || Used for intake of AIR data to populate the [[Imms]] app.
|-
| pho || Patient-level data from PHOs to populate the [[Pasifika health]] app.
|-
| reference   || A veritable smorgasbord of reference data, from tables mapping meshblock<>SA2 to ICD-10 reference data obtained from Te Whatu Ora. 
|-
| tewhatuora || Patient-level data from national collections, supplied by Te Whatu Ora. Used to populate the [[Pasifika health]] app.
|-
| kotahi || Stores CMS data from [[Kotahi]] (supplied by Karo), powering the [[Kotahi PBI]] dashboard and [[Tupaia Report]] dashboard.
|-
| rpt || Central repository for operational data from the [[Indici]] Patient Management System (supplied by Valentia), supporting integrated care models through clinical reporting and business intelligence applications.
|}