CREATE TABLE Ergo (
                id INTEGER,
                akronimio CHAR(150),
                title CHAR(150) NOT NULL,
                hmerominiaEn DATE,
                hmerominiaLik DATE,
                PRIMARY KEY(id)
                );
CREATE TABLE Organismos (
                id INTEGER,
                name CHAR(150) NOT NULL,
                city CHAR(150),
                country CHAR(150),
                PRIMARY KEY (id)
                );
CREATE TABLE Dhmosieush (
                id INTEGER,
                title CHAR(150) NOT NULL,
                periodiko CHAR(150),
                etos INTEGER,
                PRIMARY KEY(id)
                );
CREATE TABLE Paradoteo (
                id INTEGER,
                title CHAR(150),
                tupos CHAR(150) NOT NULL,
                PRIMARY KEY(id)
                );
CREATE TABLE ExeiOne(
                idParadoteo INTEGER,
                idErgo INTEGER,
                FOREIGN KEY(idParadoteo) REFERENCE Paradoteo(id),
                FOREIGN KEY(idErgo) REFERENCE Ergo(id)
                );
CREATE TABLE ExeiOne(
                idDhmosieush INTEGER,
                idErgo INTEGER,
                FOREIGN KEY(idDhmosieush) REFERENCE Dhmosieush(id),
                FOREIGN KEY(idErgo) REFERENCE Ergo(id)
                );
CREATE TABLE ErgOrg (
                idErgo INTEGER,
                idOrganismos INTEGER,
                rolos CHAR(150),
                poso FLOAT,
                FOREIGN KEY(idErgo) REFERENCE Ergo(id),
                FOREIGN KEY(idOrganimsos) REFERENCE Organimos (id)
                );