CREATE TABLE environments (
    id SERIAL,
    service_id INTEGER NOT NULL,
    iam_role VARCHAR (128) NOT NULL,
    label VARCHAR (64) NOT NULL,
    cloudformation_status VARCHAR (200) NOT NULL DEFAULT '',

    PRIMARY KEY (id),
    CONSTRAINT environments_service_id_fkey FOREIGN KEY (service_id) REFERENCES services (id)
        ON UPDATE CASCADE
);
