mscmp_syst_hierarchy.ms

TABLES 0

COLUMNS 85

Constraints 0

Anomalies 0

Routines 15

Database Properties

Database Type: PostgreSQL - 18.0 (Ubuntu 18.0-1.pgdg24.04+3)

Catalog mscmp_syst_hierarchy

This database software and documentation is licensed to you under the terms of the Muse Systems Business Management System License Agreement v1.1 or other written, superseding license that you have obtained from Muse Systems.

Only Muse Systems may license this software to you. Your continued use of this software indicates your agreement to abide by the applicable license terms.

This database may include content copyrighted by and licensed from third parties.

Please see the license or contact us for more information.

muse.information@musesystems.com :: https://muse.systems

Schema ms_syst

Public API for system management oriented data access and operations.

This schema contains procedures, functions, and views suitable for access by applications and integration tools.

Tables

Table / View	Columns	Type	Comments
syst_hierarchies	17	View	Establishes a hierarchical template for parent/child relationships to follow. The `hierarchies` relation creates a type of hierarchy which is linked to a specific feature or functional area of the application via a record’s `hierarchy_type_id` reference. Hierarchies is also the parent relation of Hierarchy Items relation (`ms_syst_data.syst_hierarchy_items`) records where each Hierarchy Items record represents a level of the hierarchy. General Usage Note that once the Hierarchy is active and in use by Hierarchy implementing Components, most changes to the Hierarchy records will not be allowed to ensure the consistency of currently used data. User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` `DELETE` System Defined Record Supported Operations `SELECT` `UPDATE` - See column comments for applicable restrictions.
syst_enum_functional_types	15	View	For those Enumerations requiring Functional Type designation, this table defines the available types and persists related metadata. Note that not all Enumerations require Functional Types. User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` `DELETE` System Defined Record Supported Operations `SELECT` `UPDATE` - See column comments for applicable restrictions.
syst_enum_items	22	View	The list of values provided by an Enumeration as well as related behavioral and informational metadata. User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` `DELETE` System Defined Record Supported Operations `SELECT` `UPDATE` - See column comments for applicable restrictions.
syst_hierarchy_items	15	View	Hierarchy Item records represent a level in the hierarchy of their parent Hierarchy. General Usage Each Hierarchy Item record is individually sequenced in its group via the `hierarchy_depth` column. Note that once the Hierarchy is active and in use by Hierarchy implementing Components, most changes to the Hierarchy Item records will not be allowed to ensure the consistency of currently used data. User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` `DELETE` System Defined Record Supported Operations `SELECT` `UPDATE` - See column comments for applicable restrictions. `DELETE` - Only user maintainable records. Supplemental Notes Once the Hierarchy is active and in use by Hierarchy implementing Components, most changes to the Hierarchy Item records will not be allowed to ensure the consistency of currently used data. Also for data consistency reasons, using this API view imposes the fundamental restriction that Hierarchy Item hierarchies can only be constructed top down and deconstructed bottom up. Updates are limited to allowing some naming updates, but not updates in hierarchy changes.
syst_enums	16	View	Enumerates the enumerations known to the system along with additional metadata useful in applying them appropriately. User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` `DELETE` System Defined Record Supported Operations `SELECT` `UPDATE` - See column comments for applicable restrictions.