Tables


SchemaSpy Analysis of mssub_bms.ms_syst

Generated on Fri Jan 19 05:41 PST 2024

XML Representation
Insertion Order Deletion Order
TABLES 0
VIEWS 4
COLUMNS 81
Constraints 0
Anomalies 0
Routines 12

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

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 Children Parents Columns Type Comments
syst_settings 0 0 28 View

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

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 0 0 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 0 0 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_enums 0 0 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.