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

Contracts

arcs

Transportation lanes connecting supply-chain nodes. Each arc defines a directed link with per-unit shipping cost, maximum throughput, transit time, and great-circle distance. Used by network flow, transportation, and routing models. — 7 col(s)

demand

Customer demand forecasts by product and planning period. Each row is a (customer, product, period) tuple with a forecasted quantity and a service-level priority (1 = critical, 5 = deferrable) that drives fulfillment sequencing. — 5 col(s)

inventory-policy

Inventory stocking parameters per warehouse and product. Defines holding costs, safety-stock floors, and maximum storage limits that feed into multi-echelon inventory optimization and network design models. — 5 col(s)

nodes

Network locations in the supply chain: factories, distribution centers, and customer zones. Each node has a type, geographic coordinates, throughput capacity, and an annualized fixed operating cost used in facility-location decisions. — 8 col(s)

products

Product master data. Each SKU has physical attributes (weight, volume) used for vehicle capacity checks and a declared unit value used in inventory holding-cost calculations and service-level prioritization. — 6 col(s)

supply-capacity

Factory production capacity by product and period. Defines the maximum units a factory can produce, the variable cost per unit, and a fixed setup cost incurred whenever production is scheduled in that period. — 6 col(s)

time-periods

Planning horizon definition. Each row is a discrete time bucket (week, month, or quarter) with start/end dates. Referenced by demand, supply-capacity, and other period-indexed contracts to ensure temporal consistency. — 4 col(s)

vehicles

Fleet master data for vehicle routing problems. Each vehicle has weight and volume limits, a per-kilometer operating cost, and a maximum number of stops per route. Vehicles are assigned to a home depot node. — 7 col(s)

arcs
demand
inventory-policy
nodes
products
time-periods

Constraints

arc-endpoints-valid

3 rule(s) — references: nodes, arcsEvery arc must connect two nodes that exist in the network (subset). Every node must have at least one outbound arc (coverage), ensuring the network graph has no isolated locations. Prevents dangling references and disconnected nodes.

demand-integrity

5 rule(s) — references: demand, nodes, products, time-periodsDemand rows must reference valid customers, products, and planning periods (subset). Every product and every time period must appear in at least one demand row (coverage). Catches orphaned demand records and ensures no product or period is left without forecast data.

inventory-integrity

1 rule(s) — references: inventory-policy, nodes, productsThere 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).

2 other constraint(s) available if you add more contracts
arc-endpoints-valid
demand-integrity
inventory-integrity
No validation errors.
Ctrl+S to save · Esc to cancel
{
  "id": "prj_seed_003",
  "name": "inventory-planning",
  "description": "Multi-echelon inventory optimization. Sets safety-stock levels and replenishment policies across the warehouse network to minimize total holding and stockout costs while meeting target service levels.",
  "contractRefs": [
    "nodes",
    "arcs",
    "products",
    "demand",
    "inventory-policy",
    "time-periods"
  ],
  "constraintRefs": [
    "arc-endpoints-valid",
    "demand-integrity",
    "inventory-integrity"
  ],
  "rowCountOverrides": {
    "arcs": {
      "mode": "exact",
      "exactRowCount": 100
    },
    "demand": {
      "mode": "exact",
      "exactRowCount": 50
    },
    "inventory-policy": {
      "mode": "default"
    },
    "nodes": {
      "mode": "default"
    },
    "products": {
      "mode": "default"
    },
    "time-periods": {
      "mode": "default"
    }
  },
  "createdAt": "2026-02-11T10:00:00Z",
  "updatedAt": "2026-02-18T04:54:36.7568121Z"
}

Test Data Generation

Configure row counts per contract, then generate synthetic data. Defaults: 20 rows/contract, max 1000.

Contract Mode Rows Source

arcs

user override (exact: 100)

demand

user override (exact: 50)

inventory-policy

400

crossProduct (20 nodes × 20 products = 400)

nodes

20

global default (20)

products

20

global default (20)

time-periods

20

global default (20)
Output Format
NODE_IDNODE_TYPENAMEREGIONLATITUDELONGITUDECAPACITYFIXED_COST

CvOS*&#s

EzD5*Sqz

ZbI8TLy7

