WebhookGatewayService — 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.InboundDeliveries

Owner: InboundDelivery · Retention: 30 days

CREATE TABLE [dbo].[InboundDeliveries] (
    [InboundId] uniqueidentifier NOT NULL,
    [TenantId] nvarchar(64) NOT NULL,
    [IngressRef] nvarchar(256) NOT NULL,
    [SubscriptionId] uniqueidentifier NULL,
    [ConnectorId] nvarchar(64) NULL,
    [ExternalId] nvarchar(256) NULL,
    [DedupKey] nvarchar(256) NULL,
    [SignatureValid] bit NOT NULL,
    [Outcome] int NOT NULL,
    [PayloadRef] nvarchar(512) NULL,
    [PayloadHash] nvarchar(128) NULL,
    [ReceivedAt] datetimeoffset NOT NULL,
    CONSTRAINT [PK_InboundDeliveries] PRIMARY KEY ([InboundId])
);
CREATE INDEX [IX_Inbound_Ingress_ReceivedAt] ON [dbo].[InboundDeliveries] ([IngressRef], [ReceivedAt]);

Column	Type	Null	Key	Description
InboundId	uniqueidentifier	no	PK
TenantId	nvarchar(64)	no
IngressRef	nvarchar(256)	no
SubscriptionId	uniqueidentifier	yes
ConnectorId	nvarchar(64)	yes
ExternalId	nvarchar(256)	yes
DedupKey	nvarchar(256)	yes
SignatureValid	bit	no
Outcome	int	no
PayloadRef	nvarchar(512)	yes
PayloadHash	nvarchar(128)	yes
ReceivedAt	datetimeoffset	no