Create Table "ArrangementType" (
        ArrangementID SERIAL,
        ArrangementType VARCHAR(40) CHARACTER SET utf8,
        INDEX arrangement_type (ArrangementeID)
);

Create Table "CommissionType" (
        CommissionID SERIAL,
        CommissionType VARCHAR(40) CHARACTER SET utf8,
        INDEX commission_type (CommissionID)
);

Create Table "Persons" (
        Surname VARCHAR(40) CHARACTER SET utf8,
        Name VARCHAR(20) CHARACTER SET utf8,
        PersonalID VARCHAR(12),
        Address VARCHAR(40) CHARACTER SET utf8,
        Zipcode MEDIUMINT,
        City VARCHAR(30) CHARACTER SET utf8,
        Phone VARCHAR(15),
        Mobile VARCHAR(15),
        Email VARCHAR(30),
        AdditionalInfo BLOB,
        INDEX persons (PersonalID)
);

Create Table "ArrangementInfo" (
        ArrangementID SERIAL,
        CommissionID SERIAL,
        PersonalID VARCHAR(12),
        INDEX arrangement_info (ArrangementID, CommissionID, PersonalID)
        FOREIGN KEY (ArrangementID)
                REFERENCES ArrangementType (ArrangementID)
                ON DELETE CASCADE ON UPDATE CASCADE,
        FOREIGN KEY (CommissionID)
                REFERENCES CommissionType (CommissionID)
                ON DELETE CASCADE ON UPDATE CASCADE,
        FOREIGN KEY (PersonalID)
                REFERENCES Persons (PersonalID)
                ON DELETE CASCADE ON UPDATE CASCADE,
);