Vetmira data export
=====================

This archive contains the complete record set for one clinic, taken at the time
shown in manifest.json.

Layout
------
  <resource>.csv      One file per resource, UTF-8 with a header row. Columns
                      map one-to-one onto the underlying tables.
  documents/          Every uploaded file, in per-patient folders.
  documents/index.csv Maps each stored file to its patient and its path here.
  manifest.json       Row counts, a SHA-256 for every member of this archive,
                      and the schema revision it was taken at.

Notes for whoever imports this
------------------------------
* Timestamps are ISO 8601. Anything ending in Z or +00:00 is UTC.
* Money is in integer minor units (cents). There are no floating-point amounts.
* Columns holding structured data (a note's diagnoses, a form's answers) contain
  JSON text inside a single CSV cell.
* Empty cells are NULL, not the string "None".

What is deliberately not here
-----------------------------
Password hashes, TOTP secrets, recovery codes, sign-in tokens, and session
records are excluded. They are credentials belonging to the system that produced
this export, not clinical records, and they are of no use in another system.
See "excluded" in manifest.json for the full list.

No card data appears anywhere in this archive, because none is ever stored.
Payments carry the processor's reference plus card brand and last four digits.

Handling
--------
This archive is unencrypted protected health information in bulk. Treat it
accordingly: transfer it over a channel appropriate to that, and delete it from
intermediate systems once it has reached its destination.
