CREATE TABLE waterway.sounding_results_iso_areas (
    sounding_result_id int NOT NULL REFERENCES waterway.sounding_results
        ON DELETE CASCADE,
    height numeric NOT NULL,
    areas geography(MULTIPOLYGON, 4326) NOT NULL,
    -- TODO: generate valid simple features and add constraint:
        -- CHECK(ST_IsSimple(CAST(areas AS geometry))),
    PRIMARY KEY (sounding_result_id, height)
);

CREATE TABLE caching.sounding_differences_iso_areas (
    sounding_differences_id int NOT NULL REFERENCES caching.sounding_differences(id)
                                ON DELETE CASCADE,
    height numeric NOT NULL,
    areas  geography(MULTIPOLYGON, 4326) NOT NULL,
    PRIMARY KEY (sounding_differences_id, height)
);

GRANT INSERT, UPDATE, DELETE ON waterway.sounding_results_iso_areas
    TO waterway_admin;

GRANT SELECT ON waterway.sounding_results_iso_areas
    TO waterway_user;

GRANT SELECT, UPDATE, DELETE, INSERT ON caching.sounding_differences_iso_areas
    TO waterway_user;