{
    "apiVersion": "operator.ptah.run/v1alpha1",
    "kind": "PtahSchema",
    "metadata": {
        "annotations": {
            "kubectl.kubernetes.io/last-applied-configuration": "{\"apiVersion\":\"operator.ptah.run/v1alpha1\",\"kind\":\"PtahSchema\",\"metadata\":{\"annotations\":{},\"name\":\"shipments\",\"namespace\":\"ptah-test-a-1-37-0-demo-03c2a0e0b9\"},\"spec\":{\"desired\":{\"ociRef\":\"oci://e2e-registry.ptah-test-a-1-37-0-demo-03c2a0e0b9.svc.cluster.local:5000/schemas/blog-shipments@sha256:7822110a8966391651f3daf3d58d78f9a66a32b33ea5feab6bfb79c4fb6f4554\",\"registryAuthFrom\":{\"mode\":\"Environment\",\"name\":\"demo-registry\",\"passwordKey\":\"password\",\"registryKey\":\"registry\",\"usernameKey\":\"username\"},\"transport\":{\"plainHTTP\":true},\"verificationPolicyFrom\":{\"key\":\"policy.yaml\",\"name\":\"blog-schema-policy\"}},\"execution\":{\"activeDeadlineSeconds\":300,\"connectTimeout\":\"30s\",\"failureRetryInterval\":\"10s\"},\"interval\":\"30s\",\"policy\":{\"allowDestructive\":false,\"apply\":\"OnApproval\",\"driftSeverity\":\"all\"},\"target\":{\"coordinationKey\":\"blog/fulfillment/primary\",\"engine\":\"PostgreSQL\",\"urlFrom\":{\"key\":\"url\",\"name\":\"demo-database\"}}}}\n"
        },
        "creationTimestamp": "2026-09-21T10:38:16Z",
        "generation": 1,
        "name": "shipments",
        "namespace": "ptah-test-a-1-37-0-demo-03c2a0e0b9",
        "resourceVersion": "4369",
        "uid": "b6f1b5e9-e143-4563-b8da-a3014042538a"
    },
    "spec": {
        "desired": {
            "ociRef": "oci://e2e-registry.ptah-test-a-1-37-0-demo-03c2a0e0b9.svc.cluster.local:5000/schemas/blog-shipments@sha256:7822110a8966391651f3daf3d58d78f9a66a32b33ea5feab6bfb79c4fb6f4554",
            "registryAuthFrom": {
                "dockerConfigJSONKey": ".dockerconfigjson",
                "mode": "Environment",
                "name": "demo-registry",
                "passwordKey": "password",
                "registryKey": "registry",
                "tokenKey": "token",
                "usernameKey": "username"
            },
            "transport": {
                "plainHTTP": true
            },
            "verificationPolicyFrom": {
                "key": "policy.yaml",
                "name": "blog-schema-policy"
            }
        },
        "execution": {
            "activeDeadlineSeconds": 300,
            "connectTimeout": "30s",
            "failureRetryInterval": "10s"
        },
        "interval": "30s",
        "policy": {
            "allowDestructive": false,
            "apply": "OnApproval",
            "driftSeverity": "all",
            "lockTimeout": "30s",
            "transactionMode": "file"
        },
        "suspend": false,
        "target": {
            "coordinationKey": "blog/fulfillment/primary",
            "engine": "PostgreSQL",
            "sharedRealm": false,
            "urlFrom": {
                "key": "url",
                "name": "demo-database"
            }
        }
    },
    "status": {
        "applied": {
            "artifactDigest": "sha256:7822110a8966391651f3daf3d58d78f9a66a32b33ea5feab6bfb79c4fb6f4554",
            "completedAt": "2026-09-21T10:40:05Z",
            "controllerImage": "e2e-registry.ptah-test-a-1-37-0-demo-03c2a0e0b9.svc.cluster.local:5000/ptah-operator@sha256:43779e7fc26eb3a9b328c671b1dee35fc60b9345a62544d85971d401cd245cb6",
            "controllerRevision": "6d72944c477c851a19d2662eb345ea313c921dd0",
            "controllerStateVersion": 1,
            "coordinationDigest": "sha256:ffe501d44834d12840fe8618ae44c598f889b4e114447060fee3f7f1e7af063b",
            "executionBindingID": "v1-c237e28bf9ff760f211f283f88698519",
            "executorImage": "e2e-registry.ptah-test-a-1-37-0-demo-03c2a0e0b9.svc.cluster.local:5000/ptah-executor@sha256:7a7dea71ff38cb6947d300552fb47dd8f4bb2bcdfa958f4d792685d3093479a9",
            "planFingerprint": "sha256:bf172ac05a4b865c6bfc1ff9e6be122368513d3824f4fc78c699751497bf0d9b",
            "planRef": {
                "name": "ptah-plan-bf172ac05a4b865c6bfc1ff9",
                "uid": "0f0a5b36-a40c-42a9-a730-a1d098d35ebe"
            },
            "ptahVersion": "v0.7.0",
            "runnerImage": "e2e-registry.ptah-test-a-1-37-0-demo-03c2a0e0b9.svc.cluster.local:5000/ptah-runner@sha256:43779e7fc26eb3a9b328c671b1dee35fc60b9345a62544d85971d401cd245cb6",
            "runnerProtocolVersion": 5,
            "targetIdentityDigest": "sha256:60e6e9da9dece534f03e2609d238924d00a4b30dec2238b49757fdd0cc64737c"
        },
        "conditions": [
            {
                "lastTransitionTime": "2026-09-21T10:38:16Z",
                "message": "Database engine \"PostgreSQL\" is supported",
                "observedGeneration": 1,
                "reason": "SupportedEngine",
                "status": "True",
                "type": "EngineSupported"
            },
            {
                "lastTransitionTime": "2026-09-21T10:40:55Z",
                "message": "Schema is in sync",
                "observedGeneration": 1,
                "reason": "InSync",
                "status": "True",
                "type": "Ready"
            },
            {
                "lastTransitionTime": "2026-09-21T10:38:22Z",
                "message": "The latest operation completed",
                "observedGeneration": 1,
                "reason": "Succeeded",
                "status": "False",
                "type": "ReconciliationFailed"
            },
            {
                "lastTransitionTime": "2026-09-21T10:40:39Z",
                "message": "Desired OCI reference resolved to immutable content",
                "observedGeneration": 1,
                "reason": "DigestPinned",
                "status": "True",
                "type": "ArtifactResolved"
            },
            {
                "lastTransitionTime": "2026-09-21T10:40:42Z",
                "message": "Artifact type and verification policy were satisfied",
                "observedGeneration": 1,
                "reason": "PolicySatisfied",
                "status": "True",
                "type": "ArtifactVerified"
            },
            {
                "lastTransitionTime": "2026-09-21T10:38:32Z",
                "message": "Database schema was observed",
                "observedGeneration": 1,
                "reason": "Observed",
                "status": "True",
                "type": "DatabaseReachable"
            },
            {
                "lastTransitionTime": "2026-09-21T10:40:55Z",
                "message": "The authoritative managed scope has no changes",
                "observedGeneration": 1,
                "reason": "ScopedConverged",
                "status": "False",
                "type": "DriftDetected"
            },
            {
                "lastTransitionTime": "2026-09-21T10:40:55Z",
                "message": "A stable scoped plan proves convergence",
                "observedGeneration": 1,
                "reason": "ScopedConverged",
                "status": "True",
                "type": "InSync"
            },
            {
                "lastTransitionTime": "2026-09-21T10:39:48Z",
                "message": "Current plan approval requirements are satisfied",
                "observedGeneration": 1,
                "reason": "Satisfied",
                "status": "False",
                "type": "ApprovalRequired"
            },
            {
                "lastTransitionTime": "2026-09-21T10:40:55Z",
                "message": "No executable plan is required",
                "observedGeneration": 1,
                "reason": "NoChanges",
                "status": "False",
                "type": "PlanReady"
            },
            {
                "lastTransitionTime": "2026-09-21T10:38:38Z",
                "message": "Reconciliation is active",
                "observedGeneration": 1,
                "reason": "Active",
                "status": "False",
                "type": "Suspended"
            },
            {
                "lastTransitionTime": "2026-09-21T10:39:51Z",
                "message": "Apply Job completed; convergence observation is pending",
                "observedGeneration": 1,
                "reason": "JobCompleted",
                "status": "False",
                "type": "Applying"
            }
        ],
        "executionBinding": {
            "controllerImage": "e2e-registry.ptah-test-a-1-37-0-demo-03c2a0e0b9.svc.cluster.local:5000/ptah-operator@sha256:43779e7fc26eb3a9b328c671b1dee35fc60b9345a62544d85971d401cd245cb6",
            "controllerRevision": "6d72944c477c851a19d2662eb345ea313c921dd0",
            "controllerStateVersion": 1,
            "epoch": "v1-c237e28bf9ff760f211f283f88698519",
            "executorImage": "e2e-registry.ptah-test-a-1-37-0-demo-03c2a0e0b9.svc.cluster.local:5000/ptah-executor@sha256:7a7dea71ff38cb6947d300552fb47dd8f4bb2bcdfa958f4d792685d3093479a9",
            "ptahVersion": "v0.7.0",
            "runnerImage": "e2e-registry.ptah-test-a-1-37-0-demo-03c2a0e0b9.svc.cluster.local:5000/ptah-runner@sha256:43779e7fc26eb3a9b328c671b1dee35fc60b9345a62544d85971d401cd245cb6",
            "runnerProtocolVersion": 5
        },
        "lastAttemptTime": "2026-09-21T10:40:55Z",
        "lastSuccessfulReconciliation": "2026-09-21T10:40:55Z",
        "nextReconciliationTime": "2026-09-21T10:41:25Z",
        "observedGeneration": 1,
        "phase": "InSync",
        "source": {
            "artifactType": "application/vnd.stokaro.ptah.schema.v1",
            "digest": "sha256:7822110a8966391651f3daf3d58d78f9a66a32b33ea5feab6bfb79c4fb6f4554",
            "mediaType": "application/vnd.oci.image.manifest.v1+json",
            "requestedReference": "oci://e2e-registry.ptah-test-a-1-37-0-demo-03c2a0e0b9.svc.cluster.local:5000/schemas/blog-shipments@sha256:7822110a8966391651f3daf3d58d78f9a66a32b33ea5feab6bfb79c4fb6f4554",
            "resolvedAt": "2026-09-21T10:40:39Z",
            "resolvedReference": "oci://e2e-registry.ptah-test-a-1-37-0-demo-03c2a0e0b9.svc.cluster.local:5000/schemas/blog-shipments@sha256:7822110a8966391651f3daf3d58d78f9a66a32b33ea5feab6bfb79c4fb6f4554",
            "size": 812,
            "verificationPolicyDigest": "sha256:c84039b250125e32f0d51caea6afd1d13ebe4e5e0f90d382ee3be2c027574007",
            "verificationPolicyUID": "46e8fd80-2d1f-45b5-95bf-723cc6977f6b",
            "verified": true,
            "verifiedAt": "2026-09-21T10:40:42Z"
        },
        "target": {
            "coordinationDigest": "sha256:ffe501d44834d12840fe8618ae44c598f889b4e114447060fee3f7f1e7af063b",
            "driftReportDigest": "sha256:f5c9e692a923dd31dc0d28c7427bf9380401cc7e56ef7586c65fe39c52ce99e8",
            "engine": "PostgreSQL",
            "identityDigest": "sha256:60e6e9da9dece534f03e2609d238924d00a4b30dec2238b49757fdd0cc64737c",
            "lastObservedAt": "2026-09-21T10:40:49Z"
        }
    }
}