CREATE TABLE events (
    id CHAR(36) NOT NULL PRIMARY KEY,
    date DATE NOT NULL,
    title VARCHAR(255) NOT NULL,
    time VARCHAR(50) NOT NULL,
    location VARCHAR(255) NOT NULL,
    description TEXT,
    createdAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updatedAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP
        ON UPDATE CURRENT_TIMESTAMP
);

CREATE TABLE event_fees (
    id CHAR(36) NOT NULL PRIMARY KEY,
    eventId CHAR(36) NOT NULL,
    feeName VARCHAR(255) NOT NULL,
    feeAmount DECIMAL(10, 2) NOT NULL,

    FOREIGN KEY (eventId)
        REFERENCES events(id)
        ON DELETE CASCADE
);