Skip to content

serveur BDD

Compare
Choose a tag to compare
@nnnnnzo nnnnnzo released this 05 Feb 10:30
· 8 commits to main since this release
103dcaf

schéma de la base de données:
CREATE TABLE batiment (id INTEGER PRIMARY KEY, nom TEXT AFTER id)
CREATE TABLE responsable (id INTEGER PRIMARY KEY, nom TEXT, prenom TEXT)
CREATE TABLE salle (id INTEGER PRIMARY KEY, numero INT, etage INT, batiment INT)
CREATE TABLE serrure (id INTEGER PRIMARY KEY)
CREATE TABLE utilisateur (id INTEGER PRIMARY KEY, nom TEXT, prenomTEXT)