-
Notifications
You must be signed in to change notification settings - Fork 0
Postgres SQL TABLE sensors
Romain Tourte edited this page Oct 2, 2019
·
3 revisions
-- Table: public.sensors
-- DROP TABLE public.sensors;
CREATE TABLE public.sensors ( "mqttUser" "char"[], "phSensor" double precision, "temperatureSensor" double precision, "doSensor" double precision, "ecSensor" double precision, "tdsSensor" double precision, "orpSensor" double precision, "user" character varying COLLATE pg_catalog."default", longitude double precision, latitude double precision, "precision" double precision, speed double precision, "time" time without time zone, date date ) WITH ( OIDS = FALSE ) TABLESPACE pg_default;
ALTER TABLE public.sensors OWNER to postgres;