Database Schema (Material Master Building Block)
The material master 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.MaterialMaster.Manager Thing.
The following diagram shows the schema for the material master database objects:
The following Data Shapes in the PTC.MaterialMaster project define the objects in the database schema:
• PTC.MaterialMaster.MaterialClassMaster—Defines the material class master.
• PTC.MaterialMaster.MaterialClassMasterLink—Defines the link between material class masters.
• PTC.MaterialMaster.MaterialMaster—Defines the material master.
• PTC.MaterialMaster.MaterialMasterLink—Defines the link between material masters.
• PTC.MaterialMaster.MaterialMasterToClassLink—Defines the link between a material master and a material class master.
• PTC.MaterialMaster.UOM—Defines the unit of measure.
• PTC.MaterialMaster.UOMConversion—Defines the conversion for a unit of measure.
These Data Shapes have a related _AP Data Shape for the purpose of adding custom properties. For example, the PTC.MaterialMaster.MaterialMaster Data Shape has an associated PTC.MaterialMaster.MaterialMaster_AP Data Shape. For information on using these _AP Data Shapes, see Adding Custom Properties to Data Model Entities.