Wellbore

a wellbore is a borehole drilled from the surface into the subsurface reservoir formation every well has at least one wellbore a well may have additional wellbores sidetracked from the main bore; each child wellbore joins its parent at a measured depth called the junction depth the main wellbore has no junction depth ( junctionmd is null); for child wellbores, junctionmd must be a positive number (e g 2000 ft) the unique constraint on wellbores is sourcewellid + sourceid a well docid\ p xhbe4jqkjqemay7aol5 record with the corresponding sourcewellid must exist before adding a wellbore variable data type unit of measure is nullable? default value description sourceid string no source id for the wellbore from wellview wvwellbore table, idrec column from openwells cd wellbore table, wellbore id column sourcewellid string no source id for the well from wellview wvwellbore table, idwell column from openwells cd wellbore table, well id column name string yes name of the wellbore junctionmd double ft yes measured depth at which a child wellbore joins its parent null for the main wellbore data integrity checks condition response sourceid or sourcewellid is null or empty record rejected sourcewellid does not exist in the well table record rejected common error messages api scenario error response add / upsert wellbore unknown sourcewellid well with source id xxx does not exist