How do you store/generate document numbering?

Question

Database

Hello.
Tell experienced programmers, how do you work with document numbering?
There is a task for different documents, to generate different numbers, someone just has 1,2,3, .. Someone with some kind of letters or symbols. With each new year, some start from 0, some do not.
How do you store and generate these numbers?
I now store a bunch of them in one table, it turns out a mess, but creating a table with numbers for each
type of document sounds kind of wasteful)

Maybe someone has something to share.

Answer 1

You can use the functions \ function that generates a number for each type of document, including the date, if necessary, then store the version of the document.
For example, the document number for the selected line in the screenshot id = 1156 may look like 338-PP-21-31012019(creation date) -01(version).
In principle, an experienced user can tell what the document is about before opening.