Fixes 902142 - adds support for partitioning matviews

This is a performance enhancement for the signature_summary reports and adds support for any matviews that we'd like to partition in the future. 


* Includes a migration that drops foreign keys on  parent signature_summary tables
* Downgrade restores the FKs
* Also runs backfill_weekly_partitions() for signature_summary tables