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 |
