Requests for creating the initial database structure

Table of Contents

Location path

Path in the assembly catalog Assignment

/era_cfg/priv/dbscripts/r_domain_master_create_base_script.sql

Creating the entity database (data) structure of the master domain.

/era_cfg/priv/dbscripts/r_domain_template_create_base_script.sql

Create a template entity database (data) structure from which the databases of all worker domains are deployed.

Overview

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

These queries are expected to create the basic layout of the database: tables, functions, etc.

Then the entire set of database update files, which are also assets, is applied to the database.

See also