DROP TABLE IF EXISTS drilling_realtime_st;

CREATE STABLE drilling_realtime_st (
    ts TIMESTAMP,
    stknum INT,
    recid INT,
    seqid INT,
    actual_date INT,
    actual_time INT,
    actcod INT,
    deptbitm FLOAT,
    deptbitv FLOAT,
    deptmeas FLOAT,
    deptvert FLOAT,
    blkpos FLOAT,
    ropa FLOAT,
    hkla FLOAT,
    hklx FLOAT,
    woba FLOAT,
    wobx FLOAT,
    torqa FLOAT,
    torqx FLOAT,
    rpma INT,
    sppa FLOAT,
    chkp FLOAT,
    spm1 INT,
    spm2 INT,
    spm3 INT,
    tvolact FLOAT,
    tvolcact FLOAT,
    mfop INT,
    mfoa FLOAT,
    mfia FLOAT,
    mdoa FLOAT,
    mdia FLOAT,
    mtoa FLOAT,
    mtia FLOAT,
    mcoa FLOAT,
    mcia FLOAT,
    stkc INT,
    lagstks INT,
    deptretm FLOAT,
    gasa FLOAT,
    space1 FLOAT,
    space2 FLOAT,
    space3 FLOAT,
    space4 FLOAT,
    space5 FLOAT
) TAGS (
    equipment_code VARCHAR(50)
);