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 true left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type
