clusters_checkins table is incorrectly schematized

[jackfrancis]

we don't need uniqueness constraints in this table

[jackfrancis]

Current table description:

deis_prod_pg-> \d+ clusters_checkins;
                                                              Table "public.clusters_checkins"
   Column    |            Type             |                                Modifiers                                | Storage  | Stats target | Description 
-------------+-----------------------------+-------------------------------------------------------------------------+----------+--------------+-------------
 checkins_id | bigint                      | not null default nextval('clusters_checkins_checkins_id_seq'::regclass) | plain    |              | 
 cluster_id  | uuid                        |                                                                         | plain    |              | 
 created_at  | timestamp without time zone |                                                                         | plain    |              | 
 data        | json                        |                                                                         | extended |              | 
Indexes:
    "clusters_checkins_pkey" PRIMARY KEY, btree (checkins_id)
    "clusters_checkins_cluster_id_created_at_key" UNIQUE CONSTRAINT, btree (cluster_id, created_at)
Has OIDs: no

The uniqueness constraints as currently defined are preventing follow-up checkin records from being added to the table.

[jackfrancis]

deis_prod_pg=> \d clusters_checkins;
                                          Table "public.clusters_checkins"
   Column    |            Type             |                                Modifiers                                
-------------+-----------------------------+-------------------------------------------------------------------------
 checkins_id | bigint                      | not null default nextval('clusters_checkins_checkins_id_seq'::regclass)
 cluster_id  | uuid                        | 
 created_at  | timestamp without time zone | 
 data        | json                        | 
Indexes:
    "clusters_checkins_pkey" PRIMARY KEY, btree (checkins_id)
    "clusters_checkins_cluster_id_created_at_key" UNIQUE CONSTRAINT, btree (cluster_id, created_at)

deis_prod_pg=> alter table clusters_checkins drop constraint clusters_checkins_cluster_id_created_at_key;
ALTER TABLE
deis_prod_pg=> \d clusters_checkins;
                                          Table "public.clusters_checkins"
   Column    |            Type             |                                Modifiers                                
-------------+-----------------------------+-------------------------------------------------------------------------
 checkins_id | bigint                      | not null default nextval('clusters_checkins_checkins_id_seq'::regclass)
 cluster_id  | uuid                        | 
 created_at  | timestamp without time zone | 
 data        | json                        | 
Indexes:
    "clusters_checkins_pkey" PRIMARY KEY, btree (checkins_id)

[jackfrancis]

Tested manually with delicious champagne.