Exploration And Appraisal Wells

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "well_no" VARCHAR,
  "well_class" VARCHAR,
  "lic_no" VARCHAR,
  "lic_op" VARCHAR,
  "spud_date" TIMESTAMP,
  "water_dep_m" DOUBLE,
  "rig_datum" VARCHAR,
  "datum_elev_m" DOUBLE,
  "td_md_m" DOUBLE,
  "td_tvdss_m" DOUBLE,
  "td_date" TIMESTAMP,
  "mech_stat" VARCHAR,
  "t1_age" VARCHAR,
  "t1_name" VARCHAR,
  "r1_age" VARCHAR,
  "r1_name" VARCHAR,
  "r1_thick_m" VARCHAR,
  "r1_rock" VARCHAR,
  "r1_fluid" VARCHAR,
  "r1_flow_hrs" DOUBLE,
  "r1_rate_bblsd" DOUBLE,
  "r1_rate_mmcfd" DOUBLE,
  "r1_choke" VARCHAR,
  "r1_oil_ton" DOUBLE,
  "r1_gas_m3" DOUBLE,
  "r1_cond_m3" DOUBLE,
  "r1_whp_bar" DOUBLE,
  "r1_wht_oc" DOUBLE,
  "r1_waterpc" DOUBLE,
  "t2_age" VARCHAR,
  "t2_name" VARCHAR,
  "r2_age" VARCHAR,
  "r2_name" VARCHAR,
  "r2_thick_m" VARCHAR,
  "r2_rock" VARCHAR,
  "r2_fluid" VARCHAR,
  "t3_age" VARCHAR,
  "t3_name" VARCHAR,
  "r3_age" VARCHAR,
  "r3_name" VARCHAR,
  "r3_thick_m" VARCHAR,
  "r3_rock" VARCHAR,
  "r3_fluid" VARCHAR,
  "t4_age" VARCHAR,
  "t4_name" VARCHAR,
  "r4_age" VARCHAR,
  "r4_name" VARCHAR,
  "r4_thick_m" DOUBLE,
  "r4_rock" VARCHAR,
  "r4_fluid" VARCHAR,
  "comments" VARCHAR
);