Data Schema
...
Well
Wellbore
Wellbore Tubing
tubing is the pipe or conduit to transport fluids from the reservoir to the surface the tubing sits inside the casing and is constructed in sections both casing and tubing are manufactured to certain diameters and wall thicknesses variable data type unit of measure is nullable? default value description sourceid string no from wellview table wvtub use idrec column from openwells table cd assembly use assembly id column sourcewellid string no from wellview table wvtub use idwell column from openwells table cd assembly use well id column sourcewellboreid string no from wellview table wvtub use idrecwellbore column from openwells table cd assembly use wellbore id column topmd double ft no 0 0 top depth bottommd double ft no bottom depth id double in no inner diameter from wellview table wvtub use szidnommincalc column od double in no outer diameter from wellview table wvtub use szodnommincalc column roughness double in yes 0 0006 roughness of tubing rundate datetime offset yes datetime offset (with timezone) in iso 8601 format example 2022 09 27t16 28 37+0000 pulldate datetime offset yes datetime offset (with timezone) in iso 8601 format example 2022 09 27t16 28 37+0000 wellbore tubing notes tubing data is optional for wells with no tubing data and tubing pressures missing or atmospheric, the well model will interpret casing flow for wells with no tubing data and tubing pressures greater than atmospheric tubing pressures, the well model will interpret tubing flow (tubing properties and dimensions will be copied from the temporally adjacent tubing string) top measured depth notes if the topmd is null, the system will assume 0 0 ft as the default topmd value roughness notes if the roughness is null, the system will assume 0 0003 as the default roughness value data integrity checks condition response sourceid, sourcewellid, or sourcewellboreid is null or empty record rejected sourceid, sourcewellid, or sourcewellboreid does not exist record rejected