10 lines
275 B
SQL
10 lines
275 B
SQL
-- Add migration script here
|
|
CREATE TABLE Telemetry (
|
|
timestamp TIMESTAMP NOT NULL,
|
|
Software_Version INT NOT NULL,
|
|
Voltage FLOAT,
|
|
Temperature FLOAT,
|
|
uptime INT NOT NULL,
|
|
device_id MACADDR NOT NULL,
|
|
FOREIGN KEY (device_id) REFERENCES Devices(ID)
|
|
); |