1 year ago

#360143

test-img

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

Accepted video resources