SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE zimmer( honr INTEGER, znr INTEGER, kapazitaet INTEGER NOT NULL, preis DECIMAL (7,2) NOT NULL, zname VARCHAR (100), CONSTRAINT pkzimmer PRIMARY KEY (honr, znr), CONSTRAINT fkzimmer FOREIGN KEY (honr) REFERENCES hotel (honr) ON DELETE CASCADE, CONSTRAINT chkapazitaet CHECK (kapazitaet > 0) ); CREATE TABLE gast( name VARCHAR (50) NOT NULL, vorname VARCHAR (50) NOT NULL, strasse VARCHAR (50) NOT NULL, plz CHAR (5) NOT NULL, hnr VARCHAR (5) NOT NULL, ort VARCHAR (100), gebdatum DATE, gnr INTEGER, CONSTRAINT pkgast PRIMARY KEY (gnr) ); CREATE TABLE hotel( honr INTEGER, hname VARCHAR (50) NOT NULL, strasse VARCHAR (50) NOT NULL, plz CHAR (5) NOT NULL, hnr VARCHAR (5) NOT NULL, ort VARCHAR (50) NOT NULL, CONSTRAINT pkhotel PRIMARY KEY (honr) )