Aeroscan Table
Schema SQLAinzy
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