CREATE TABLE "shards" (
          "object_ulid" CHAR(26) REFERENCES "objects"("object_ulid"),

          "shard_index" INT NOT NULL,
          "shard_data" BYTEA NOT NULL,
          "shard_txid" CHAR(64),
          "shard_tx_on_chain" BOOLEAN NOT NULL,

          PRIMARY KEY ("object_ulid", "shard_index"),

          -- Constraint to enforce valid ULID
          CONSTRAINT "valid_ulid_constraint" CHECK ("object_ulid" ~ '^[0-9A-HJKMNP-TV-Z]{26}$')
        );

{
    "records": [
        [
            {
                "stringValue": "01J78A3XQ3H75JFVQ14V58Q9E0"
            },
            {
                "longValue": 1
            },
            {},
            {
                "stringValue": "shard_txid                                                      "
            },
            {
                "booleanValue": false
            }
        ]
    ],
    "numberOfRecordsUpdated": 0
}

{
    "records": [
        [
            {
                "stringValue": "01J78A3XQ3H75JFVQ14V58Q9E0"
            },
            {
                "longValue": 1
            },
            {
                "blobValue": "aGVsbG8gd29ybGQ="
            },
            {
                "stringValue": "shard_txid                                                      "
            },
            {
                "booleanValue": false
            }
        ]
    ],
    "numberOfRecordsUpdated": 0
}

$ echo 'aGVsbG8gd29ybGQ=' | base64 -d
hello world

### Anything else?

_No response_