1 year ago
#360143
David
UUID and auto increment INT as primay key for diffrent tables in one db
I have a database with about 100 tables, I want to add REST API requests connected with some tables. I don't want to expose id from the database directly to the request so I want to change PK (primary key) from auto-increment int to UUID for particular tables.
Do you think that this is nothing wrong with that situation - to have partly as PK UUID and partly auto-increment int (one table has UUID and another autoincrement int)?
I've just wanted to know if there could be any performance issue with such hybrid solution I want to choose and if there are any disadvantage to not use such options.
mysql
primary-key
uuid
auto-increment
0 Answers
Your Answer