Data Schema
Well

Well Test

valid well tests can be imported to overlay on production charts and compare with allocated volumes the uwi field should link to a uwi in the well docid\ p xhbe4jqkjqemay7aol5 table the well test table can support a variety of well test types including welltest, tracer, cgr, and salinity the default type value is welltest, which indicates a standard production volume measurement through a test separator the unique constraint on well test entries is 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 type string yes welltest describes the type of the well test welltest standard measurements through test separator tracer cgr salinity isvalid boolean yes true whether the well test is valid or invalid oilrate double bbl/d yes oil flow rate gasrate double mscf/d yes gas flow rate waterrate double bbl/d yes water flow rate tubingpressure double psig yes tubing / wellhead pressure tubingtemperature double degf yes tubing / wellhead temperature casingpressure double psig yes casing pressure casingtemperature double degf yes casing temperature gaugepressure double psig yes downhole gauge pressure (downhole gauge must be available in downhole equipment table) gaugetemperature double degf yes downhole gauge temperature (downhole gauge must be available in downhole equipment table) choke double % yes choke opening % upstreamchokepressure double psig yes upstream choke pressure downstreamchokepressure double psig yes downstream choke pressure basicsedimentandwater double % yes percentage basic sediment and water duration double hrs yes well test duration separatorpressure double psig yes test separator pressure separatortemperature double degf yes test separator temperature gasliftinjectionrate double mscf/d yes test gas lift injection rate watergasratio double stb/mmscf yes test water/gas ratio condensategasratio double stb/mmscf yes test condensate/gas ratio salinity double ppm yes test salinity