Edit: inventory-integrity
Name
Must be unique (case-insensitive).
Description
Owner

Tags

supply-chain
referential-integrity
inventory
crossProduct

Rules

Rule 1
Type
The child table will have one row for every combination of distinct values from two parent columns (Cartesian product). Row count = parent1 distinct values x parent2 distinct values.
Child Contract
Dimension 1
Child Column
Parent Contract
Parent Column
Dimension 2
Child Column
Parent Contract
Parent Column

Referenced Contracts (auto-computed)

No validation errors.
Ctrl+S to save · Esc to cancel 
{
  "id": "cst_seed_004",
  "name": "inventory-integrity",
  "description": "There must be exactly one inventory-policy row for every (warehouse, product) combination. The crossProduct rule ensures referential integrity (all warehouse and product IDs come from their parent tables) and completeness (no combination is missing).",
  "tags": [
    "supply-chain",
    "referential-integrity",
    "inventory",
    "crossProduct"
  ],
  "rules": [
    {
      "type": "crossProduct",
      "mappings": [
        {
          "left": "inventory-policy.WAREHOUSE_ID",
          "right": "nodes.NODE_ID"
        },
        {
          "left": "inventory-policy.PRODUCT_ID",
          "right": "products.PRODUCT_ID"
        }
      ]
    }
  ],
  "contractRefs": [
    "inventory-policy",
    "nodes",
    "products"
  ],
  "createdAt": "2026-02-11T10:00:00Z",
  "updatedAt": "2026-02-18T04:55:32.1736566Z"
}