Database Schema (Shift Building Block)
The shift 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.Shift.Manager Thing.
The following diagram shows the schema for the shift database objects:
The following Data Shapes in the PTC.Shift project define the objects in the database schema:
• PTC.Shift.Calendar—Defines the data for a calendar.
• PTC.Shift.CalendarDayRepeating—Defines the data for a repeating calendar day.
• PTC.Shift.CalendarException—Defines the data for a calendar exception.
• PTC.Shift.CalendarType—Defines the calendar type.
• PTC.Shift.Crew—Defines the data for a crew.
• PTC.Shift.ModelCalendarLink—Defines the link between a model and a calendar.
• PTC.Shift.Shift—Defines the data for a shift.
• PTC.Shift.ShiftInstance—Defines the data for a shift instance.
• PTC.Shift.ShiftSchedule—Defines the data for a shift schedule.
• PTC.Shift.ShiftToCrewLink—Defines the link between a shift and a crew.
• PTC.Shift.ShiftToWorkActivityLink—Defines the link between a shift and a work activity.
• PTC.Shift.WorkActivity—Defines the data for a work activity.
These Data Shapes have a related _AP Data Shape for the purpose of adding custom properties. For example, the PTC.Shift.Shift Data Shape has an associated PTC.Shift.Shift_AP Data Shape. For information on using these _AP Data Shapes, see Adding Custom Properties to Data Model Entities.