TS Domain
This page presents the ERD for each AggregateRoot, grouping related entities into domain boundaries. Each AggregateRoot enforces business rules, processes commands synchronously, and defines consistency borders within a single transactional scope. An indicative json schema is created to how the export of a aggregate root will approximitly look like
Time Series Link Group
Aggregate Root: TimeSeriesLinkGroup
Represents groups of linked time series with their associated details for data organization and management.
erDiagram
"TS.TimeSeriesLinkGroupDetails" {
uniqueidentifier Id PK
uniqueidentifier TimeSeriesLinkGroupId FK
nvarchar Key
nvarchar Value
datetimeoffset StartDate
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"TS.TimeSeriesLinkGroups" {
uniqueidentifier Id PK
nvarchar Reference
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"TS.TimeSeriesLinkGroupDetails" }o--|| "TS.TimeSeriesLinkGroups" : "TimeSeriesLinkGroupId"
erDiagram
"TS.TimeSeriesLinkGroupDetails" {
uniqueidentifier Id PK
uniqueidentifier TimeSeriesLinkGroupId FK
nvarchar Key
nvarchar Value
datetimeoffset StartDate
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"TS.TimeSeriesLinkGroups" {
uniqueidentifier Id PK
nvarchar Reference
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"TS.TimeSeriesLinkGroupDetails" }o--|| "TS.TimeSeriesLinkGroups" : "TimeSeriesLinkGroupId"{
"definitions": {
"TS.TimeSeriesLinkGroupDetails": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"TimeSeriesLinkGroupId": {
"type": "string",
"description": "FK to TS.TimeSeriesLinkGroups"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"StartDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"TS.TimeSeriesLinkGroups": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Reference": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
}
},
"title": "TS.TimeSeriesLinkGroup",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Data Lookup Table
Aggregate Root: DataLookupTable
Represents lookup tables with their schemas, columns, and data for reference data management.
erDiagram
"TS.DataLookupTableData" {
uniqueidentifier Id PK
uniqueidentifier DataLookupTableId
uniqueidentifier DataLookupTableSchemaId
datetimeoffset ReceivedDateTime
varbinary CompressedCsvData
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"TS.DataLookupTableSchemaColumns" {
}
"TS.DataLookupTableSchemas" {
}
"TS.DataLookupTables" {
}
erDiagram
"TS.DataLookupTableData" {
uniqueidentifier Id PK
uniqueidentifier DataLookupTableId
uniqueidentifier DataLookupTableSchemaId
datetimeoffset ReceivedDateTime
varbinary CompressedCsvData
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"TS.DataLookupTableSchemaColumns" {
}
"TS.DataLookupTableSchemas" {
}
"TS.DataLookupTables" {
}{
"definitions": {
"TS.DataLookupTableData": {
"properties": {
"DataLookupTableSchemaId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"DataLookupTableId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ReceivedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CompressedCsvData": {
"type": "string",
"description": "varbinary"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"TS.DataLookupTableSchemas": {
"properties": {
},
"type": "object"
},
"TS.DataLookupTableSchemaColumns": {
"properties": {
},
"type": "object"
},
"TS.DataLookupTables": {
"properties": {
},
"type": "object"
}
},
"title": "TS.DataLookupTable",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}