Page 1 of 1

Duplicate IDs in Contact and Company table?

PostPosted: Wed Jan 20, 2016 12:45 am
by Regine
Hi John,

Just wondering if there is a chance, that the IDs in the ID field in the contact table could be the same as in the ID field in the company table?

In previous version of SeedCode Complete the IDs had a letter prefix related to the table and hence there were always unique.

Just wondering as I want to integrate fmSpark to create letters from the Company table as well as from the Contacts table, but if the IDs would overlap, I would get a mess in the letter history/tracking.

Thanking you in advance.

kind regards

Regine

Re: Duplicate IDs in Contact and Company table?

PostPosted: Wed Jan 20, 2016 2:50 pm
by John Sindelar
Both tables use UUIDs for their IDs so while there is a chance that you'd get the same IDs it is so absolutely way out that I don't believe it's credible. For example, developers have created millions and millions of records with these UUIDs and not seen duplicates. Note that we're not using any prefixing so you can't tell if an ID belongs to a contact or company just by looking at it.