sql/create_endpoints.sql

CREATE TABLE IF NOT EXISTS endpoints (
    space_id TEXT NOT NULL,
    endpoint_type TEXT NOT NULL,  -- 'sse' or 'schema'
    endpoint_url TEXT NOT NULL,
    FOREIGN KEY(space_id) REFERENCES spaces(space_id) ON DELETE CASCADE,
    PRIMARY KEY (space_id, endpoint_type)
);