Schemas

CDP4Server Database Schema's

The CDP4Server Database contains multiple database schema's.

SiteDirectory

Every CDP4Server database contains a single SiteDirectory schema. Al EngineeringModels that are available through a COMET WebService share the same SiteDirectory, so only one is present.

Engineeringmodel

For every EngineeringModel a specific schema is created, therefore a CP4Server can contain multiple EngineeringModel schema's:

• One for each EngineeringModel.
• The naming convention is EngineeringModel_[EngineeringModel_Iid].
• All data related to the EngineeringModel is stored in this schema.

Iteration

For every EngineeringModel a specific Iteration schema is created, therefore a CP4Server can contain multiple Iteration schema's:

• One for every EngineeringModel.
• The naming convention is Iteration_[EngineeringModel_Iid]. (the unique identifier of the container EngineeringModel is used to identify the schema of the corresponding Iteration)
• All data related to the EngineeringModel's containing Iterations is stored in this schema, therefore data for multiple Iterations could be present in this schema.

NOTE: even though an Engineering Model can contain multiple Iterations, there is only one Iteration schema per Engineering Model. All data for all Iterations of that model is stored in the same Iteration schema