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 docid\ y5pxm hjtoozmhybvyzte 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