The Skedulo core data model
This page provides an overview of the Skedulo Pulse Platform core data model.
About the standard data model
Data model field types
- Optional Geolocation - internal only
- Lookup (relationship to one record)
- Has Many (relationship to many records)
All fields can be of an
optional type, for example
Optional Picklist or
Geolocation is an internal type, therefore it can’t be added as a custom field and is always optional.
Data model data types
Optional Field can have one of the following data types:
- Geolocation (Lat, Long pair of BigDecimals)
Picklists are represented as
Multipicklists are represented as arrays of
Data model constraints, triggers, and indexes
The standard data model contains various data integrity constraints and triggers that implement business logic with respect to the relationship between objects.
For example, the
Duration of a
Job must be the difference between the
End timestamps and the
JobStatus field is automatically updated based on the combined status of all the
Custom data models
Skedulo Pulse Platform customers can create custom objects that consist of a
description and a set of fields.
Skedulo for Salesforce customers can map Salesforce custom objects to their Skedulo data model.
Skedulo Pulse Platform customers can create custom fields on standard objects or custom objects.
Fields can be of types equivalent to the data model types above. There are also special types for
Text Area and
URL, which are internally represented as strings.
Was this page helpful?