This table provides expansions of the well drilling purpose codes used in the Well Data Table (WELL_DATA). A primary key constraint has been included.
| No. | Column name | Data type | Notes |
|---|---|---|---|
| 1 | WELL_TYPE | Varchar(3) | Primary key |
| 2 | PURPOSE | Varchar(32) |
| WELL_TYPE | PURPOSE |
|---|---|
| HYD | Hydrocarbon exploration |
| MIN | Mineral exploration |
| STO | Gas storage (salt cavern) |
| UNK | Unknown |
| WAT | Water extraction |
| COA | Coal exploration |
| GEO | Geological survey |