This is the multi-page printable view of this section. Click here to print.
Pricing Data Brokers module
The documentation of the Vertex Pricing Data Brokers module
- 1: PDB Domain
1 - PDB 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
Market
Aggregate Root: Market
Represents markets for pricing data with their associated products and brokers.
erDiagram
"PDB.MarketMetadatas" {
uniqueidentifier Id PK
uniqueidentifier MarketId FK
nvarchar Key
nvarchar Value
uniqueidentifier PricingDataBrokerId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PDB.MarketProductDeliveries" {
uniqueidentifier Id PK
nvarchar Name
uniqueidentifier MarketProductId FK
datetimeoffset StartDateTimeOffset
uniqueidentifier DeliverySettlementPeriodId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PDB.MarketProductDeliveryMetadatas" {
uniqueidentifier Id PK
uniqueidentifier MarketProductDeliveryId FK
nvarchar Key
nvarchar Value
uniqueidentifier PriceSourceId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PDB.MarketProductDeliveryPriceSource" {
uniqueidentifier MarketProductDeliveryId PK
uniqueidentifier PriceSourceId PK
}
"PDB.MarketProductDeliverySettlementPeriod" {
uniqueidentifier MarketProductId PK
uniqueidentifier DeliverySettlementPeriodId PK
}
"PDB.MarketProductMetadatas" {
uniqueidentifier Id PK
uniqueidentifier MarketProductId FK
nvarchar Key
nvarchar Value
uniqueidentifier PricingDataBrokerId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PDB.MarketProducts" {
uniqueidentifier Id PK
nvarchar Name
nvarchar Code
uniqueidentifier MarketId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
int MarketProductConfigurationType
bit Concealed
}
"PDB.Markets" {
uniqueidentifier Id PK
nvarchar Name
nvarchar Description
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
nvarchar Code
bit Concealed
}
"PDB.PriceSources" {
uniqueidentifier Id PK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier PricingBrokerId FK
uniqueidentifier PricingDataBrokerId
bit Concealed
}
"PDB.MarketMetadatas" }o--|| "PDB.Markets" : "MarketId"
"PDB.MarketProductDeliveries" }o--|| "PDB.DeliverySettlementPeriods" : "DeliverySettlementPeriodId"
"PDB.MarketProductDeliveries" }o--|| "PDB.MarketProducts" : "MarketProductId"
"PDB.MarketProductDeliveryMetadatas" }o--|| "PDB.MarketProductDeliveries" : "MarketProductDeliveryId"
"PDB.MarketProductDeliveryPriceSource" }o--|| "PDB.MarketProductDeliveries" : "MarketProductDeliveryId"
"PDB.MarketProductDeliveryMetadatas" }o--|| "PDB.PriceSources" : "PriceSourceId"
"PDB.MarketProductDeliveryPriceSource" }o--|| "PDB.PriceSources" : "PriceSourceId"
"PDB.MarketProductDeliverySettlementPeriod" }o--|| "PDB.DeliverySettlementPeriods" : "DeliverySettlementPeriodId"
"PDB.MarketProductDeliverySettlementPeriod" }o--|| "PDB.MarketProducts" : "MarketProductId"
"PDB.MarketProductMetadatas" }o--|| "PDB.MarketProducts" : "MarketProductId"
"PDB.FetchPrograms" }o--|| "PDB.MarketProducts" : "MarketProductId"
"PDB.MarketProducts" }o--|| "PDB.Markets" : "MarketId"
"PDB.FetchProgramMetadatas" }o--|| "PDB.PriceSources" : "PriceSourceId"
"PDB.FetchProgramPriceSource" }o--|| "PDB.PriceSources" : "PriceSourceId"
"PDB.PriceSources" }o--|| "PDB.PricingBrokers" : "PricingBrokerId"
erDiagram
"PDB.MarketMetadatas" {
uniqueidentifier Id PK
uniqueidentifier MarketId FK
nvarchar Key
nvarchar Value
uniqueidentifier PricingDataBrokerId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PDB.MarketProductDeliveries" {
uniqueidentifier Id PK
nvarchar Name
uniqueidentifier MarketProductId FK
datetimeoffset StartDateTimeOffset
uniqueidentifier DeliverySettlementPeriodId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PDB.MarketProductDeliveryMetadatas" {
uniqueidentifier Id PK
uniqueidentifier MarketProductDeliveryId FK
nvarchar Key
nvarchar Value
uniqueidentifier PriceSourceId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PDB.MarketProductDeliveryPriceSource" {
uniqueidentifier MarketProductDeliveryId PK
uniqueidentifier PriceSourceId PK
}
"PDB.MarketProductDeliverySettlementPeriod" {
uniqueidentifier MarketProductId PK
uniqueidentifier DeliverySettlementPeriodId PK
}
"PDB.MarketProductMetadatas" {
uniqueidentifier Id PK
uniqueidentifier MarketProductId FK
nvarchar Key
nvarchar Value
uniqueidentifier PricingDataBrokerId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PDB.MarketProducts" {
uniqueidentifier Id PK
nvarchar Name
nvarchar Code
uniqueidentifier MarketId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
int MarketProductConfigurationType
bit Concealed
}
"PDB.Markets" {
uniqueidentifier Id PK
nvarchar Name
nvarchar Description
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
nvarchar Code
bit Concealed
}
"PDB.PriceSources" {
uniqueidentifier Id PK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
uniqueidentifier PricingBrokerId FK
uniqueidentifier PricingDataBrokerId
bit Concealed
}
"PDB.MarketMetadatas" }o--|| "PDB.Markets" : "MarketId"
"PDB.MarketProductDeliveries" }o--|| "PDB.DeliverySettlementPeriods" : "DeliverySettlementPeriodId"
"PDB.MarketProductDeliveries" }o--|| "PDB.MarketProducts" : "MarketProductId"
"PDB.MarketProductDeliveryMetadatas" }o--|| "PDB.MarketProductDeliveries" : "MarketProductDeliveryId"
"PDB.MarketProductDeliveryPriceSource" }o--|| "PDB.MarketProductDeliveries" : "MarketProductDeliveryId"
"PDB.MarketProductDeliveryMetadatas" }o--|| "PDB.PriceSources" : "PriceSourceId"
"PDB.MarketProductDeliveryPriceSource" }o--|| "PDB.PriceSources" : "PriceSourceId"
"PDB.MarketProductDeliverySettlementPeriod" }o--|| "PDB.DeliverySettlementPeriods" : "DeliverySettlementPeriodId"
"PDB.MarketProductDeliverySettlementPeriod" }o--|| "PDB.MarketProducts" : "MarketProductId"
"PDB.MarketProductMetadatas" }o--|| "PDB.MarketProducts" : "MarketProductId"
"PDB.FetchPrograms" }o--|| "PDB.MarketProducts" : "MarketProductId"
"PDB.MarketProducts" }o--|| "PDB.Markets" : "MarketId"
"PDB.FetchProgramMetadatas" }o--|| "PDB.PriceSources" : "PriceSourceId"
"PDB.FetchProgramPriceSource" }o--|| "PDB.PriceSources" : "PriceSourceId"
"PDB.PriceSources" }o--|| "PDB.PricingBrokers" : "PricingBrokerId"{
"definitions": {
"PDB.MarketProducts": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"MarketProductConfigurationType": {
"type": "integer",
"description": "int"
},
"MarketId": {
"type": "string",
"description": "FK to PDB.Markets"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"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"
},
"PDB.MarketProductDeliverySettlementPeriod": {
"properties": {
"MarketProductId": {
"type": "string",
"description": "FK to PDB.MarketProducts"
},
"DeliverySettlementPeriodId": {
"type": "string",
"description": "FK to PDB.DeliverySettlementPeriods"
}
},
"type": "object"
},
"PDB.MarketProductDeliveries": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"MarketProductId": {
"type": "string",
"description": "FK to PDB.MarketProducts"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"StartDateTimeOffset": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"DeliverySettlementPeriodId": {
"type": "string",
"description": "FK to PDB.DeliverySettlementPeriods"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PDB.MarketProductDeliveryMetadatas": {
"properties": {
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"MarketProductDeliveryId": {
"type": "string",
"description": "FK to PDB.MarketProductDeliveries"
},
"PriceSourceId": {
"type": "string",
"description": "FK to PDB.PriceSources"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Key": {
"type": "string",
"description": "nvarchar"
}
},
"type": "object"
},
"PDB.PriceSources": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PricingBrokerId": {
"type": "string",
"description": "FK to PDB.PricingBrokers"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingDataBrokerId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PDB.MarketMetadatas": {
"properties": {
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PricingDataBrokerId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"MarketId": {
"type": "string",
"description": "FK to PDB.Markets"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Key": {
"type": "string",
"description": "nvarchar"
}
},
"type": "object"
},
"PDB.MarketProductMetadatas": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"MarketProductId": {
"type": "string",
"description": "FK to PDB.MarketProducts"
},
"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"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"PricingDataBrokerId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PDB.Markets": {
"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"
},
"Code": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PDB.MarketProductDeliveryPriceSource": {
"properties": {
"MarketProductDeliveryId": {
"type": "string",
"description": "FK to PDB.MarketProductDeliveries"
},
"PriceSourceId": {
"type": "string",
"description": "FK to PDB.PriceSources"
}
},
"type": "object"
}
},
"title": "PDB.Market",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Pricing Broker
Aggregate Root: PricingBroker
Represents brokers that provide pricing data and services for market products.
erDiagram
"PDB.PricingBrokerMetadatas" {
uniqueidentifier Id PK
uniqueidentifier PricingBrokerId FK
nvarchar Key
nvarchar Value
uniqueidentifier PricingDataBrokerId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PDB.PricingBrokers" {
uniqueidentifier Id PK
nvarchar Name
nvarchar Code
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PDB.PricingBrokerMetadatas" }o--|| "PDB.PricingBrokers" : "PricingBrokerId"
"PDB.PriceSources" }o--|| "PDB.PricingBrokers" : "PricingBrokerId"
erDiagram
"PDB.PricingBrokerMetadatas" {
uniqueidentifier Id PK
uniqueidentifier PricingBrokerId FK
nvarchar Key
nvarchar Value
uniqueidentifier PricingDataBrokerId
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PDB.PricingBrokers" {
uniqueidentifier Id PK
nvarchar Name
nvarchar Code
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PDB.PricingBrokerMetadatas" }o--|| "PDB.PricingBrokers" : "PricingBrokerId"
"PDB.PriceSources" }o--|| "PDB.PricingBrokers" : "PricingBrokerId"{
"definitions": {
"PDB.PricingBrokers": {
"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"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"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"
},
"PDB.PricingBrokerMetadatas": {
"properties": {
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PricingDataBrokerId": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"PricingBrokerId": {
"type": "string",
"description": "FK to PDB.PricingBrokers"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"Key": {
"type": "string",
"description": "nvarchar"
}
},
"type": "object"
}
},
"title": "PDB.PricingBroker",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}Fetch Program
Aggregate Root: FetchProgram
Represents programs for fetching pricing data from external sources and brokers.
erDiagram
"PDB.DeliverySettlementPeriods" {
uniqueidentifier Id PK
uniqueidentifier SettlementTimeFrameId FK
uniqueidentifier DeliveryTimeFrameId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PDB.FetchProgramMetadatas" {
uniqueidentifier Id PK
uniqueidentifier FetchProgramId FK
nvarchar Key
nvarchar Value
uniqueidentifier PriceSourceId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PDB.FetchProgramPriceSource" {
uniqueidentifier FetchProgramId PK
uniqueidentifier PriceSourceId PK
}
"PDB.FetchPrograms" {
uniqueidentifier Id PK
nvarchar Name
uniqueidentifier MarketProductId FK
int NumberOfDeliverySettlementPeriods
uniqueidentifier DeliverySettlementPeriodId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
int FetcherFlags
bit Concealed
}
"PDB.TimeFrames" {
uniqueidentifier Id PK
int Value
int TimeFrameType
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PDB.DeliverySettlementPeriods" }o--|| "PDB.TimeFrames" : "DeliveryTimeFrameId"
"PDB.DeliverySettlementPeriods" }o--|| "PDB.TimeFrames" : "SettlementTimeFrameId"
"PDB.FetchPrograms" }o--|| "PDB.DeliverySettlementPeriods" : "DeliverySettlementPeriodId"
"PDB.MarketProductDeliveries" }o--|| "PDB.DeliverySettlementPeriods" : "DeliverySettlementPeriodId"
"PDB.MarketProductDeliverySettlementPeriod" }o--|| "PDB.DeliverySettlementPeriods" : "DeliverySettlementPeriodId"
"PDB.FetchProgramMetadatas" }o--|| "PDB.FetchPrograms" : "FetchProgramId"
"PDB.FetchProgramMetadatas" }o--|| "PDB.PriceSources" : "PriceSourceId"
"PDB.FetchProgramPriceSource" }o--|| "PDB.FetchPrograms" : "FetchProgramId"
"PDB.FetchProgramPriceSource" }o--|| "PDB.PriceSources" : "PriceSourceId"
"PDB.FetchPrograms" }o--|| "PDB.MarketProducts" : "MarketProductId"
erDiagram
"PDB.DeliverySettlementPeriods" {
uniqueidentifier Id PK
uniqueidentifier SettlementTimeFrameId FK
uniqueidentifier DeliveryTimeFrameId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PDB.FetchProgramMetadatas" {
uniqueidentifier Id PK
uniqueidentifier FetchProgramId FK
nvarchar Key
nvarchar Value
uniqueidentifier PriceSourceId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PDB.FetchProgramPriceSource" {
uniqueidentifier FetchProgramId PK
uniqueidentifier PriceSourceId PK
}
"PDB.FetchPrograms" {
uniqueidentifier Id PK
nvarchar Name
uniqueidentifier MarketProductId FK
int NumberOfDeliverySettlementPeriods
uniqueidentifier DeliverySettlementPeriodId FK
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
int FetcherFlags
bit Concealed
}
"PDB.TimeFrames" {
uniqueidentifier Id PK
int Value
int TimeFrameType
uniqueidentifier Tenant
datetimeoffset EntityCreatedDateTime
datetimeoffset EntityUpdatedDateTime
uniqueidentifier EntityCreatedAuthToken
uniqueidentifier EntityUpdatedAuthToken
bit Concealed
}
"PDB.DeliverySettlementPeriods" }o--|| "PDB.TimeFrames" : "DeliveryTimeFrameId"
"PDB.DeliverySettlementPeriods" }o--|| "PDB.TimeFrames" : "SettlementTimeFrameId"
"PDB.FetchPrograms" }o--|| "PDB.DeliverySettlementPeriods" : "DeliverySettlementPeriodId"
"PDB.MarketProductDeliveries" }o--|| "PDB.DeliverySettlementPeriods" : "DeliverySettlementPeriodId"
"PDB.MarketProductDeliverySettlementPeriod" }o--|| "PDB.DeliverySettlementPeriods" : "DeliverySettlementPeriodId"
"PDB.FetchProgramMetadatas" }o--|| "PDB.FetchPrograms" : "FetchProgramId"
"PDB.FetchProgramMetadatas" }o--|| "PDB.PriceSources" : "PriceSourceId"
"PDB.FetchProgramPriceSource" }o--|| "PDB.FetchPrograms" : "FetchProgramId"
"PDB.FetchProgramPriceSource" }o--|| "PDB.PriceSources" : "PriceSourceId"
"PDB.FetchPrograms" }o--|| "PDB.MarketProducts" : "MarketProductId"{
"definitions": {
"PDB.DeliverySettlementPeriods": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"SettlementTimeFrameId": {
"type": "string",
"description": "FK to PDB.TimeFrames"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"DeliveryTimeFrameId": {
"type": "string",
"description": "FK to PDB.TimeFrames"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
}
},
"type": "object"
},
"PDB.FetchProgramPriceSource": {
"properties": {
"FetchProgramId": {
"type": "string",
"description": "FK to PDB.FetchPrograms"
},
"PriceSourceId": {
"type": "string",
"description": "FK to PDB.PriceSources"
}
},
"type": "object"
},
"PDB.FetchPrograms": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"FetcherFlags": {
"type": "integer",
"description": "int"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Name": {
"type": "string",
"description": "nvarchar"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"NumberOfDeliverySettlementPeriods": {
"type": "integer",
"description": "int"
},
"EntityUpdatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
},
"MarketProductId": {
"type": "string",
"description": "FK to PDB.MarketProducts"
},
"DeliverySettlementPeriodId": {
"type": "string",
"description": "FK to PDB.DeliverySettlementPeriods"
},
"Tenant": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"EntityCreatedDateTime": {
"format": "date-time",
"description": "datetimeoffset",
"type": "string"
}
},
"type": "object"
},
"PDB.TimeFrames": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"TimeFrameType": {
"type": "integer",
"description": "int"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Value": {
"type": "integer",
"description": "int"
},
"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"
},
"PDB.FetchProgramMetadatas": {
"properties": {
"Concealed": {
"type": "boolean",
"description": "bit"
},
"EntityUpdatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Id": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"Key": {
"type": "string",
"description": "nvarchar"
},
"PriceSourceId": {
"type": "string",
"description": "FK to PDB.PriceSources"
},
"EntityCreatedAuthToken": {
"format": "uuid",
"description": "uniqueidentifier",
"type": "string"
},
"FetchProgramId": {
"type": "string",
"description": "FK to PDB.FetchPrograms"
},
"Value": {
"type": "string",
"description": "nvarchar"
},
"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"
}
},
"title": "PDB.FetchProgram",
"$comment": "Generated from Mermaid ERD with property-level descriptions",
"$schema": "http://json-schema.org/draft-07/schema#",
"type": "object"
}