     PRIMARY KEY(id)
 );
 
-CREATE TABLE Saison (
-    id INTEGER NOT NULL,
-    turnus TURNUESSE,
-    start_datum DATE,
-    end_datum DATE,
-
-    PRIMARY KEY(id)
-);
-
-CREATE TABLE Verein (
-    id INTEGER NOT NULL,
-    name VARCHAR(50),
-    heimatstadion VARCHAR(100),
-    ort VARCHAR(30),
-
-    PRIMARY KEY(id)
-);
 
 CREATE TABLE Team (
     id INTEGER NOT NULL,

CREATE TYPE turnuesse AS ENUM ('Sommer', 'Winter');

CREATE TABLE Liga (
    id INTEGER NOT NULL,


    PRIMARY KEY(id)
);

CREATE TABLE Saison (
    id INTEGER NOT NULL,
    turnus TURNUESSE,
    start_datum DATE,
    end_datum DATE,

    PRIMARY KEY(id)
);

CREATE TABLE Verein (
    id INTEGER NOT NULL,
    name VARCHAR(50),
    heimatstadion VARCHAR(100),
    ort VARCHAR(30),

    PRIMARY KEY(id)
);


CREATE TABLE Spiel (
    id INTEGER NOT NULL,
