Appshet and MySQL Key Columns

[Luis_DfG]

Hello,

I have an App that it's connected to a MySQL database.

The way that the DB manager generates his keys for all his tables is through an integer column with auto increment.

I could try to calculate the next auto increment key value but I believe this will create conflics in the future (e.g. multiple users saving records at the same time).

However, I could be able to feed the column key through Appsheet, but we will have users also pouring information into the database through a web-app as well.

Under this scenario, is it possible for MySQL to generate a unique ID as Appsheet does?

If that is not possible, and the MySQL database must key the int + auto increment, shall we have two key columns? one used in the Appsheet environment and the other on the web-app environment?

Is there any other approach we could take?

Thanks in advance!