drop table if exists rig_xml;

create table rig_xml (
    well_uid    text,  -- e.g. W-12
    well_name   text,  -- e.g. 6507/7-A-42
    rig_uid     text,  -- e.g. xr31
    rig_name    text,  -- e.g. Deep Drill #5
    rig_owner   text,  -- e.g. Deep Drilling Co.
    rig_contact text,  -- e.g. John Doe
    rig_email   text,  -- e.g. John.Doe@his-ISP.com
    doc         xml
) distributed by (rig_uid);