Aeroscan Table

Schema SQL
 avatar
Ainzy
mysql
5 months ago
826 B
8
Indexable
CREATE TABLE BME680
(
  sensorReadingID INT       NOT NULL AUTO_INCREMENT,
  timestamp       TIMESTAMP NOT NULL,
  temperature     FLOAT     NULL    ,
  humidity        FLOAT     NULL    ,
  PRIMARY KEY (sensorReadingID)
);

ALTER TABLE BME680
  ADD CONSTRAINT UQ_sensorReadingID UNIQUE (sensorReadingID);

ALTER TABLE BME680
  ADD CONSTRAINT UQ_timestamp UNIQUE (timestamp);

CREATE TABLE PMS7003
(
  sensorReadingID INT       NOT NULL AUTO_INCREMENT,
  timestamp       TIMESTAMP NOT NULL,
  PM1             INT       NULL    ,
  PM2_5           INT       NULL    ,
  PM10            INT       NULL    ,
  PRIMARY KEY (sensorReadingID)
);

ALTER TABLE PMS7003
  ADD CONSTRAINT UQ_sensorReadingID UNIQUE (sensorReadingID);

ALTER TABLE PMS7003
  ADD CONSTRAINT UQ_timestamp UNIQUE (timestamp);
Editor is loading...
Leave a Comment