PFC 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
Price Forward Curve Group
Aggregate Root: PriceForwardCurveGroup
Represents groups of price forward curves with their details and associated curves for price forecasting and analysis.
erDiagram
"PFC.PriceForwardCurveGroupDetails" {
uniqueidentifier Id PK
nvarchar Key
nvarchar Value
int FormatType
uniqueidentifier CustomEnumId
uniqueidentifier PriceForwardCurveGroupId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PFC.PriceForwardCurveGroups" {
uniqueidentifier Id PK
nvarchar Name
int Unit
int Interval
int IntervalType
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
uniqueidentifier ProductCustomEnumComponentId
nvarchar ExternalReference
nvarchar InternalReference
}
"PFC.PriceForwardCurves" {
uniqueidentifier Id PK
nvarchar TimeSeriesCode
nvarchar DataSlotReference
nvarchar Revision
int SnapshotTimestamp
datetimeoffset Start
datetimeoffset End
uniqueidentifier PriceForwardCurveGroupId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
datetimeoffset CalculationDate
datetimeoffset CreationDateTime
bit Revoked
}
"PFC.PriceForwardCurveGroupDetails" }o--|| "PFC.PriceForwardCurveGroups" : "PriceForwardCurveGroupId"
"PFC.PriceForwardCurves" }o--|| "PFC.PriceForwardCurveGroups" : "PriceForwardCurveGroupId"
erDiagram
"PFC.PriceForwardCurveGroupDetails" {
uniqueidentifier Id PK
nvarchar Key
nvarchar Value
int FormatType
uniqueidentifier CustomEnumId
uniqueidentifier PriceForwardCurveGroupId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PFC.PriceForwardCurveGroups" {
uniqueidentifier Id PK
nvarchar Name
int Unit
int Interval
int IntervalType
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
uniqueidentifier ProductCustomEnumComponentId
nvarchar ExternalReference
nvarchar InternalReference
}
"PFC.PriceForwardCurves" {
uniqueidentifier Id PK
nvarchar TimeSeriesCode
nvarchar DataSlotReference
nvarchar Revision
int SnapshotTimestamp
datetimeoffset Start
datetimeoffset End
uniqueidentifier PriceForwardCurveGroupId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
datetimeoffset CalculationDate
datetimeoffset CreationDateTime
bit Revoked
}
"PFC.PriceForwardCurveGroupDetails" }o--|| "PFC.PriceForwardCurveGroups" : "PriceForwardCurveGroupId"
"PFC.PriceForwardCurves" }o--|| "PFC.PriceForwardCurveGroups" : "PriceForwardCurveGroupId"{
"definitions": {
"PFC.PriceForwardCurveGroups": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"InternalReference": {
"type": "string",
"description": "nvarchar"
},
"ExternalReference": {
"type": "string",
"description": "nvarchar"
},
"Interval": {
"type": "integer",
"description": "int"
},
"Unit": {
"type": "integer",
"description": "int"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"IntervalType": {
"type": "integer",
"description": "int"
},
"ProductCustomEnumComponentId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PFC.PriceForwardCurves": {
"properties": {
"End": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"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"
},
"SnapshotTimestamp": {
"type": "integer",
"description": "int"
},
"CreationDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"CalculationDate": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Start": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"DataSlotReference": {
"type": "string",
"description": "nvarchar"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"TimeSeriesCode": {
"type": "string",
"description": "nvarchar"
},
"Revoked": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Revision": {
"type": "string",
"description": "nvarchar"
},
"PriceForwardCurveGroupId": {
"type": "string",
"description": "FK to PFC.PriceForwardCurveGroups"
}
},
"type": "object"
},
"PFC.PriceForwardCurveGroupDetails": {
"properties": {
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"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"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"FormatType": {
"type": "integer",
"description": "int"
},
"CustomEnumId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PriceForwardCurveGroupId": {
"type": "string",
"description": "FK to PFC.PriceForwardCurveGroups"
}
},
"type": "object"
}
},
"title": "PFC.PriceForwardCurveGroup",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}