A Smart 3D project uses a set of seven interrelated databases: site, site schema, catalog, catalog schema, model, reports, and reports schema. You must create these databases before using Smart 3D.
The graphic below depicts the order of creation and the relationships between these databases.
1 - Site 2 - Site schema 3 - Catalog 4 - Catalog schema 5 - Model 6 - Reports 7 - Reports schema |
Site database
Serves as the primary or main database and the container for the other databases. The site contains all permission groups and related data and allows you to access the model and catalog databases. You must create the site database before creating the model or catalog databases. A site database can point to multiple model databases and multiple catalog databases. Typically, there is one site database set for each location.
Site schema database
Contains metadata describing and managing backup and maintenance needs for all databases. When you create the site database, you also create the site schema database.
Catalog database
Contains reference data, which includes information for commodity components, physical dimensions, and standards based on industry specifications. Catalog data includes:
-
Graphical symbols that you can place in the model, such as equipment or piping components
-
Non-graphical, tabular data, such as specification data
-
Parts that you place in the model, such as piping components and equipment
-
Rules that govern how the parts are placed and connected
Catalog schema database
Contains metadata that describes the format of business objects, such as pipe and structural shapes, and their relationships. When you create the catalog database, you also create the catalog schema. Model and catalog databases share the same catalog schema database.
Model database
Contains all of the physical data and three-dimensional objects in the model.
Reports database
Interacts with the catalog and model databases to generate tabular reports from Smart 3D data. The reports database is a set of queries and views that point to the data in the other databases. The reports database and schema are created during the model creation process.
Reports schema database
Contains metadata that describes the report formats.