Skip to content

Latest commit

 

History

History
14 lines (9 loc) · 764 Bytes

README.md

File metadata and controls

14 lines (9 loc) · 764 Bytes
Raw

Database Architecture

db directory contains sql migration files intended to be run against a PostGIS database using Flyway (or simply run in sequence).

  • install flyway
  • rename flyway.conf.template to flyway.conf and fill in the configuration
  • run flyway migrate to run all the sql scripts. Run flyway clean migrate to delete pre-existing data in the schema and re-create the db objects from scratch

ci

pipelines are run at https://kwvmxgit.ad.nerc.ac.uk/bmgf-maps/web/database-architecture

Data import

JSON schemas that define the structure of data to be imported can be found at /doc/data-import-schemas. All data that is to be inserted into the db should be checked against these schemas.