{
  "table": {
    "table_name": "identities",
    "owner_database": "subagentidentities",
    "owner_site": "subagentidentities.com",
    "column_count": 9,
    "source": "live-queried via D1 MCP this session",
    "created_at": "2026-07-02 05:45:20"
  },
  "columns": [
    {
      "id": 54,
      "table_name": "identities",
      "column_name": "id",
      "column_type": "TEXT",
      "not_null": 1,
      "default_value": null,
      "is_pk": 1,
      "ordinal": 1
    },
    {
      "id": 55,
      "table_name": "identities",
      "column_name": "name",
      "column_type": "TEXT",
      "not_null": 1,
      "default_value": null,
      "is_pk": 0,
      "ordinal": 2
    },
    {
      "id": 56,
      "table_name": "identities",
      "column_name": "surface",
      "column_type": "TEXT",
      "not_null": 1,
      "default_value": null,
      "is_pk": 0,
      "ordinal": 3
    },
    {
      "id": 57,
      "table_name": "identities",
      "column_name": "attribution_mode",
      "column_type": "TEXT",
      "not_null": 1,
      "default_value": null,
      "is_pk": 0,
      "ordinal": 4
    },
    {
      "id": 58,
      "table_name": "identities",
      "column_name": "acts_as",
      "column_type": "TEXT",
      "not_null": 1,
      "default_value": null,
      "is_pk": 0,
      "ordinal": 5
    },
    {
      "id": 59,
      "table_name": "identities",
      "column_name": "credential_source",
      "column_type": "TEXT",
      "not_null": 1,
      "default_value": null,
      "is_pk": 0,
      "ordinal": 6
    },
    {
      "id": 60,
      "table_name": "identities",
      "column_name": "access_scope",
      "column_type": "TEXT",
      "not_null": 1,
      "default_value": null,
      "is_pk": 0,
      "ordinal": 7
    },
    {
      "id": 61,
      "table_name": "identities",
      "column_name": "billing_owner",
      "column_type": "TEXT",
      "not_null": 1,
      "default_value": null,
      "is_pk": 0,
      "ordinal": 8
    },
    {
      "id": 62,
      "table_name": "identities",
      "column_name": "source_doc",
      "column_type": "TEXT",
      "not_null": 1,
      "default_value": null,
      "is_pk": 0,
      "ordinal": 9
    }
  ]
}