Ensure that all tables that reference ci_pipelines have partition_id column

We need to check and update(if needed) all the tables that reference ci_pipelines for:

• - Determine referencing tables \d+ ci_pipelines
• - They have a partition_id column for each FK
• - the partition_id column is correctly populated with an appropriate value

Currently only these tables don't have partition_id:

table name	MR
ci_pipeline_chat_data	Add partition_id to Ci::PipelineChatData (!139515 - merged)
ci_pipeline_metadata	Add partition_id to Ci::PipelineMetadata (!141078 - merged)
ci_pipelines_config	Add partition_id to Ci::PipelineConfig (!141461 - merged)
ci_pipeline_artifacts	Add partition_id to Ci::PipelineArtifact (!141345 - merged)