Spike: Explore how to prevent duplicate components in `catalog_resource_components`
Summary - Why is this spike needed?
As discussed in #450737 (comment 1908087764), we have several things to consider to prevent duplicate components from being added into catalog_resource_components
.
Timebox Expectations
1-2 weeks of analysis and evaluating options before determining a path forward.
Expected Outcomes
-
Possible cause(s) are determined -
Technical proposal added to Backend: Add unique constraint on `catalog_reso... (#450737) -
Weight added to Backend: Add unique constraint on `catalog_reso... (#450737)