Integration Platform — data model

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.

ConnectorRegistryService

erDiagram
    ConnectorDescriptor {
        string connectorId PK
        string version
        string tenantId
        string provider
        list_string capabilities
        string adapterRef
        json retryProfile
        json rateLimitProfile
        json webhookScheme
        string configurationForm
        string certificationRef
        enum_ConnectorState state
        string releaseId
    }
    Subscription {
        guid subscriptionId PK
        string tenantId
        string projectId
        string connectorId
        guid connectionId
        list_string eventTypes
        json target
        string ingressRef
        bool active
        datetime lastDeliveryAt
    }
    Delivery {
        guid deliveryId PK
        string tenantId
        enum_DeliveryDirection direction
        string connectorId
        guid connectionId
        guid subscriptionId
        string externalId
        string dedupKey
        enum_DeliveryState state
        string payloadRef
        hash payloadHash
        int attempts
        string receiptRef
        datetime receivedAt
        datetime settledAt
    }

Hold "Alt" / "Option" to enable pan & zoom

Tables: dbo.ConnectorDescriptors, dbo.Subscriptions, dbo.Deliveries — see the DDL appendix.

IntegrationService

erDiagram
    Connection {
        guid connectionId PK
        string tenantId
        string name
        string provider
        json endpointPolicy
        enum_CredentialKind credentialKind
        string credentialRef
        json rotation
        enum_ConnectionState state
        bool healthy
        datetime lastVerifiedAt
        long version
    }
    Grant {
        guid grantId

        enum_GrantSubjectKind subjectKind

        string subjectId

        list_string scopes

        string grantedBy

        datetime grantedAt

        datetime expiresAt

    }
    Connection ||--o{ Grant : contains

Hold "Alt" / "Option" to enable pan & zoom

Grant (entity)

Permission for a subject to use the connection with an optional scope narrowing.

Field	Type	Required	Description
grantId	guid	yes
subjectKind	enum:GrantSubjectKind	yes
subjectId	string	yes
scopes	list:string	yes	Narrowing of the endpoint policy for this subject.
grantedBy	string	yes
grantedAt	datetime	yes
expiresAt	datetime	no

Tables: dbo.Connections, dbo.ConnectionGrants — see the DDL appendix.

WebhookGatewayService

erDiagram
    InboundDelivery {
        guid inboundId PK
        string tenantId
        string ingressRef
        guid subscriptionId
        string connectorId
        string externalId
        string dedupKey
        bool signatureValid
        enum_VerificationOutcome outcome
        string payloadRef
        hash payloadHash
        datetime receivedAt
    }

Hold "Alt" / "Option" to enable pan & zoom

Tables: dbo.InboundDeliveries — see the DDL appendix.