Data Schema
Well
Forecast
the well forecast table allows you to load internal/customer forecasts, which can be compared to the prodx pi based forecasts in various variance reports in the application customer forecasts are not versioned in prodx; therefore at any given point in time, there can only be one customer forecast per well it is important to clear any old versions of forecasts before inserting new ones if there is any chance the date might differ, as different dates than the original forecast will insert if subsequent versions of forecasts maintain the same date, they can be pushed without deletion since the unique constraint of uwi + date will allow an update of the existing records the forecast table has a unique constraint of uwi + date variable data type unit of measure is nullable? default value description uwi string no unique well identifier date datetime offset no datetime offset (with timezone) in iso 8601 format example 2022 09 27t16 28 37+0000 oilrate double bbl/d no 0 0 oil flow rate gasrate double mscf/d no 0 0 gas flow rate waterrate double bbl/d no 0 0 water flow rate