managing symbols as integral values for partitioned databases

any standard convention here?

If enums (what you probably know) are not the answer then what is your question exactly?