{
  "table": {
    "table_name": "tasks",
    "owner_database": "subagenttasks",
    "owner_site": "subagenttasks.com",
    "column_count": 13,
    "source": "live-queried via D1 MCP this session",
    "created_at": "2026-07-02 05:45:20"
  },
  "columns": [
    {
      "id": 38,
      "table_name": "tasks",
      "column_name": "id",
      "column_type": "TEXT",
      "not_null": 1,
      "default_value": null,
      "is_pk": 1,
      "ordinal": 1
    },
    {
      "id": 39,
      "table_name": "tasks",
      "column_name": "subject",
      "column_type": "TEXT",
      "not_null": 1,
      "default_value": null,
      "is_pk": 0,
      "ordinal": 2
    },
    {
      "id": 40,
      "table_name": "tasks",
      "column_name": "description",
      "column_type": "TEXT",
      "not_null": 1,
      "default_value": null,
      "is_pk": 0,
      "ordinal": 3
    },
    {
      "id": 41,
      "table_name": "tasks",
      "column_name": "active_form",
      "column_type": "TEXT",
      "not_null": 0,
      "default_value": null,
      "is_pk": 0,
      "ordinal": 4
    },
    {
      "id": 42,
      "table_name": "tasks",
      "column_name": "status",
      "column_type": "TEXT",
      "not_null": 1,
      "default_value": "'pending'",
      "is_pk": 0,
      "ordinal": 5
    },
    {
      "id": 43,
      "table_name": "tasks",
      "column_name": "owner",
      "column_type": "TEXT",
      "not_null": 0,
      "default_value": null,
      "is_pk": 0,
      "ordinal": 6
    },
    {
      "id": 44,
      "table_name": "tasks",
      "column_name": "metadata",
      "column_type": "TEXT",
      "not_null": 1,
      "default_value": "'{}'",
      "is_pk": 0,
      "ordinal": 7
    },
    {
      "id": 45,
      "table_name": "tasks",
      "column_name": "session_id",
      "column_type": "TEXT",
      "not_null": 1,
      "default_value": null,
      "is_pk": 0,
      "ordinal": 8
    },
    {
      "id": 46,
      "table_name": "tasks",
      "column_name": "source_site",
      "column_type": "TEXT",
      "not_null": 1,
      "default_value": null,
      "is_pk": 0,
      "ordinal": 9
    },
    {
      "id": 47,
      "table_name": "tasks",
      "column_name": "contract_id",
      "column_type": "TEXT",
      "not_null": 0,
      "default_value": null,
      "is_pk": 0,
      "ordinal": 10
    },
    {
      "id": 48,
      "table_name": "tasks",
      "column_name": "blocked_reason",
      "column_type": "TEXT",
      "not_null": 0,
      "default_value": null,
      "is_pk": 0,
      "ordinal": 11
    },
    {
      "id": 49,
      "table_name": "tasks",
      "column_name": "created_at",
      "column_type": "TEXT",
      "not_null": 1,
      "default_value": "datetime('now')",
      "is_pk": 0,
      "ordinal": 12
    },
    {
      "id": 50,
      "table_name": "tasks",
      "column_name": "updated_at",
      "column_type": "TEXT",
      "not_null": 1,
      "default_value": "datetime('now')",
      "is_pk": 0,
      "ordinal": 13
    }
  ]
}