GeneratedProductHost — DDL appendix

Generated from the architecture model

This page is rendered from model/**/*.yaml by tools/docs_model during mkdocs build. Edit the YAML, not this page; hand-written design lives on the linked service, platform and plane pages.

Dialect shown: SQL Server (nvarchar, uniqueidentifier, datetimeoffset). Migrations are authored as FluentMigrator classes in the service's DatabaseModel.Migrations project; the TenantId column and the NHibernate tenant filter follow canonical ADR-0100 in SharedDb mode.

dbo.ProductDescriptors

Owner: ProductDescriptor

CREATE TABLE [dbo].[ProductDescriptors] (
    [ProductId] nvarchar(128) NOT NULL,
    [TenantId] nvarchar(64) NOT NULL,
    [ReleaseId] uniqueidentifier NOT NULL,
    [GeneratedByJson] nvarchar(max) NOT NULL,
    [TenancyMode] int NOT NULL,
    [OperationsMode] int NOT NULL,
    [ContextsJson] nvarchar(2000) NOT NULL,
    [GatewayRef] nvarchar(256) NOT NULL,
    [HealthEndpointsJson] nvarchar(2000) NOT NULL,
    [AdminEndpointsJson] nvarchar(2000) NOT NULL,
    [ObjectivesJson] nvarchar(2000) NOT NULL,
    CONSTRAINT [PK_ProductDescriptors] PRIMARY KEY ([ProductId])
);

Column	Type	Null	Key	Description
ProductId	nvarchar(128)	no	PK
TenantId	nvarchar(64)	no
ReleaseId	uniqueidentifier	no
GeneratedByJson	nvarchar(max)	no
TenancyMode	int	no
OperationsMode	int	no
ContextsJson	nvarchar(2000)	no
GatewayRef	nvarchar(256)	no
HealthEndpointsJson	nvarchar(2000)	no
AdminEndpointsJson	nvarchar(2000)	no
ObjectivesJson	nvarchar(2000)	no

dbo.OperationsHandovers

Owner: ManagedOperationsHandover

CREATE TABLE [dbo].[OperationsHandovers] (
    [HandoverId] uniqueidentifier NOT NULL,
    [TenantId] nvarchar(64) NOT NULL,
    [ProductId] nvarchar(128) NOT NULL,
    [ManagedEdition] nvarchar(16) NOT NULL,
    [ObjectivesJson] nvarchar(2000) NOT NULL,
    [RunbookRefsJson] nvarchar(2000) NOT NULL,
    [ContactsJson] nvarchar(2000) NOT NULL,
    [MaintenanceWindowsJson] nvarchar(1024) NULL,
    [OffboardingTermsJson] nvarchar(2000) NOT NULL,
    [AcknowledgedBy] nvarchar(256) NULL,
    [AcknowledgedAt] datetimeoffset NULL,
    CONSTRAINT [PK_OperationsHandovers] PRIMARY KEY ([HandoverId])
);
ALTER TABLE [dbo].[OperationsHandovers] ADD CONSTRAINT [FK_OperationsHandovers_ProductDescriptors_ProductId] FOREIGN KEY ([ProductId]) REFERENCES [dbo].[ProductDescriptors] ([ProductId]);

Column	Type	Null	Key	Description
HandoverId	uniqueidentifier	no	PK
TenantId	nvarchar(64)	no
ProductId	nvarchar(128)	no	FK → ProductDescriptors.ProductId
ManagedEdition	nvarchar(16)	no
ObjectivesJson	nvarchar(2000)	no
RunbookRefsJson	nvarchar(2000)	no
ContactsJson	nvarchar(2000)	no
MaintenanceWindowsJson	nvarchar(1024)	yes
OffboardingTermsJson	nvarchar(2000)	no
AcknowledgedBy	nvarchar(256)	yes
AcknowledgedAt	datetimeoffset	yes