Add work item weight sources table

What does this MR do and why?

This will store cached rolled up weight values for work items.

I've also added the method to upsert values into this table.

In future MRs, we will trigger this every time a child work item changes hierarchy / weight / state. We will also backfill this for existing records.

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #475273