Tables


SchemaSpy Analysis of mssub_bms.ms_syst_data

Generated on Fri Jan 19 05:41 PST 2024

XML Representation
Insertion Order Deletion Order
TABLES 7
VIEWS 0
COLUMNS 128
Constraints 6
Anomalies 0
Routines 4

Database Properties

Database Type: PostgreSQL - 16.1 (Ubuntu 16.1-1.pgdg22.04+1)

Catalog mssub_bms

Copyright © Lima Buttgereit Holdings LLC d/b/a Muse Systems

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_settings 0 0 28 Table

Configuration data which establishes application behaviors, defaults, and provides a reference center to interested application functionality.

syst_complex_format_values 3 1 22 Table

The list of values provided by an enumeration as well as related behavioral and informational metadata.

syst_enum_items 12 2 22 Table

The list of values provided by an Enumeration as well as related behavioral and informational metadata.

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_interaction_logs 0 2 12 Table

Records interactions to drive both system functionality and to provide usage telemetry.

syst_enums 2 0 16 Table

Enumerates the enumerations known to the system along with additional metadata useful in applying them appropriately.

syst_complex_formats 1 0 14 Table

Establishes definitions for complex data types and their user interface related formatting.

Complex data types may include concepts such as street addresses, personal names, and phone numbers; in each of these cases there are typically multiple fields, but internationally there is no consistent definition of what fields are available and how they should be ordered or arranged.