here's the scenario:
say i have tables A and B (id, name, C_id), both have a foreign key reference to table C (A_or_B_id, foo)
in the interest of normalization, i'm consolidating A and B into a new table X. obviously i cannot preserve the key id from one of the tables, let it be table B...