we shouldn't have FK constraints in reports tables because this is a bad scene if we need to partition. ADU by build will likely need to be partitioned by date.