Data Schema
...
Network
Constraints

Network Joint Constraint

The network joint constraint table describes time-based constraints to apply to joint elements in a network for network optimization and forecasting defaults.

Constraints will apply from the last date they were set. For example, if a record is added with date 2023-01-01T00:00:00+0000 with the "maxOilRate" variable set to 1200 STB/d, that constraint will continue to apply until a future record is added with a different value for "maxOilRate".

A NULL value for a particular constraint effectively makes that variable unconstrained. With this in mind, it is important to take care to manage constraints appropriately if various constraint variables are changing on different time horizons, as it could be easy to reset constraints unexpectedly with NULL values.

The unique constraint on the Network Joint Constraint table rows is sourceNetworkId + sourceId + date

Variable

Data Type

Unit of Measure

Is Nullable?

Default Value

Description

sourceNetworkId

String

-

No

-

Source ID of Network Well Definition

sourceId

String

-

No

-

Source ID of the joint which should match a joint sourceId defined as an upstream or downstream sourceId of a pipe

date

DateTimeOffset

-

No

-

Date at which the constraint becomes applicable. Datetime offset (with timezone) in ISO 8601 format. Example: 2022-09-27T16:28:37+0000

maxPressure

Double

psi

Yes

-

Maximum pressure constraint

minPressure

Double

psi

Yes

-

Minimum pressure constraint

maxMolarFractionCO2

Double

molar fraction

Yes

-

Maximum molar fraction CO2 constraint

maxMolarFractionN2

Double

molar fraction

Yes

-

Maximum molar fraction N2 constraint

maxMolarFractionH2S

Double

molar fraction

Yes

-

Maximum molar fraction H2S constraint

maxOilRate

Double

STB/d

Yes

-

Maximum oil rate constraint

maxGasRate

Double

Mscf/d

Yes

-

Maximum gas rate constraint

maxWaterRate

Double

STB/d

Yes

-

Maximum water rate constraint

maxLiquidRate

Double

STB/d

Yes

-

Maximum liquid rate constraint