AgentCardService — 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.AgentCards

Owner: AgentCard

CREATE TABLE [dbo].[AgentCards] (
    [CardId] uniqueidentifier NOT NULL,
    [TenantId] nvarchar(64) NOT NULL,
    [AgentId] nvarchar(128) NOT NULL,
    [ReleaseId] nvarchar(256) NOT NULL,
    [Visibility] int NOT NULL,
    [CardJson] nvarchar(max) NOT NULL,
    [ReleaseHash] nvarchar(128) NOT NULL,
    [PublishedAt] datetimeoffset NOT NULL,
    [WithdrawnAt] datetimeoffset NULL,
    CONSTRAINT [PK_AgentCards] PRIMARY KEY ([CardId])
);
CREATE UNIQUE INDEX [UX_AgentCards_Tenant_Agent_Release] ON [dbo].[AgentCards] ([TenantId], [AgentId], [ReleaseId]);

Column	Type	Null	Key	Description
CardId	uniqueidentifier	no	PK
TenantId	nvarchar(64)	no
AgentId	nvarchar(128)	no
ReleaseId	nvarchar(256)	no
Visibility	int	no
CardJson	nvarchar(max)	no
ReleaseHash	nvarchar(128)	no
PublishedAt	datetimeoffset	no
WithdrawnAt	datetimeoffset	yes