Well Events

the well events table captures significant events and notes over a well's history events fall into two categories interventions , which represent workover history, and comments , which can be any event or note that adds context to the well during analysis the unique constraint on well events is sourcewellid + date + eventtype — a well can have both an intervention and a comment at the same timestamp variable data type unit of measure is nullable? default value description sourcewellid string no source id for the well from wellview wvwellheader table, idwell column from openwells cd well table, well id column date datetime offset no datetime of the event datetime offset (with timezone) in iso 8601 format example 2022 09 27t16 28 37 +0000 eventtype string no intervention or comment this broad categorization determines the icon shown in the prodx platform intervention highlights workover events, comment is for any general note on the well comment string no description of the event or comment max 1000 characters data integrity checks condition response sourcewellid does not exist in the well table record rejected and current batch aborted eventtype is not intervention or comment record rejected comment exceeds 1000 characters record rejected any non nullable field is null record rejected if any record in a post references an unknown sourcewellid , the whole batch is aborted — records earlier in the payload are not committed common error messages api scenario error response add / upsert event unknown sourcewellid well with source id xxx was not found, current batch aborted