Add blueprint docs about partitioning builds metadata first

What does this MR do and why?

This merge request extends partitioning blueprint with our strategy to choosing the first CI database table that we will partition. It also adds the reasoning behind this decision and implications to uniform pipeline partition ids framework.

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.