Database-design.md

Database design documentation

The database design documentation was created using http://dbmstools.sourceforge.net/. See the README.md file in the rifDatabase/ERD directory for how to re-create it. This is the current SAHSULAND database. The core schema and the SAHSUland example data are documented.

• SAHSUland core rif40 schema

• SAHSUland example data - the rif_data schema

• Example test case data; also show structure of the output tables - the rif_studies schema

The following are not documented:

• Partitioning (rif40_partitions schema). This will be a separate series of WIKIs.
• PL/pgsql code in rif40_<code area/type, e.g. R, sql, sm - for statemachine, geo>_pkgs. Again this will be documented separately.

There is also a [Powerpoint] (https://github.com/smallAreaHealthStatisticsUnit/rapidInquiryFacility/blob/master/rifDatabase/RIF%20database.pptx?raw=true) presentation of the new RIF database design.