Database Schema (Status Building Block)
The status building block leverages the PTC.DBConnection building block to implement the database. All database configurations and rules can be found by examining the GetDBInfo service on the PTC.Status.Manager Thing.
The following diagram shows the schema for the status database objects:
The following Data Shapes in the PTC.Status project define the objects in the database schema:
• PTC.Status.StatusDefinition—Defines a set of status definitions for each status type.
• PTC.Status.StatusType—Defines the status types.
These Data Shapes have a related _AP Data Shape for the purpose of adding custom properties. For example, the PTC.Status.StatusDefinition Data Shape has an associated PTC.Status.StatusDefinition_AP Data Shape. For information on using these _AP Data Shapes, see Adding Custom Properties to Data Model Entities.