Zum Inhalt
HALOWERK

Technische Prüfungen & Formate

relational / relational delete action propagation

An agent that plans deletion from a complete relational export needs cascade closure surviving blocking references and pending null assignments measured before execution.

POST https://detect.halowerk.com/v1/relational/relational-delete-action-propagation

Eingaben

Felder des veröffentlichten Eingabeschemas
FeldTypPflichtBeschreibung
artifactobjectJa
Vollständiges Eingabeschema anzeigen
{
  "type": "object",
  "properties": {
    "artifact": {
      "type": "object",
      "properties": {
        "tables": {
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "width": {
                "type": "integer",
                "minimum": 1,
                "maximum": 12
              },
              "rows": {
                "type": "array",
                "items": {
                  "type": "array",
                  "items": {
                    "anyOf": [
                      {
                        "type": "integer",
                        "minimum": -1000000000,
                        "maximum": 1000000000
                      },
                      {
                        "type": "string",
                        "minLength": 0,
                        "maxLength": 128
                      },
                      {
                        "type": "boolean"
                      },
                      {
                        "type": "null"
                      }
                    ]
                  },
                  "minItems": 1,
                  "maxItems": 12
                },
                "minItems": 0,
                "maxItems": 64
              }
            },
            "required": [
              "width",
              "rows"
            ],
            "additionalProperties": false
          },
          "minItems": 1,
          "maxItems": 4
        },
        "foreign_keys": {
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "source_table": {
                "type": "integer",
                "minimum": 0,
                "maximum": 3
              },
              "target_table": {
                "type": "integer",
                "minimum": 0,
                "maximum": 3
              },
              "source_columns": {
                "type": "array",
                "items": {
                  "type": "integer",
                  "minimum": 0,
                  "maximum": 11
                },
                "minItems": 1,
                "maxItems": 12
              },
              "target_columns": {
                "type": "array",
                "items": {
                  "type": "integer",
                  "minimum": 0,
                  "maximum": 11
                },
                "minItems": 1,
                "maxItems": 12
              },
              "action": {
                "type": "string",
                "minLength": 5,
                "maxLength": 8,
                "enum": [
                  "cascade",
                  "block",
                  "set_null"
                ]
              }
            },
            "required": [
              "source_table",
              "target_table",
              "source_columns",
              "target_columns",
              "action"
            ],
            "additionalProperties": false
          },
          "minItems": 0,
          "maxItems": 8
        },
        "deletes": {
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "table": {
                "type": "integer",
                "minimum": 0,
                "maximum": 3
              },
              "row": {
                "type": "integer",
                "minimum": 0,
                "maximum": 63
              }
            },
            "required": [
              "table",
              "row"
            ],
            "additionalProperties": false
          },
          "minItems": 1,
          "maxItems": 64
        }
      },
      "required": [
        "tables",
        "foreign_keys",
        "deletes"
      ],
      "additionalProperties": false
    }
  },
  "required": [
    "artifact"
  ],
  "additionalProperties": false
}

Originalschema öffnen

Veröffentlichtes Eingabebeispiel

{
  "artifact": {
    "tables": [
      {
        "width": 1,
        "rows": [
          [
            1
          ]
        ]
      },
      {
        "width": 1,
        "rows": [
          [
            1
          ]
        ]
      }
    ],
    "foreign_keys": [
      {
        "source_table": 1,
        "target_table": 0,
        "source_columns": [
          0
        ],
        "target_columns": [
          0
        ],
        "action": "cascade"
      }
    ],
    "deletes": [
      {
        "table": 0,
        "row": 0
      }
    ]
  }
}

Ergebnis & Dokumentation

Maschinenlesbare Dokumentation dieses Hubs

Quelle dieser Seite: der veröffentlichte HALOWERK-Katalog. Stand: 2026-11-01, 15:19 UTC.

Weitere Endpunkte dieses Hubs

Alle Endpunkte dieses Hubs →