I am working to improve an old PHP project.
For that project we have a Client table in a postgresql database.
Each client have two sequences in the database.
Before, everytime we had a new client, DEV team had to insert the client in the client table and create two sequences.
INSERT INTO client (...) VALUES (...);
CREATE SEQUENCE client_n_seq1;
CREATE SEQUENCE client_n_seq2;
Now I want that DEV team don't insert clients in the database, I want to provide a tool to make the "business people" insert them.
The first requirement is, the PHP code should not create the sequence.
What I was thinking about is to create a database function triggered every time after insert a client in the client table.
The first sequence is used to numerate the receipts generated for that client. The second sequence is a identifier of a file, that should be imported in a third party software .
My question is: What is your opinion? there is another way to provide the same functionality (have two "sequences", and increment the value one by one) without creating those sequences in the database?