mscmp_syst_instance.ms

Database Properties

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

Catalog mscmp_syst_instance

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

All Tables Views Comments

Search:

Table / View	Columns	Type	Comments
syst_application_contexts	15	View	Applications are written with certain security and connection characteristics in mind which correlate to database roles used by the application for establishing connections. This table defines the datastore contexts the application is expecting so that Instance records can be validated against the expectations. 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.
syst_applications	11	View	Describes the known applications which is managed by the global database and authentication infrastructure. User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` System Defined Record Supported Operations `SELECT`
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_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.
syst_instance_contexts	14	View	Instance specific settings which determine how each Instance connects to the defined Application Contexts. User Defined Record Supported Operations `SELECT` `UPDATE`
syst_instance_type_applications	10	View	A many-to-many relation indicating which Instance Types are usable for each Application. General Usage Note that creating ms_syst_data.syst_application_contexts records prior to inserting an Instance Type/Application association into this table is recommended as default Instance Type Context records can be created automatically on INSERT into this table so long as the supporting data is available. After insert here, manipulations of what Contexts Applications require must be handled manually. User Defined Record Supported Operations `INSERT` `SELECT` `DELETE`
syst_instance_type_contexts	11	View	Establishes Instance Type defaults for each of an Application’s defined datastore contexts. General Usage In practice, these records are used in the creation of Instance Context records, but do not establish a direct relationship; records in this table simply inform us what Instance Contexts should exist and give us default values to use in their creation. User Defined Record Supported Operations `SELECT` `UPDATE`
syst_instances	18	View	Defines known application instances and provides their configuration settings. User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` `DELETE`
syst_owners	11	View	Identifies instance owners. Instance owners are typically the clients which have commissioned the use of an application instance. User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` `DELETE`

Showing 1 to 10 of 10 entries