This is a description of the EnergyModel module
This is the multi-page printable view of this section. Click here to print.
EnergyModel module
The EnergyModel module in Vertex
1 - Energy 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
Calendar
Aggregate Root: Calendar
Represents calendars with their associated events for scheduling and time management.
erDiagram
"Energy.CalendarEvents" {
uniqueidentifier Id PK
uniqueidentifier CalendarId FK
nvarchar Description
datetime Date
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Energy.Calendars" {
uniqueidentifier Id PK
nvarchar Name
nvarchar Description
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Energy.CalendarEvents" }o--|| "Energy.Calendars" : "CalendarId"
erDiagram
"Energy.CalendarEvents" {
uniqueidentifier Id PK
uniqueidentifier CalendarId FK
nvarchar Description
datetime Date
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Energy.Calendars" {
uniqueidentifier Id PK
nvarchar Name
nvarchar Description
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Energy.CalendarEvents" }o--|| "Energy.Calendars" : "CalendarId"{
"definitions": {
"Energy.CalendarEvents": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"CalendarId": {
"type": "string",
"description": "FK to Energy.Calendars"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Date": {
"type": "string",
"description": "datetime"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Description": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Energy.Calendars": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Description": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
}
},
"title": "Energy.Calendar",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Market Party
Aggregate Root: MarketParty
Represents parties in the energy market with their roles and relationships.
erDiagram
"Energy.MarketParties" {
uniqueidentifier Id PK
nvarchar EAN
bit IsOwnMarketParty
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
nvarchar Name
bit Concealed
}
"Energy.MarketPartyRoles" {
uniqueidentifier Id PK
uniqueidentifier MarketPartyId FK
int MarketRole
nvarchar Comment
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Energy.MarketParty_TimeSeries" {
uniqueidentifier Id PK
uniqueidentifier MarketPartyId FK
int TimeSeriesLinkType
nvarchar TSCode
nvarchar TSDataSlotReference
nvarchar TSRevision
uniqueidentifier TimeSeriesLinkGroupId
uniqueidentifier TimeSeriesLinkGroupTypeImplementationId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Energy.MarketParty_TimeSeries" }o--|| "Energy.MarketParties" : "MarketPartyId"
"Energy.MarketPartyRoles" }o--|| "Energy.MarketParties" : "MarketPartyId"
"Energy.NetAreaGridOperatorPeriods" }o--|| "Energy.MarketPartyRoles" : "GridOperatorId"
"Energy.SupplyMeteringPointPeriods" }o--|| "Energy.MarketPartyRoles" : "BalanceResponsiblePartyId"
"Energy.SupplyMeteringPointPeriods" }o--|| "Energy.MarketPartyRoles" : "GridOperatorPartyId"
"Energy.SupplyMeteringPointPeriods" }o--|| "Energy.MarketPartyRoles" : "MeteringResponsiblePartyId"
"Energy.SupplyMeteringPointPeriods" }o--|| "Energy.MarketPartyRoles" : "SupplierId"
erDiagram
"Energy.MarketParties" {
uniqueidentifier Id PK
nvarchar EAN
bit IsOwnMarketParty
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
nvarchar Name
bit Concealed
}
"Energy.MarketPartyRoles" {
uniqueidentifier Id PK
uniqueidentifier MarketPartyId FK
int MarketRole
nvarchar Comment
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Energy.MarketParty_TimeSeries" {
uniqueidentifier Id PK
uniqueidentifier MarketPartyId FK
int TimeSeriesLinkType
nvarchar TSCode
nvarchar TSDataSlotReference
nvarchar TSRevision
uniqueidentifier TimeSeriesLinkGroupId
uniqueidentifier TimeSeriesLinkGroupTypeImplementationId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Energy.MarketParty_TimeSeries" }o--|| "Energy.MarketParties" : "MarketPartyId"
"Energy.MarketPartyRoles" }o--|| "Energy.MarketParties" : "MarketPartyId"
"Energy.NetAreaGridOperatorPeriods" }o--|| "Energy.MarketPartyRoles" : "GridOperatorId"
"Energy.SupplyMeteringPointPeriods" }o--|| "Energy.MarketPartyRoles" : "BalanceResponsiblePartyId"
"Energy.SupplyMeteringPointPeriods" }o--|| "Energy.MarketPartyRoles" : "GridOperatorPartyId"
"Energy.SupplyMeteringPointPeriods" }o--|| "Energy.MarketPartyRoles" : "MeteringResponsiblePartyId"
"Energy.SupplyMeteringPointPeriods" }o--|| "Energy.MarketPartyRoles" : "SupplierId"{
"definitions": {
"Energy.MarketParties": {
"properties": {
"EAN": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"IsOwnMarketParty": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Energy.MarketPartyRoles": {
"properties": {
"Comment": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"MarketPartyId": {
"type": "string",
"description": "FK to Energy.MarketParties"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"MarketRole": {
"type": "integer",
"description": "int"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Energy.MarketParty_TimeSeries": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"TSRevision": {
"type": "string",
"description": "nvarchar"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"TimeSeriesLinkGroupTypeImplementationId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"TSCode": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"MarketPartyId": {
"type": "string",
"description": "FK to Energy.MarketParties"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"TSDataSlotReference": {
"type": "string",
"description": "nvarchar"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"TimeSeriesLinkGroupId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"TimeSeriesLinkType": {
"type": "integer",
"description": "int"
}
},
"type": "object"
}
},
"title": "Energy.MarketParty",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Holiday
Aggregate Root: Holiday
Represents holidays and special days for calendar and scheduling purposes.
erDiagram
"Energy.Holidays" {
uniqueidentifier Id PK
datetime Date
nvarchar Description
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
erDiagram
"Energy.Holidays" {
uniqueidentifier Id PK
datetime Date
nvarchar Description
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}{
"definitions": {
"Energy.Holidays": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Description": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Date": {
"type": "string",
"description": "datetime"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
}
},
"title": "Energy.Holiday",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Metering Point
Aggregate Root: MeteringPoint
Represents metering points for energy measurement and monitoring.
erDiagram
"Energy.MasterDataMeteringPointPeriods" {
uniqueidentifier Id PK
nvarchar ClientName
int MarketSegment
int EnergyFlowDirection
int MeteringMethod
int AllocationMethod
int PhysicalStatus
int EnergyDeliveryStatus
decimal ContractedCapacity
int AdministrativeStatusSmartMeter
nvarchar LocationDescription
nvarchar CapTarCode
nvarchar InvoiceMonth
uniqueidentifier MeteringPointId FK
nvarchar Comment
datetime Start
datetime End
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
decimal MaxConsumption
int Subtype
int Switchability
nvarchar PrimaryAllocationPoint
nvarchar SecondaryAllocationPointsConcatenated
nvarchar PhysicalCapacity
bit Concealed
}
"Energy.MeteringPointInformationPeriods" {
uniqueidentifier Id PK
nvarchar Appliance
int ArticleSub
int DisconnectionMethod
int SDERegulation
int SustainableEnergy
nvarchar BAGId
nvarchar BAGBuildingId
nvarchar TNTId
uniqueidentifier MeteringPointId FK
nvarchar Comment
datetime Start
datetime End
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Energy.MeteringPoints" {
uniqueidentifier Id PK
nvarchar EAN
nvarchar Comment
uniqueidentifier Tenant
int Switch
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier AddressId FK
int ProductType
bit IsVirtual
bit IsManual
int CARStatusFlags
bit Concealed
}
"Energy.PeriodicMeterReadings" {
uniqueidentifier Id PK
int ConsumptionPeakStart
int ConsumptionPeakEnd
int ConsumptionPeakTotal
int ConsumptionPeakMax
int ConsumptionPeakMin
int ConsumptionOffPeakStart
int ConsumptionOffPeakEnd
int ConsumptionOffPeakTotal
int ConsumptionOffPeakMax
int ConsumptionOffPeakMin
int ProductionPeakStart
int ProductionPeakEnd
int ProductionPeakTotal
int ProductionPeakMax
int ProductionPeakMin
int ProductionOffPeakStart
int ProductionOffPeakEnd
int ProductionOffPeakTotal
int ProductionOffPeakMax
int ProductionOffPeakMin
uniqueidentifier MeteringPointId FK
nvarchar Comment
datetime Start
datetime End
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Energy.ProfileEAVMeteringPointPeriods" {
uniqueidentifier Id PK
uniqueidentifier ProfileId FK
int EAEnergyConsumptionNettedPeak
int EAEnergyConsumptionNettedOffPeak
uniqueidentifier MeteringPointId FK
nvarchar Comment
datetime Start
datetime End
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
int EAEnergyProductionNettedPeak
int EAEnergyProductionNettedOffPeak
bit Concealed
}
"Energy.ReconciliationMeteringPointPeriods" {
uniqueidentifier Id PK
datetime MeteringMonth
datetime APXMonth
uniqueidentifier PeriodicMeterReadingId FK
uniqueidentifier MasterDataId FK
uniqueidentifier MeteringPointId FK
nvarchar Comment
datetime Start
datetime End
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Energy.SupplyMeteringPointPeriods" {
uniqueidentifier Id PK
uniqueidentifier SupplierId FK
uniqueidentifier BalanceResponsiblePartyId FK
uniqueidentifier MeteringResponsiblePartyId FK
uniqueidentifier MeteringPointId FK
nvarchar Comment
datetime Start
datetime End
uniqueidentifier GridOperatorPartyId FK
bit Confirmed
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Energy.MasterDataMeteringPointPeriods" }o--|| "Energy.MeteringPoints" : "MeteringPointId"
"Energy.ReconciliationMeteringPointPeriods" }o--|| "Energy.MasterDataMeteringPointPeriods" : "MasterDataId"
"Energy.MeteringPointInformationPeriods" }o--|| "Energy.MeteringPoints" : "MeteringPointId"
"Energy.CustomMasterDataMeteringPointPeriods" }o--|| "Energy.MeteringPoints" : "MeteringPointId"
"Energy.CustomMeteringPointInformationPeriods" }o--|| "Energy.MeteringPoints" : "MeteringPointId"
"Energy.CustomProfileEAVMeteringPointPeriods" }o--|| "Energy.MeteringPoints" : "MeteringPointId"
"Energy.MeteringPoints" }o--|| "Energy.Addresses" : "AddressId"
"Energy.NetAreaMeteringPointPeriods" }o--|| "Energy.MeteringPoints" : "MeteringPointId"
"Energy.PeriodicMeterReadings" }o--|| "Energy.MeteringPoints" : "MeteringPointId"
"Energy.ProfileEAVMeteringPointPeriods" }o--|| "Energy.MeteringPoints" : "MeteringPointId"
"Energy.ReconciliationMeteringPointPeriods" }o--|| "Energy.MeteringPoints" : "MeteringPointId"
"Energy.SupplyMeteringPointPeriods" }o--|| "Energy.MeteringPoints" : "MeteringPointId"
"Energy.ReconciliationMeteringPointPeriods" }o--|| "Energy.PeriodicMeterReadings" : "PeriodicMeterReadingId"
"Energy.ProfileEAVMeteringPointPeriods" }o--|| "Energy.Profiles" : "ProfileId"
"Energy.SupplyMeteringPointPeriods" }o--|| "Energy.MarketPartyRoles" : "BalanceResponsiblePartyId"
"Energy.SupplyMeteringPointPeriods" }o--|| "Energy.MarketPartyRoles" : "GridOperatorPartyId"
"Energy.SupplyMeteringPointPeriods" }o--|| "Energy.MarketPartyRoles" : "MeteringResponsiblePartyId"
"Energy.SupplyMeteringPointPeriods" }o--|| "Energy.MarketPartyRoles" : "SupplierId"
erDiagram
"Energy.MasterDataMeteringPointPeriods" {
uniqueidentifier Id PK
nvarchar ClientName
int MarketSegment
int EnergyFlowDirection
int MeteringMethod
int AllocationMethod
int PhysicalStatus
int EnergyDeliveryStatus
decimal ContractedCapacity
int AdministrativeStatusSmartMeter
nvarchar LocationDescription
nvarchar CapTarCode
nvarchar InvoiceMonth
uniqueidentifier MeteringPointId FK
nvarchar Comment
datetime Start
datetime End
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
decimal MaxConsumption
int Subtype
int Switchability
nvarchar PrimaryAllocationPoint
nvarchar SecondaryAllocationPointsConcatenated
nvarchar PhysicalCapacity
bit Concealed
}
"Energy.MeteringPointInformationPeriods" {
uniqueidentifier Id PK
nvarchar Appliance
int ArticleSub
int DisconnectionMethod
int SDERegulation
int SustainableEnergy
nvarchar BAGId
nvarchar BAGBuildingId
nvarchar TNTId
uniqueidentifier MeteringPointId FK
nvarchar Comment
datetime Start
datetime End
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Energy.MeteringPoints" {
uniqueidentifier Id PK
nvarchar EAN
nvarchar Comment
uniqueidentifier Tenant
int Switch
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier AddressId FK
int ProductType
bit IsVirtual
bit IsManual
int CARStatusFlags
bit Concealed
}
"Energy.PeriodicMeterReadings" {
uniqueidentifier Id PK
int ConsumptionPeakStart
int ConsumptionPeakEnd
int ConsumptionPeakTotal
int ConsumptionPeakMax
int ConsumptionPeakMin
int ConsumptionOffPeakStart
int ConsumptionOffPeakEnd
int ConsumptionOffPeakTotal
int ConsumptionOffPeakMax
int ConsumptionOffPeakMin
int ProductionPeakStart
int ProductionPeakEnd
int ProductionPeakTotal
int ProductionPeakMax
int ProductionPeakMin
int ProductionOffPeakStart
int ProductionOffPeakEnd
int ProductionOffPeakTotal
int ProductionOffPeakMax
int ProductionOffPeakMin
uniqueidentifier MeteringPointId FK
nvarchar Comment
datetime Start
datetime End
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Energy.ProfileEAVMeteringPointPeriods" {
uniqueidentifier Id PK
uniqueidentifier ProfileId FK
int EAEnergyConsumptionNettedPeak
int EAEnergyConsumptionNettedOffPeak
uniqueidentifier MeteringPointId FK
nvarchar Comment
datetime Start
datetime End
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
int EAEnergyProductionNettedPeak
int EAEnergyProductionNettedOffPeak
bit Concealed
}
"Energy.ReconciliationMeteringPointPeriods" {
uniqueidentifier Id PK
datetime MeteringMonth
datetime APXMonth
uniqueidentifier PeriodicMeterReadingId FK
uniqueidentifier MasterDataId FK
uniqueidentifier MeteringPointId FK
nvarchar Comment
datetime Start
datetime End
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Energy.SupplyMeteringPointPeriods" {
uniqueidentifier Id PK
uniqueidentifier SupplierId FK
uniqueidentifier BalanceResponsiblePartyId FK
uniqueidentifier MeteringResponsiblePartyId FK
uniqueidentifier MeteringPointId FK
nvarchar Comment
datetime Start
datetime End
uniqueidentifier GridOperatorPartyId FK
bit Confirmed
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Energy.MasterDataMeteringPointPeriods" }o--|| "Energy.MeteringPoints" : "MeteringPointId"
"Energy.ReconciliationMeteringPointPeriods" }o--|| "Energy.MasterDataMeteringPointPeriods" : "MasterDataId"
"Energy.MeteringPointInformationPeriods" }o--|| "Energy.MeteringPoints" : "MeteringPointId"
"Energy.CustomMasterDataMeteringPointPeriods" }o--|| "Energy.MeteringPoints" : "MeteringPointId"
"Energy.CustomMeteringPointInformationPeriods" }o--|| "Energy.MeteringPoints" : "MeteringPointId"
"Energy.CustomProfileEAVMeteringPointPeriods" }o--|| "Energy.MeteringPoints" : "MeteringPointId"
"Energy.MeteringPoints" }o--|| "Energy.Addresses" : "AddressId"
"Energy.NetAreaMeteringPointPeriods" }o--|| "Energy.MeteringPoints" : "MeteringPointId"
"Energy.PeriodicMeterReadings" }o--|| "Energy.MeteringPoints" : "MeteringPointId"
"Energy.ProfileEAVMeteringPointPeriods" }o--|| "Energy.MeteringPoints" : "MeteringPointId"
"Energy.ReconciliationMeteringPointPeriods" }o--|| "Energy.MeteringPoints" : "MeteringPointId"
"Energy.SupplyMeteringPointPeriods" }o--|| "Energy.MeteringPoints" : "MeteringPointId"
"Energy.ReconciliationMeteringPointPeriods" }o--|| "Energy.PeriodicMeterReadings" : "PeriodicMeterReadingId"
"Energy.ProfileEAVMeteringPointPeriods" }o--|| "Energy.Profiles" : "ProfileId"
"Energy.SupplyMeteringPointPeriods" }o--|| "Energy.MarketPartyRoles" : "BalanceResponsiblePartyId"
"Energy.SupplyMeteringPointPeriods" }o--|| "Energy.MarketPartyRoles" : "GridOperatorPartyId"
"Energy.SupplyMeteringPointPeriods" }o--|| "Energy.MarketPartyRoles" : "MeteringResponsiblePartyId"
"Energy.SupplyMeteringPointPeriods" }o--|| "Energy.MarketPartyRoles" : "SupplierId"{
"definitions": {
"Energy.SupplyMeteringPointPeriods": {
"properties": {
"End": {
"type": "string",
"description": "datetime"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Start": {
"type": "string",
"description": "datetime"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Comment": {
"type": "string",
"description": "nvarchar"
},
"MeteringResponsiblePartyId": {
"type": "string",
"description": "FK to Energy.MarketPartyRoles"
},
"MeteringPointId": {
"type": "string",
"description": "FK to Energy.MeteringPoints"
},
"GridOperatorPartyId": {
"type": "string",
"description": "FK to Energy.MarketPartyRoles"
},
"BalanceResponsiblePartyId": {
"type": "string",
"description": "FK to Energy.MarketPartyRoles"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Confirmed": {
"type": "boolean",
"description": "bit"
},
"SupplierId": {
"type": "string",
"description": "FK to Energy.MarketPartyRoles"
}
},
"type": "object"
},
"Energy.ReconciliationMeteringPointPeriods": {
"properties": {
"End": {
"type": "string",
"description": "datetime"
},
"MeteringMonth": {
"type": "string",
"description": "datetime"
},
"APXMonth": {
"type": "string",
"description": "datetime"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"MasterDataId": {
"type": "string",
"description": "FK to Energy.MasterDataMeteringPointPeriods"
},
"Start": {
"type": "string",
"description": "datetime"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Comment": {
"type": "string",
"description": "nvarchar"
},
"MeteringPointId": {
"type": "string",
"description": "FK to Energy.MeteringPoints"
},
"PeriodicMeterReadingId": {
"type": "string",
"description": "FK to Energy.PeriodicMeterReadings"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
},
"Energy.MeteringPointInformationPeriods": {
"properties": {
"Comment": {
"type": "string",
"description": "nvarchar"
},
"DisconnectionMethod": {
"type": "integer",
"description": "int"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Appliance": {
"type": "string",
"description": "nvarchar"
},
"Start": {
"type": "string",
"description": "datetime"
},
"End": {
"type": "string",
"description": "datetime"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"TNTId": {
"type": "string",
"description": "nvarchar"
},
"BAGBuildingId": {
"type": "string",
"description": "nvarchar"
},
"ArticleSub": {
"type": "integer",
"description": "int"
},
"MeteringPointId": {
"type": "string",
"description": "FK to Energy.MeteringPoints"
},
"SDERegulation": {
"type": "integer",
"description": "int"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"SustainableEnergy": {
"type": "integer",
"description": "int"
},
"BAGId": {
"type": "string",
"description": "nvarchar"
}
},
"type": "object"
},
"Energy.PeriodicMeterReadings": {
"properties": {
"ProductionPeakTotal": {
"type": "integer",
"description": "int"
},
"ConsumptionPeakStart": {
"type": "integer",
"description": "int"
},
"MeteringPointId": {
"type": "string",
"description": "FK to Energy.MeteringPoints"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ConsumptionPeakEnd": {
"type": "integer",
"description": "int"
},
"ConsumptionOffPeakStart": {
"type": "integer",
"description": "int"
},
"Start": {
"type": "string",
"description": "datetime"
},
"ConsumptionPeakMax": {
"type": "integer",
"description": "int"
},
"ConsumptionOffPeakEnd": {
"type": "integer",
"description": "int"
},
"ProductionOffPeakMax": {
"type": "integer",
"description": "int"
},
"ConsumptionOffPeakMax": {
"type": "integer",
"description": "int"
},
"ProductionPeakMax": {
"type": "integer",
"description": "int"
},
"ProductionOffPeakTotal": {
"type": "integer",
"description": "int"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Comment": {
"type": "string",
"description": "nvarchar"
},
"ConsumptionPeakMin": {
"type": "integer",
"description": "int"
},
"ConsumptionPeakTotal": {
"type": "integer",
"description": "int"
},
"ProductionPeakMin": {
"type": "integer",
"description": "int"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ProductionOffPeakEnd": {
"type": "integer",
"description": "int"
},
"ProductionOffPeakMin": {
"type": "integer",
"description": "int"
},
"ProductionOffPeakStart": {
"type": "integer",
"description": "int"
},
"ProductionPeakStart": {
"type": "integer",
"description": "int"
},
"ConsumptionOffPeakMin": {
"type": "integer",
"description": "int"
},
"ProductionPeakEnd": {
"type": "integer",
"description": "int"
},
"ConsumptionOffPeakTotal": {
"type": "integer",
"description": "int"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"End": {
"type": "string",
"description": "datetime"
}
},
"type": "object"
},
"Energy.MasterDataMeteringPointPeriods": {
"properties": {
"LocationDescription": {
"type": "string",
"description": "nvarchar"
},
"MeteringPointId": {
"type": "string",
"description": "FK to Energy.MeteringPoints"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"AllocationMethod": {
"type": "integer",
"description": "int"
},
"Start": {
"type": "string",
"description": "datetime"
},
"PrimaryAllocationPoint": {
"type": "string",
"description": "nvarchar"
},
"CapTarCode": {
"type": "string",
"description": "nvarchar"
},
"EnergyFlowDirection": {
"type": "integer",
"description": "int"
},
"EnergyDeliveryStatus": {
"type": "integer",
"description": "int"
},
"InvoiceMonth": {
"type": "string",
"description": "nvarchar"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SecondaryAllocationPointsConcatenated": {
"type": "string",
"description": "nvarchar"
},
"ClientName": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Comment": {
"type": "string",
"description": "nvarchar"
},
"MeteringMethod": {
"type": "integer",
"description": "int"
},
"End": {
"type": "string",
"description": "datetime"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"MaxConsumption": {
"type": "string",
"description": "decimal"
},
"MarketSegment": {
"type": "integer",
"description": "int"
},
"PhysicalStatus": {
"type": "integer",
"description": "int"
},
"Subtype": {
"type": "integer",
"description": "int"
},
"PhysicalCapacity": {
"type": "string",
"description": "nvarchar"
},
"AdministrativeStatusSmartMeter": {
"type": "integer",
"description": "int"
},
"ContractedCapacity": {
"type": "string",
"description": "decimal"
},
"Switchability": {
"type": "integer",
"description": "int"
},
"Concealed": {
"type": "boolean",
"description": "bit"
}
},
"type": "object"
},
"Energy.MeteringPoints": {
"properties": {
"ProductType": {
"type": "integer",
"description": "int"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EAN": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"IsVirtual": {
"type": "boolean",
"description": "bit"
},
"IsManual": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Comment": {
"type": "string",
"description": "nvarchar"
},
"Switch": {
"type": "integer",
"description": "int"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"AddressId": {
"type": "string",
"description": "FK to Energy.Addresses"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CARStatusFlags": {
"type": "integer",
"description": "int"
}
},
"type": "object"
},
"Energy.ProfileEAVMeteringPointPeriods": {
"properties": {
"EAEnergyProductionNettedOffPeak": {
"type": "integer",
"description": "int"
},
"End": {
"type": "string",
"description": "datetime"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EAEnergyConsumptionNettedPeak": {
"type": "integer",
"description": "int"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Start": {
"type": "string",
"description": "datetime"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Comment": {
"type": "string",
"description": "nvarchar"
},
"EAEnergyConsumptionNettedOffPeak": {
"type": "integer",
"description": "int"
},
"MeteringPointId": {
"type": "string",
"description": "FK to Energy.MeteringPoints"
},
"EAEnergyProductionNettedPeak": {
"type": "integer",
"description": "int"
},
"ProfileId": {
"type": "string",
"description": "FK to Energy.Profiles"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
}
},
"title": "Energy.MeteringPoint",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Profile
Aggregate Root: Profile
Represents energy consumption and production profiles for analysis and planning.
erDiagram
"Energy.Profiles" {
uniqueidentifier Id PK
nvarchar Code
nvarchar Description
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit IsElectricity
bit IsGas
bit Concealed
}
"Energy.CustomProfileEAVMeteringPointPeriods" }o--|| "Energy.Profiles" : "ProfileId"
"Energy.ProfileEAVMeteringPointPeriods" }o--|| "Energy.Profiles" : "ProfileId"
erDiagram
"Energy.Profiles" {
uniqueidentifier Id PK
nvarchar Code
nvarchar Description
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit IsElectricity
bit IsGas
bit Concealed
}
"Energy.CustomProfileEAVMeteringPointPeriods" }o--|| "Energy.Profiles" : "ProfileId"
"Energy.ProfileEAVMeteringPointPeriods" }o--|| "Energy.Profiles" : "ProfileId"{
"definitions": {
"Energy.Profiles": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"IsGas": {
"type": "boolean",
"description": "bit"
},
"Description": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"IsElectricity": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Code": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
}
},
"title": "Energy.Profile",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Reference Sequence Generator
Aggregate Root: ReferenceSequenceGenerator
Generates reference sequences for data organization and identification.
erDiagram
"Energy.ReferenceSequenceEntries" {
uniqueidentifier Id PK
uniqueidentifier ReferenceSequenceGeneratorId FK
uniqueidentifier InternalId
nvarchar InternalReference
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Energy.ReferenceSequenceGenerators" {
uniqueidentifier Id PK
nvarchar SequenceDefinitionRule
uniqueidentifier Tenant
nvarchar SequenceName
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Energy.ReferenceSequenceEntries" }o--|| "Energy.ReferenceSequenceGenerators" : "ReferenceSequenceGeneratorId"
erDiagram
"Energy.ReferenceSequenceEntries" {
uniqueidentifier Id PK
uniqueidentifier ReferenceSequenceGeneratorId FK
uniqueidentifier InternalId
nvarchar InternalReference
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Energy.ReferenceSequenceGenerators" {
uniqueidentifier Id PK
nvarchar SequenceDefinitionRule
uniqueidentifier Tenant
nvarchar SequenceName
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Energy.ReferenceSequenceEntries" }o--|| "Energy.ReferenceSequenceGenerators" : "ReferenceSequenceGeneratorId"{
"definitions": {
"Energy.ReferenceSequenceEntries": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"InternalId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"InternalReference": {
"type": "string",
"description": "nvarchar"
},
"ReferenceSequenceGeneratorId": {
"type": "string",
"description": "FK to Energy.ReferenceSequenceGenerators"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Energy.ReferenceSequenceGenerators": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"SequenceName": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"SequenceDefinitionRule": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
}
},
"title": "Energy.ReferenceSequenceGenerator",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Gas Transfer Point
Aggregate Root: GasTransferPoint
Represents gas transfer points for gas trading and transportation.
erDiagram
"Energy.GasTransferPoints" {
uniqueidentifier Id PK
nvarchar EAN
int Year
decimal ConnectionTariff
decimal ExitTariff
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
decimal PeakDeliveryG1A
decimal PeakDeliveryG2A
bit Concealed
}
erDiagram
"Energy.GasTransferPoints" {
uniqueidentifier Id PK
nvarchar EAN
int Year
decimal ConnectionTariff
decimal ExitTariff
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
decimal PeakDeliveryG1A
decimal PeakDeliveryG2A
bit Concealed
}{
"definitions": {
"Energy.GasTransferPoints": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"ConnectionTariff": {
"type": "string",
"description": "decimal"
},
"EAN": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Year": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PeakDeliveryG2A": {
"type": "string",
"description": "decimal"
},
"PeakDeliveryG1A": {
"type": "string",
"description": "decimal"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ExitTariff": {
"type": "string",
"description": "decimal"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
}
},
"title": "Energy.GasTransferPoint",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Decision Table
Aggregate Root: DecisionTable
Represents decision tables for business rule processing and decision making.
erDiagram
"Energy.DecisionTableColumnLabels" {
uniqueidentifier Id PK
int Index
nvarchar Value
int DataType
uniqueidentifier EnumId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier DecisionTreeDataId FK
int Type
bit Concealed
}
"Energy.DecisionTableNodeOperands" {
uniqueidentifier Id PK
nvarchar Operand
uniqueidentifier DecisionTableNodeId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Energy.DecisionTableNodes" {
uniqueidentifier Id PK
uniqueidentifier ParentNodeId FK
uniqueidentifier ColumnLabelId FK
int Index
int DataType
uniqueidentifier EnumId
int Operator
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier DecisionTreeDataId FK
int Type
bit IsError
bit IsManual
bit Concealed
}
"Energy.DecisionTables" {
uniqueidentifier Id PK
nvarchar Name
nvarchar Description
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Energy.DecisionTreeDatas" {
uniqueidentifier Id PK
datetimeoffset StartDateTime
uniqueidentifier DecisionTableId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
nvarchar Comment
nvarchar VersionString
}
"Energy.DecisionTableColumnLabels" }o--|| "Energy.DecisionTreeDatas" : "DecisionTreeDataId"
"Energy.DecisionTableNodes" }o--|| "Energy.DecisionTableColumnLabels" : "ColumnLabelId"
"Energy.DecisionTableNodeOperands" }o--|| "Energy.DecisionTableNodes" : "DecisionTableNodeId"
"Energy.DecisionTableNodes" }o--|| "Energy.DecisionTableNodes" : "ParentNodeId"
"Energy.DecisionTableNodes" }o--|| "Energy.DecisionTreeDatas" : "DecisionTreeDataId"
"Energy.DecisionTreeDatas" }o--|| "Energy.DecisionTables" : "DecisionTableId"
erDiagram
"Energy.DecisionTableColumnLabels" {
uniqueidentifier Id PK
int Index
nvarchar Value
int DataType
uniqueidentifier EnumId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier DecisionTreeDataId FK
int Type
bit Concealed
}
"Energy.DecisionTableNodeOperands" {
uniqueidentifier Id PK
nvarchar Operand
uniqueidentifier DecisionTableNodeId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Energy.DecisionTableNodes" {
uniqueidentifier Id PK
uniqueidentifier ParentNodeId FK
uniqueidentifier ColumnLabelId FK
int Index
int DataType
uniqueidentifier EnumId
int Operator
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier DecisionTreeDataId FK
int Type
bit IsError
bit IsManual
bit Concealed
}
"Energy.DecisionTables" {
uniqueidentifier Id PK
nvarchar Name
nvarchar Description
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"Energy.DecisionTreeDatas" {
uniqueidentifier Id PK
datetimeoffset StartDateTime
uniqueidentifier DecisionTableId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
nvarchar Comment
nvarchar VersionString
}
"Energy.DecisionTableColumnLabels" }o--|| "Energy.DecisionTreeDatas" : "DecisionTreeDataId"
"Energy.DecisionTableNodes" }o--|| "Energy.DecisionTableColumnLabels" : "ColumnLabelId"
"Energy.DecisionTableNodeOperands" }o--|| "Energy.DecisionTableNodes" : "DecisionTableNodeId"
"Energy.DecisionTableNodes" }o--|| "Energy.DecisionTableNodes" : "ParentNodeId"
"Energy.DecisionTableNodes" }o--|| "Energy.DecisionTreeDatas" : "DecisionTreeDataId"
"Energy.DecisionTreeDatas" }o--|| "Energy.DecisionTables" : "DecisionTableId"{
"definitions": {
"Energy.DecisionTableColumnLabels": {
"properties": {
"EnumId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Type": {
"type": "integer",
"description": "int"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Index": {
"type": "integer",
"description": "int"
},
"DataType": {
"type": "integer",
"description": "int"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"DecisionTreeDataId": {
"type": "string",
"description": "FK to Energy.DecisionTreeDatas"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
},
"Energy.DecisionTreeDatas": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"VersionString": {
"type": "string",
"description": "nvarchar"
},
"Comment": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"DecisionTableId": {
"type": "string",
"description": "FK to Energy.DecisionTables"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"StartDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Energy.DecisionTables": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Description": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"Energy.DecisionTableNodeOperands": {
"properties": {
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Operand": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"DecisionTableNodeId": {
"type": "string",
"description": "FK to Energy.DecisionTableNodes"
}
},
"type": "object"
},
"Energy.DecisionTableNodes": {
"properties": {
"EnumId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Operator": {
"type": "integer",
"description": "int"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"IsManual": {
"type": "boolean",
"description": "bit"
},
"Index": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ParentNodeId": {
"type": "string",
"description": "FK to Energy.DecisionTableNodes"
},
"DataType": {
"type": "integer",
"description": "int"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Type": {
"type": "integer",
"description": "int"
},
"IsError": {
"type": "boolean",
"description": "bit"
},
"DecisionTreeDataId": {
"type": "string",
"description": "FK to Energy.DecisionTreeDatas"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"ColumnLabelId": {
"type": "string",
"description": "FK to Energy.DecisionTableColumnLabels"
}
},
"type": "object"
}
},
"title": "Energy.DecisionTable",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Exit Capacity
Aggregate Root: ExitCapacity
Represents exit capacities for energy transportation and network management.
erDiagram
"Energy.ExitCapacities" {
uniqueidentifier Id PK
datetime MonthYear
decimal HourlyFractionG1A
decimal HourlyFractionG2A
decimal HourlyFractionG2C
decimal TelemetryProfileFactor
decimal ProfileMonthlyFraction
decimal TelemetryMonthlyFraction
decimal ProfileFitFactor
decimal TelemetryFitFactor
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
decimal PeakDeliveryMonthlyFraction
bit Concealed
}
erDiagram
"Energy.ExitCapacities" {
uniqueidentifier Id PK
datetime MonthYear
decimal HourlyFractionG1A
decimal HourlyFractionG2A
decimal HourlyFractionG2C
decimal TelemetryProfileFactor
decimal ProfileMonthlyFraction
decimal TelemetryMonthlyFraction
decimal ProfileFitFactor
decimal TelemetryFitFactor
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
decimal PeakDeliveryMonthlyFraction
bit Concealed
}{
"definitions": {
"Energy.ExitCapacities": {
"properties": {
"TelemetryMonthlyFraction": {
"type": "string",
"description": "decimal"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"HourlyFractionG2A": {
"type": "string",
"description": "decimal"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"ProfileFitFactor": {
"type": "string",
"description": "decimal"
},
"TelemetryProfileFactor": {
"type": "string",
"description": "decimal"
},
"MonthYear": {
"type": "string",
"description": "datetime"
},
"HourlyFractionG2C": {
"type": "string",
"description": "decimal"
},
"TelemetryFitFactor": {
"type": "string",
"description": "decimal"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"HourlyFractionG1A": {
"type": "string",
"description": "decimal"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"PeakDeliveryMonthlyFraction": {
"type": "string",
"description": "decimal"
},
"ProfileMonthlyFraction": {
"type": "string",
"description": "decimal"
}
},
"type": "object"
}
},
"title": "Energy.ExitCapacity",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}