Data synchronization function: A, B two tables some records A copy, and each record to change an application Id (used for distinguish), and then insert the changed record to the table
Among which the relationship between the two tables have a maintenance, how to change the data according to the original relationship, maintenance to the middle table again?

CodePudding user response:

Used to distinguish between the field is a primary key, can't change, change the primary key is equivalent to delete, and create,
If the original primary key, external references the primary key of the record is also failed, you can only change in the main table at the same time to update the associative table (because at that time and the old primary key information),

CodePudding user response:

Want to combine business, there are may change the primary key field is not cooperation system, then can use a uuid do system on the primary key, so the other fields including the "primary key" on the business can literally change,

CodePudding user response:

Thank you, forgot to say, application Id is not a primary key, is used to distinguish between a field in each record

CodePudding user response:

Can I bother to answer