Types
AggregationRtQuery
Inheritance: System-2.0.8/Entity-1 ➔ System-2.0.8/PersistentQuery-1 ➔ System-2.0.8/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.8/Entity-1 ➔ System-2.0.8/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.8/Entity-1 ➔ System-2.0.8/Configuration-1
Base type for all configuration types
Entity
Inheritance: System-2.0.8/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.8/Entity-1 ➔ System-2.0.8/PersistentQuery-1 ➔ System-2.0.8/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.8/Entity-1 ➔ System-2.0.8/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.0.8/Entity-1 ➔ System-2.0.8/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.0.8/Entity-1 ➔ System-2.0.8/PersistentQuery-1 ➔ System-2.0.8/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 |
StreamDataAggregationQuery
Inheritance: System-2.0.8/Entity-1 ➔ System-2.0.8/PersistentQuery-1 ➔ System-2.0.8/StreamDataAggregationQuery-1
Persistent query that performs aggregation operations (Count, Min, Max, Avg, Sum) on time-series stream data from CrateDB without grouping.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/AggregationQueryColumns | False | ||
| 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 |
StreamDataDownsamplingQuery
Inheritance: System-2.0.8/Entity-1 ➔ System-2.0.8/PersistentQuery-1 ➔ System-2.0.8/StreamDataDownsamplingQuery-1
Persistent query that downsamples time-series stream data from CrateDB using DATE_BIN bucketing with per-column aggregation (AVG, MIN, MAX). Requires From, To, and Limit (bucket count).
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/AggregationQueryColumns | False | ||
| System-2/StreamDataQuery.RtIds | True | ||
| System-2/StreamDataQuery.From | False | ||
| System-2/StreamDataQuery.To | False | ||
| System-2/StreamDataQuery.Limit | False | ||
| System-2/Query.FieldFilter | True |
StreamDataGroupingAggregationQuery
Inheritance: System-2.0.8/Entity-1 ➔ System-2.0.8/PersistentQuery-1 ➔ System-2.0.8/StreamDataGroupingAggregationQuery-1
Persistent query that performs grouped aggregation operations with GROUP BY functionality on time-series stream data from CrateDB.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/Query.GroupByColumns | False | ||
| System-2/AggregationQueryColumns | False | ||
| 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 |
StreamDataSimpleQuery
Inheritance: System-2.0.8/Entity-1 ➔ System-2.0.8/PersistentQuery-1 ➔ System-2.0.8/StreamDataSimpleQuery-1
Persistent query that retrieves time-series stream data from CrateDB for a given CK type with optional RtIds scope, time filtering, and field filters.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/StreamDataQuery.Columns | False | ||
| System-2/StreamDataQuery.RtIds | True | ||
| System-2/StreamDataQuery.From | True | ||
| System-2/StreamDataQuery.To | True | ||
| System-2/StreamDataQuery.Limit | True | ||
| System-2/Query.Sorting | True | ||
| System-2/Query.FieldFilter | True |
Tenant
Inheritance: System-2.0.8/Entity-1 ➔ System-2.0.8/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.8/Entity-1 ➔ System-2.0.8/Configuration-1 ➔ System-2.0.8/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.8/Entity-1 ➔ System-2.0.8/Configuration-1 ➔ System-2.0.8/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 |