Add docs about indexes created to facilitate cross partition cascades on deletes
The following discussion from !598 (merged) should be addressed:
-
@iroussos started a discussion: @jdrpereira non-blocking minor:
Should we add a comment here and on the other unique indexes that we have added to facilitate the cascading delete lookups?
Now that we reordered the columns on the unique index, it is clear that this unique constraint is already covered by the primary key (which also explicitly defines uniqueness) and could be confusing to someone checking the schema as we don't clearly call out why we have this index defined.