CREATE TABLE IF NOT EXISTS plant_types (
    id SERIAL PRIMARY KEY NOT NULL,
    name VARCHAR(100) NOT NULL,
    watering_frequency_in_minutes INT
);

CREATE TABLE IF NOT EXISTS plants (
    id SERIAL PRIMARY KEY NOT NULL,
    user_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,
    name VARCHAR(200),
    plant_type_id INT REFERENCES plant_types(id) ON DELETE SET NULL
);