Postgresql parkeergarage

-- DDL
CREATE DATABASE parkeergarage
    WITH
    OWNER = postgres
    ENCODING = 'UTF8'
    LC_COLLATE = 'Dutch_Netherlands.1252'
    LC_CTYPE = 'Dutch_Netherlands.1252'
    TABLESPACE = pg_default
    CONNECTION LIMIT = -1;

-- DML
CREATE TABLE Bezetting_Data (id SERIAL NOT NULL, start_tijd timestamp with zone NOT NULL, eind_tijd timestamp with zone, Parkeerplekid int4 NOT NULL, PRIMARY KEY (id));
CREATE TABLE Parkeerplek (id SERIAL NOT NULL, bezet boolean NOT NULL, Verdiepingid int4 NOT NULL, PRIMARY KEY (id));
CREATE TABLE Verdieping (id SERIAL NOT NULL, PRIMARY KEY (id));
ALTER TABLE Parkeerplek ADD CONSTRAINT FKParkeerple325300 FOREIGN KEY (Verdiepingid) REFERENCES Verdieping (id);
ALTER TABLE Bezetting_Data ADD CONSTRAINT FKBezetting_380955 FOREIGN KEY (Parkeerplekid) REFERENCES Parkeerplek (id);

INSERT INTO Verdieping (id) VALUES (0), (1), (2);

INSERT INTO Parkeerplek (id, bezet, verdiepingid)
VALUES  (0, false, 0), (1, false, 0), (2, false, 0), (3, false, 0), (4, false, 0), (5, false, 0),
        (6, false, 1), (7, false, 1), (8, false, 1), (9, false, 1), (10, false, 1), (11, false, 1),
        (12, false, 2), (13, false, 2), (14, false, 2), (15, false, 2), (16, false, 2), (17, false, 2);