Data Schema
...
Well
Wellbore
Wellbore
a wellbore is a borehole drilled from the surface into the subsurface reservoir formation each well will have a at least one wellbore in some cases, a well may have more than one wellbore in such cases the additional wellbores will be children "sidetracked" from the main bore at a certain depth the depth is known as the junction depth for main wellbores the junction depth will be 0 for child wellbores the junction depth (ft) must be a positive number (e g 2000 ft) variable data type unit of measure is nullable? default value description sourceid string no from wellview table wvwellbore use idrec column from openwells table cd wellbore use wellbore id column sourcewellid string no from wellview table wvwellbore use idwell column from openwells table cd wellbore use well id column name string yes name of wellbore junctionmd double ft yes measured depth at which a child wellbore joins the parent wellbore wellbore notes you must have a well record with a corresponding uwi in the system before adding a wellbore junction measured depth notes if this is the parent wellbore, junctionmd should be null data integrity checks condition response sourceid or sourcewellid is null or empty record rejected sourceid or sourcewellid does not exist record rejected