#872 update volumes_15min_mvt pkey

[gabrielwol]

What this pull request accomplishes:

• Removes volume_15min_mvt_uid from pkey of volumes_15min_mvt so that it works as a unique constraint.

Issue(s) this solves:

• #872

What, in particular, needs to reviewed:

What needs to be done by a sysadmin after this PR is merged

• [X] duplicates deleted by clearing + re-aggregating
• [ ] Alter pkey:

ALTER TABLE miovision_api.volumes_15min_mvt DROP CONSTRAINT volumes_15min_mvt_int_uid_dt_bin_class_leg_mvmt_uid_pkey PRIMARY KEY (volume_15min_mvt_uid, intersection_uid, datetime_bin, classification_uid, leg, movement_uid);

ALTER TABLE miovision_api.volumes_15min_mvt ADD CONSTRAINT volumes_15min_mvt_int_dt_bin_class_leg_mvmt_uid_pkey PRIMARY KEY (intersection_uid, datetime_bin, classification_uid, leg, movement_uid);

Surprisingly, I tried this in my personal schema and it works, despite temporarily dropping the pkey used for partitioning.