search

openreferral / specification

The Human Services Data Specification - a data exchange format developed by the Open Referral Initiative
https://openreferral.org
Other
117 stars 49 forks source link

Docs page for database schemas needed #276

Open odscjames opened 2 years ago

odscjames commented 2 years ago

We have database schemas in https://github.com/openreferral/specification/tree/master/database but nothing in the docs mentions that - we should add a page/section somewhere.

From https://github.com/openreferral/specification/issues/235

Things to include:

The Mysql one is for Mysql 8.0.

I imported Mysql to Mariadb 10.2 (the last still supported version) fine only after searching and replacing "utf8mb4_0900_ai_ci" -> "utf8mb4_general_ci". I'm going to suggest this is ok as long as it is documented, because I think anyone using this will want to review the collation used anyway and pick one appropriate to their local area (and we should make sure that is in the docs!).

odscjames commented 2 years ago

There is now a Postgres 12 schema too.