Hi Wim, Yes, that is looks correct to me.
Cheers, Jens On Tue, Jul 1, 2014 at 8:37 AM, Wim Deblauwe <wim.debla...@gmail.com> wrote: > 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 >