Editing Kaute Postgres

==Background==
Kaute Postgres is the informal name of the main database instance used for reporting and analytics within K'aute Pasifika.

==Technical info==
The database is PostgreSQL 11.18, provisioned in Azure via [[Cloudland]]. Access to it is based on an IP allow list, which currently includes the K'aute office by default. Other IP addresses can be added on request (but this should be avoided if possible).

Data is stored in a 'kaute_main' database on this instance.

==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.
|}

==Access/Usage==
User accounts are requested via [[Cloudland]]. These provide credentials which can be used in IDEs/apps such as [https://dbeaver.io/ DBeaver] or programmatically.