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)
);

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

GRANT SELECT ON waterway.sounding_results_iso_areas
    TO waterway_user;