Create ci_runners_taggings partitioned table
To partition and shard the taggings
table we need to create tables for each polymorphic relation. For its relation with ci_runners
we must create a new table ci_runners_taggings
to encapsulate the many to many relation between tags
and runners.
ci_runners_taggings
should have these columns:
id bigint
-
tag_id bigint
, FK totags
-
runner_id bigint
, FK toci_runners
- sharding key
An unique index on (tag_id, runner_id) to ensure that tags are unique per runner.
Edited by Pedro Pombeiro - OOO from Oct 13-24