1. I can see here that Stack Exchange sites have separate databases.
But does it have separate users tables for each database? If yes, then how are passwords synchronised across databases?
2. I can see from here that every site's user table has the AccountId of the Stack Exchange Network profile.
Here is Nick Craver, network profile with ID 7598.
His profile in History Site has the account ID linked with the same ID, 7598. Check this query.
I can't see the Accounts table anywhere in the data dumps.
Is the Accounts table with AccountId stored in a separate database?
I would like to know the database structure for accounts.