i really dont need a number generator, only a unique PK. but i want that this PK be generate automatically
for example i have a Category calling Computer in English but i have the same Category in Spanish (Computadora) i assigned the ID->1 for both
So if i put the Pk ID in the table2 number i have error for unique violation when i want INSERT another name in a diferent language for the same category
For that reason i declare ID in the table2 like a FK from ID in the table1