change label static

change label static

  

I have some static tables with a defined Labels and ID

ex:

ID-LABEL

1-BLUE

2-RED

3-BLACK

4-GREEN


It happens in some situations that moved the bados bank and the same static changes the id relationship with the label

ex:

ID-LABEL

1-RED

2-BLUE

3-GREEN

4-BLACK


I was reading some suggestions to turn off the auto-increment Static.


But I have a situation that already have a client base populated pointing to the ID = 1 where the Label is RED

What is your suggestion to be no problems?

well, it isn't static anymore if the labels change...

so you end up converting them or make static entities with a text-field as PK


@J, I think what he means is that accross databases the auto numbers are different for different labels, and he wants to migrate data or the like.

@Marco: If that's what you mean, I'm not sure what to advise you, as I don't know your specific use case. I can tell you however, that we never use autonumbers for static entities, but always codes. It's easier to maintain, and easier for visual inspection of tables using the static entity.