Hi,

I have the following table:

CREATE TABLE integration_time (
message_source_id uuid,
traffic_data_type varchar,
integration_period varchar,
integration_time timestamp,
PRIMARY KEY ((message_source_id,traffic_data_type,integration_period))
);

I want the combination of (message_source_id, traffic_data_type,
integration_period) to be unique. Is this the correct way to do it (with
the double brackets) ?

This table will be relative small, it just stores the last time something
was done in the application for that unique combination of those 3
parameters. Worst case there will be 30000 rows in that table and they will
always be fetched by quering on the 3 parameters at the same time.

regards,

Wim

Reply via email to