AnsweredAssumed Answered

PrimaryKey

Question asked by vincer on Sep 21, 2018
Latest reply on Sep 22, 2018 by philmodjunk

After reading so many pages about best practice for choosing a PrimaryKey...need to check if I am in a safe way

What I have done until now is:

a) not visible to the users

b) do not use an auto-generated serial number (need to update next serial number settings and not unique throughout the database)

c) numeric value (faster sorting)

d) do not use Get (UUID) since it is text

e) no plug-ins (easier portability)

 

My actual calculation of PrimaryKey is very basically numeric field with auto-enter calculation as follows:

GetAsNumber ( Get (UUID))

- Do not replace existing value of field: checked

- Prohibit modification of value during data entry: checked

 

Is it a wrong choice and with critical limitations, or safe enough for continuing this way ?

Many thanks for your feedback

Vince

Outcomes