Types

Version: 2.0.2

AggregationRtQuery

Inheritance: System-2.0.2/Entity-1 ➔ System-2.0.2/PersistentQuery-1 ➔ System-2.0.2/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

AutoIncrement

Inheritance: System-2.0.2/Entity-1 ➔ System-2.0.2/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

Configuration

Inheritance: System-2.0.2/Entity-1 ➔ System-2.0.2/Configuration-1

Base type for all configuration types

Entity

Inheritance: System-2.0.2/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.0.2/Entity-1 ➔ System-2.0.2/PersistentQuery-1 ➔ System-2.0.2/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

MigrationHistory

Inheritance: System-2.0.2/Entity-1 ➔ System-2.0.2/MigrationHistory-1

Records executed CK model migrations per tenant. Each instance represents one migration execution from a source version to a target version.

ID	Auto Complete Values	Auto Increment Reference	Is Optional
System-2/MigrationHistory.CkModelName			False
System-2/MigrationHistory.FromVersion			False
System-2/MigrationHistory.ToVersion			False
System-2/MigrationHistory.ExecutedAt			False
System-2/MigrationHistory.Success			False
System-2/MigrationHistory.EntitiesAffected			True
System-2/MigrationHistory.EntitiesAdded			True
System-2/MigrationHistory.EntitiesUpdated			True
System-2/MigrationHistory.EntitiesDeleted			True
System-2/MigrationHistory.DurationMs			True
System-2/MigrationHistory.Errors			True
System-2/MigrationHistory.Warnings			True
System-2/MigrationHistory.BackupId			True

PersistentQuery

Inheritance: System-2.0.2/Entity-1 ➔ System-2.0.2/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

Query

Inheritance: System-2.0.2/Entity-1 ➔ System-2.0.2/Query-1

Legacy query type for backward compatibility. Use SimpleRtQuery, AggregationRtQuery, or GroupingAggregationRtQuery instead.

ID	Auto Complete Values	Auto Increment Reference	Is Optional
System-2/Query.CkTypeId			False
System-2/Query.Types			False
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
System-2/Name			False

SimpleRtQuery

Inheritance: System-2.0.2/Entity-1 ➔ System-2.0.2/PersistentQuery-1 ➔ System-2.0.2/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

Tenant

Inheritance: System-2.0.2/Entity-1 ➔ System-2.0.2/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.0.2/Entity-1 ➔ System-2.0.2/Configuration-1 ➔ System-2.0.2/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.0.2/Entity-1 ➔ System-2.0.2/Configuration-1 ➔ System-2.0.2/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