Skip to content
Snippets Groups Projects
entry.sql 790 B
Newer Older
CREATE TYPE smartdata_v1.v1_1_digital (
    value blob,
    error tinyint,
    confidence tinyint,
    gw bigint
);

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

CREATE TYPE smartdata_v1.v1_1_si_blob (
    period int,
    gateway bigint,
    uncertainty int,
    data blob
);


CREATE TYPE smartdata_v1.v1_2_digital (
    value blob,
    error tinyint,
    confidence tinyint,
    x int,
    y int,
    z int,
    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_si_blob (
    x int,
    y int,
    z int,
    period int,
    gateway bigint,
    uncertainty int,
    data blob
);