CREATE TYPE smartdata_v1.v1_1_si (
    value double,
    error tinyint,
    confidence tinyint,
    gw bigint
);

CREATE TYPE smartdata_v1.v1_1_digital (
    value blob,
    error tinyint,
    confidence tinyint,
    gw bigint
);

CREATE TYPE smartdata_v1.v1_2_si (
    value double,
    error tinyint,
    confidence tinyint,
    x int,
    y int,
    z int,
    gw bigint
);

CREATE TYPE smartdata_v1.v1_2_digital (
    value blob,
    error tinyint,
    confidence tinyint,
    x int,
    y int,
    z int,
    gw bigint
);