mscmp_syst_hierarchy.ms_syst

TABLES 5

COLUMNS 84

Constraints 6

Anomalies 0

Routines 12

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_data

Internal system management data for use by Muse Systems developers.

All member objects of this schema are considered “private”.

Direct usage of this schema or its member objects is not supported. Please consider using features from ms_syst Public API schema or other Public APIs as appropriate.

Tables

Table / View	Children	Parents	Columns	Type	Comments
syst_hierarchies	1	2	17	Table	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.
syst_enum_functional_types	1	1	14	Table	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.
syst_enum_items	2	2	22	Table	The list of values provided by an Enumeration as well as related behavioral and informational metadata.
syst_hierarchy_items	0	1	15	Table	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.
syst_enums	2	0	16	Table	Enumerates the enumerations known to the system along with additional metadata useful in applying them appropriately.