Well Events

the well events table captures significant events and notes during the well's history these are split into two categories interventions and comments interventions should represent workover history comments can be any type of event or note that would add context to the well during analysis the unique constraint on well events is sourcewellid + date variable data type unit of measure is nullable? default value description sourcewellid string no source well id date datetime offset no datetime offset (with timezone) in iso 8601 format example 2022 09 27t16 28 37+0000 eventtype string no "intervention" or "comment" this is a broad categorization that will determine what type of icon shows in the prodx platform "intervention" is used to highlight workover events "comment" is used for any general comments on the well comment string (1024 characters) no description of the event or the comment