Data Schema
...
Network
Constraints

Network Well Constraint

the network well constraint table describes time based constraints to apply to well 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 "maxpressure" variable set to 2100 psi, that constraint will continue to apply until a future record is added with a different value for "maxpressure" 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 well 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 header docid\ irxj rg5leh701vw2okjl sourcewellid string no source id of network well definition docid\ y5pxm hjtoozmhybvyzte sourceid string no source id for the well/date constraint this sourceid enables upsert functionality from client source systems of record 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 psig yes maximum pressure constraint minpressure double psig yes minimum pressure 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 maxdrawdown double psi yes maximum drawdown constraint (reservoir pressure bottomhole pressure) planneddowntime double % yes planned downtime in percent (100% == 24 hours) maxgasliftinjectionrate double mscf/d yes maximum gas lift injection rate mingasliftinjectionrate double mscf/d yes minimum gas lift injection rate maxgasliftinjectionpressure double psig yes maximum gas lift injection pressure mingasliftinjectionpressure double psig yes minimum gas lift injection pressure