Requests for creating the initial DB structure

Location path

Path in the build directory Purpose

/era_cfg/priv/dbscripts/r_domain_master_create_base_script.sql

Creation of the master domain entity DB (data) structure.

/era_cfg/priv/dbscripts/r_domain_template_create_base_script.sql

Creation of the template entity DB (data) structure from which all working domain DBs are deployed.

Overview

The set of files defines requests to the PostgreSQL DB server that will be executed in each domain when its DB is created by the corresponding logical role.

These requests are expected to create the base DB layout: tables, functions, etc.

Then the entire set of DB update files, also assets, is applied to the DB.

See also