gela_cerva_schema

CREATE TABLE core_devices (
    device_id          int PRIMARY KEY,
    device_mac         VARCHAR(500) NOT NULL,
    description        VARCHAR(500) NOT NULL,
    user_id            NUMBER(38) NOT NULL,
    temp_variation   NUMBER(38) NOT NULL,
    set_point        NUMBER(38) NOT NULL,
    bandwith         NUMBER(38) NOT NULL,
    control_type     NUMBER(1) NOT NULL,
    max_temp         NUMBER(38) NOT NULL,
    min_temp         NUMBER(38) NOT NULL,
    relay_state      NUMBER(1) NOT NULL,
    sm_mode          NUMBER(1) NOT NULL
);

CREATE TABLE core_temperatures (
    device_id      INT NOT NULL,
    temperature_id      INT CONSTRAINT pk PRIMARY KEY,
    temperature   NUMBER(38) NOT NULL,
    temperature_date          DATE NOT NULL,
    CONSTRAINT fk_device_id FOREIGN KEY (device_id) REFERENCES core_devices (device_id)
);

DROP TABLE core_devices;
DROP TABLE core_temperatures;