1  CREATE TABLE events(
 2    id UUID DEFAULT generate_uuid_v7(),
 3    name TEXT NOT NULL,
 4    source TEXT NOT NULL,
 5    type TEXT NOT NULL,
 6    specversion FLOAT NOT NULL,
 7    datacontenttype TEXT NOT NULL,
 8    time TIMESTAMPTZ NOT NULL,
 9    data jsonb NOT NULL,
10    PRIMARY KEY (time, id)
11  );
12  
13  SELECT create_hypertable('events', 'time', if_not_exists => TRUE);