Data Schema
...
Well
Wellbore
Wellbore Deviation Survey
a deviation survey is a measurement of the three dimensional path of a wellbore a survey can be performed with either magnetic or gyroscopic instrumentation measurements are taken from frequent sections (points) all of the way along the wellbore variable data type unit of measure is nullable? default value description sourceid string no from wellview table wvwellboredirsurveydata use idrec column from openwells table cd survey station use survey id column sourcewellid string no from wellview table wvwellboredirsurveydata use idwell column from openwells table cd survey station use well id column sourcewellboreid string no from wellview table wvwellboredirsurveydata use idrecparent column from openwells table cd survey station use wellbore id column md double ft no 0 0 measured depth inc double decimal degrees yes inclination azi double decimal degrees yes azimuth tvd double ft no 0 0 true vertical depth deviation survey notes for each well, we expect at least three deviation survey points typically, a deviation survey will contain numerous data points to describe the well trajectory if less than three points are provided, the well model may not compute data integrity checks condition response sourceid, sourcewellid, or sourcewellboreid is null or empty record rejected sourceid, sourcewellid, or sourcewellboreid does not exist record rejected if md null or empty record rejected if tvd null or empty record rejected