RGZTthcs9UMw

34.01

-149.22

1896

3762.96

kC%Q&&S#fU@$

kQ#JX0uO

lmuW9S*W

c13b6TYm2xM9

-59.30

-112.25

69

5669.57

B2Vr1D%x#Mw!

oPdiJSiyK

xZakXVP3

7hX#vy2b5u

-7.80

-14.00

5725

422.89

G9Am6*BNPF1

FN71SI@3

hf!#$C137ndm

Mojd#zSgWP#8

77.59

-6.19

9711

2062.08

gyNN9JXt8

MsVntGDp9

YCjEux@83!

s@$*c0@a0C

-80.85

69.27

7032

1738.45

QYNo#ci9B

gEHjFQU#

HF69UE5rod

9eq@AlBofP

-85.86

123.90

6889

2228.32

xM3@JZ&W

p6kJJduNZ0

943emZ93E!@i

zENpbPQv2*H

-23.31

163.39

5572

2093.37

qkZD9Pl&@Li

Tn2120F6

y!ocjG$Q

j%gZnYGsdKgF

-71.18

-136.85

5970

1462.20

4@zepudjN

9acidg3Tz

1l7KZ6CG8@Q

YREaxmB%4O

-52.06

-34.28

1227

8646.68

ISI1VUIa

NnGbRtdGw%1R

TA6d664X

I#HDGOLW

-18.91

103.95

9934

2538.69

&d$U5LP%

1H0qzu*3

gg%9BC1Mbj

3u&Gvfie

48.53

125.73

2589

8239.64

tH7d5JVfx6

I%70%&%5XX

MqKSV$kp

r#ut#D4T

21.91

-64.38

4140

407.33

6C$*R1@L0l

JJbOkBOd2X%

Uq$AWxQE!h

%LDqsui4

14.46

-54.60

4672

321.76

vHPpld4W0wV

V4JPH0pLJE4

ePSxqS!xKMwn

oJbyZ*SB

26.24

-177.31

1215

4959.96

poJajBSk

u9EmiWzn

PunR*9TGQOe

0DccLPVI2

-86.53

50.33

2468

3360.59

6WJQk@vIxuzZ

Xp#8NZCqw

T*tIC&II0BN

jK*aC6MDpZv

14.03

134.08

8167

1276.83

MR7E7pVI

2%I1xb$*uEIq

svg0hlfC@T

o*9PB01Dn

85.28

77.11

2363

8344.16

LMSn04Mw@t8S

wEEN65DmWYGE

NRtu7ei0s8i

XhPYhB2GrY&

-35.49

18.58

170

1573.57

flz91Af0G%!F

w7MEhEw7jJ

kwK*Zc8!1*hX

8WhnU#I1T*

-35.45

-120.33

8931

4057.08

v00EbTGVX07

zpTvctdn

SpX@9lz7ENRr

xWSgqMY2kaHh

-38.26

-26.50

9609

6947.40

Generated 610 total rows across 6 contracts. Data saved to the tenant data directory.
Constraint Verification
Constraint Rule Result

arc-endpoints-valid

arcs.FROM_NODE ⊆ nodes.NODE_ID

All 100 values valid

arc-endpoints-valid

arcs.TO_NODE ⊆ nodes.NODE_ID

All 100 values valid

arc-endpoints-valid

arcs.FROM_NODE covers all values from nodes.NODE_ID

All 20 parent values covered

demand-integrity

demand.CUSTOMER_ID ⊆ nodes.NODE_ID

All 50 values valid

demand-integrity

demand.PRODUCT_ID ⊆ products.PRODUCT_ID

All 50 values valid

demand-integrity

demand.PERIOD ⊆ time-periods.PERIOD_ID

All 50 values valid

demand-integrity

demand.PRODUCT_ID covers all values from products.PRODUCT_ID

All 20 parent values covered

demand-integrity

demand.PERIOD covers all values from time-periods.PERIOD_ID

All 20 parent values covered

inventory-integrity

Cross-product: inventory-policy.WAREHOUSE_ID↔nodes.NODE_ID × inventory-policy.PRODUCT_ID↔products.PRODUCT_ID

400 rows = product of 20 × 20

9 of 9 rules passed.