Question about Database

[eluser]slowgary[/eluser]
Do you really want to give your users the primary key of your tables as their user id? Seems like a bad choice. What if you decide to alter your schema? Also, is your first user going to have an id of 1??

Additionally, I'm not sure there's a reliable way to 'alternate' IDs between tables or that it's even a good idea. I really think you might end up with a serious mess on your hands in the long run.

If 'experts' and 'employers' are both 'users', why not just have 1 table for 'users' and add a field for 'user_type', which can be enumerated as 'experts', 'employers'? This way you don't have to worry about managing the primary key. Also, if you're looking for a friendly ID to be able to give the user, you should just allow them to choose their own alphanumeric username. I think UUIDs are actually 36 characters as a string, but if you choose to give your users a numeric ID, you'll need to give them a very large number to assure that you don't run out of numbers. A number like '234509567759' is not as friendly as a username like 'happyharry'.