Change TI table to have unique UUID id/pk per attempt

[kaxil]

We want to update the task instance and ti history tables to have a unique id per attempt (this row id will be used in the strong identity token issued to reach TI attempt.)

We want to add a single column pk of a UUID, and should use UUID v7 (as it has better temporal sorting behaviours than the random v4). For the migration to update existing rows we can use v4 which most DBs have natively.

We should propose keep the "denormalized" columns of dag_id and run_id for easier searching/querying.

[gyli]

Hi @kaxil , seems like you have already implemented the major part of this issue, including adding the UUIDv7 column and switching the pk columns #43161. Is there any missing part undone for this issue, or are we good to close this one?