Currently I am dealing with a sys that track manuscripts. For every manuscript submitted, an auto increment id will assigned. If manuscript is accepted to be published, a reference number will be given.

The reference number for each accepted script needs to be distinct, logical and must be flexible and allow for future changes.

I need some suggestions on the implementation of the reference number.

If you have piror experience, please share with me how you think the reference number should be, such that it will be unique, logical, easy to handle and flexible.

Thank you so much!

Have a happy new year!