The SmartPlant schemas are configured to use separate data dictionaries for SmartPlant Engineering Manager and each engineering application. While each application sees only the reference data that applies to it, each application shares some common SmartPlant Engineering Manager data. This configuration supports the requirement for distributed management of the relational database, supports navigation across application tables for read‑only access, and supports integration of data across applications.
A valid site with one plant consists of six database schemas when you use SmartPlant P&ID as your application, seven database schemas when you use SmartPlant Electrical, and nine database schemas if you use both applications concurrently. The plant structure schemas are shared between SmartPlant P&ID and SmartPlant Electrical.
For example, in the following figure, the site server contains two plants, one with both SmartPlant P&ID and SmartPlant Electrical associated to it and the other with only the SmartPlant P&ID application associated.
The figure below shows the schemas that would exist in the database for this configuration example, assuming that both applications are in the same database instance. On a given database server, we recommend putting all plants in one database instance.
The majority of database activity occurs in the application schemas (SPPID Schema, SPPID Data Dictionary Schema, SPEL Schema, SPEL Data Dictionary Schema, and SPEL Reference Schema) since this is where the application data is stored. The plant schema contains the smallest amount of data compared with the other schemas.