Types
AggregationRtQuery
Inheritance: System-2.5.0/Entity-1 ➔ System-2.5.0/PersistentQuery-1 ➔ System-2.5.0/AggregationRtQuery-1
Query type for performing aggregation operations (Count, Min, Max, Avg, Sum) on entity data without grouping.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/AggregationQueryColumns | False | ||
| System-2/Query.FieldFilter | True | ||
| System-2/Query.TextSearchFilter | True | ||
| System-2/Query.AttributeSearchFilter | True |
AggregationSdQuery
Inheritance: System-2.5.0/Entity-1 ➔ System-2.5.0/PersistentQuery-1 ➔ System-2.5.0/StreamDataQuery-1 ➔ System-2.5.0/AggregationSdQuery-1
Persistent stream-data query that performs aggregation operations (Count, Min, Max, Avg, Sum) on time-series data without grouping.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/AggregationQueryColumns | False |
AutoIncrement
Inheritance: System-2.5.0/Entity-1 ➔ System-2.5.0/AutoIncrement-1
Manages auto-incrementing sequences for generating unique identifiers with configurable format and range.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/AutoIncrement.End | False | ||
| System-2/AutoIncrement.Format | True | ||
| System-2/AutoIncrement.CurrentValue | False |
BlueprintBackup
Inheritance: System-2.5.0/Entity-1 ➔ System-2.5.0/BlueprintBackup-1
Snapshot of seed entities captured immediately before a blueprint apply, used to support rollback.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/BlueprintBackup.BlueprintName | False | ||
| System-2/BlueprintBackup.BlueprintVersion | False | ||
| System-2/BlueprintBackup.CreatedAt | False | ||
| System-2/BlueprintBackup.SnapshotJson | False |
BlueprintHistory
Inheritance: System-2.5.0/Entity-1 ➔ System-2.5.0/BlueprintHistory-1
Append-only audit log of blueprint apply operations in the tenant. One entity per apply (install, update, rollback, re-apply).
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/BlueprintHistory.BlueprintName | False | ||
| System-2/BlueprintHistory.BlueprintVersion | False | ||
| System-2/BlueprintHistory.AppliedAt | False | ||
| System-2/BlueprintHistory.ApplicationMode | False | ||
| System-2/BlueprintHistory.PreviousBlueprintName | True | ||
| System-2/BlueprintHistory.PreviousVersion | True | ||
| System-2/BlueprintHistory.EntitiesCreated | False | ||
| System-2/BlueprintHistory.EntitiesUpdated | False | ||
| System-2/BlueprintHistory.EntitiesDeleted | False | ||
| System-2/BlueprintHistory.SeedDataChecksum | True |
BlueprintInstallation
Inheritance: System-2.5.0/Entity-1 ➔ System-2.5.0/BlueprintInstallation-1
Records a blueprint that is currently installed in the tenant. One entity per installed blueprint; replaced on update or re-apply, removed on uninstall.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/BlueprintInstallation.BlueprintName | False | ||
| System-2/BlueprintInstallation.BlueprintVersion | False | ||
| System-2/BlueprintInstallation.InstalledAt | False | ||
| System-2/BlueprintInstallation.LastUpdatedAt | False | ||
| System-2/BlueprintInstallation.SeedDataChecksum | True | ||
| System-2/BlueprintInstallation.IsDependency | False | ||
| System-2/BlueprintInstallation.ResolvedDependencies | True |
Configuration
Inheritance: System-2.5.0/Entity-1 ➔ System-2.5.0/Configuration-1
Base type for all configuration types
DownsamplingSdQuery
Inheritance: System-2.5.0/Entity-1 ➔ System-2.5.0/PersistentQuery-1 ➔ System-2.5.0/StreamDataQuery-1 ➔ System-2.5.0/DownsamplingSdQuery-1
Persistent stream-data query that downsamples time-series data using DATE_BIN bucketing with per-column aggregation (AVG, MIN, MAX). From, To, and Limit (bucket count) are required at the API level even though the schema marks them optional on the base.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/AggregationQueryColumns | False |
Entity
Inheritance: System-2.5.0/Entity-1
Abstract base type for all entities in the system. Provides common indexing and association capabilities.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/RtBlueprintSource | True | ||
| System-2/RtBlueprintLocked | True | ||
| System-2/RtBlueprintAppliedAt | True |
Outbound Associations
| Outbound Name | Outbound Multiplicity | CkRoleId | TargetCKTypeId | Target Attributes |
|---|---|---|---|---|
| RelatesTo | N | System-2/Related | System-2/Entity |
Inbound Associations
| Inbound Name | Inbound Multiplicity | CkRoleId | TargetCKTypeId | Target Attributes |
|---|---|---|---|---|
| RelatesFrom | N | System-2/Related | System-2/Entity |
GroupingAggregationRtQuery
Inheritance: System-2.5.0/Entity-1 ➔ System-2.5.0/PersistentQuery-1 ➔ System-2.5.0/GroupingAggregationRtQuery-1
Query type for performing grouped aggregation operations with GROUP BY functionality on entity data.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/Query.GroupByColumns | False | ||
| System-2/AggregationQueryColumns | False | ||
| System-2/Query.FieldFilter | True | ||
| System-2/Query.TextSearchFilter | True | ||
| System-2/Query.AttributeSearchFilter | True |
GroupingAggregationSdQuery
Inheritance: System-2.5.0/Entity-1 ➔ System-2.5.0/PersistentQuery-1 ➔ System-2.5.0/StreamDataQuery-1 ➔ System-2.5.0/GroupingAggregationSdQuery-1
Persistent stream-data query that performs grouped aggregation with GROUP BY functionality on time-series data.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/Query.GroupByColumns | False | ||
| System-2/AggregationQueryColumns | False |
MigrationHistory
Inheritance: System-2.5.0/Entity-1 ➔ System-2.5.0/MigrationHistory-1
Records executed CK model migrations per tenant. Each instance represents one migration execution from a source version to a target version.
PersistentQuery
Inheritance: System-2.5.0/Entity-1 ➔ System-2.5.0/PersistentQuery-1
Abstract base type for all query types. Defines common query properties like name, description, and target type.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/Name | False | ||
| System-2/Description | True | ||
| System-2/Query.CkTypeId | False | ||
| System-2/Query.NavigationFilterMode | True |
SimpleRtQuery
Inheritance: System-2.5.0/Entity-1 ➔ System-2.5.0/PersistentQuery-1 ➔ System-2.5.0/SimpleRtQuery-1
Query type for retrieving rows/tuples from entities with support for column selection, sorting, and filtering.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/Query.Columns | False | ||
| System-2/Query.Sorting | True | ||
| System-2/Query.FieldFilter | True | ||
| System-2/Query.TextSearchFilter | True | ||
| System-2/Query.AttributeSearchFilter | True |
SimpleSdQuery
Inheritance: System-2.5.0/Entity-1 ➔ System-2.5.0/PersistentQuery-1 ➔ System-2.5.0/StreamDataQuery-1 ➔ System-2.5.0/SimpleSdQuery-1
Persistent stream-data query that retrieves time-series rows for a given CK type with optional column projection, sorting, and field filters.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/StreamDataQuery.Columns | False | ||
| System-2/Query.Sorting | True |
StreamDataQuery
Inheritance: System-2.5.0/Entity-1 ➔ System-2.5.0/PersistentQuery-1 ➔ System-2.5.0/StreamDataQuery-1
Abstract base for stream-data query types. Carries the common time-range, limit, rtId scope, archive reference, and field-filter attributes shared by all concrete SdQuery subtypes.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/StreamDataQuery.ArchiveRtId | True | ||
| System-2/StreamDataQuery.RtIds | True | ||
| System-2/StreamDataQuery.From | True | ||
| System-2/StreamDataQuery.To | True | ||
| System-2/StreamDataQuery.Limit | True | ||
| System-2/Query.FieldFilter | True |
Tenant
Inheritance: System-2.5.0/Entity-1 ➔ System-2.5.0/Tenant-1
Represents a tenant in the multi-tenant system with its unique identifier, parent relationship, and database mapping.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/TenantId | False | ||
| System-2/ParentTenantId | True | ||
| System-2/DatabaseName | False |
TenantConfiguration
Inheritance: System-2.5.0/Entity-1 ➔ System-2.5.0/Configuration-1 ➔ System-2.5.0/TenantConfiguration-1
Configuration for a tenant regarding data version of schema or identity data
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/ConfigurationValue | True |
TenantModeConfiguration
Inheritance: System-2.5.0/Entity-1 ➔ System-2.5.0/Configuration-1 ➔ System-2.5.0/TenantModeConfiguration-1
Configuration for a tenant if the tenant is in a specific mode, e.g. test mode or maintenance mode
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/EnvironmentMode | False | ||
| System-2/MaintenanceLevel | False | ||
| System-2/PublishCkModelObservability | True | ||
| System-2/PublishWorkloadObservability | True |