Remove redundant LFK CI partitioned tables

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

• Work on this issue
• Close this issue

Problem

We have LFKs for projects <-> stages and projects <-> pipelines and regular FKs for pipelines <-> stages.

The LFK from projects to stages seems redundant in this case and it also executes queries without partition_id.

Solution

• Investigate if we can remove redundant LFKs for our new partitioned tables