Data Schema
...
Well
Wellbore
Wellbore Microstring
microstrings are smaller strings ran inside of tubing, which are used for chemical or foam injection variable data type unit of measure is nullable? default value description sourceid string no sourcewellid string no sourcewellboreid string no topmd double ft no 0 0 top depth bottommd double ft no bottom depth id double in no inner diameter od double in no outer diameter roughness double in yes 0 0003 roughness 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 microstring notes microstring data is optional currently it is used for effective diameter in tubing pressure traverses 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