Campus Serre  1.0
BTS SN-IR La Salle Avignon 2018
Base de données SQLite

pragma foreign_keys = on;

CREATE TABLE seuils ( "idSeuils" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL , "temperatureMin" REAL NOT NULL, "temperatureMax" REAL NOT NULL, "vitesseMax" REAL );

CREATE TABLE consignes ( "idConsignes" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL , "temperatureJourMin" REAL NOT NULL, "temperatureJourMax" REAL NOT NULL, "temperatureNuitMin" REAL NOT NULL, "temperatureNuitMax" REAL NOT NULL, "hygrometrieSolMin" REAL, "hygrometrieSolMax" REAL, "hygrometrieAirMin" REAL, "hygrometrieAirMax" REAL );

CREATE TABLE cultures ( "idCulture" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL , "nom" VARCHAR(255) NOT NULL , "description" TEXT NULL , "idConsignes" INTEGER NOT NULL , "idSeuils" INTEGER NOT NULL , CONSTRAINT fk_cultures_1 FOREIGN KEY (idSeuils) REFERENCES seuils (idSeuils) ON DELETE CASCADE, CONSTRAINT fk_cultures_2 FOREIGN KEY (idConsignes) REFERENCES consignes (idConsignes) ON DELETE CASCADE );

CREATE TABLE mesures ( "idMesure" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL , "date" DATE NOT NULL, "heure" TIME NOT NULL, "temperatureAir" FLOAT NOT NULL, "temperatureSol" REAL, "hygrometrieAir" REAL, "hygrometrieSol" REAL, "vitesseVent" REAL, "directionVent" INTEGER, "ouvrant" INTEGER, "vanne" INTEGER, "chauffage" INTEGER, "idCulture" INTEGER NOT NULL , CONSTRAINT fk_mesures_1 FOREIGN KEY (idCulture) REFERENCES cultures (idCulture) ON DELETE CASCADE );

INSERT INTO seuils(temperatureMin,temperatureMax,vitesseMax) VALUES('-2','30','95'); INSERT INTO consignes(temperatureJourMin,temperatureJourMax,temperatureNuitMin,temperatureNuitMax,hygrometrieSolMin,hygrometrieSolMax,hygrometrieAirMin,hygrometrieAirMax) VALUES('18','22','10','13','','','70','80'); INSERT INTO cultures(nom,description,idConsignes,idSeuils) VALUES('Fraise Ciflorette','Variété de printemps','1','1');

campus-serre.png
 Tout Classes Fichiers Fonctions Variables Macros